ABAP Select data from SAP table IBRNFITEMC 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 IBRNFITEMC 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 IBRNFITEMC. 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 IBRNFITEMC 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_IBRNFITEMC TYPE STANDARD TABLE OF IBRNFITEMC,
      WA_IBRNFITEMC TYPE IBRNFITEMC,
      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: <IBRNFITEMC> TYPE IBRNFITEMC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IBRNFITEMC
*  INTO TABLE @DATA(IT_IBRNFITEMC2).
*--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_IBRNFITEMC INDEX 1 INTO DATA(WA_IBRNFITEMC2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<IBRNFITEMC>-MANDT = 1.
<IBRNFITEMC>-BR_NOTAFISCAL = 1.
<IBRNFITEMC>-BR_NOTAFISCALITEM = 1.
<IBRNFITEMC>-BR_NFITEMTITLE = 1.
<IBRNFITEMC>-BR_NFITEMSECONDARYTITLE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IBRNFITEMC-BR_NFITEMTYPEFRMTDDESC, sy-vline,
  WA_IBRNFITEMC-PLANT, sy-vline,
  WA_IBRNFITEMC-BR_PLANTNAMEFRMTDDESC, sy-vline,
  WA_IBRNFITEMC-BATCH, sy-vline,
  WA_IBRNFITEMC-MATERIALGROUP, sy-vline,
  WA_IBRNFITEMC-QUANTITYINBASEUNIT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_IBRNFITEMC 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_IBRNFITEMC 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_IBRNFITEMC INTO WA_IBRNFITEMC.


*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 CUNIT, internal->external for field BASEUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_IBRNFITEMC-BASEUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IBRNFITEMC-BASEUNIT.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit EAN11, internal->external for field INTERNATIONALARTICLENUMBER
CALL FUNCTION 'CONVERSION_EXIT_EAN11_OUTPUT'
  EXPORTING
    input =                      WA_IBRNFITEMC-INTERNATIONALARTICLENUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IBRNFITEMC-INTERNATIONALARTICLENUMBER.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field VEHICLEGROSSWEIGHTUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_IBRNFITEMC-VEHICLEGROSSWEIGHTUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_IBRNFITEMC-VEHICLEGROSSWEIGHTUNIT.
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_IBRNFITEMC_STR, 
MANDT TYPE STRING,
BR_NOTAFISCAL TYPE STRING,
BR_NOTAFISCALITEM TYPE STRING,
BR_NFITEMTITLE TYPE STRING,
BR_NFITEMSECONDARYTITLE TYPE STRING,
BR_NFITEMTYPEFRMTDDESC TYPE STRING,
PLANT TYPE STRING,
BR_PLANTNAMEFRMTDDESC TYPE STRING,
BATCH TYPE STRING,
MATERIALGROUP TYPE STRING,
QUANTITYINBASEUNIT TYPE STRING,
BASEUNIT TYPE STRING,
BR_NFPERCENTRETURNED TYPE STRING,
VALUATIONTYPE TYPE STRING,
BR_NFITEMISSTATISTICAL TYPE STRING,
BR_NFISSERVICEITEM TYPE STRING,
BR_NFSOURCEDOCUMENTFRMTDDESC TYPE STRING,
BR_NFREFDOCUMENTFRMTDDESC TYPE STRING,
MATERIAL TYPE STRING,
MATERIALNAME TYPE STRING,
NCMFRMTDCODE TYPE STRING,
BR_CSTFRMTDCODE TYPE STRING,
BR_CFOPFRMTDCODE TYPE STRING,
BR_CFOPITEMOPERATIONCODE TYPE STRING,
BR_NFITEMUNITPRICEAMOUNT TYPE STRING,
BR_ICMSBASEAMOUNT TYPE STRING,
BR_ICMSTAXAMOUNT TYPE STRING,
BR_IPITAXAMOUNT TYPE STRING,
BR_ICMSTAXRATE TYPE STRING,
BR_IPITAXRATE TYPE STRING,
NETPRICEAMOUNT TYPE STRING,
NETVALUEAMOUNT TYPE STRING,
BR_NFNETDISCOUNTAMOUNT TYPE STRING,
BR_EXEMPTEDICMSAMOUNT2DCMLS TYPE STRING,
BR_ICMSSTATISTICALEXEMPTIONAMT TYPE STRING,
BR_NFNETFREIGHTAMOUNT TYPE STRING,
BR_NFNETINSURANCEAMOUNT TYPE STRING,
BR_NFNETOTHEREXPENSESAMOUNT TYPE STRING,
BR_NFTOTALAMOUNT TYPE STRING,
BR_NFPRICEAMOUNTWITHTAXES TYPE STRING,
BR_NFVALUEAMOUNTWITHTAXES TYPE STRING,
BR_NFDISCOUNTAMOUNTWITHTAXES TYPE STRING,
BR_NFEXEMPTEDICMSWITHTAXES TYPE STRING,
BR_NFFREIGHTAMOUNTWITHTAXES TYPE STRING,
BR_NFINSURANCEAMOUNTWITHTAXES TYPE STRING,
BR_NFEXPENSESAMOUNTWITHTAXES TYPE STRING,
BR_NFTOTALAMOUNTWITHTAXES TYPE STRING,
BR_CFOPFRMTDDESC TYPE STRING,
BR_MATERIALORIGIN TYPE STRING,
BR_MATERIALUSAGE TYPE STRING,
ISPRODUCEDINHOUSE TYPE STRING,
BR_NCMDESC TYPE STRING,
BR_NFAPPROXIMATETOTALTAXAMOUNT TYPE STRING,
BR_FCINUMBER TYPE STRING,
BR_NFITEMHASTAXINCENTIVE TYPE STRING,
TAXINCENTIVECODE TYPE STRING,
BR_CSTISSCODE TYPE STRING,
BR_ISSBENEFITCODE TYPE STRING,
BR_ICMSTAXLAWFRMTDDESC TYPE STRING,
BR_IPITAXLAWFRMTDDESC TYPE STRING,
BR_COFINSTAXLAWFRMTDDESC TYPE STRING,
BR_PISTAXLAWFRMTDDESC TYPE STRING,
GLACCOUNT TYPE STRING,
BR_NFISPHYSICALMVTOFMATERIAL TYPE STRING,
INTERNATIONALARTICLENUMBER TYPE STRING,
BR_RECOPINUMBER TYPE STRING,
BR_ISSSUSPENSIONPROCESS TYPE STRING,
BR_NFESTATISTICALAMOUNT TYPE STRING,
BR_NFPARTNERCNAE TYPE STRING,
BR_BUSINESSPLACECNAE TYPE STRING,
BR_NFTRIBUTARYQUANTITY TYPE STRING,
BR_NFTRIBUTARYUNIT TYPE STRING,
PURCHASEORDER TYPE STRING,
PURCHASEORDERITEM TYPE STRING,
BR_NFEXTERNALITEMNUMBER TYPE STRING,
BR_NFFREIGHTNATURE TYPE STRING,
PRODUCTIONISINRELEVANTSCALE TYPE STRING,
BR_MANUFACTURERCNPJ TYPE STRING,
BR_ICMSTAXSITUATION TYPE STRING,
BR_IPITAXSITUATIONFRMTDDESC TYPE STRING,
BR_COFINSTAXSITUATIONFRMTDDESC TYPE STRING,
BR_PISTAXSITUATIONFRMTDDESC TYPE STRING,
BR_ICMSBASEDETN TYPE STRING,
BR_ICMSSTBASEDETERMINATION TYPE STRING,
BR_ICMSSTMARGINADDEDPERCENT TYPE STRING,
BR_ICMSSTLGLCLASSFCTNFRMTDDESC TYPE STRING,
BR_ICMSSTDESTTAXAMOUNT TYPE STRING,
BR_ICMSSTDESTTAXBASEAMOUNT TYPE STRING,
BR_SUBSTITUTEICMSAMOUNT TYPE STRING,
BR_FCPONICMSSTWITHHELDBASEAMT TYPE STRING,
BR_FCPONICMSSTWITHHELDRATE TYPE STRING,
BR_FCPONICMSSTWITHHELDAMOUNT TYPE STRING,
BR_ICMSEXEMPTIONREASON TYPE STRING,
BR_ICMSDEFERMENTAMOUNT TYPE STRING,
BR_ICMSDEFERRALTAXRATE TYPE STRING,
BR_WITHHOLDINGICMSSTBASEAMOUNT TYPE STRING,
BR_WITHHOLDINGICMSSTAMOUNT TYPE STRING,
BR_ICMSSTRATEINCLUDINGFCP TYPE STRING,
BR_REDUCNPCTEFFCTVCALCBASIS TYPE STRING,
BR_EFFCTVCALCBASISAMOUNT TYPE STRING,
BR_EFFECTIVEICMSRATE TYPE STRING,
BR_EFFECTIVEICMSAMOUNT TYPE STRING,
BR_IPILEGALCLASSFCTNFRMTDDESC TYPE STRING,
BR_TOBACCOBEVERAGEIPICLASSFCTN TYPE STRING,
BR_IPICONTROLSEALCODE TYPE STRING,
BR_IPICONTROLSEALQUANTITYVALUE TYPE STRING,
BR_IOFTAXAMOUNT TYPE STRING,
CUSTOMSCHARGESAMOUNT TYPE STRING,
BR_ANPCODE TYPE STRING,
BR_NFREGISTERCODIF TYPE STRING,
BR_NFEENVRMTTEMPERATUREFUELQTY TYPE STRING,
BR_NFEFUELCNSMRREGIONFRMTDDESC TYPE STRING,
BR_NFNATURALGASPERCENT TYPE STRING,
BR_NFPERCENTAGENATURALGASUNIT TYPE STRING,
BR_GLPRATIO TYPE STRING,
BR_GLPRATIOUNIT TYPE STRING,
BR_GLGNNRATIO TYPE STRING,
BR_GLGNNRATIOUNIT TYPE STRING,
BR_GLGNIRATIO TYPE STRING,
BR_GLGNIRATIOUNIT TYPE STRING,
BR_GLPNETVALUEAMOUNT TYPE STRING,
BR_NFFUELCIDETAXBASEQUANTITY TYPE STRING,
BR_NFFUELCIDETAXRATE TYPE STRING,
BR_NFFUELCIDETAXAMOUNT TYPE STRING,
BR_NFEFUELNOZZLE TYPE STRING,
BR_NFEFUELPUMP TYPE STRING,
BR_NFEFUELTANK TYPE STRING,
BR_NFEFUELGAUGESTARTQUANTITY TYPE STRING,
BR_NFEFUELGAUGEENDQUANTITY TYPE STRING,
VEHICLEMODEL TYPE STRING,
VEHICLEYEAROFMANUFACTURE TYPE STRING,
VEHICLEMODELYEAR TYPE STRING,
VEHICLEFUELTYPE TYPE STRING,
VEHICLEENGINEPOWER TYPE STRING,
VEHICLECYLINDERCAPACITYVALUE TYPE STRING,
VEHICLEENGINENUMBER TYPE STRING,
VEHICLECARMAKERCOLOR TYPE STRING,
VEHICLEPAINTINGTYPE TYPE STRING,
VEHICLECOLORDESC TYPE STRING,
VEHICLECHASSIS TYPE STRING,
VEHICLESERIALNUMBER TYPE STRING,
VEHICLENETWEIGHT TYPE STRING,
VEHICLENETWEIGHTUNIT TYPE STRING,
VEHICLEGROSSWEIGHT TYPE STRING,
VEHICLEGROSSWEIGHTUNIT TYPE STRING,
VEHICLEMAXIMUMCAPACITYVALUE TYPE STRING,
VEHICLEMAXTRACTIONCAPACITY TYPE STRING,
DISTANCEBETWEENAXLESQTYVALUE TYPE STRING,
VEHICLEUSAGE TYPE STRING,
VEHICLECONDITION TYPE STRING,
VEHICLERESTRICTION TYPE STRING,
VEHICLEOPERATIONTYPE TYPE STRING,
BR_NFITEMCOSTCENTERFRMTDDESC TYPE STRING,
BR_NFITMINTERNALORDERFRMTDDESC TYPE STRING,
BR_NFITEMPROFITCENTERFRMTDDESC TYPE STRING,
BR_NFITEMWBSELEMENTFRMTDDESC TYPE STRING,
BR_NFITEMCOSTOBJECTFRMTDDESC TYPE STRING,
BR_NFITMPROJNETWORKFRMTDDESC TYPE STRING,
BR_NFITEMCOSTSEGMENTFRMTDDESC TYPE STRING,
BR_ANVISACODE TYPE STRING,
BR_ANVISAEXEMPTIONREASONTEXT TYPE STRING,
MEDICINECONSUMERMAXPRICE TYPE STRING,
BR_NFITEMEXPRTSQNCNUMBER TYPE STRING,
BR_NFEXMLVERSION TYPE STRING,
BR_NFEMODEL TYPE STRING,
ORIGINREFERENCEDOCUMENT TYPE STRING,
ORIGINREFERENCEDOCUMENTITEM TYPE STRING,
PREDECESSORREFERENCEDOCUMENT TYPE STRING,
PREDECESSORREFERENCEDOCITEM TYPE STRING,
REFERENCEDOCUMENT TYPE STRING,
REFERENCEDOCUMENTITEM TYPE STRING,
BR_NBSCODE TYPE STRING,
BR_EFDREINFSERVICECODE TYPE STRING,
BR_LC116SERVICECODE TYPE STRING,
SALESDOCUMENTCURRENCY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_IBRNFITEMC_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_IBRNFITEMC_STR-MANDT sy-vline 
WA_IBRNFITEMC_STR-BR_NOTAFISCAL sy-vline 
WA_IBRNFITEMC_STR-BR_NOTAFISCALITEM sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMTITLE sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMSECONDARYTITLE sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMTYPEFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-PLANT sy-vline 
WA_IBRNFITEMC_STR-BR_PLANTNAMEFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BATCH sy-vline 
WA_IBRNFITEMC_STR-MATERIALGROUP sy-vline 
WA_IBRNFITEMC_STR-QUANTITYINBASEUNIT sy-vline 
WA_IBRNFITEMC_STR-BASEUNIT sy-vline 
WA_IBRNFITEMC_STR-BR_NFPERCENTRETURNED sy-vline 
WA_IBRNFITEMC_STR-VALUATIONTYPE sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMISSTATISTICAL sy-vline 
WA_IBRNFITEMC_STR-BR_NFISSERVICEITEM sy-vline 
WA_IBRNFITEMC_STR-BR_NFSOURCEDOCUMENTFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFREFDOCUMENTFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-MATERIAL sy-vline 
WA_IBRNFITEMC_STR-MATERIALNAME sy-vline 
WA_IBRNFITEMC_STR-NCMFRMTDCODE sy-vline 
WA_IBRNFITEMC_STR-BR_CSTFRMTDCODE sy-vline 
WA_IBRNFITEMC_STR-BR_CFOPFRMTDCODE sy-vline 
WA_IBRNFITEMC_STR-BR_CFOPITEMOPERATIONCODE sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMUNITPRICEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSBASEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSTAXAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_IPITAXAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSTAXRATE sy-vline 
WA_IBRNFITEMC_STR-BR_IPITAXRATE sy-vline 
WA_IBRNFITEMC_STR-NETPRICEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-NETVALUEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFNETDISCOUNTAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_EXEMPTEDICMSAMOUNT2DCMLS sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTATISTICALEXEMPTIONAMT sy-vline 
WA_IBRNFITEMC_STR-BR_NFNETFREIGHTAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFNETINSURANCEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFNETOTHEREXPENSESAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFTOTALAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFPRICEAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFVALUEAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFDISCOUNTAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFEXEMPTEDICMSWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFFREIGHTAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFINSURANCEAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFEXPENSESAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_NFTOTALAMOUNTWITHTAXES sy-vline 
WA_IBRNFITEMC_STR-BR_CFOPFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_MATERIALORIGIN sy-vline 
WA_IBRNFITEMC_STR-BR_MATERIALUSAGE sy-vline 
WA_IBRNFITEMC_STR-ISPRODUCEDINHOUSE sy-vline 
WA_IBRNFITEMC_STR-BR_NCMDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFAPPROXIMATETOTALTAXAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_FCINUMBER sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMHASTAXINCENTIVE sy-vline 
WA_IBRNFITEMC_STR-TAXINCENTIVECODE sy-vline 
WA_IBRNFITEMC_STR-BR_CSTISSCODE sy-vline 
WA_IBRNFITEMC_STR-BR_ISSBENEFITCODE sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSTAXLAWFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_IPITAXLAWFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_COFINSTAXLAWFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_PISTAXLAWFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-GLACCOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFISPHYSICALMVTOFMATERIAL sy-vline 
WA_IBRNFITEMC_STR-INTERNATIONALARTICLENUMBER sy-vline 
WA_IBRNFITEMC_STR-BR_RECOPINUMBER sy-vline 
WA_IBRNFITEMC_STR-BR_ISSSUSPENSIONPROCESS sy-vline 
WA_IBRNFITEMC_STR-BR_NFESTATISTICALAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFPARTNERCNAE sy-vline 
WA_IBRNFITEMC_STR-BR_BUSINESSPLACECNAE sy-vline 
WA_IBRNFITEMC_STR-BR_NFTRIBUTARYQUANTITY sy-vline 
WA_IBRNFITEMC_STR-BR_NFTRIBUTARYUNIT sy-vline 
WA_IBRNFITEMC_STR-PURCHASEORDER sy-vline 
WA_IBRNFITEMC_STR-PURCHASEORDERITEM sy-vline 
WA_IBRNFITEMC_STR-BR_NFEXTERNALITEMNUMBER sy-vline 
WA_IBRNFITEMC_STR-BR_NFFREIGHTNATURE sy-vline 
WA_IBRNFITEMC_STR-PRODUCTIONISINRELEVANTSCALE sy-vline 
WA_IBRNFITEMC_STR-BR_MANUFACTURERCNPJ sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSTAXSITUATION sy-vline 
WA_IBRNFITEMC_STR-BR_IPITAXSITUATIONFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_COFINSTAXSITUATIONFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_PISTAXSITUATIONFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSBASEDETN sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTBASEDETERMINATION sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTMARGINADDEDPERCENT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTLGLCLASSFCTNFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTDESTTAXAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTDESTTAXBASEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_SUBSTITUTEICMSAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_FCPONICMSSTWITHHELDBASEAMT sy-vline 
WA_IBRNFITEMC_STR-BR_FCPONICMSSTWITHHELDRATE sy-vline 
WA_IBRNFITEMC_STR-BR_FCPONICMSSTWITHHELDAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSEXEMPTIONREASON sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSDEFERMENTAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSDEFERRALTAXRATE sy-vline 
WA_IBRNFITEMC_STR-BR_WITHHOLDINGICMSSTBASEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_WITHHOLDINGICMSSTAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ICMSSTRATEINCLUDINGFCP sy-vline 
WA_IBRNFITEMC_STR-BR_REDUCNPCTEFFCTVCALCBASIS sy-vline 
WA_IBRNFITEMC_STR-BR_EFFCTVCALCBASISAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_EFFECTIVEICMSRATE sy-vline 
WA_IBRNFITEMC_STR-BR_EFFECTIVEICMSAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_IPILEGALCLASSFCTNFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_TOBACCOBEVERAGEIPICLASSFCTN sy-vline 
WA_IBRNFITEMC_STR-BR_IPICONTROLSEALCODE sy-vline 
WA_IBRNFITEMC_STR-BR_IPICONTROLSEALQUANTITYVALUE sy-vline 
WA_IBRNFITEMC_STR-BR_IOFTAXAMOUNT sy-vline 
WA_IBRNFITEMC_STR-CUSTOMSCHARGESAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_ANPCODE sy-vline 
WA_IBRNFITEMC_STR-BR_NFREGISTERCODIF sy-vline 
WA_IBRNFITEMC_STR-BR_NFEENVRMTTEMPERATUREFUELQTY sy-vline 
WA_IBRNFITEMC_STR-BR_NFEFUELCNSMRREGIONFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFNATURALGASPERCENT sy-vline 
WA_IBRNFITEMC_STR-BR_NFPERCENTAGENATURALGASUNIT sy-vline 
WA_IBRNFITEMC_STR-BR_GLPRATIO sy-vline 
WA_IBRNFITEMC_STR-BR_GLPRATIOUNIT sy-vline 
WA_IBRNFITEMC_STR-BR_GLGNNRATIO sy-vline 
WA_IBRNFITEMC_STR-BR_GLGNNRATIOUNIT sy-vline 
WA_IBRNFITEMC_STR-BR_GLGNIRATIO sy-vline 
WA_IBRNFITEMC_STR-BR_GLGNIRATIOUNIT sy-vline 
WA_IBRNFITEMC_STR-BR_GLPNETVALUEAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFFUELCIDETAXBASEQUANTITY sy-vline 
WA_IBRNFITEMC_STR-BR_NFFUELCIDETAXRATE sy-vline 
WA_IBRNFITEMC_STR-BR_NFFUELCIDETAXAMOUNT sy-vline 
WA_IBRNFITEMC_STR-BR_NFEFUELNOZZLE sy-vline 
WA_IBRNFITEMC_STR-BR_NFEFUELPUMP sy-vline 
WA_IBRNFITEMC_STR-BR_NFEFUELTANK sy-vline 
WA_IBRNFITEMC_STR-BR_NFEFUELGAUGESTARTQUANTITY sy-vline 
WA_IBRNFITEMC_STR-BR_NFEFUELGAUGEENDQUANTITY sy-vline 
WA_IBRNFITEMC_STR-VEHICLEMODEL sy-vline 
WA_IBRNFITEMC_STR-VEHICLEYEAROFMANUFACTURE sy-vline 
WA_IBRNFITEMC_STR-VEHICLEMODELYEAR sy-vline 
WA_IBRNFITEMC_STR-VEHICLEFUELTYPE sy-vline 
WA_IBRNFITEMC_STR-VEHICLEENGINEPOWER sy-vline 
WA_IBRNFITEMC_STR-VEHICLECYLINDERCAPACITYVALUE sy-vline 
WA_IBRNFITEMC_STR-VEHICLEENGINENUMBER sy-vline 
WA_IBRNFITEMC_STR-VEHICLECARMAKERCOLOR sy-vline 
WA_IBRNFITEMC_STR-VEHICLEPAINTINGTYPE sy-vline 
WA_IBRNFITEMC_STR-VEHICLECOLORDESC sy-vline 
WA_IBRNFITEMC_STR-VEHICLECHASSIS sy-vline 
WA_IBRNFITEMC_STR-VEHICLESERIALNUMBER sy-vline 
WA_IBRNFITEMC_STR-VEHICLENETWEIGHT sy-vline 
WA_IBRNFITEMC_STR-VEHICLENETWEIGHTUNIT sy-vline 
WA_IBRNFITEMC_STR-VEHICLEGROSSWEIGHT sy-vline 
WA_IBRNFITEMC_STR-VEHICLEGROSSWEIGHTUNIT sy-vline 
WA_IBRNFITEMC_STR-VEHICLEMAXIMUMCAPACITYVALUE sy-vline 
WA_IBRNFITEMC_STR-VEHICLEMAXTRACTIONCAPACITY sy-vline 
WA_IBRNFITEMC_STR-DISTANCEBETWEENAXLESQTYVALUE sy-vline 
WA_IBRNFITEMC_STR-VEHICLEUSAGE sy-vline 
WA_IBRNFITEMC_STR-VEHICLECONDITION sy-vline 
WA_IBRNFITEMC_STR-VEHICLERESTRICTION sy-vline 
WA_IBRNFITEMC_STR-VEHICLEOPERATIONTYPE sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMCOSTCENTERFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFITMINTERNALORDERFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMPROFITCENTERFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMWBSELEMENTFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMCOSTOBJECTFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFITMPROJNETWORKFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMCOSTSEGMENTFRMTDDESC sy-vline 
WA_IBRNFITEMC_STR-BR_ANVISACODE sy-vline 
WA_IBRNFITEMC_STR-BR_ANVISAEXEMPTIONREASONTEXT sy-vline 
WA_IBRNFITEMC_STR-MEDICINECONSUMERMAXPRICE sy-vline 
WA_IBRNFITEMC_STR-BR_NFITEMEXPRTSQNCNUMBER sy-vline 
WA_IBRNFITEMC_STR-BR_NFEXMLVERSION sy-vline 
WA_IBRNFITEMC_STR-BR_NFEMODEL sy-vline 
WA_IBRNFITEMC_STR-ORIGINREFERENCEDOCUMENT sy-vline 
WA_IBRNFITEMC_STR-ORIGINREFERENCEDOCUMENTITEM sy-vline 
WA_IBRNFITEMC_STR-PREDECESSORREFERENCEDOCUMENT sy-vline 
WA_IBRNFITEMC_STR-PREDECESSORREFERENCEDOCITEM sy-vline 
WA_IBRNFITEMC_STR-REFERENCEDOCUMENT sy-vline 
WA_IBRNFITEMC_STR-REFERENCEDOCUMENTITEM sy-vline 
WA_IBRNFITEMC_STR-BR_NBSCODE sy-vline 
WA_IBRNFITEMC_STR-BR_EFDREINFSERVICECODE sy-vline 
WA_IBRNFITEMC_STR-BR_LC116SERVICECODE sy-vline 
WA_IBRNFITEMC_STR-SALESDOCUMENTCURRENCY sy-vline      INTO ld_text SEPARATED BY SPACE.

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