ABAP Select data from SAP table FAC_S_BS_ITM_ODATA 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 FAC_S_BS_ITM_ODATA 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 FAC_S_BS_ITM_ODATA. 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 FAC_S_BS_ITM_ODATA 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_FAC_S_BS_ITM_ODATA TYPE STANDARD TABLE OF FAC_S_BS_ITM_ODATA,
      WA_FAC_S_BS_ITM_ODATA TYPE FAC_S_BS_ITM_ODATA,
      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: <FAC_S_BS_ITM_ODATA> TYPE FAC_S_BS_ITM_ODATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FAC_S_BS_ITM_ODATA
*  INTO TABLE @DATA(IT_FAC_S_BS_ITM_ODATA2).
*--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_FAC_S_BS_ITM_ODATA INDEX 1 INTO DATA(WA_FAC_S_BS_ITM_ODATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FAC_S_BS_ITM_ODATA>-ABSND = 1.
<FAC_S_BS_ITM_ODATA>-BUKRS = 1.
<FAC_S_BS_ITM_ODATA>-HBKID = 1.
<FAC_S_BS_ITM_ODATA>-HKTID = 1.
<FAC_S_BS_ITM_ODATA>-AZNUM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FAC_S_BS_ITM_ODATA-AZDAT, sy-vline,
  WA_FAC_S_BS_ITM_ODATA-ASTAT, sy-vline,
  WA_FAC_S_BS_ITM_ODATA-WAERS, sy-vline,
  WA_FAC_S_BS_ITM_ODATA-VB1OK, sy-vline,
  WA_FAC_S_BS_ITM_ODATA-VB2OK, sy-vline,
  WA_FAC_S_BS_ITM_ODATA-KWBTR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FAC_S_BS_ITM_ODATA 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_FAC_S_BS_ITM_ODATA 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_FAC_S_BS_ITM_ODATA INTO WA_FAC_S_BS_ITM_ODATA.


*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 ALPHA, internal->external for field AZNUM
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AZNUM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AZNUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field KWBTR
CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-KWBTR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-KWBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field KWBTR_ABS
CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-KWBTR_ABS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-KWBTR_ABS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ESNUM
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-ESNUM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-ESNUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AVKON
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AVKON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AVKON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUKEY
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-KUKEY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-KUKEY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field FWBTR
CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-FWBTR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-FWBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PRCTR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-PRCTR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-PRCTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VERTN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-VERTN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-VERTN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field BELNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-BELNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-BELNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field SPESK
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-SPESK
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-SPESK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field SPESF
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-SPESF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-SPESF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field AKBLN_GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AKBLN_GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AKBLN_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field AK1BL_GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AK1BL_GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AK1BL_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field NBBLN_GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-NBBLN_GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-NBBLN_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field BELNR_GJAHR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-BELNR_GJAHR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-BELNR_GJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field NBBLN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-NBBLN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-NBBLN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AK1BL
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AK1BL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AK1BL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AKBLN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AKBLN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AKBLN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KNRZA
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-KNRZA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-KNRZA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SDOC2
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-SDOC2
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-SDOC2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field ARRSK
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-ARRSK
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-ARRSK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field HKONT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-HKONT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-HKONT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AZSNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-AZSNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-AZSNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field SSBTR
CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-SSBTR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-SSBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field SUMSO
CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-SUMSO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-SUMSO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field SUMHA
CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-SUMHA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-SUMHA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU172, internal->external for field ESBTR
CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-ESBTR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-ESBTR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ANZES
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-ANZES
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-ANZES.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field POSTINGRULE
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-POSTINGRULE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-POSTINGRULE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FAC_S_BS_ITM_ODATA-KUNNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FAC_S_BS_ITM_ODATA-KUNNR.
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_FAC_S_BS_ITM_ODATA_STR, 
ABSND TYPE STRING,
BUKRS TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
AZNUM TYPE STRING,
AZDAT TYPE STRING,
ASTAT TYPE STRING,
WAERS TYPE STRING,
VB1OK TYPE STRING,
VB2OK TYPE STRING,
KWBTR TYPE STRING,
KWBTR_ABS TYPE STRING,
GRPNR TYPE STRING,
VGINT TYPE STRING,
VGINT_TEXT TYPE STRING,
ESNUM TYPE STRING,
TATXT TYPE STRING,
TATYP TYPE STRING,
INTAG TYPE STRING,
VALUT TYPE STRING,
EPVOZ TYPE STRING,
AVKOA TYPE STRING,
AVKOATX TYPE STRING,
AVKON TYPE STRING,
HAS_ATTACHMENT TYPE STRING,
HAS_NOTE TYPE STRING,
MEMO_LINE_1 TYPE STRING,
MEMO_LINE TYPE STRING,
N2PCH TYPE STRING,
ISINPROCESS TYPE STRING,
BANK_KEY TYPE STRING,
BANK_ACCT TYPE STRING,
KUKEY TYPE STRING,
FWAER TYPE STRING,
FWBTR TYPE STRING,
CURR_RATE TYPE STRING,
PARTN TYPE STRING,
AVSID TYPE STRING,
BVDAT TYPE STRING,
BUDAT TYPE STRING,
BUTIM TYPE STRING,
VGEXT TYPE STRING,
BUTXT TYPE STRING,
BUSAB TYPE STRING,
BUSAB_NAME TYPE STRING,
PROCESSOR TYPE STRING,
PROCESSOR_NAME TYPE STRING,
KOSTL TYPE STRING,
GSBER TYPE STRING,
PRCTR TYPE STRING,
VERTN TYPE STRING,
VERTT TYPE STRING,
PNOTA TYPE STRING,
CONF_CHECT TYPE STRING,
PIPRE TYPE STRING,
ESTAT TYPE STRING,
BELNR TYPE STRING,
GJAHR TYPE STRING,
SPESK TYPE STRING,
SPESF TYPE STRING,
TEXTS TYPE STRING,
KFMOD TYPE STRING,
VGSAP TYPE STRING,
AKBLN_GJAHR TYPE STRING,
AK1BL_GJAHR TYPE STRING,
NBBLN_GJAHR TYPE STRING,
BELNR_GJAHR TYPE STRING,
XBLNR TYPE STRING,
ZUONR TYPE STRING,
PABKS TYPE STRING,
PABLZ TYPE STRING,
PASWI TYPE STRING,
PAKTO TYPE STRING,
INFO1 TYPE STRING,
INFO2 TYPE STRING,
NBBLN TYPE STRING,
AK1BL TYPE STRING,
AKBLN TYPE STRING,
KNRZA TYPE STRING,
BATCH TYPE STRING,
KURSF TYPE STRING,
SGTXT TYPE STRING,
JPDAT TYPE STRING,
POSAG TYPE STRING,
SDOC2 TYPE STRING,
VGREF TYPE STRING,
XBENR TYPE STRING,
XBTYP TYPE STRING,
ARRSK TYPE STRING,
PFORM TYPE STRING,
KIDNO TYPE STRING,
KKREF TYPE STRING,
MANSP TYPE STRING,
B1APP TYPE STRING,
B1APP_TEXT TYPE STRING,
B1STD TYPE STRING,
B1ERR TYPE STRING,
B1DOC TYPE STRING,
B1TYP TYPE STRING,
B2APP TYPE STRING,
B2APP_TEXT TYPE STRING,
B2STD TYPE STRING,
B2ERR TYPE STRING,
B2DOC TYPE STRING,
B2TYP TYPE STRING,
PIBAN TYPE STRING,
AZIDT TYPE STRING,
KIPRE TYPE STRING,
HKONT TYPE STRING,
KTONR TYPE STRING,
KTOIH TYPE STRING,
KTOSB TYPE STRING,
AZSNR TYPE STRING,
KTOPL TYPE STRING,
SSTYP TYPE STRING,
SSBTR TYPE STRING,
SUMSO TYPE STRING,
SUMHA TYPE STRING,
ESTYP TYPE STRING,
ESBTR TYPE STRING,
HZINS TYPE STRING,
BKTOA TYPE STRING,
ANZES TYPE STRING,
VGTYP TYPE STRING,
EFART TYPE STRING,
EUSER TYPE STRING,
EUSER_NAME TYPE STRING,
EDATE TYPE STRING,
ETIME TYPE STRING,
BKREF TYPE STRING,
INPUT_FORMAT TYPE STRING,
SIBAN TYPE STRING,
BANKA TYPE STRING,
GENERATED_ID TYPE STRING,
ACC_ID TYPE STRING,
PROCESSING_STATUS TYPE STRING,
HOLD_DOC_UUID TYPE STRING,
IS_POSTED_ON_ACCOUNT TYPE STRING,
EPERL TYPE STRING,
REPROCREASONCODE TYPE STRING,
REPROCREASONCODE_T TYPE STRING,
VGMAN TYPE STRING,
VGMAN_TEXT TYPE STRING,
BANK_ACCT_TECH_ID TYPE STRING,
BANK_ACCT_UUID TYPE STRING,
BANK_STATEMENT_ITM_LIFECYC_STS TYPE STRING,
CONF_RENUM TYPE STRING,
CUST_REF TYPE STRING,
IS_REPROCESSED TYPE STRING,
ML_STATUS TYPE STRING,
ML_STATUS_NAME TYPE STRING,
ML_STATUS_ACCDET TYPE STRING,
ML_STATUS_ACCDET_NAME TYPE STRING,
INCOMINGPAYMENTFILEID TYPE STRING,
COPILOT_KEY TYPE STRING,
BS_ITEM_ID TYPE STRING,
COMPANYCODENAME TYPE STRING,
HOUSEBANKACCOUNTDESCRIPTION TYPE STRING,
POSTINGRULE TYPE STRING,
POSTINGRULEDESCRIPTION TYPE STRING,
POSTINGRULEUUID TYPE STRING,
PAYMENTCLEARINGGRPID TYPE STRING,
LB_DESTINATION TYPE STRING,
LB_ORIGIN TYPE STRING,
LB_NUM TYPE STRING,
ANWND TYPE STRING,
KUNNR TYPE STRING,
PART_APPL_STATUS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FAC_S_BS_ITM_ODATA_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_FAC_S_BS_ITM_ODATA_STR-ABSND sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BUKRS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HBKID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HKTID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AZNUM sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AZDAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ASTAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-WAERS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VB1OK sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VB2OK sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KWBTR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KWBTR_ABS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-GRPNR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGINT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGINT_TEXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ESNUM sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-TATXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-TATYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-INTAG sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VALUT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-EPVOZ sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AVKOA sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AVKOATX sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AVKON sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HAS_ATTACHMENT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HAS_NOTE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-MEMO_LINE_1 sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-MEMO_LINE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-N2PCH sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ISINPROCESS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BANK_KEY sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BANK_ACCT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KUKEY sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-FWAER sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-FWBTR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-CURR_RATE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PARTN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AVSID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BVDAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BUDAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BUTIM sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGEXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BUTXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BUSAB sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BUSAB_NAME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PROCESSOR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PROCESSOR_NAME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KOSTL sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-GSBER sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PRCTR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VERTN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VERTT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PNOTA sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-CONF_CHECT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PIPRE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ESTAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BELNR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-GJAHR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SPESK sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SPESF sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-TEXTS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KFMOD sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGSAP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AKBLN_GJAHR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AK1BL_GJAHR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-NBBLN_GJAHR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BELNR_GJAHR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-XBLNR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ZUONR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PABKS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PABLZ sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PASWI sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PAKTO sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-INFO1 sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-INFO2 sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-NBBLN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AK1BL sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AKBLN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KNRZA sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BATCH sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KURSF sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SGTXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-JPDAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-POSAG sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SDOC2 sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGREF sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-XBENR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-XBTYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ARRSK sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PFORM sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KIDNO sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KKREF sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-MANSP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B1APP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B1APP_TEXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B1STD sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B1ERR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B1DOC sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B1TYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B2APP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B2APP_TEXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B2STD sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B2ERR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B2DOC sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-B2TYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PIBAN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AZIDT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KIPRE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HKONT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KTONR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KTOIH sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KTOSB sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-AZSNR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KTOPL sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SSTYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SSBTR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SUMSO sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SUMHA sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ESTYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ESBTR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HZINS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BKTOA sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ANZES sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGTYP sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-EFART sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-EUSER sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-EUSER_NAME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-EDATE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ETIME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BKREF sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-INPUT_FORMAT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-SIBAN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BANKA sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-GENERATED_ID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ACC_ID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PROCESSING_STATUS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HOLD_DOC_UUID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-IS_POSTED_ON_ACCOUNT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-EPERL sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-REPROCREASONCODE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-REPROCREASONCODE_T sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGMAN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-VGMAN_TEXT sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BANK_ACCT_TECH_ID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BANK_ACCT_UUID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BANK_STATEMENT_ITM_LIFECYC_STS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-CONF_RENUM sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-CUST_REF sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-IS_REPROCESSED sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ML_STATUS sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ML_STATUS_NAME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ML_STATUS_ACCDET sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ML_STATUS_ACCDET_NAME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-INCOMINGPAYMENTFILEID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-COPILOT_KEY sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-BS_ITEM_ID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-COMPANYCODENAME sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-HOUSEBANKACCOUNTDESCRIPTION sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-POSTINGRULE sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-POSTINGRULEDESCRIPTION sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-POSTINGRULEUUID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PAYMENTCLEARINGGRPID sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-LB_DESTINATION sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-LB_ORIGIN sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-LB_NUM sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-ANWND sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-KUNNR sy-vline 
WA_FAC_S_BS_ITM_ODATA_STR-PART_APPL_STATUS sy-vline      INTO ld_text SEPARATED BY SPACE.

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