ABAP Select data from SAP table ICAOPENITMLSTITM 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 ICAOPENITMLSTITM 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 ICAOPENITMLSTITM. 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 ICAOPENITMLSTITM 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_ICAOPENITMLSTITM TYPE STANDARD TABLE OF ICAOPENITMLSTITM,
      WA_ICAOPENITMLSTITM TYPE ICAOPENITMLSTITM,
      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: <ICAOPENITMLSTITM> TYPE ICAOPENITMLSTITM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ICAOPENITMLSTITM
*  INTO TABLE @DATA(IT_ICAOPENITMLSTITM2).
*--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_ICAOPENITMLSTITM INDEX 1 INTO DATA(WA_ICAOPENITMLSTITM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ICAOPENITMLSTITM ASSIGNING <ICAOPENITMLSTITM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ICAOPENITMLSTITM>-MANDT = 1.
<ICAOPENITMLSTITM>-CAOPENITEMLISTUUID = 1.
<ICAOPENITMLSTITM>-CADOCUMENTNUMBER = 1.
<ICAOPENITMLSTITM>-CAREPETITIONITEMNUMBER = 1.
<ICAOPENITMLSTITM>-CABPITEMNUMBER = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ICAOPENITMLSTITM-CASUBITEMNUMBER, sy-vline,
WA_ICAOPENITMLSTITM-COMPANYCODE, sy-vline,
WA_ICAOPENITMLSTITM-BUSINESSAREA, sy-vline,
WA_ICAOPENITMLSTITM-BUSINESSPLACE, sy-vline,
WA_ICAOPENITMLSTITM-SEGMENT, sy-vline,
WA_ICAOPENITMLSTITM-PROFITCENTER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ICAOPENITMLSTITM 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_ICAOPENITMLSTITM 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_ICAOPENITMLSTITM INTO WA_ICAOPENITMLSTITM. *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 CADOCUMENTNUMBER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ICAOPENITMLSTITM-CADOCUMENTNUMBER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ICAOPENITMLSTITM-CADOCUMENTNUMBER.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit EXCRT, internal->external for field CAEXCHANGERATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_ICAOPENITMLSTITM-CAEXCHANGERATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ICAOPENITMLSTITM-CAEXCHANGERATE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field CAREVENUEDISTRFINALRECIPIENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ICAOPENITMLSTITM-CAREVENUEDISTRFINALRECIPIENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ICAOPENITMLSTITM-CAREVENUEDISTRFINALRECIPIENT.
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_ICAOPENITMLSTITM_STR,
MANDT TYPE STRING,
CAOPENITEMLISTUUID TYPE STRING,
CADOCUMENTNUMBER TYPE STRING,
CAREPETITIONITEMNUMBER TYPE STRING,
CABPITEMNUMBER TYPE STRING,
CASUBITEMNUMBER TYPE STRING,
COMPANYCODE TYPE STRING,
BUSINESSAREA TYPE STRING,
BUSINESSPLACE TYPE STRING,
SEGMENT TYPE STRING,
PROFITCENTER TYPE STRING,
DIVISION TYPE STRING,
PERSONNELNUMBER TYPE STRING,
PARTNERCOMPANY TYPE STRING,
BUSINESSPARTNER TYPE STRING,
CACONTRACT TYPE STRING,
CAPROVIDERCONTRACTITEMNUMBER TYPE STRING,
CAADDITIONALCONTRACT TYPE STRING,
CONTRACTACCOUNT TYPE STRING,
CASUBAPPLICATION TYPE STRING,
ALTVCONTRACTACCTFORCOLLVBILLS TYPE STRING,
CARECONCILIATIONACCOUNT TYPE STRING,
CAAPPLICATIONAREA TYPE STRING,
CAMAINTRANSACTION TYPE STRING,
CASUBTRANSACTION TYPE STRING,
CAACCOUNTDETERMINATIONCODE TYPE STRING,
CADOUBTFULORVALUEADJMTCODE TYPE STRING,
CAACCOUNTASSIGNMENTCATEGORY TYPE STRING,
CAACCOUNTASSIGNMENT TYPE STRING,
CADOCUMENTTYPE TYPE STRING,
CAISDOWNPAYMENTREQUEST TYPE STRING,
CAITEMISONLYFORSETTLEMENT TYPE STRING,
CASTATISTICALITEMCODE TYPE STRING,
CABPITEMTEXT TYPE STRING,
CANUMBEROFREPETITIONITEMS TYPE STRING,
CAREPETITIONGROUP TYPE STRING,
CASTARTDATEOFBILLINGPERIOD TYPE STRING,
CAENDDATEOFBILLINGPERIOD TYPE STRING,
CAGROUPINGCODEFORBPITEMS TYPE STRING,
CAPERIODCODE TYPE STRING,
CACHANGEISFORBIDDEN TYPE STRING,
CAINTERESTCODE TYPE STRING,
CAROUNDINGITEMCODE TYPE STRING,
CARECEIVINGCOUNTRY TYPE STRING,
CAINTERNALPOSTINGREASONCODE TYPE STRING,
CAWORKFLOWCHECKREASON TYPE STRING,
CAWORKFLOWCHECKPROCESS TYPE STRING,
CANEGATIVEPOSTINGCONTROLCODE TYPE STRING,
CAPARTNERSETTLEMENTSTATUS TYPE STRING,
CAISPARTOFJOINTLIABILITY TYPE STRING,
CASUBSTITUTEDOCUMENTNUMBER TYPE STRING,
CASUBSTITUTEDOCUMENTCATEGORY TYPE STRING,
CASTATISTICALCODEOFORIGINITEM TYPE STRING,
CADOCUMENTNUMBEROFORIGINITEM TYPE STRING,
CAREFERENCEDOCUMENT TYPE STRING,
DOCUMENTDATE TYPE STRING,
CAPOSTINGDATE TYPE STRING,
CANETDUEDATE TYPE STRING,
CADEFERRALDATE TYPE STRING,
TRANSACTIONCURRENCY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
CAEXCHANGERATE TYPE STRING,
CAAMOUNTINLOCALCURRENCY TYPE STRING,
CAAMOUNTINTRANSACTIONCURRENCY TYPE STRING,
CAAMOUNTINSECONDCURRENCY TYPE STRING,
CAAMOUNTINTHIRDCURRENCY TYPE STRING,
CACASHDISCOUNTDUEDATE TYPE STRING,
CACASHDISCOUNTRATE TYPE STRING,
CAELIGIBLEAMOUNTFORCSHDISCOUNT TYPE STRING,
TAXCODE TYPE STRING,
CASUPPLEMENTARYTAXCODE TYPE STRING,
CATAXAMOUNTINLOCALCURRENCY TYPE STRING,
CATAXAMOUNTINTRANSCURRENCY TYPE STRING,
CATAXAMOUNTINSECONDCURRENCY TYPE STRING,
CATAXAMOUNTINTHIRDCURRENCY TYPE STRING,
CADOWNPAYMENTTAXACCOUNT TYPE STRING,
CADOWNPAYMENTOFFSETTAXACCOUNT TYPE STRING,
TAXJURISDICTION TYPE STRING,
CATAXDATE TYPE STRING,
WITHHOLDINGTAXCODE TYPE STRING,
CAWITHHOLDINGTAXSUPPLEMENT TYPE STRING,
CAWITHHOLDINGTAXCATEGORY TYPE STRING,
CABASEAMOUNTFORWITHHOLDINGTAX TYPE STRING,
CAWITHHOLDINGTAXAMOUNT TYPE STRING,
CAWITHHOLDINGTAXPERCENTAGE TYPE STRING,
WITHHOLDINGTAXCERTIFICATE TYPE STRING,
CAOTHERTAXCODE TYPE STRING,
CAGROUPINGCODEFORTAXITEMS TYPE STRING,
CATAXPORTIONINLOCALCURRENCY TYPE STRING,
CATAXPORTIONINTRANSCURRENCY TYPE STRING,
CATAXISCALCULATEDEXTERNALLY TYPE STRING,
CAPAYMENTMETHOD TYPE STRING,
CAPAYMENTCOMPANYCODE TYPE STRING,
CAGROUPINGFORPAYMENT TYPE STRING,
CAPAYMENTSPECIFICATIONCATEGORY TYPE STRING,
CACLEARINGSTATUS TYPE STRING,
CACLEARINGDATE TYPE STRING,
CACLEARINGDOCUMENTNUMBER TYPE STRING,
CAPOSTINGDATEOFCLEARINGDOC TYPE STRING,
CACLEARINGREASON TYPE STRING,
CACLEARINGCURRENCY TYPE STRING,
CACLEARINGAMOUNTINCLEARINGCRCY TYPE STRING,
CATAXAMOUNTINCLEARINGCRCY TYPE STRING,
CACASHDISCAMOUNTINCLEARINGCRCY TYPE STRING,
CAVALUEDATEFORCLEARING TYPE STRING,
CACLEARINGRESTRICTIONCODE TYPE STRING,
CACLEARINGPOSTINGISRESET TYPE STRING,
CAITEMISWITHDRAWN TYPE STRING,
CAITEMISEXCLUDEDFROMDUNNING TYPE STRING,
CADUNNINGPROCEDURE TYPE STRING,
CAGRPGCODEFORTRANSFTOCOLLAGCY TYPE STRING,
CAISINCLUDEDINCOLLECTIONCASE TYPE STRING,
CASHPLANNINGGROUP TYPE STRING,
PLANNINGLEVEL TYPE STRING,
CAADDITIONALDAYSFORCASHMGMT TYPE STRING,
PLANNEDAMTINTRANSACTIONCRCY TYPE STRING,
CAALTVBPFORPAYMENT TYPE STRING,
CABANKOFALTVBPFORPAYMENT TYPE STRING,
CAADDRESSOFALTVBPFORPAYMENT TYPE STRING,
CACARDOFALTVBPFORPAYMENT TYPE STRING,
CAGLPOSTINGCURRENCY TYPE STRING,
CAGLPOSTINGAMOUNT TYPE STRING,
CAGLPOSTINGTAXAMOUNT TYPE STRING,
CAISSEPARATELINEITEMINGL TYPE STRING,
CAISCASHFLOWITEM TYPE STRING,
CACASHFLOWACCOUNT TYPE STRING,
CACASHFLOWCOMPANYCODE TYPE STRING,
CAPAYMENTPRENOTIFICATIONCODE TYPE STRING,
CASEPAPRENOTIFICATIONNUMBER TYPE STRING,
CASEPAPRENOTIFORIGINCODE TYPE STRING,
CASEPAPRENOTIFEXECUTIONDATE TYPE STRING,
CASEPAPRENOTIFICATIONRQMTCODE TYPE STRING,
CAREVENUEDISTRFINALRECIPIENT TYPE STRING,
CAREVENUEDISTRCURRENTSTATUS TYPE STRING,
CAREVENUEDISTRLASTSTATUS TYPE STRING,
CACURRENTFACTORINGSTATUSOFRBL TYPE STRING,
CAFACTORINGCHECKSTSFORCLRGINFO TYPE STRING,
SEPAMANDATECAINTERNALID TYPE STRING,
CONTROLLINGAREA TYPE STRING,
CHARTOFACCOUNTS TYPE STRING,
COUNTRY TYPE STRING,
TAXCALCULATIONPROCEDURE TYPE STRING,END OF T_EKKO_STR. DATA: WA_ICAOPENITMLSTITM_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_ICAOPENITMLSTITM_STR-MANDT sy-vline
WA_ICAOPENITMLSTITM_STR-CAOPENITEMLISTUUID sy-vline
WA_ICAOPENITMLSTITM_STR-CADOCUMENTNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CAREPETITIONITEMNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CABPITEMNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CASUBITEMNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-COMPANYCODE sy-vline
WA_ICAOPENITMLSTITM_STR-BUSINESSAREA sy-vline
WA_ICAOPENITMLSTITM_STR-BUSINESSPLACE sy-vline
WA_ICAOPENITMLSTITM_STR-SEGMENT sy-vline
WA_ICAOPENITMLSTITM_STR-PROFITCENTER sy-vline
WA_ICAOPENITMLSTITM_STR-DIVISION sy-vline
WA_ICAOPENITMLSTITM_STR-PERSONNELNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-PARTNERCOMPANY sy-vline
WA_ICAOPENITMLSTITM_STR-BUSINESSPARTNER sy-vline
WA_ICAOPENITMLSTITM_STR-CACONTRACT sy-vline
WA_ICAOPENITMLSTITM_STR-CAPROVIDERCONTRACTITEMNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CAADDITIONALCONTRACT sy-vline
WA_ICAOPENITMLSTITM_STR-CONTRACTACCOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CASUBAPPLICATION sy-vline
WA_ICAOPENITMLSTITM_STR-ALTVCONTRACTACCTFORCOLLVBILLS sy-vline
WA_ICAOPENITMLSTITM_STR-CARECONCILIATIONACCOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CAAPPLICATIONAREA sy-vline
WA_ICAOPENITMLSTITM_STR-CAMAINTRANSACTION sy-vline
WA_ICAOPENITMLSTITM_STR-CASUBTRANSACTION sy-vline
WA_ICAOPENITMLSTITM_STR-CAACCOUNTDETERMINATIONCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CADOUBTFULORVALUEADJMTCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAACCOUNTASSIGNMENTCATEGORY sy-vline
WA_ICAOPENITMLSTITM_STR-CAACCOUNTASSIGNMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CADOCUMENTTYPE sy-vline
WA_ICAOPENITMLSTITM_STR-CAISDOWNPAYMENTREQUEST sy-vline
WA_ICAOPENITMLSTITM_STR-CAITEMISONLYFORSETTLEMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CASTATISTICALITEMCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CABPITEMTEXT sy-vline
WA_ICAOPENITMLSTITM_STR-CANUMBEROFREPETITIONITEMS sy-vline
WA_ICAOPENITMLSTITM_STR-CAREPETITIONGROUP sy-vline
WA_ICAOPENITMLSTITM_STR-CASTARTDATEOFBILLINGPERIOD sy-vline
WA_ICAOPENITMLSTITM_STR-CAENDDATEOFBILLINGPERIOD sy-vline
WA_ICAOPENITMLSTITM_STR-CAGROUPINGCODEFORBPITEMS sy-vline
WA_ICAOPENITMLSTITM_STR-CAPERIODCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CACHANGEISFORBIDDEN sy-vline
WA_ICAOPENITMLSTITM_STR-CAINTERESTCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAROUNDINGITEMCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CARECEIVINGCOUNTRY sy-vline
WA_ICAOPENITMLSTITM_STR-CAINTERNALPOSTINGREASONCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAWORKFLOWCHECKREASON sy-vline
WA_ICAOPENITMLSTITM_STR-CAWORKFLOWCHECKPROCESS sy-vline
WA_ICAOPENITMLSTITM_STR-CANEGATIVEPOSTINGCONTROLCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAPARTNERSETTLEMENTSTATUS sy-vline
WA_ICAOPENITMLSTITM_STR-CAISPARTOFJOINTLIABILITY sy-vline
WA_ICAOPENITMLSTITM_STR-CASUBSTITUTEDOCUMENTNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CASUBSTITUTEDOCUMENTCATEGORY sy-vline
WA_ICAOPENITMLSTITM_STR-CASTATISTICALCODEOFORIGINITEM sy-vline
WA_ICAOPENITMLSTITM_STR-CADOCUMENTNUMBEROFORIGINITEM sy-vline
WA_ICAOPENITMLSTITM_STR-CAREFERENCEDOCUMENT sy-vline
WA_ICAOPENITMLSTITM_STR-DOCUMENTDATE sy-vline
WA_ICAOPENITMLSTITM_STR-CAPOSTINGDATE sy-vline
WA_ICAOPENITMLSTITM_STR-CANETDUEDATE sy-vline
WA_ICAOPENITMLSTITM_STR-CADEFERRALDATE sy-vline
WA_ICAOPENITMLSTITM_STR-TRANSACTIONCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-COMPANYCODECURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAEXCHANGERATE sy-vline
WA_ICAOPENITMLSTITM_STR-CAAMOUNTINLOCALCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAAMOUNTINTRANSACTIONCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAAMOUNTINSECONDCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAAMOUNTINTHIRDCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CACASHDISCOUNTDUEDATE sy-vline
WA_ICAOPENITMLSTITM_STR-CACASHDISCOUNTRATE sy-vline
WA_ICAOPENITMLSTITM_STR-CAELIGIBLEAMOUNTFORCSHDISCOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-TAXCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CASUPPLEMENTARYTAXCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXAMOUNTINLOCALCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXAMOUNTINTRANSCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXAMOUNTINSECONDCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXAMOUNTINTHIRDCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CADOWNPAYMENTTAXACCOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CADOWNPAYMENTOFFSETTAXACCOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-TAXJURISDICTION sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXDATE sy-vline
WA_ICAOPENITMLSTITM_STR-WITHHOLDINGTAXCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAWITHHOLDINGTAXSUPPLEMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CAWITHHOLDINGTAXCATEGORY sy-vline
WA_ICAOPENITMLSTITM_STR-CABASEAMOUNTFORWITHHOLDINGTAX sy-vline
WA_ICAOPENITMLSTITM_STR-CAWITHHOLDINGTAXAMOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CAWITHHOLDINGTAXPERCENTAGE sy-vline
WA_ICAOPENITMLSTITM_STR-WITHHOLDINGTAXCERTIFICATE sy-vline
WA_ICAOPENITMLSTITM_STR-CAOTHERTAXCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAGROUPINGCODEFORTAXITEMS sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXPORTIONINLOCALCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXPORTIONINTRANSCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXISCALCULATEDEXTERNALLY sy-vline
WA_ICAOPENITMLSTITM_STR-CAPAYMENTMETHOD sy-vline
WA_ICAOPENITMLSTITM_STR-CAPAYMENTCOMPANYCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAGROUPINGFORPAYMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CAPAYMENTSPECIFICATIONCATEGORY sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGSTATUS sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGDATE sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGDOCUMENTNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CAPOSTINGDATEOFCLEARINGDOC sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGREASON sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGAMOUNTINCLEARINGCRCY sy-vline
WA_ICAOPENITMLSTITM_STR-CATAXAMOUNTINCLEARINGCRCY sy-vline
WA_ICAOPENITMLSTITM_STR-CACASHDISCAMOUNTINCLEARINGCRCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAVALUEDATEFORCLEARING sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGRESTRICTIONCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CACLEARINGPOSTINGISRESET sy-vline
WA_ICAOPENITMLSTITM_STR-CAITEMISWITHDRAWN sy-vline
WA_ICAOPENITMLSTITM_STR-CAITEMISEXCLUDEDFROMDUNNING sy-vline
WA_ICAOPENITMLSTITM_STR-CADUNNINGPROCEDURE sy-vline
WA_ICAOPENITMLSTITM_STR-CAGRPGCODEFORTRANSFTOCOLLAGCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAISINCLUDEDINCOLLECTIONCASE sy-vline
WA_ICAOPENITMLSTITM_STR-CASHPLANNINGGROUP sy-vline
WA_ICAOPENITMLSTITM_STR-PLANNINGLEVEL sy-vline
WA_ICAOPENITMLSTITM_STR-CAADDITIONALDAYSFORCASHMGMT sy-vline
WA_ICAOPENITMLSTITM_STR-PLANNEDAMTINTRANSACTIONCRCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAALTVBPFORPAYMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CABANKOFALTVBPFORPAYMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CAADDRESSOFALTVBPFORPAYMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CACARDOFALTVBPFORPAYMENT sy-vline
WA_ICAOPENITMLSTITM_STR-CAGLPOSTINGCURRENCY sy-vline
WA_ICAOPENITMLSTITM_STR-CAGLPOSTINGAMOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CAGLPOSTINGTAXAMOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CAISSEPARATELINEITEMINGL sy-vline
WA_ICAOPENITMLSTITM_STR-CAISCASHFLOWITEM sy-vline
WA_ICAOPENITMLSTITM_STR-CACASHFLOWACCOUNT sy-vline
WA_ICAOPENITMLSTITM_STR-CACASHFLOWCOMPANYCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAPAYMENTPRENOTIFICATIONCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CASEPAPRENOTIFICATIONNUMBER sy-vline
WA_ICAOPENITMLSTITM_STR-CASEPAPRENOTIFORIGINCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CASEPAPRENOTIFEXECUTIONDATE sy-vline
WA_ICAOPENITMLSTITM_STR-CASEPAPRENOTIFICATIONRQMTCODE sy-vline
WA_ICAOPENITMLSTITM_STR-CAREVENUEDISTRFINALRECIPIENT sy-vline
WA_ICAOPENITMLSTITM_STR-CAREVENUEDISTRCURRENTSTATUS sy-vline
WA_ICAOPENITMLSTITM_STR-CAREVENUEDISTRLASTSTATUS sy-vline
WA_ICAOPENITMLSTITM_STR-CACURRENTFACTORINGSTATUSOFRBL sy-vline
WA_ICAOPENITMLSTITM_STR-CAFACTORINGCHECKSTSFORCLRGINFO sy-vline
WA_ICAOPENITMLSTITM_STR-SEPAMANDATECAINTERNALID sy-vline
WA_ICAOPENITMLSTITM_STR-CONTROLLINGAREA sy-vline
WA_ICAOPENITMLSTITM_STR-CHARTOFACCOUNTS sy-vline
WA_ICAOPENITMLSTITM_STR-COUNTRY sy-vline
WA_ICAOPENITMLSTITM_STR-TAXCALCULATIONPROCEDURE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.