ABAP Select data from SAP table ISDBILLINGDOC 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 ISDBILLINGDOC 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 ISDBILLINGDOC. 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 ISDBILLINGDOC 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_ISDBILLINGDOC TYPE STANDARD TABLE OF ISDBILLINGDOC,
      WA_ISDBILLINGDOC TYPE ISDBILLINGDOC,
      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: <ISDBILLINGDOC> TYPE ISDBILLINGDOC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ISDBILLINGDOC
*  INTO TABLE @DATA(IT_ISDBILLINGDOC2).
*--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_ISDBILLINGDOC INDEX 1 INTO DATA(WA_ISDBILLINGDOC2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ISDBILLINGDOC ASSIGNING <ISDBILLINGDOC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ISDBILLINGDOC>-MANDT = 1.
<ISDBILLINGDOC>-BILLINGDOCUMENT = 1.
<ISDBILLINGDOC>-SDDOCUMENTCATEGORY = 1.
<ISDBILLINGDOC>-BILLINGDOCUMENTCATEGORY = 1.
<ISDBILLINGDOC>-BILLINGDOCUMENTTYPE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ISDBILLINGDOC-CREATEDBYUSER, sy-vline,
WA_ISDBILLINGDOC-CREATIONDATE, sy-vline,
WA_ISDBILLINGDOC-CREATIONTIME, sy-vline,
WA_ISDBILLINGDOC-LASTCHANGEDATE, sy-vline,
WA_ISDBILLINGDOC-LASTCHANGEDATETIME, sy-vline,
WA_ISDBILLINGDOC-LOGICALSYSTEM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ISDBILLINGDOC 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_ISDBILLINGDOC 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_ISDBILLINGDOC INTO WA_ISDBILLINGDOC. *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 BILLINGDOCUMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ISDBILLINGDOC-BILLINGDOCUMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISDBILLINGDOC-BILLINGDOCUMENT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field CUSTOMERREBATEAGREEMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ISDBILLINGDOC-CUSTOMERREBATEAGREEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ISDBILLINGDOC-CUSTOMERREBATEAGREEMENT.
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_ISDBILLINGDOC_STR,
MANDT TYPE STRING,
BILLINGDOCUMENT TYPE STRING,
SDDOCUMENTCATEGORY TYPE STRING,
BILLINGDOCUMENTCATEGORY TYPE STRING,
BILLINGDOCUMENTTYPE TYPE STRING,
CREATEDBYUSER TYPE STRING,
CREATIONDATE TYPE STRING,
CREATIONTIME TYPE STRING,
LASTCHANGEDATE TYPE STRING,
LASTCHANGEDATETIME TYPE STRING,
LOGICALSYSTEM TYPE STRING,
SALESORGANIZATION TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
DIVISION TYPE STRING,
BILLINGDOCUMENTDATE TYPE STRING,
BILLINGDOCUMENTISCANCELLED TYPE STRING,
CANCELLEDBILLINGDOCUMENT TYPE STRING,
BILLINGDOCCOMBINATIONCRITERIA TYPE STRING,
MANUALINVOICEMAINTISRELEVANT TYPE STRING,
NMBROFPAGES TYPE STRING,
ISINTRASTATREPORTINGRELEVANT TYPE STRING,
ISINTRASTATREPORTINGEXCLUDED TYPE STRING,
BILLINGDOCUMENTISTEMPORARY TYPE STRING,
TOTALNETAMOUNT TYPE STRING,
TRANSACTIONCURRENCY TYPE STRING,
STATISTICSCURRENCY TYPE STRING,
TOTALTAXAMOUNT TYPE STRING,
CUSTOMERPRICEGROUP TYPE STRING,
PRICELISTTYPE TYPE STRING,
TAXDEPARTURECOUNTRY TYPE STRING,
VATREGISTRATION TYPE STRING,
VATREGISTRATIONORIGIN TYPE STRING,
VATREGISTRATIONCOUNTRY TYPE STRING,
HIERARCHYTYPEPRICING TYPE STRING,
CUSTOMERTAXCLASSIFICATION1 TYPE STRING,
CUSTOMERTAXCLASSIFICATION2 TYPE STRING,
CUSTOMERTAXCLASSIFICATION3 TYPE STRING,
CUSTOMERTAXCLASSIFICATION4 TYPE STRING,
CUSTOMERTAXCLASSIFICATION5 TYPE STRING,
CUSTOMERTAXCLASSIFICATION6 TYPE STRING,
CUSTOMERTAXCLASSIFICATION7 TYPE STRING,
CUSTOMERTAXCLASSIFICATION8 TYPE STRING,
CUSTOMERTAXCLASSIFICATION9 TYPE STRING,
ISEUTRIANGULARDEAL TYPE STRING,
SDPRICINGPROCEDURE TYPE STRING,
SHIPPINGCONDITION TYPE STRING,
PLANTSUPPLIER TYPE STRING,
INCOTERMSVERSION TYPE STRING,
INCOTERMSCLASSIFICATION TYPE STRING,
INCOTERMSTRANSFERLOCATION TYPE STRING,
INCOTERMSLOCATION1 TYPE STRING,
INCOTERMSLOCATION2 TYPE STRING,
PAYERPARTY TYPE STRING,
CONTRACTACCOUNT TYPE STRING,
CUSTOMERPAYMENTTERMS TYPE STRING,
PAYMENTMETHOD TYPE STRING,
PAYMENTREFERENCE TYPE STRING,
FIXEDVALUEDATE TYPE STRING,
ADDITIONALVALUEDAYS TYPE STRING,
SEPAMANDATE TYPE STRING,
COMPANYCODE TYPE STRING,
FISCALYEAR TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
FISCALPERIOD TYPE STRING,
CUSTOMERACCOUNTASSIGNMENTGROUP TYPE STRING,
ACCOUNTINGEXCHANGERATEISSET TYPE STRING,
ACCOUNTINGEXCHANGERATE TYPE STRING,
EXCHANGERATEDATE TYPE STRING,
EXCHANGERATETYPE TYPE STRING,
DOCUMENTREFERENCEID TYPE STRING,
ASSIGNMENTREFERENCE TYPE STRING,
DUNNINGAREA TYPE STRING,
DUNNINGBLOCKINGREASON TYPE STRING,
DUNNINGKEY TYPE STRING,
INTERNALFINANCIALDOCUMENT TYPE STRING,
ISRELEVANTFORACCRUAL TYPE STRING,
SOLDTOPARTY TYPE STRING,
PARTNERCOMPANY TYPE STRING,
PURCHASEORDERBYCUSTOMER TYPE STRING,
CUSTOMERGROUP TYPE STRING,
COUNTRY TYPE STRING,
CITYCODE TYPE STRING,
SALESDISTRICT TYPE STRING,
REGION TYPE STRING,
COUNTY TYPE STRING,
CREDITCONTROLAREA TYPE STRING,
CUSTOMERREBATEAGREEMENT TYPE STRING,
PRICINGDOCUMENT TYPE STRING,
OVERALLSDPROCESSSTATUS TYPE STRING,
OVERALLBILLINGSTATUS TYPE STRING,
ACCOUNTINGPOSTINGSTATUS TYPE STRING,
ACCOUNTINGTRANSFERSTATUS TYPE STRING,
BILLINGISSUETYPE TYPE STRING,
INVOICELISTSTATUS TYPE STRING,
OVRLITMGENERALINCOMPLETIONSTS TYPE STRING,
OVERALLPRICINGINCOMPLETIONSTS TYPE STRING,
INVOICECLEARINGSTATUS TYPE STRING,
INVOICELISTTYPE TYPE STRING,
INVOICELISTBILLINGDATE TYPE STRING,END OF T_EKKO_STR. DATA: WA_ISDBILLINGDOC_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_ISDBILLINGDOC_STR-MANDT sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCUMENT sy-vline
WA_ISDBILLINGDOC_STR-SDDOCUMENTCATEGORY sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCUMENTCATEGORY sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCUMENTTYPE sy-vline
WA_ISDBILLINGDOC_STR-CREATEDBYUSER sy-vline
WA_ISDBILLINGDOC_STR-CREATIONDATE sy-vline
WA_ISDBILLINGDOC_STR-CREATIONTIME sy-vline
WA_ISDBILLINGDOC_STR-LASTCHANGEDATE sy-vline
WA_ISDBILLINGDOC_STR-LASTCHANGEDATETIME sy-vline
WA_ISDBILLINGDOC_STR-LOGICALSYSTEM sy-vline
WA_ISDBILLINGDOC_STR-SALESORGANIZATION sy-vline
WA_ISDBILLINGDOC_STR-DISTRIBUTIONCHANNEL sy-vline
WA_ISDBILLINGDOC_STR-DIVISION sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCUMENTDATE sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCUMENTISCANCELLED sy-vline
WA_ISDBILLINGDOC_STR-CANCELLEDBILLINGDOCUMENT sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCCOMBINATIONCRITERIA sy-vline
WA_ISDBILLINGDOC_STR-MANUALINVOICEMAINTISRELEVANT sy-vline
WA_ISDBILLINGDOC_STR-NMBROFPAGES sy-vline
WA_ISDBILLINGDOC_STR-ISINTRASTATREPORTINGRELEVANT sy-vline
WA_ISDBILLINGDOC_STR-ISINTRASTATREPORTINGEXCLUDED sy-vline
WA_ISDBILLINGDOC_STR-BILLINGDOCUMENTISTEMPORARY sy-vline
WA_ISDBILLINGDOC_STR-TOTALNETAMOUNT sy-vline
WA_ISDBILLINGDOC_STR-TRANSACTIONCURRENCY sy-vline
WA_ISDBILLINGDOC_STR-STATISTICSCURRENCY sy-vline
WA_ISDBILLINGDOC_STR-TOTALTAXAMOUNT sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERPRICEGROUP sy-vline
WA_ISDBILLINGDOC_STR-PRICELISTTYPE sy-vline
WA_ISDBILLINGDOC_STR-TAXDEPARTURECOUNTRY sy-vline
WA_ISDBILLINGDOC_STR-VATREGISTRATION sy-vline
WA_ISDBILLINGDOC_STR-VATREGISTRATIONORIGIN sy-vline
WA_ISDBILLINGDOC_STR-VATREGISTRATIONCOUNTRY sy-vline
WA_ISDBILLINGDOC_STR-HIERARCHYTYPEPRICING sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION1 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION2 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION3 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION4 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION5 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION6 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION7 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION8 sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERTAXCLASSIFICATION9 sy-vline
WA_ISDBILLINGDOC_STR-ISEUTRIANGULARDEAL sy-vline
WA_ISDBILLINGDOC_STR-SDPRICINGPROCEDURE sy-vline
WA_ISDBILLINGDOC_STR-SHIPPINGCONDITION sy-vline
WA_ISDBILLINGDOC_STR-PLANTSUPPLIER sy-vline
WA_ISDBILLINGDOC_STR-INCOTERMSVERSION sy-vline
WA_ISDBILLINGDOC_STR-INCOTERMSCLASSIFICATION sy-vline
WA_ISDBILLINGDOC_STR-INCOTERMSTRANSFERLOCATION sy-vline
WA_ISDBILLINGDOC_STR-INCOTERMSLOCATION1 sy-vline
WA_ISDBILLINGDOC_STR-INCOTERMSLOCATION2 sy-vline
WA_ISDBILLINGDOC_STR-PAYERPARTY sy-vline
WA_ISDBILLINGDOC_STR-CONTRACTACCOUNT sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERPAYMENTTERMS sy-vline
WA_ISDBILLINGDOC_STR-PAYMENTMETHOD sy-vline
WA_ISDBILLINGDOC_STR-PAYMENTREFERENCE sy-vline
WA_ISDBILLINGDOC_STR-FIXEDVALUEDATE sy-vline
WA_ISDBILLINGDOC_STR-ADDITIONALVALUEDAYS sy-vline
WA_ISDBILLINGDOC_STR-SEPAMANDATE sy-vline
WA_ISDBILLINGDOC_STR-COMPANYCODE sy-vline
WA_ISDBILLINGDOC_STR-FISCALYEAR sy-vline
WA_ISDBILLINGDOC_STR-ACCOUNTINGDOCUMENT sy-vline
WA_ISDBILLINGDOC_STR-FISCALPERIOD sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERACCOUNTASSIGNMENTGROUP sy-vline
WA_ISDBILLINGDOC_STR-ACCOUNTINGEXCHANGERATEISSET sy-vline
WA_ISDBILLINGDOC_STR-ACCOUNTINGEXCHANGERATE sy-vline
WA_ISDBILLINGDOC_STR-EXCHANGERATEDATE sy-vline
WA_ISDBILLINGDOC_STR-EXCHANGERATETYPE sy-vline
WA_ISDBILLINGDOC_STR-DOCUMENTREFERENCEID sy-vline
WA_ISDBILLINGDOC_STR-ASSIGNMENTREFERENCE sy-vline
WA_ISDBILLINGDOC_STR-DUNNINGAREA sy-vline
WA_ISDBILLINGDOC_STR-DUNNINGBLOCKINGREASON sy-vline
WA_ISDBILLINGDOC_STR-DUNNINGKEY sy-vline
WA_ISDBILLINGDOC_STR-INTERNALFINANCIALDOCUMENT sy-vline
WA_ISDBILLINGDOC_STR-ISRELEVANTFORACCRUAL sy-vline
WA_ISDBILLINGDOC_STR-SOLDTOPARTY sy-vline
WA_ISDBILLINGDOC_STR-PARTNERCOMPANY sy-vline
WA_ISDBILLINGDOC_STR-PURCHASEORDERBYCUSTOMER sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERGROUP sy-vline
WA_ISDBILLINGDOC_STR-COUNTRY sy-vline
WA_ISDBILLINGDOC_STR-CITYCODE sy-vline
WA_ISDBILLINGDOC_STR-SALESDISTRICT sy-vline
WA_ISDBILLINGDOC_STR-REGION sy-vline
WA_ISDBILLINGDOC_STR-COUNTY sy-vline
WA_ISDBILLINGDOC_STR-CREDITCONTROLAREA sy-vline
WA_ISDBILLINGDOC_STR-CUSTOMERREBATEAGREEMENT sy-vline
WA_ISDBILLINGDOC_STR-PRICINGDOCUMENT sy-vline
WA_ISDBILLINGDOC_STR-OVERALLSDPROCESSSTATUS sy-vline
WA_ISDBILLINGDOC_STR-OVERALLBILLINGSTATUS sy-vline
WA_ISDBILLINGDOC_STR-ACCOUNTINGPOSTINGSTATUS sy-vline
WA_ISDBILLINGDOC_STR-ACCOUNTINGTRANSFERSTATUS sy-vline
WA_ISDBILLINGDOC_STR-BILLINGISSUETYPE sy-vline
WA_ISDBILLINGDOC_STR-INVOICELISTSTATUS sy-vline
WA_ISDBILLINGDOC_STR-OVRLITMGENERALINCOMPLETIONSTS sy-vline
WA_ISDBILLINGDOC_STR-OVERALLPRICINGINCOMPLETIONSTS sy-vline
WA_ISDBILLINGDOC_STR-INVOICECLEARINGSTATUS sy-vline
WA_ISDBILLINGDOC_STR-INVOICELISTTYPE sy-vline
WA_ISDBILLINGDOC_STR-INVOICELISTBILLINGDATE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.