ABAP Select data from SAP table BAPI2017_GM_ITEM_SHOW_OIL 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 BAPI2017_GM_ITEM_SHOW_OIL 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 BAPI2017_GM_ITEM_SHOW_OIL. 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 BAPI2017_GM_ITEM_SHOW_OIL 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_BAPI2017_GM_ITEM_SHOW_OIL TYPE STANDARD TABLE OF BAPI2017_GM_ITEM_SHOW_OIL,
      WA_BAPI2017_GM_ITEM_SHOW_OIL TYPE BAPI2017_GM_ITEM_SHOW_OIL,
      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: <BAPI2017_GM_ITEM_SHOW_OIL> TYPE BAPI2017_GM_ITEM_SHOW_OIL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BAPI2017_GM_ITEM_SHOW_OIL
*  INTO TABLE @DATA(IT_BAPI2017_GM_ITEM_SHOW_OIL2).
*--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_BAPI2017_GM_ITEM_SHOW_OIL INDEX 1 INTO DATA(WA_BAPI2017_GM_ITEM_SHOW_OIL2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<BAPI2017_GM_ITEM_SHOW_OIL>-MAT_DOC = 1.
<BAPI2017_GM_ITEM_SHOW_OIL>-DOC_YEAR = 1.
<BAPI2017_GM_ITEM_SHOW_OIL>-MATDOC_ITM = 1.
<BAPI2017_GM_ITEM_SHOW_OIL>-LINE_ID = 1.
<BAPI2017_GM_ITEM_SHOW_OIL>-PARENT_ID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BAPI2017_GM_ITEM_SHOW_OIL-LINE_DEPTH, sy-vline,
  WA_BAPI2017_GM_ITEM_SHOW_OIL-MATERIAL, sy-vline,
  WA_BAPI2017_GM_ITEM_SHOW_OIL-PLANT, sy-vline,
  WA_BAPI2017_GM_ITEM_SHOW_OIL-STGE_LOC, sy-vline,
  WA_BAPI2017_GM_ITEM_SHOW_OIL-BATCH, sy-vline,
  WA_BAPI2017_GM_ITEM_SHOW_OIL-MOVE_TYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BAPI2017_GM_ITEM_SHOW_OIL 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_BAPI2017_GM_ITEM_SHOW_OIL 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_BAPI2017_GM_ITEM_SHOW_OIL INTO WA_BAPI2017_GM_ITEM_SHOW_OIL.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit IMKEY, internal->external for field RL_EST_KEY
CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-RL_EST_KEY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-RL_EST_KEY.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit NUMCV, internal->external for field ACTIVITY
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-ACTIVITY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-ACTIVITY.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit FMCIS, internal->external for field CMMT_ITEM
CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-CMMT_ITEM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-CMMT_ITEM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit MATNL, internal->external for field MATERIAL_EXTERNAL
CALL FUNCTION 'CONVERSION_EXIT_MATNL_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-MATERIAL_EXTERNAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-MATERIAL_EXTERNAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATNW, internal->external for field MATERIAL_VERSION
CALL FUNCTION 'CONVERSION_EXIT_MATNW_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-MATERIAL_VERSION
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-MATERIAL_VERSION.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATNL, internal->external for field MOVE_MAT_EXTERNAL
CALL FUNCTION 'CONVERSION_EXIT_MATNL_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-MOVE_MAT_EXTERNAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-MOVE_MAT_EXTERNAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATNW, internal->external for field MOVE_MAT_VERSION
CALL FUNCTION 'CONVERSION_EXIT_MATNW_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-MOVE_MAT_VERSION
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-MOVE_MAT_VERSION.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit FMCIL, internal->external for field CMMT_ITEM_LONG
CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-CMMT_ITEM_LONG
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-CMMT_ITEM_LONG.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field INTTRACKINGNUMBER
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_BAPI2017_GM_ITEM_SHOW_OIL-INTTRACKINGNUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_BAPI2017_GM_ITEM_SHOW_OIL-INTTRACKINGNUMBER.
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_BAPI2017_GM_ITEM_SHOW_OIL_STR, 
MAT_DOC TYPE STRING,
DOC_YEAR TYPE STRING,
MATDOC_ITM TYPE STRING,
LINE_ID TYPE STRING,
PARENT_ID TYPE STRING,
LINE_DEPTH TYPE STRING,
MATERIAL TYPE STRING,
PLANT TYPE STRING,
STGE_LOC TYPE STRING,
BATCH TYPE STRING,
MOVE_TYPE TYPE STRING,
STCK_TYPE TYPE STRING,
SPEC_STOCK TYPE STRING,
VENDOR TYPE STRING,
CUSTOMER TYPE STRING,
SALES_ORD TYPE STRING,
S_ORD_ITEM TYPE STRING,
SCHED_LINE TYPE STRING,
VAL_TYPE TYPE STRING,
ENTRY_QNT TYPE STRING,
ENTRY_UOM TYPE STRING,
ENTRY_UOM_ISO TYPE STRING,
PO_PR_QNT TYPE STRING,
ORDERPR_UN TYPE STRING,
ORDERPR_UN_ISO TYPE STRING,
PO_NUMBER TYPE STRING,
PO_ITEM TYPE STRING,
SHIPPING TYPE STRING,
COMP_SHIP TYPE STRING,
NO_MORE_GR TYPE STRING,
ITEM_TEXT TYPE STRING,
GR_RCPT TYPE STRING,
UNLOAD_PT TYPE STRING,
COSTCENTER TYPE STRING,
ORDERID TYPE STRING,
ORDER_ITNO TYPE STRING,
CALC_MOTIVE TYPE STRING,
ASSET_NO TYPE STRING,
SUB_NUMBER TYPE STRING,
RESERV_NO TYPE STRING,
RES_ITEM TYPE STRING,
RES_TYPE TYPE STRING,
WITHDRAWN TYPE STRING,
MOVE_MAT TYPE STRING,
MOVE_PLANT TYPE STRING,
MOVE_STLOC TYPE STRING,
MOVE_BATCH TYPE STRING,
MOVE_VAL_TYPE TYPE STRING,
MVT_IND TYPE STRING,
MOVE_REAS TYPE STRING,
RL_EST_KEY TYPE STRING,
REF_DATE TYPE STRING,
COST_OBJ TYPE STRING,
PROFIT_SEGM_NO TYPE STRING,
PROFIT_CTR TYPE STRING,
WBS_ELEM TYPE STRING,
NETWORK TYPE STRING,
ACTIVITY TYPE STRING,
PART_ACCT TYPE STRING,
AMOUNT_LC TYPE STRING,
AMOUNT_SV TYPE STRING,
CURRENCY TYPE STRING,
CURRENCY_ISO TYPE STRING,
REF_DOC_YR TYPE STRING,
REF_DOC TYPE STRING,
REF_DOC_IT TYPE STRING,
EXPIRYDATE TYPE STRING,
PROD_DATE TYPE STRING,
FUND TYPE STRING,
FUNDS_CTR TYPE STRING,
CMMT_ITEM TYPE STRING,
VAL_SALES_ORD TYPE STRING,
VAL_S_ORD_ITEM TYPE STRING,
VAL_WBS_ELEM TYPE STRING,
CO_BUSPROC TYPE STRING,
ACTTYPE TYPE STRING,
SUPPL_VEND TYPE STRING,
X_AUTO_CRE TYPE STRING,
MATERIAL_EXTERNAL TYPE STRING,
MATERIAL_GUID TYPE STRING,
MATERIAL_VERSION TYPE STRING,
MOVE_MAT_EXTERNAL TYPE STRING,
MOVE_MAT_GUID TYPE STRING,
MOVE_MAT_VERSION TYPE STRING,
GRANT_NBR TYPE STRING,
CMMT_ITEM_LONG TYPE STRING,
FUNC_AREA_LONG TYPE STRING,
ORIGINCITY TYPE STRING,
ORIGINCOUNTY TYPE STRING,
ORIGINREGION TYPE STRING,
ORIGINCOUNTRYISO TYPE STRING,
DESTINATIONCITY TYPE STRING,
DESTINATIONCOUNTY TYPE STRING,
DESTINATIONREGION TYPE STRING,
DESTINATIONCOUTRYISO TYPE STRING,
TAXORIGIN TYPE STRING,
TAXDESTINATION TYPE STRING,
PIPELINETRIPNUMBER TYPE STRING,
PIPELINEBATCHNUMBER TYPE STRING,
MODEOFTRANSPORT TYPE STRING,
ALTERNATEORIGIN TYPE STRING,
ALTERNATEDESTINATION TYPE STRING,
TRUCKNUMBER TYPE STRING,
VENDOR_NO TYPE STRING,
EXTERNALLICENSE TYPE STRING,
VALIDFROM TYPE STRING,
VALIDTO TYPE STRING,
LICENSETYPE TYPE STRING,
INTERNALLICENSE TYPE STRING,
FOLLOWONLICENSE TYPE STRING,
FOLLOWONQUANTITY TYPE STRING,
EXTERNALBILLOFLADING TYPE STRING,
MISCDELIVERYNUMBER TYPE STRING,
HANDLING_TYPE TYPE STRING,
ED_PRICING_EXTERN TYPE STRING,
INTTRACKINGNUMBER TYPE STRING,
TRACKINGNUMBERYEAR TYPE STRING,
EXTTRACKINGNUMBER TYPE STRING,
TRACKINGITEM TYPE STRING,
FINALTRANSFERIND TYPE STRING,
ISSUINGVALUATIONTYPE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BAPI2017_GM_ITEM_SHOW_OIL_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_BAPI2017_GM_ITEM_SHOW_OIL_STR-MAT_DOC sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-DOC_YEAR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MATDOC_ITM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-LINE_ID sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PARENT_ID sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-LINE_DEPTH sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MATERIAL sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PLANT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-STGE_LOC sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-BATCH sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_TYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-STCK_TYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-SPEC_STOCK sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VENDOR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CUSTOMER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-SALES_ORD sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-S_ORD_ITEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-SCHED_LINE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VAL_TYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ENTRY_QNT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ENTRY_UOM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ENTRY_UOM_ISO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PO_PR_QNT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORDERPR_UN sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORDERPR_UN_ISO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PO_NUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PO_ITEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-SHIPPING sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-COMP_SHIP sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-NO_MORE_GR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ITEM_TEXT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-GR_RCPT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-UNLOAD_PT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-COSTCENTER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORDERID sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORDER_ITNO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CALC_MOTIVE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ASSET_NO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-SUB_NUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-RESERV_NO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-RES_ITEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-RES_TYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-WITHDRAWN sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_MAT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_PLANT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_STLOC sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_BATCH sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_VAL_TYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MVT_IND sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_REAS sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-RL_EST_KEY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-REF_DATE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-COST_OBJ sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PROFIT_SEGM_NO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PROFIT_CTR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-WBS_ELEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-NETWORK sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ACTIVITY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PART_ACCT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-AMOUNT_LC sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-AMOUNT_SV sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CURRENCY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CURRENCY_ISO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-REF_DOC_YR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-REF_DOC sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-REF_DOC_IT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-EXPIRYDATE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PROD_DATE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-FUND sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-FUNDS_CTR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CMMT_ITEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VAL_SALES_ORD sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VAL_S_ORD_ITEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VAL_WBS_ELEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CO_BUSPROC sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ACTTYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-SUPPL_VEND sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-X_AUTO_CRE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MATERIAL_EXTERNAL sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MATERIAL_GUID sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MATERIAL_VERSION sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_MAT_EXTERNAL sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_MAT_GUID sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MOVE_MAT_VERSION sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-GRANT_NBR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-CMMT_ITEM_LONG sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-FUNC_AREA_LONG sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORIGINCITY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORIGINCOUNTY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORIGINREGION sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ORIGINCOUNTRYISO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-DESTINATIONCITY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-DESTINATIONCOUNTY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-DESTINATIONREGION sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-DESTINATIONCOUTRYISO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-TAXORIGIN sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-TAXDESTINATION sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PIPELINETRIPNUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-PIPELINEBATCHNUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MODEOFTRANSPORT sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ALTERNATEORIGIN sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ALTERNATEDESTINATION sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-TRUCKNUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VENDOR_NO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-EXTERNALLICENSE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VALIDFROM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-VALIDTO sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-LICENSETYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-INTERNALLICENSE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-FOLLOWONLICENSE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-FOLLOWONQUANTITY sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-EXTERNALBILLOFLADING sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-MISCDELIVERYNUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-HANDLING_TYPE sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ED_PRICING_EXTERN sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-INTTRACKINGNUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-TRACKINGNUMBERYEAR sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-EXTTRACKINGNUMBER sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-TRACKINGITEM sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-FINALTRANSFERIND sy-vline 
WA_BAPI2017_GM_ITEM_SHOW_OIL_STR-ISSUINGVALUATIONTYPE sy-vline      INTO ld_text SEPARATED BY SPACE.

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