ABAP Select data from SAP table FINS_ACDOC_EXT_IN 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 FINS_ACDOC_EXT_IN 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 FINS_ACDOC_EXT_IN. 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 FINS_ACDOC_EXT_IN 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_FINS_ACDOC_EXT_IN TYPE STANDARD TABLE OF FINS_ACDOC_EXT_IN,
      WA_FINS_ACDOC_EXT_IN TYPE FINS_ACDOC_EXT_IN,
      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: <FINS_ACDOC_EXT_IN> TYPE FINS_ACDOC_EXT_IN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FINS_ACDOC_EXT_IN
*  INTO TABLE @DATA(IT_FINS_ACDOC_EXT_IN2).
*--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_FINS_ACDOC_EXT_IN INDEX 1 INTO DATA(WA_FINS_ACDOC_EXT_IN2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FINS_ACDOC_EXT_IN ASSIGNING <FINS_ACDOC_EXT_IN>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FINS_ACDOC_EXT_IN>-LEDGER = 1.
<FINS_ACDOC_EXT_IN>-COMPANYCODE = 1.
<FINS_ACDOC_EXT_IN>-FISCALYEAR = 1.
<FINS_ACDOC_EXT_IN>-ACCOUNTINGDOCUMENT = 1.
<FINS_ACDOC_EXT_IN>-LEDGERGLLINEITEM = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FINS_ACDOC_EXT_IN-ACCOUNTASSIGNMENT, sy-vline,
WA_FINS_ACDOC_EXT_IN-ACCOUNTASSIGNMENTTYPE, sy-vline,
WA_FINS_ACDOC_EXT_IN-PARTNERACCOUNTASSIGNMENT, sy-vline,
WA_FINS_ACDOC_EXT_IN-PARTNERACCOUNTASSIGNMENTTYPE, sy-vline,
WA_FINS_ACDOC_EXT_IN-ACCOUNTASSIGNMENTNUMBER, sy-vline,
WA_FINS_ACDOC_EXT_IN-ACCOUNTINGDOCCREATEDBYUSER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FINS_ACDOC_EXT_IN 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_FINS_ACDOC_EXT_IN 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_FINS_ACDOC_EXT_IN INTO WA_FINS_ACDOC_EXT_IN. *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 LEDGER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-LEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-LEDGER.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit CUNIT, internal->external for field BASEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-BASEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-BASEUNIT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field MATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-MATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-MATERIAL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit KONPD, internal->external for field PROJECTINTERNALID CALL FUNCTION 'CONVERSION_EXIT_KONPD_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-PROJECTINTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-PROJECTINTERNALID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field PROJECTEXTERNALID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-PROJECTEXTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-PROJECTEXTERNALID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit KONPD, internal->external for field PARTNERPROJECTINTERNALID CALL FUNCTION 'CONVERSION_EXIT_KONPD_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-PARTNERPROJECTINTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-PARTNERPROJECTINTERNALID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field PARTNERPROJECTEXTERNALID CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-PARTNERPROJECTEXTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-PARTNERPROJECTEXTERNALID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field WBSELEMENTINTERNALID CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-WBSELEMENTINTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-WBSELEMENTINTERNALID.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit MATN1, internal->external for field SOLDMATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-SOLDMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-SOLDMATERIAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SERVICEDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FINS_ACDOC_EXT_IN-SERVICEDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FINS_ACDOC_EXT_IN-SERVICEDOCUMENT.
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_FINS_ACDOC_EXT_IN_STR,
LEDGER TYPE STRING,
COMPANYCODE TYPE STRING,
FISCALYEAR TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
LEDGERGLLINEITEM TYPE STRING,
ACCOUNTASSIGNMENT TYPE STRING,
ACCOUNTASSIGNMENTTYPE TYPE STRING,
PARTNERACCOUNTASSIGNMENT TYPE STRING,
PARTNERACCOUNTASSIGNMENTTYPE TYPE STRING,
ACCOUNTASSIGNMENTNUMBER TYPE STRING,
ACCOUNTINGDOCCREATEDBYUSER TYPE STRING,
ACCOUNTINGDOCEXTERNALREFERENCE TYPE STRING,
ACCOUNTINGDOCUMENTCATEGORY TYPE STRING,
ACCOUNTINGDOCUMENTCLASS TYPE STRING,
ACCOUNTINGDOCUMENTITEM TYPE STRING,
ACCOUNTINGDOCUMENTTYPE TYPE STRING,
ALTERNATIVEGLACCOUNT TYPE STRING,
ASSETTRANSACTIONTYPE TYPE STRING,
ASSETVALUEDATE TYPE STRING,
ASSIGNMENTREFERENCE TYPE STRING,
BALANCETRANSACTIONCURRENCY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
TRANSACTIONCURRENCY TYPE STRING,
AMOUNTINBALANCETRANSACCRCY TYPE STRING,
AMOUNTINCOMPANYCODECURRENCY TYPE STRING,
AMOUNTINTRANSACTIONCURRENCY TYPE STRING,
BASEUNIT TYPE STRING,
BRANCHACCOUNT TYPE STRING,
BUSINESSAREA TYPE STRING,
BUSINESSPLACE TYPE STRING,
BUSINESSTRANSACTIONTYPE TYPE STRING,
CLEARINGACCOUNTINGDOCUMENT TYPE STRING,
CLEARINGDATE TYPE STRING,
CLEARINGDOCFISCALYEAR TYPE STRING,
CONSUMPTIONPOSTING TYPE STRING,
COSTCENTER TYPE STRING,
COSTCTRACTIVITYTYPE TYPE STRING,
COSTOBJECT TYPE STRING,
COSTORIGINGROUP TYPE STRING,
CUSTOMER TYPE STRING,
DEBITCREDITCODE TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
DIVISION TYPE STRING,
DOCUMENTDATE TYPE STRING,
POSTINGDATE TYPE STRING,
EXCHANGERATEDATE TYPE STRING,
FINANCIALACCOUNTTYPE TYPE STRING,
FISCALPERIOD TYPE STRING,
FIXEDASSET TYPE STRING,
FOLLOWONDOCUMENTTYPE TYPE STRING,
FUNCTIONALAREA TYPE STRING,
GLACCOUNT TYPE STRING,
GOODSMOVEMENTREFDOCTYPE TYPE STRING,
GOODSMOVEMENTTYPE TYPE STRING,
HOUSEBANK TYPE STRING,
HOUSEBANKACCOUNT TYPE STRING,
INTERCOMPANYTRANSACTION TYPE STRING,
INVOICEITEMREFERENCE TYPE STRING,
INVOICEREFERENCE TYPE STRING,
INVOICEREFERENCEFISCALYEAR TYPE STRING,
ISAUTOMATICALLYCREATED TYPE STRING,
ISMATERIALRELATEDORIGIN TYPE STRING,
ISNEGATIVEPOSTING TYPE STRING,
ISNOTCASHDISCOUNTLIABLE TYPE STRING,
ISREVERSALDOCUMENT TYPE STRING,
ISSALESRELATED TYPE STRING,
LEDGERGROUP TYPE STRING,
MASTERFIXEDASSET TYPE STRING,
MATERIAL TYPE STRING,
OFFSETTINGACCOUNT TYPE STRING,
ORDERCATEGORY TYPE STRING,
ORDERID TYPE STRING,
ORDERINTERNALBILLOFOPERATIONS TYPE STRING,
ORDERINTBILLOFOPERATIONSITEM TYPE STRING,
PARTNERBUSINESSAREA TYPE STRING,
PARTNERCOMPANY TYPE STRING,
PARTNERFUNCTIONALAREA TYPE STRING,
PARTNERPROFITCENTER TYPE STRING,
PARTNERSEGMENT TYPE STRING,
PERSONNELNUMBER TYPE STRING,
PLANT TYPE STRING,
POSTINGKEY TYPE STRING,
PRODCOSTESTNUMBER TYPE STRING,
PROFITABILITYSEGMENT TYPE STRING,
PROFITCENTER TYPE STRING,
PROJECTNETWORK TYPE STRING,
PURCHASINGDOCUMENT TYPE STRING,
PURCHASINGDOCUMENTITEM TYPE STRING,
QUANTITYINBASEUNIT TYPE STRING,
REFERENCE1IDBYBUSINESSPARTNER TYPE STRING,
REFERENCE2IDBYBUSINESSPARTNER TYPE STRING,
REFERENCE3IDBYBUSINESSPARTNER TYPE STRING,
REFERENCE1INDOCUMENTHEADER TYPE STRING,
REFERENCE2INDOCUMENTHEADER TYPE STRING,
REFERENCEDOCUMENTLOGICALSYSTEM TYPE STRING,
REFERENCEDOCUMENTTYPE TYPE STRING,
ORIGINALREFERENCEDOCUMENT TYPE STRING,
REVERSEDOCUMENT TYPE STRING,
REVERSEDOCUMENTFISCALYEAR TYPE STRING,
SALESORDER TYPE STRING,
SALESORDERITEM TYPE STRING,
SALESORGANIZATION TYPE STRING,
SEGMENT TYPE STRING,
SETTLEMENTFISCALYEARPERIOD TYPE STRING,
SETTLEMENTREFERENCEDATE TYPE STRING,
SPECIALGLACCOUNTASSIGNMENT TYPE STRING,
SPECIALGLCODE TYPE STRING,
SUPPLIER TYPE STRING,
TAXCODE TYPE STRING,
TAXDETERMINATIONDATE TYPE STRING,
TAXJURISDICTION TYPE STRING,
TRANSACTIONTYPEDETERMINATION TYPE STRING,
VALUATIONAREA TYPE STRING,
VALUATIONCLASS TYPE STRING,
VALUATIONTYPE TYPE STRING,
PROJECTINTERNALID TYPE STRING,
PROJECTEXTERNALID TYPE STRING,
PARTNERPROJECTINTERNALID TYPE STRING,
PARTNERPROJECTEXTERNALID TYPE STRING,
WBSELEMENTEXTERNALID TYPE STRING,
WBSELEMENTINTERNALID TYPE STRING,
WORKITEM TYPE STRING,
DOCUMENTITEMTEXT TYPE STRING,
CUSTOMERGROUP TYPE STRING,
BILLTOPARTY TYPE STRING,
SHIPTOPARTY TYPE STRING,
CUSTOMERSUPPLIERCOUNTRY TYPE STRING,
CUSTOMERSUPPLIERINDUSTRY TYPE STRING,
SALESDISTRICT TYPE STRING,
MATERIALGROUP TYPE STRING,
SOLDMATERIAL TYPE STRING,
BILLINGDOCUMENTTYPE TYPE STRING,
CONTROLLINGAREA TYPE STRING,
SERVICEDOCUMENTTYPE TYPE STRING,
SERVICEDOCUMENT TYPE STRING,
SERVICEDOCUMENTITEM TYPE STRING,
DUMMY_INCL_EEW_COBL TYPE STRING,
ROWINDEX TYPE STRING,
ACDOC_EEW_DUMMY TYPE STRING,END OF T_EKKO_STR. DATA: WA_FINS_ACDOC_EXT_IN_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_FINS_ACDOC_EXT_IN_STR-LEDGER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-COMPANYCODE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-FISCALYEAR sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-LEDGERGLLINEITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTASSIGNMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTASSIGNMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERACCOUNTASSIGNMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERACCOUNTASSIGNMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTASSIGNMENTNUMBER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCCREATEDBYUSER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCEXTERNALREFERENCE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCUMENTCATEGORY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCUMENTCLASS sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCUMENTITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACCOUNTINGDOCUMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ALTERNATIVEGLACCOUNT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ASSETTRANSACTIONTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ASSETVALUEDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ASSIGNMENTREFERENCE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BALANCETRANSACTIONCURRENCY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-COMPANYCODECURRENCY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-TRANSACTIONCURRENCY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-AMOUNTINBALANCETRANSACCRCY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-AMOUNTINCOMPANYCODECURRENCY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-AMOUNTINTRANSACTIONCURRENCY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BASEUNIT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BRANCHACCOUNT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BUSINESSAREA sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BUSINESSPLACE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BUSINESSTRANSACTIONTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CLEARINGACCOUNTINGDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CLEARINGDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CLEARINGDOCFISCALYEAR sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CONSUMPTIONPOSTING sy-vline
WA_FINS_ACDOC_EXT_IN_STR-COSTCENTER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-COSTCTRACTIVITYTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-COSTOBJECT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-COSTORIGINGROUP sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CUSTOMER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-DEBITCREDITCODE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-DISTRIBUTIONCHANNEL sy-vline
WA_FINS_ACDOC_EXT_IN_STR-DIVISION sy-vline
WA_FINS_ACDOC_EXT_IN_STR-DOCUMENTDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-POSTINGDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-EXCHANGERATEDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-FINANCIALACCOUNTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-FISCALPERIOD sy-vline
WA_FINS_ACDOC_EXT_IN_STR-FIXEDASSET sy-vline
WA_FINS_ACDOC_EXT_IN_STR-FOLLOWONDOCUMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-FUNCTIONALAREA sy-vline
WA_FINS_ACDOC_EXT_IN_STR-GLACCOUNT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-GOODSMOVEMENTREFDOCTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-GOODSMOVEMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-HOUSEBANK sy-vline
WA_FINS_ACDOC_EXT_IN_STR-HOUSEBANKACCOUNT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-INTERCOMPANYTRANSACTION sy-vline
WA_FINS_ACDOC_EXT_IN_STR-INVOICEITEMREFERENCE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-INVOICEREFERENCE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-INVOICEREFERENCEFISCALYEAR sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ISAUTOMATICALLYCREATED sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ISMATERIALRELATEDORIGIN sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ISNEGATIVEPOSTING sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ISNOTCASHDISCOUNTLIABLE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ISREVERSALDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ISSALESRELATED sy-vline
WA_FINS_ACDOC_EXT_IN_STR-LEDGERGROUP sy-vline
WA_FINS_ACDOC_EXT_IN_STR-MASTERFIXEDASSET sy-vline
WA_FINS_ACDOC_EXT_IN_STR-MATERIAL sy-vline
WA_FINS_ACDOC_EXT_IN_STR-OFFSETTINGACCOUNT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ORDERCATEGORY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ORDERID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ORDERINTERNALBILLOFOPERATIONS sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ORDERINTBILLOFOPERATIONSITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERBUSINESSAREA sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERCOMPANY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERFUNCTIONALAREA sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERPROFITCENTER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERSEGMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PERSONNELNUMBER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PLANT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-POSTINGKEY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PRODCOSTESTNUMBER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PROFITABILITYSEGMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PROFITCENTER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PROJECTNETWORK sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PURCHASINGDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PURCHASINGDOCUMENTITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-QUANTITYINBASEUNIT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCE1IDBYBUSINESSPARTNER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCE2IDBYBUSINESSPARTNER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCE3IDBYBUSINESSPARTNER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCE1INDOCUMENTHEADER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCE2INDOCUMENTHEADER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCEDOCUMENTLOGICALSYSTEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REFERENCEDOCUMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ORIGINALREFERENCEDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REVERSEDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-REVERSEDOCUMENTFISCALYEAR sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SALESORDER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SALESORDERITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SALESORGANIZATION sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SEGMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SETTLEMENTFISCALYEARPERIOD sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SETTLEMENTREFERENCEDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SPECIALGLACCOUNTASSIGNMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SPECIALGLCODE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SUPPLIER sy-vline
WA_FINS_ACDOC_EXT_IN_STR-TAXCODE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-TAXDETERMINATIONDATE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-TAXJURISDICTION sy-vline
WA_FINS_ACDOC_EXT_IN_STR-TRANSACTIONTYPEDETERMINATION sy-vline
WA_FINS_ACDOC_EXT_IN_STR-VALUATIONAREA sy-vline
WA_FINS_ACDOC_EXT_IN_STR-VALUATIONCLASS sy-vline
WA_FINS_ACDOC_EXT_IN_STR-VALUATIONTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PROJECTINTERNALID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PROJECTEXTERNALID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERPROJECTINTERNALID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-PARTNERPROJECTEXTERNALID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-WBSELEMENTEXTERNALID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-WBSELEMENTINTERNALID sy-vline
WA_FINS_ACDOC_EXT_IN_STR-WORKITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-DOCUMENTITEMTEXT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CUSTOMERGROUP sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BILLTOPARTY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SHIPTOPARTY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CUSTOMERSUPPLIERCOUNTRY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CUSTOMERSUPPLIERINDUSTRY sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SALESDISTRICT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-MATERIALGROUP sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SOLDMATERIAL sy-vline
WA_FINS_ACDOC_EXT_IN_STR-BILLINGDOCUMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-CONTROLLINGAREA sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SERVICEDOCUMENTTYPE sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SERVICEDOCUMENT sy-vline
WA_FINS_ACDOC_EXT_IN_STR-SERVICEDOCUMENTITEM sy-vline
WA_FINS_ACDOC_EXT_IN_STR-DUMMY_INCL_EEW_COBL sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ROWINDEX sy-vline
WA_FINS_ACDOC_EXT_IN_STR-ACDOC_EEW_DUMMY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.