ABAP Select data from SAP table FISRGSTR1ITM into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP FISRGSTR1ITM 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 FISRGSTR1ITM. 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 FISRGSTR1ITM 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_FISRGSTR1ITM TYPE STANDARD TABLE OF FISRGSTR1ITM, WA_FISRGSTR1ITM TYPE FISRGSTR1ITM, 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: <FISRGSTR1ITM> TYPE FISRGSTR1ITM. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_FISRGSTR1ITM. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM FISRGSTR1ITM INTO TABLE IT_FISRGSTR1ITM. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM FISRGSTR1ITM * INTO TABLE @DATA(IT_FISRGSTR1ITM2). *--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_FISRGSTR1ITM INDEX 1 INTO DATA(WA_FISRGSTR1ITM2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_FISRGSTR1ITM ASSIGNING <FISRGSTR1ITM>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<FISRGSTR1ITM>-MANDT = 1.
<FISRGSTR1ITM>-COMPANYCODE = 1.
<FISRGSTR1ITM>-ACCOUNTINGDOCUMENT = 1.
<FISRGSTR1ITM>-FISCALYEAR = 1.
<FISRGSTR1ITM>-TAXITEM = 1.
ENDLOOP. LOOP AT IT_FISRGSTR1ITM INTO WA_FISRGSTR1ITM. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_FISRGSTR1ITM-TAXCODE, sy-vline,
WA_FISRGSTR1ITM-TRANSACTIONTYPEDETERMINATION, sy-vline,
WA_FISRGSTR1ITM-TAXCALCULATIONPROCEDURE, sy-vline,
WA_FISRGSTR1ITM-TAXRATE, sy-vline,
WA_FISRGSTR1ITM-GLACCOUNT, sy-vline,
WA_FISRGSTR1ITM-TAXITEMGROUP, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FISRGSTR1ITM 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_FISRGSTR1ITM 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_FISRGSTR1ITM INTO WA_FISRGSTR1ITM. *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 ACCOUNTINGDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-ACCOUNTINGDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-ACCOUNTINGDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field FISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-FISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-FISCALYEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field GLACCOUNT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-GLACCOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-GLACCOUNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field REVERSEDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-REVERSEDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-REVERSEDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field REVERSEDOCUMENTFISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-REVERSEDOCUMENTFISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-REVERSEDOCUMENTFISCALYEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LEDGER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-LEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-LEDGER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit EXCRT, internal->external for field EXCHANGERATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-EXCHANGERATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-EXCHANGERATE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ODNIT, internal->external for field ALTERNATIVEREFERENCEDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ODNIT_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-ALTERNATIVEREFERENCEDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-ALTERNATIVEREFERENCEDOCUMENT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC172, internal->external for field TAXBASEAMOUNTINRPTGCRCY CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXBASEAMOUNTINRPTGCRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXBASEAMOUNTINRPTGCRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC172, internal->external for field TAXAMOUNTINRPTGCRCY CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXAMOUNTINRPTGCRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXAMOUNTINRPTGCRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field TAXAMOUNTINCOCODECRCY CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXAMOUNTINCOCODECRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXAMOUNTINCOCODECRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field TAXBASEAMOUNTINCOCODECRCY CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXBASEAMOUNTINCOCODECRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXBASEAMOUNTINCOCODECRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field TAXAMOUNT CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXAMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXAMOUNT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field TAXBASEAMOUNTINCOUNTRYCRCY CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXBASEAMOUNTINCOUNTRYCRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXBASEAMOUNTINCOUNTRYCRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field TAXAMOUNTINCOUNTRYCRCY CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXAMOUNTINCOUNTRYCRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXAMOUNTINCOUNTRYCRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field TAXBASEAMOUNTINTRANSCRCY CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXBASEAMOUNTINTRANSCRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXBASEAMOUNTINTRANSCRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field TAXBASEAMTINADDITIONALCRCY1 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXBASEAMTINADDITIONALCRCY1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXBASEAMTINADDITIONALCRCY1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field TAXBASEAMTINADDITIONALCRCY2 CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXBASEAMTINADDITIONALCRCY2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXBASEAMTINADDITIONALCRCY2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field TAXAMOUNTINADDITIONALCURRENCY1 CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXAMOUNTINADDITIONALCURRENCY1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXAMOUNTINADDITIONALCURRENCY1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field TAXAMOUNTINADDITIONALCURRENCY2 CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-TAXAMOUNTINADDITIONALCURRENCY2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-TAXAMOUNTINADDITIONALCURRENCY2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CUSTOMER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-CUSTOMER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-CUSTOMER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BUSINESSPARTNER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-BUSINESSPARTNER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-BUSINESSPARTNER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field REBZG CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-REBZG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-REBZG.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field REBZJ CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-REBZJ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-REBZJ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field INVDMBTR CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-INVDMBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-INVDMBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-MATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-MEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-MEINS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field HKONT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-HKONT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-HKONT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU132, internal->external for field DMBTR CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-DMBTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-DMBTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field GST_PART CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FISRGSTR1ITM-GST_PART IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FISRGSTR1ITM-GST_PART.
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_FISRGSTR1ITM_STR,
MANDT TYPE STRING,
COMPANYCODE TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
FISCALYEAR TYPE STRING,
TAXITEM TYPE STRING,
TAXCODE TYPE STRING,
TRANSACTIONTYPEDETERMINATION TYPE STRING,
TAXCALCULATIONPROCEDURE TYPE STRING,
TAXRATE TYPE STRING,
GLACCOUNT TYPE STRING,
TAXITEMGROUP TYPE STRING,
BUSINESSPLACE TYPE STRING,
TAXJURISDICTION TYPE STRING,
LOWESTLEVELTAXJURISDICTION TYPE STRING,
ACCOUNTINGDOCUMENTTYPE TYPE STRING,
REFERENCEDOCUMENTTYPE TYPE STRING,
REVERSEDOCUMENT TYPE STRING,
REVERSEDOCUMENTFISCALYEAR TYPE STRING,
EUTAXCLASSIFICATION TYPE STRING,
LEDGER TYPE STRING,
LEDGERGROUP TYPE STRING,
POSTINGDATE TYPE STRING,
DOCUMENTDATE TYPE STRING,
TAXREPORTINGDATE TYPE STRING,
REPORTINGDATE TYPE STRING,
FISCALPERIOD TYPE STRING,
EXCHANGERATE TYPE STRING,
ISREVERSAL TYPE STRING,
ISREVERSED TYPE STRING,
DOCUMENTREFERENCEID TYPE STRING,
ALTERNATIVEREFERENCEDOCUMENT TYPE STRING,
ACCOUNTINGDOCUMENTHEADERTEXT TYPE STRING,
COMPANYCODECOUNTRY TYPE STRING,
REPORTINGCOUNTRY TYPE STRING,
TAXRETURNCOUNTRY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
COUNTRYCURRENCY TYPE STRING,
DOCUMENTCURRENCY TYPE STRING,
REPORTINGCURRENCY TYPE STRING,
ADDITIONALCURRENCY1 TYPE STRING,
ADDITIONALCURRENCY2 TYPE STRING,
TAXBASEAMOUNTINRPTGCRCY TYPE STRING,
TAXAMOUNTINRPTGCRCY TYPE STRING,
TAXAMOUNTINCOCODECRCY TYPE STRING,
TAXBASEAMOUNTINCOCODECRCY TYPE STRING,
TAXAMOUNT TYPE STRING,
TAXBASEAMOUNTINCOUNTRYCRCY TYPE STRING,
TAXAMOUNTINCOUNTRYCRCY TYPE STRING,
TAXBASEAMOUNTINTRANSCRCY TYPE STRING,
TAXBASEAMTINADDITIONALCRCY1 TYPE STRING,
TAXBASEAMTINADDITIONALCRCY2 TYPE STRING,
TAXAMOUNTINADDITIONALCURRENCY1 TYPE STRING,
TAXAMOUNTINADDITIONALCURRENCY2 TYPE STRING,
CUSTOMER TYPE STRING,
TAXTYPE TYPE STRING,
TARGETTAXCODE TYPE STRING,
TAXNUMBER1 TYPE STRING,
TAXNUMBER2 TYPE STRING,
TAXNUMBER3 TYPE STRING,
BUSINESSPARTNER TYPE STRING,
BUSINESSPARTNERNAME TYPE STRING,
CUSTOMERSUPPLIERADDRESS TYPE STRING,
SUPPLIERACCOUNTGROUP TYPE STRING,
CONDITIONTYPE TYPE STRING,
TAXISNOTDEDUCTIBLE TYPE STRING,
UMSKS TYPE STRING,
SHKZG TYPE STRING,
REBZG TYPE STRING,
REBZJ TYPE STRING,
REBZZ TYPE STRING,
REBZT TYPE STRING,
INVXBLNR TYPE STRING,
BLDAT TYPE STRING,
VATDATE TYPE STRING,
INVDMBTR TYPE STRING,
LAND1 TYPE STRING,
LAND TYPE STRING,
SDDOCUMENTCATEGORY TYPE STRING,
TAXCOUNTRY TYPE STRING,
NILTYPE TYPE STRING,
RVCHRG TYPE STRING,
IMPORT TYPE STRING,
ORIGINALREFERENCEDOCUMENT TYPE STRING,
COND_NAME TYPE STRING,
HSN_SAC TYPE STRING,
MATNR TYPE STRING,
MENGE TYPE STRING,
MEINS TYPE STRING,
WERKS TYPE STRING,
HKONT TYPE STRING,
TEXT1 TYPE STRING,
EDOC_IN_UQC TYPE STRING,
CONDNAME TYPE STRING,
KBETR TYPE STRING,
DMBTR TYPE STRING,
PLC_SUP TYPE STRING,
GST_PART TYPE STRING,
LEGAL_STATE_CODE TYPE STRING,
TAXKD TYPE STRING,
REGISTEREDIND TYPE STRING,END OF T_EKKO_STR. DATA: WA_FISRGSTR1ITM_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_FISRGSTR1ITM_STR-MANDT sy-vline
WA_FISRGSTR1ITM_STR-COMPANYCODE sy-vline
WA_FISRGSTR1ITM_STR-ACCOUNTINGDOCUMENT sy-vline
WA_FISRGSTR1ITM_STR-FISCALYEAR sy-vline
WA_FISRGSTR1ITM_STR-TAXITEM sy-vline
WA_FISRGSTR1ITM_STR-TAXCODE sy-vline
WA_FISRGSTR1ITM_STR-TRANSACTIONTYPEDETERMINATION sy-vline
WA_FISRGSTR1ITM_STR-TAXCALCULATIONPROCEDURE sy-vline
WA_FISRGSTR1ITM_STR-TAXRATE sy-vline
WA_FISRGSTR1ITM_STR-GLACCOUNT sy-vline
WA_FISRGSTR1ITM_STR-TAXITEMGROUP sy-vline
WA_FISRGSTR1ITM_STR-BUSINESSPLACE sy-vline
WA_FISRGSTR1ITM_STR-TAXJURISDICTION sy-vline
WA_FISRGSTR1ITM_STR-LOWESTLEVELTAXJURISDICTION sy-vline
WA_FISRGSTR1ITM_STR-ACCOUNTINGDOCUMENTTYPE sy-vline
WA_FISRGSTR1ITM_STR-REFERENCEDOCUMENTTYPE sy-vline
WA_FISRGSTR1ITM_STR-REVERSEDOCUMENT sy-vline
WA_FISRGSTR1ITM_STR-REVERSEDOCUMENTFISCALYEAR sy-vline
WA_FISRGSTR1ITM_STR-EUTAXCLASSIFICATION sy-vline
WA_FISRGSTR1ITM_STR-LEDGER sy-vline
WA_FISRGSTR1ITM_STR-LEDGERGROUP sy-vline
WA_FISRGSTR1ITM_STR-POSTINGDATE sy-vline
WA_FISRGSTR1ITM_STR-DOCUMENTDATE sy-vline
WA_FISRGSTR1ITM_STR-TAXREPORTINGDATE sy-vline
WA_FISRGSTR1ITM_STR-REPORTINGDATE sy-vline
WA_FISRGSTR1ITM_STR-FISCALPERIOD sy-vline
WA_FISRGSTR1ITM_STR-EXCHANGERATE sy-vline
WA_FISRGSTR1ITM_STR-ISREVERSAL sy-vline
WA_FISRGSTR1ITM_STR-ISREVERSED sy-vline
WA_FISRGSTR1ITM_STR-DOCUMENTREFERENCEID sy-vline
WA_FISRGSTR1ITM_STR-ALTERNATIVEREFERENCEDOCUMENT sy-vline
WA_FISRGSTR1ITM_STR-ACCOUNTINGDOCUMENTHEADERTEXT sy-vline
WA_FISRGSTR1ITM_STR-COMPANYCODECOUNTRY sy-vline
WA_FISRGSTR1ITM_STR-REPORTINGCOUNTRY sy-vline
WA_FISRGSTR1ITM_STR-TAXRETURNCOUNTRY sy-vline
WA_FISRGSTR1ITM_STR-COMPANYCODECURRENCY sy-vline
WA_FISRGSTR1ITM_STR-COUNTRYCURRENCY sy-vline
WA_FISRGSTR1ITM_STR-DOCUMENTCURRENCY sy-vline
WA_FISRGSTR1ITM_STR-REPORTINGCURRENCY sy-vline
WA_FISRGSTR1ITM_STR-ADDITIONALCURRENCY1 sy-vline
WA_FISRGSTR1ITM_STR-ADDITIONALCURRENCY2 sy-vline
WA_FISRGSTR1ITM_STR-TAXBASEAMOUNTINRPTGCRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXAMOUNTINRPTGCRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXAMOUNTINCOCODECRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXBASEAMOUNTINCOCODECRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXAMOUNT sy-vline
WA_FISRGSTR1ITM_STR-TAXBASEAMOUNTINCOUNTRYCRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXAMOUNTINCOUNTRYCRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXBASEAMOUNTINTRANSCRCY sy-vline
WA_FISRGSTR1ITM_STR-TAXBASEAMTINADDITIONALCRCY1 sy-vline
WA_FISRGSTR1ITM_STR-TAXBASEAMTINADDITIONALCRCY2 sy-vline
WA_FISRGSTR1ITM_STR-TAXAMOUNTINADDITIONALCURRENCY1 sy-vline
WA_FISRGSTR1ITM_STR-TAXAMOUNTINADDITIONALCURRENCY2 sy-vline
WA_FISRGSTR1ITM_STR-CUSTOMER sy-vline
WA_FISRGSTR1ITM_STR-TAXTYPE sy-vline
WA_FISRGSTR1ITM_STR-TARGETTAXCODE sy-vline
WA_FISRGSTR1ITM_STR-TAXNUMBER1 sy-vline
WA_FISRGSTR1ITM_STR-TAXNUMBER2 sy-vline
WA_FISRGSTR1ITM_STR-TAXNUMBER3 sy-vline
WA_FISRGSTR1ITM_STR-BUSINESSPARTNER sy-vline
WA_FISRGSTR1ITM_STR-BUSINESSPARTNERNAME sy-vline
WA_FISRGSTR1ITM_STR-CUSTOMERSUPPLIERADDRESS sy-vline
WA_FISRGSTR1ITM_STR-SUPPLIERACCOUNTGROUP sy-vline
WA_FISRGSTR1ITM_STR-CONDITIONTYPE sy-vline
WA_FISRGSTR1ITM_STR-TAXISNOTDEDUCTIBLE sy-vline
WA_FISRGSTR1ITM_STR-UMSKS sy-vline
WA_FISRGSTR1ITM_STR-SHKZG sy-vline
WA_FISRGSTR1ITM_STR-REBZG sy-vline
WA_FISRGSTR1ITM_STR-REBZJ sy-vline
WA_FISRGSTR1ITM_STR-REBZZ sy-vline
WA_FISRGSTR1ITM_STR-REBZT sy-vline
WA_FISRGSTR1ITM_STR-INVXBLNR sy-vline
WA_FISRGSTR1ITM_STR-BLDAT sy-vline
WA_FISRGSTR1ITM_STR-VATDATE sy-vline
WA_FISRGSTR1ITM_STR-INVDMBTR sy-vline
WA_FISRGSTR1ITM_STR-LAND1 sy-vline
WA_FISRGSTR1ITM_STR-LAND sy-vline
WA_FISRGSTR1ITM_STR-SDDOCUMENTCATEGORY sy-vline
WA_FISRGSTR1ITM_STR-TAXCOUNTRY sy-vline
WA_FISRGSTR1ITM_STR-NILTYPE sy-vline
WA_FISRGSTR1ITM_STR-RVCHRG sy-vline
WA_FISRGSTR1ITM_STR-IMPORT sy-vline
WA_FISRGSTR1ITM_STR-ORIGINALREFERENCEDOCUMENT sy-vline
WA_FISRGSTR1ITM_STR-COND_NAME sy-vline
WA_FISRGSTR1ITM_STR-HSN_SAC sy-vline
WA_FISRGSTR1ITM_STR-MATNR sy-vline
WA_FISRGSTR1ITM_STR-MENGE sy-vline
WA_FISRGSTR1ITM_STR-MEINS sy-vline
WA_FISRGSTR1ITM_STR-WERKS sy-vline
WA_FISRGSTR1ITM_STR-HKONT sy-vline
WA_FISRGSTR1ITM_STR-TEXT1 sy-vline
WA_FISRGSTR1ITM_STR-EDOC_IN_UQC sy-vline
WA_FISRGSTR1ITM_STR-CONDNAME sy-vline
WA_FISRGSTR1ITM_STR-KBETR sy-vline
WA_FISRGSTR1ITM_STR-DMBTR sy-vline
WA_FISRGSTR1ITM_STR-PLC_SUP sy-vline
WA_FISRGSTR1ITM_STR-GST_PART sy-vline
WA_FISRGSTR1ITM_STR-LEGAL_STATE_CODE sy-vline
WA_FISRGSTR1ITM_STR-TAXKD sy-vline
WA_FISRGSTR1ITM_STR-REGISTEREDIND sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.