ABAP Select data from SAP table PBRSPEDNFSTCT 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 PBRSPEDNFSTCT 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 PBRSPEDNFSTCT. 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 PBRSPEDNFSTCT 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_PBRSPEDNFSTCT TYPE STANDARD TABLE OF PBRSPEDNFSTCT,
      WA_PBRSPEDNFSTCT TYPE PBRSPEDNFSTCT,
      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: <PBRSPEDNFSTCT> TYPE PBRSPEDNFSTCT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PBRSPEDNFSTCT
*  INTO TABLE @DATA(IT_PBRSPEDNFSTCT2).
*--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_PBRSPEDNFSTCT INDEX 1 INTO DATA(WA_PBRSPEDNFSTCT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PBRSPEDNFSTCT>-MANDT = 1.
<PBRSPEDNFSTCT>-BR_NOTAFISCAL = 1.
<PBRSPEDNFSTCT>-BR_NOTAFISCALITEM = 1.
<PBRSPEDNFSTCT>-BR_TAXTYPE = 1.
<PBRSPEDNFSTCT>-ORIGINALTAXGROUP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PBRSPEDNFSTCT-COMPANYCODE, sy-vline,
  WA_PBRSPEDNFSTCT-BUSINESSPLACE, sy-vline,
  WA_PBRSPEDNFSTCT-BR_PAYMENTFORM, sy-vline,
  WA_PBRSPEDNFSTCT-BR_NFISSUEDATE, sy-vline,
  WA_PBRSPEDNFSTCT-BR_NFSERIES, sy-vline,
  WA_PBRSPEDNFSTCT-BR_NFPARTNERTYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PBRSPEDNFSTCT 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_PBRSPEDNFSTCT 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_PBRSPEDNFSTCT INTO WA_PBRSPEDNFSTCT.


*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 BR_NFPARTNER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PBRSPEDNFSTCT-BR_NFPARTNER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PBRSPEDNFSTCT-BR_NFPARTNER.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field BR_NFITMFXDMKTTARIFFUNIT4DCMLS
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PBRSPEDNFSTCT-BR_NFITMFXDMKTTARIFFUNIT4DCMLS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PBRSPEDNFSTCT-BR_NFITMFXDMKTTARIFFUNIT4DCMLS.
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_PBRSPEDNFSTCT_STR, 
MANDT TYPE STRING,
BR_NOTAFISCAL TYPE STRING,
BR_NOTAFISCALITEM TYPE STRING,
BR_TAXTYPE TYPE STRING,
ORIGINALTAXGROUP TYPE STRING,
COMPANYCODE TYPE STRING,
BUSINESSPLACE TYPE STRING,
BR_PAYMENTFORM TYPE STRING,
BR_NFISSUEDATE TYPE STRING,
BR_NFSERIES TYPE STRING,
BR_NFPARTNERTYPE TYPE STRING,
BR_NFPARTNER TYPE STRING,
LICENSEPLATE TYPE STRING,
BR_NFENUMBER TYPE STRING,
BR_NFISSUEDBY TYPE STRING,
BR_NFSITUATIONCODE TYPE STRING,
BR_NFTYPE TYPE STRING,
BR_NFDOCUMENTTYPE TYPE STRING,
BR_NFMODEL TYPE STRING,
BR_NFDIRECTION TYPE STRING,
BR_ISNFE TYPE STRING,
BR_NFPARTNERREGIONCODE TYPE STRING,
BR_NFISCANCELED TYPE STRING,
BR_CTEJURISDICTIONCODEORIGIN TYPE STRING,
BR_CTEJURISDICTIONCODEDEST TYPE STRING,
FREIGHTPAYER TYPE STRING,
BR_NFPARTNERTAXJURISDICTION TYPE STRING,
BR_NFCANCELLATIONDATE TYPE STRING,
BR_NFSHIPPINGUNITBRAND TYPE STRING,
BR_NFSVERIFICATIONCODE TYPE STRING,
BR_NFSUBSERIES TYPE STRING,
SUPPLIERINVOICE TYPE STRING,
BR_NFSNUMBER TYPE STRING,
BR_NFPARTNERSTATETAXNUMBER TYPE STRING,
BR_NFISMUNICIPAL TYPE STRING,
BR_NFHASSERVICEITEM TYPE STRING,
SALESDOCUMENTCURRENCY TYPE STRING,
HEADERWEIGHTUNIT TYPE STRING,
INCOTERMSCLASSIFICATION TYPE STRING,
BR_NFPARTNERMUNICIPALTAXNUMBER TYPE STRING,
BR_NFREFERENCEDOCUMENT TYPE STRING,
BR_NFPOSTINGDATE TYPE STRING,
CREATIONDATE TYPE STRING,
CREATEDBYUSER TYPE STRING,
BR_NFISCREATEDMANUALLY TYPE STRING,
BR_NFPARTNERFUNCTION TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
BR_NFISCONTINGENCY TYPE STRING,
BR_CTEDOCUMENTTYPE TYPE STRING,
BR_CTESERVICETYPE TYPE STRING,
PAYMENTTERMS TYPE STRING,
BR_NFARRIVALORDEPARTUREDATE TYPE STRING,
BR_NFPARTNERNAME1 TYPE STRING,
BR_NFPARTNERDISTRICTNAME TYPE STRING,
BR_NFPARTNERCITYNAME TYPE STRING,
BR_NFPARTNERPOSTALCODE TYPE STRING,
BR_NFPARTNERSTREETNAME TYPE STRING,
BUSINESSPARTNERHOUSENUMBER TYPE STRING,
BPHSNMBRSUPLMNTTXT TYPE STRING,
PHONENUMBER TYPE STRING,
NFHEADERTOTALAMOUNT TYPE STRING,
MATERIALOLDID TYPE STRING,
MATERIAL TYPE STRING,
MATERIALNAME TYPE STRING,
BR_NFISPHYSICALMVTOFMATERIAL TYPE STRING,
BR_ICMSTAXSITUATION TYPE STRING,
BR_CFOPCODE TYPE STRING,
BR_IPITAXSITUATION TYPE STRING,
BR_PISTAXSITUATION TYPE STRING,
BR_COFINSTAXSITUATION TYPE STRING,
GLACCOUNT TYPE STRING,
BR_MATERIALUSAGE TYPE STRING,
VALUATIONTYPE TYPE STRING,
BR_NFEXTERNALITEMNUMBER TYPE STRING,
BR_NFISSERVICEITEM TYPE STRING,
BR_ICMSTAXLAW TYPE STRING,
BR_IPITAXLAW TYPE STRING,
BR_MATERIALORIGIN TYPE STRING,
BR_COFINSTAXLAW TYPE STRING,
BR_PISTAXLAW TYPE STRING,
QUANTITYINBASEUNIT TYPE STRING,
BR_NFITEMTYPE TYPE STRING,
BR_IPICONTROLSEALCODE TYPE STRING,
BR_IPICONTROLSEALQUANTITYVALUE TYPE STRING,
BR_ICMSBASEDETN TYPE STRING,
PURCHASEORDER TYPE STRING,
PURCHASEORDERITEM TYPE STRING,
NETPRICEAMOUNT TYPE STRING,
BR_NFTOTALAMOUNT TYPE STRING,
BR_NFTOTALAMOUNTWITHTAXES TYPE STRING,
BR_NFVALUEAMOUNTWITHTAXES TYPE STRING,
NETVALUEAMOUNT TYPE STRING,
BR_NFDISCOUNTAMOUNTWITHTAXES TYPE STRING,
BR_NFFREIGHTAMOUNTWITHTAXES TYPE STRING,
BR_NFINSURANCEAMOUNTWITHTAXES TYPE STRING,
BR_NFNETOTHEREXPENSESAMOUNT TYPE STRING,
BR_EXEMPTEDICMSAMOUNT TYPE STRING,
NCMCODE TYPE STRING,
BR_NFSOURCEDOCUMENTNUMBER TYPE STRING,
BR_NFSOURCEDOCUMENTTYPE TYPE STRING,
BR_NFSOURCEDOCUMENTITEM TYPE STRING,
PLANT TYPE STRING,
BATCH TYPE STRING,
BR_ISSTAXSITUATION TYPE STRING,
BR_ISSTAXLAW TYPE STRING,
BR_NFITEMISSTATISTICAL TYPE STRING,
BR_REFERENCENFNUMBER TYPE STRING,
BR_REFERENCENFITEM TYPE STRING,
BR_NFPRICEAMOUNTWITHTAXES TYPE STRING,
COSTCENTER TYPE STRING,
BR_NBSCODE TYPE STRING,
BASEUNIT TYPE STRING,
TAXGROUP TYPE STRING,
BR_NFITEMORIGINALBASEAMOUNT TYPE STRING,
BR_ORIGLNFITEMEXCLBASEAMOUNT TYPE STRING,
BR_ORIGLNFITEMOTHERBASEAMOUNT TYPE STRING,
BR_ORIGINALNFITEMTAXRATE TYPE STRING,
BR_NFITEMTAXAMOUNT TYPE STRING,
BR_NFITEMTAXBASEPCT1 TYPE STRING,
BR_NFITEMTAXBASEPCT2 TYPE STRING,
BR_NFITEMISSTATISTICALTAX TYPE STRING,
BR_NFITEMHASFIXEDMKTTARIFF TYPE STRING,
BR_NFITEMFIXEDMKTTARIFFBASEQTY TYPE STRING,
BR_NFITEMFIXEDMARKETTARIFFUNIT TYPE STRING,
BR_NFITEMWHLDGCOLLECTIONCODE TYPE STRING,
BR_NFITEMFIXEDMKTTARIFFTAXRATE TYPE STRING,
BR_NFITEMFIXEDMKTTARIFFQTY TYPE STRING,
BR_NFITMFXDMKTTARIFFUNIT4DCMLS TYPE STRING,
BR_NFITEMHASWITHHOLDINGTAX TYPE STRING,
BR_NFSSERVICETYPEINCOMING TYPE STRING,
BR_NFSSERVICETYPEOUTGOING TYPE STRING,
TAXJURISDICTION TYPE STRING,
BR_UFTAXJURISDICTION TYPE STRING,
BR_NFISTAXINNETAMOUNT TYPE STRING,
BR_ICMSISINCLUDEDINAMOUNT TYPE STRING,
NFITEMEXCLUDEDBASEAMOUNT TYPE STRING,
NFITEMOTHERBASEAMOUNT TYPE STRING,
NFITEMBASEAMOUNT TYPE STRING,
NFITEMTAXRATE TYPE STRING,
BR_IPIREDUCTIONTAXAMOUNT TYPE STRING,
BR_ICMSREDUCTIONTAXAMOUNT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PBRSPEDNFSTCT_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_PBRSPEDNFSTCT_STR-MANDT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NOTAFISCAL sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NOTAFISCALITEM sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_TAXTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-ORIGINALTAXGROUP sy-vline 
WA_PBRSPEDNFSTCT_STR-COMPANYCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BUSINESSPLACE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_PAYMENTFORM sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISSUEDATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSERIES sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNER sy-vline 
WA_PBRSPEDNFSTCT_STR-LICENSEPLATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFENUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISSUEDBY sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSITUATIONCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFDOCUMENTTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFMODEL sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFDIRECTION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ISNFE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERREGIONCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISCANCELED sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_CTEJURISDICTIONCODEORIGIN sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_CTEJURISDICTIONCODEDEST sy-vline 
WA_PBRSPEDNFSTCT_STR-FREIGHTPAYER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERTAXJURISDICTION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFCANCELLATIONDATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSHIPPINGUNITBRAND sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSVERIFICATIONCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSUBSERIES sy-vline 
WA_PBRSPEDNFSTCT_STR-SUPPLIERINVOICE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSNUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERSTATETAXNUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISMUNICIPAL sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFHASSERVICEITEM sy-vline 
WA_PBRSPEDNFSTCT_STR-SALESDOCUMENTCURRENCY sy-vline 
WA_PBRSPEDNFSTCT_STR-HEADERWEIGHTUNIT sy-vline 
WA_PBRSPEDNFSTCT_STR-INCOTERMSCLASSIFICATION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERMUNICIPALTAXNUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFREFERENCEDOCUMENT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPOSTINGDATE sy-vline 
WA_PBRSPEDNFSTCT_STR-CREATIONDATE sy-vline 
WA_PBRSPEDNFSTCT_STR-CREATEDBYUSER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISCREATEDMANUALLY sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERFUNCTION sy-vline 
WA_PBRSPEDNFSTCT_STR-ACCOUNTINGDOCUMENT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISCONTINGENCY sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_CTEDOCUMENTTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_CTESERVICETYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-PAYMENTTERMS sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFARRIVALORDEPARTUREDATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERNAME1 sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERDISTRICTNAME sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERCITYNAME sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERPOSTALCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPARTNERSTREETNAME sy-vline 
WA_PBRSPEDNFSTCT_STR-BUSINESSPARTNERHOUSENUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BPHSNMBRSUPLMNTTXT sy-vline 
WA_PBRSPEDNFSTCT_STR-PHONENUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-NFHEADERTOTALAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-MATERIALOLDID sy-vline 
WA_PBRSPEDNFSTCT_STR-MATERIAL sy-vline 
WA_PBRSPEDNFSTCT_STR-MATERIALNAME sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISPHYSICALMVTOFMATERIAL sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ICMSTAXSITUATION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_CFOPCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_IPITAXSITUATION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_PISTAXSITUATION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_COFINSTAXSITUATION sy-vline 
WA_PBRSPEDNFSTCT_STR-GLACCOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_MATERIALUSAGE sy-vline 
WA_PBRSPEDNFSTCT_STR-VALUATIONTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFEXTERNALITEMNUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISSERVICEITEM sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ICMSTAXLAW sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_IPITAXLAW sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_MATERIALORIGIN sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_COFINSTAXLAW sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_PISTAXLAW sy-vline 
WA_PBRSPEDNFSTCT_STR-QUANTITYINBASEUNIT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_IPICONTROLSEALCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_IPICONTROLSEALQUANTITYVALUE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ICMSBASEDETN sy-vline 
WA_PBRSPEDNFSTCT_STR-PURCHASEORDER sy-vline 
WA_PBRSPEDNFSTCT_STR-PURCHASEORDERITEM sy-vline 
WA_PBRSPEDNFSTCT_STR-NETPRICEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFTOTALAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFTOTALAMOUNTWITHTAXES sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFVALUEAMOUNTWITHTAXES sy-vline 
WA_PBRSPEDNFSTCT_STR-NETVALUEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFDISCOUNTAMOUNTWITHTAXES sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFFREIGHTAMOUNTWITHTAXES sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFINSURANCEAMOUNTWITHTAXES sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFNETOTHEREXPENSESAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_EXEMPTEDICMSAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-NCMCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSOURCEDOCUMENTNUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSOURCEDOCUMENTTYPE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSOURCEDOCUMENTITEM sy-vline 
WA_PBRSPEDNFSTCT_STR-PLANT sy-vline 
WA_PBRSPEDNFSTCT_STR-BATCH sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ISSTAXSITUATION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ISSTAXLAW sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMISSTATISTICAL sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_REFERENCENFNUMBER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_REFERENCENFITEM sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFPRICEAMOUNTWITHTAXES sy-vline 
WA_PBRSPEDNFSTCT_STR-COSTCENTER sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NBSCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BASEUNIT sy-vline 
WA_PBRSPEDNFSTCT_STR-TAXGROUP sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMORIGINALBASEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ORIGLNFITEMEXCLBASEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ORIGLNFITEMOTHERBASEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ORIGINALNFITEMTAXRATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMTAXAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMTAXBASEPCT1 sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMTAXBASEPCT2 sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMISSTATISTICALTAX sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMHASFIXEDMKTTARIFF sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMFIXEDMKTTARIFFBASEQTY sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMFIXEDMARKETTARIFFUNIT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMWHLDGCOLLECTIONCODE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMFIXEDMKTTARIFFTAXRATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMFIXEDMKTTARIFFQTY sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITMFXDMKTTARIFFUNIT4DCMLS sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFITEMHASWITHHOLDINGTAX sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSSERVICETYPEINCOMING sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFSSERVICETYPEOUTGOING sy-vline 
WA_PBRSPEDNFSTCT_STR-TAXJURISDICTION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_UFTAXJURISDICTION sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_NFISTAXINNETAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ICMSISINCLUDEDINAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-NFITEMEXCLUDEDBASEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-NFITEMOTHERBASEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-NFITEMBASEAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-NFITEMTAXRATE sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_IPIREDUCTIONTAXAMOUNT sy-vline 
WA_PBRSPEDNFSTCT_STR-BR_ICMSREDUCTIONTAXAMOUNT sy-vline      INTO ld_text SEPARATED BY SPACE.

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