ABAP Select data from SAP table FICA_CASH_DESK_STR_DFKKCJC into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP FICA_CASH_DESK_STR_DFKKCJC table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to FICA_CASH_DESK_STR_DFKKCJC. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the FICA_CASH_DESK_STR_DFKKCJC table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_FICA_CASH_DESK_STR_DFKKCJC TYPE STANDARD TABLE OF FICA_CASH_DESK_STR_DFKKCJC,
      WA_FICA_CASH_DESK_STR_DFKKCJC TYPE FICA_CASH_DESK_STR_DFKKCJC,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <FICA_CASH_DESK_STR_DFKKCJC> TYPE FICA_CASH_DESK_STR_DFKKCJC.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_FICA_CASH_DESK_STR_DFKKCJC.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM FICA_CASH_DESK_STR_DFKKCJC
  INTO TABLE IT_FICA_CASH_DESK_STR_DFKKCJC.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FICA_CASH_DESK_STR_DFKKCJC
*  INTO TABLE @DATA(IT_FICA_CASH_DESK_STR_DFKKCJC2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_FICA_CASH_DESK_STR_DFKKCJC INDEX 1 INTO DATA(WA_FICA_CASH_DESK_STR_DFKKCJC2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FICA_CASH_DESK_STR_DFKKCJC ASSIGNING <FICA_CASH_DESK_STR_DFKKCJC>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FICA_CASH_DESK_STR_DFKKCJC>-WA_DFKKCJC = 1.
<FICA_CASH_DESK_STR_DFKKCJC>-MANDT = 1.
<FICA_CASH_DESK_STR_DFKKCJC>-OFFIC = 1.
<FICA_CASH_DESK_STR_DFKKCJC>-CHDSK = 1.
<FICA_CASH_DESK_STR_DFKKCJC>-SEQNO = 1.

ENDLOOP.

LOOP AT IT_FICA_CASH_DESK_STR_DFKKCJC INTO WA_FICA_CASH_DESK_STR_DFKKCJC.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FICA_CASH_DESK_STR_DFKKCJC-CPUDT, sy-vline,
  WA_FICA_CASH_DESK_STR_DFKKCJC-WAERS, sy-vline,
  WA_FICA_CASH_DESK_STR_DFKKCJC-PAYTP, sy-vline,
  WA_FICA_CASH_DESK_STR_DFKKCJC-BLDAT, sy-vline,
  WA_FICA_CASH_DESK_STR_DFKKCJC-BLSEQ, sy-vline,
  WA_FICA_CASH_DESK_STR_DFKKCJC-CDSTA, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FICA_CASH_DESK_STR_DFKKCJC you want to display...

  WRITE:/ sy-uline.
* Aternatively use generic code to Write field values (and NAME) to screen report
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE wa_FICA_CASH_DESK_STR_DFKKCJC TO <field>.
    IF sy-subrc <> 0. EXIT. ENDIF.
    WRITE:/ 'Field Value', <field>, sy-vline.
    gd_str = <field> .
    lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ).
    lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ).
    WRITE:/ 'Field Name', lv_fieldname.
  ENDDO.

  
*Redo loop but convert all fields from internal to out value  
LOOP AT IT_FICA_CASH_DESK_STR_DFKKCJC INTO WA_FICA_CASH_DESK_STR_DFKKCJC.


*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Convert all fields to display/output versions using conversion routines
  PERFORM convert_all_field_values CHANGING wa_EKKO.
	 
ENDLOOP.

  
*&---------------------------------------------------------------------*
*& Form convert_all_field_values
*&---------------------------------------------------------------------*
FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO.
DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit ISOLA, internal->external for field SPRAS
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_FICA_CASH_DESK_STR_DFKKCJC-SPRAS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FICA_CASH_DESK_STR_DFKKCJC-SPRAS.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_FICA_CASH_DESK_STR_DFKKCJC_STR, 
WA_DFKKCJC TYPE STRING,
MANDT TYPE STRING,
OFFIC TYPE STRING,
CHDSK TYPE STRING,
SEQNO TYPE STRING,
CPUDT TYPE STRING,
WAERS TYPE STRING,
PAYTP TYPE STRING,
BLDAT TYPE STRING,
BLSEQ TYPE STRING,
CDSTA TYPE STRING,
CPUTM TYPE STRING,
ERNAM TYPE STRING,
STAMT TYPE STRING,
SDAMT TYPE STRING,
POAMT TYPE STRING,
PDAMT TYPE STRING,
CSAMT TYPE STRING,
DIAMT TYPE STRING,
DEAMT TYPE STRING,
WIAMT TYPE STRING,
SLAMT TYPE STRING,
SVAMT TYPE STRING,
SEAMT TYPE STRING,
RPFLG TYPE STRING,
WA_DFKKCJMT TYPE STRING,
MANDT TYPE STRING,
SPRAS TYPE STRING,
OFFIC TYPE STRING,
CHDSK TYPE STRING,
OFTXT TYPE STRING,
CHTXT TYPE STRING,
WA_USER_ADDR TYPE STRING,
MANDT TYPE STRING,
BNAME TYPE STRING,
NAME_FIRST TYPE STRING,
NAME_LAST TYPE STRING,
NAME_TEXTC TYPE STRING,
TEL_EXTENS TYPE STRING,
KOSTL TYPE STRING,
BUILDING TYPE STRING,
ROOMNUMBER TYPE STRING,
DEPARTMENT TYPE STRING,
INHOUSE_ML TYPE STRING,
NAME1 TYPE STRING,
CITY1 TYPE STRING,
POST_CODE1 TYPE STRING,
MC_NAMEFIR TYPE STRING,
MC_NAMELAS TYPE STRING,
MC_NAME1 TYPE STRING,
MC_CITY1 TYPE STRING,
COMPANY TYPE STRING,
IDADTYPE TYPE STRING,
T_DFKKKO TYPE STRING,
T_DFKKCJT_V TYPE STRING,
T_DFKKCJT_E TYPE STRING,
T_DFKKCJT_D TYPE STRING,
T_DFKKCJC2 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FICA_CASH_DESK_STR_DFKKCJC_STR type T_EKKO_STR.

DATA: ld_text TYPE string.

LOOP AT IT_EKKO INTO WA_EKKO.
  MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR.
  CONCATENATE: sy-vline
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-WA_DFKKCJC sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MANDT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-OFFIC sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CHDSK sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-SEQNO sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CPUDT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-WAERS sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-PAYTP sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-BLDAT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-BLSEQ sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CDSTA sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CPUTM sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-ERNAM sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-STAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-SDAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-POAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-PDAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CSAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-DIAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-DEAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-WIAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-SLAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-SVAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-SEAMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-RPFLG sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-WA_DFKKCJMT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MANDT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-SPRAS sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-OFFIC sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CHDSK sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-OFTXT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CHTXT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-WA_USER_ADDR sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MANDT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-BNAME sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-NAME_FIRST sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-NAME_LAST sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-NAME_TEXTC sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-TEL_EXTENS sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-KOSTL sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-BUILDING sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-ROOMNUMBER sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-DEPARTMENT sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-INHOUSE_ML sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-NAME1 sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-CITY1 sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-POST_CODE1 sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MC_NAMEFIR sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MC_NAMELAS sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MC_NAME1 sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-MC_CITY1 sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-COMPANY sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-IDADTYPE sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-T_DFKKKO sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-T_DFKKCJT_V sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-T_DFKKCJT_E sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-T_DFKKCJT_D sy-vline 
WA_FICA_CASH_DESK_STR_DFKKCJC_STR-T_DFKKCJC2 sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.