ABAP Select data from SAP table OIJNOMIVB 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 OIJNOMIVB 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 OIJNOMIVB. 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 OIJNOMIVB 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_OIJNOMIVB TYPE STANDARD TABLE OF OIJNOMIVB,
      WA_OIJNOMIVB TYPE OIJNOMIVB,
      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: <OIJNOMIVB> TYPE OIJNOMIVB.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM OIJNOMIVB
*  INTO TABLE @DATA(IT_OIJNOMIVB2).
*--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_OIJNOMIVB INDEX 1 INTO DATA(WA_OIJNOMIVB2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<OIJNOMIVB>-MANDT = 1.
<OIJNOMIVB>-NOMTK = 1.
<OIJNOMIVB>-NOMIT = 1.
<OIJNOMIVB>-SITYP = 1.
<OIJNOMIVB>-ISTAT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_OIJNOMIVB-ISUBSTAT, sy-vline,
  WA_OIJNOMIVB-IDATE, sy-vline,
  WA_OIJNOMIVB-SCHED_TST_FROM, sy-vline,
  WA_OIJNOMIVB-SCHED_TST_TO, sy-vline,
  WA_OIJNOMIVB-LOCID, sy-vline,
  WA_OIJNOMIVB-S_MATNR_I, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_OIJNOMIVB 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_OIJNOMIVB 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_OIJNOMIVB INTO WA_OIJNOMIVB.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field DUTY_TO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_OIJNOMIVB-DUTY_TO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_OIJNOMIVB-DUTY_TO.
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_OIJNOMIVB_STR, 
MANDT TYPE STRING,
NOMTK TYPE STRING,
NOMIT TYPE STRING,
SITYP TYPE STRING,
ISTAT TYPE STRING,
ISUBSTAT TYPE STRING,
IDATE TYPE STRING,
SCHED_TST_FROM TYPE STRING,
SCHED_TST_TO TYPE STRING,
LOCID TYPE STRING,
S_MATNR_I TYPE STRING,
MATNR_I TYPE STRING,
MENGE TYPE STRING,
UNIT_I TYPE STRING,
UNIT_I_T TYPE STRING,
DOCIND TYPE STRING,
DOCNR TYPE STRING,
DOCITM TYPE STRING,
DOCSCHEDLN TYPE STRING,
QTYFCR TYPE STRING,
QTYFCR_UOM TYPE STRING,
WORKLIST_I TYPE STRING,
TANK TYPE STRING,
CONS TYPE STRING,
PARTNR TYPE STRING,
CONPAT TYPE STRING,
INSPE TYPE STRING,
IMPOEXPO TYPE STRING,
FLAG_IMEX TYPE STRING,
OWNER TYPE STRING,
CHARG_O TYPE STRING,
CHARG_D TYPE STRING,
RVP TYPE STRING,
VALUATIONTYPE_O TYPE STRING,
VALUATIONTYPE_D TYPE STRING,
SHNUM TYPE STRING,
SHITEM TYPE STRING,
ILOCK TYPE STRING,
PRORATEQTY TYPE STRING,
ASSIGNEDQTY TYPE STRING,
ACTDAT TYPE STRING,
ACTTIME TYPE STRING,
ACTUALS TYPE STRING,
ACTUALQTY TYPE STRING,
ACTUALUOM TYPE STRING,
ITBOTOL TYPE STRING,
ITBUTOL TYPE STRING,
ITBOTOLABS TYPE STRING,
ITBUTOLABS TYPE STRING,
ITTOLUNIT TYPE STRING,
UNLIMITED TYPE STRING,
BLOIND TYPE STRING,
DELIND TYPE STRING,
UPDATEXDOK TYPE STRING,
INCOMPLETE_FLAG TYPE STRING,
DOCTYP TYPE STRING,
LDRATE TYPE STRING,
LDQUOM TYPE STRING,
LDTUOM TYPE STRING,
THIRD_NOMNR TYPE STRING,
UPMAT TYPE STRING,
REFITEM TYPE STRING,
STLTY TYPE STRING,
STLKN TYPE STRING,
CHARG_D_CREATE TYPE STRING,
CHARG_O_CREATE TYPE STRING,
CO_CARR TYPE STRING,
CO_SHIP TYPE STRING,
CO_TSYST TYPE STRING,
COMMCTL TYPE STRING,
SOLDTO TYPE STRING,
PRORATE_ROUTINE TYPE STRING,
CHARG_L TYPE STRING,
CHARG_L_CREATE TYPE STRING,
TCNUM TYPE STRING,
TCITM TYPE STRING,
GA_NMSHIPPER TYPE STRING,
GA_CONF_QTY TYPE STRING,
GA_CONF_UOM TYPE STRING,
GA_TECHSCH_QTY TYPE STRING,
GA_TECHSCH_UOM TYPE STRING,
GA_CONF_QTY_CAL TYPE STRING,
GA_TSCH_QTY_CAL TYPE STRING,
GA_ALLOCATED_QTY TYPE STRING,
GA_ALLOCATED_UOM TYPE STRING,
GA_RANK TYPE STRING,
CYCLE_ITEM TYPE STRING,
LESSHNUM TYPE STRING,
LESTPNUM TYPE STRING,
ATL_DELV_NUMBER TYPE STRING,
ATL_DELV_ITM TYPE STRING,
ATL_CRDT_QTY TYPE STRING,
ATL_CRDT_UOM TYPE STRING,
ATL_CRDT_VAL TYPE STRING,
ATL_CRDT_CURR TYPE STRING,
PRE_EXIST_IND TYPE STRING,
PLANIND TYPE STRING,
LOCPT TYPE STRING,
LOCSL TYPE STRING,
QUICKCONF TYPE STRING,
ERDAT TYPE STRING,
ERZEIT TYPE STRING,
ERNAM TYPE STRING,
AEDAT TYPE STRING,
AEZEIT TYPE STRING,
AENAM TYPE STRING,
LOCNAM TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
NOMIT_CONS TYPE STRING,
ACTUALQTY_PAR TYPE STRING,
ACTUALUOM_PAR TYPE STRING,
LOV_IND TYPE STRING,
FERRYIND TYPE STRING,
RAILCARQTY TYPE STRING,
OITAXFROM TYPE STRING,
OIHANTYP TYPE STRING,
OITAXGRP TYPE STRING,
OITAXTO TYPE STRING,
OIOILCON TYPE STRING,
OIEDBAL TYPE STRING,
OIPRICIE TYPE STRING,
OIINEX TYPE STRING,
OIEDBALM TYPE STRING,
LOG_PROC TYPE STRING,
TAX_PROC TYPE STRING,
OICERTF1 TYPE STRING,
OIDATFM1 TYPE STRING,
OIDATTO1 TYPE STRING,
OIH_LICTP TYPE STRING,
OIH_LICIN TYPE STRING,
OIH_LCFOL TYPE STRING,
OIH_FOLQTY TYPE STRING,
OICERTF1_GI TYPE STRING,
OIDATFM1_GI TYPE STRING,
OIDATTO1_GI TYPE STRING,
OIH_LICTP_GI TYPE STRING,
OIH_LICIN_GI TYPE STRING,
OIH_LCFOL_GI TYPE STRING,
OIH_FOLQTY_GI TYPE STRING,
OIPIPEVAL TYPE STRING,
OIC_LIFNR TYPE STRING,
OIC_DCITYC TYPE STRING,
OIC_DCOUNC TYPE STRING,
OIC_DREGIO TYPE STRING,
OIC_DLAND1 TYPE STRING,
OIC_OCITYC TYPE STRING,
OIC_OCOUNC TYPE STRING,
OIC_OREGIO TYPE STRING,
OIC_OLAND1 TYPE STRING,
OIC_PORGIN TYPE STRING,
OIC_PDESTN TYPE STRING,
OIC_PTRIP TYPE STRING,
OIC_PBATCH TYPE STRING,
OIC_MOT TYPE STRING,
OIC_AORGIN TYPE STRING,
OIC_ADESTN TYPE STRING,
OIC_TRUCKN TYPE STRING,
OIA_BASELO TYPE STRING,
OIEDOK TYPE STRING,
OIEDOK_GI TYPE STRING,
OIEDBAL_GI TYPE STRING,
OIEDBALM_GI TYPE STRING,
OIHANTYP_GI TYPE STRING,
OIINEX_GI TYPE STRING,
OITAXGRP_GI TYPE STRING,
OITAXFROM_GI TYPE STRING,
OITAXTO_GI TYPE STRING,
BWTAR_INTRANSIT TYPE STRING,
HT_GL TYPE STRING,
HT_LOAD TYPE STRING,
HT_DIS TYPE STRING,
LICIN_NUM TYPE STRING,
LICEXT_NUM TYPE STRING,
OIH_DISTLIC TYPE STRING,
SHIP_FROM TYPE STRING,
DUTY_TO TYPE STRING,
_DATAAGING TYPE STRING,
DUMMY_NOMITM_INCL_EEW_PS TYPE STRING,
/DMBE/SMARTID TYPE STRING,
/DMBE/OPTIONALITYKEY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_OIJNOMIVB_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_OIJNOMIVB_STR-MANDT sy-vline 
WA_OIJNOMIVB_STR-NOMTK sy-vline 
WA_OIJNOMIVB_STR-NOMIT sy-vline 
WA_OIJNOMIVB_STR-SITYP sy-vline 
WA_OIJNOMIVB_STR-ISTAT sy-vline 
WA_OIJNOMIVB_STR-ISUBSTAT sy-vline 
WA_OIJNOMIVB_STR-IDATE sy-vline 
WA_OIJNOMIVB_STR-SCHED_TST_FROM sy-vline 
WA_OIJNOMIVB_STR-SCHED_TST_TO sy-vline 
WA_OIJNOMIVB_STR-LOCID sy-vline 
WA_OIJNOMIVB_STR-S_MATNR_I sy-vline 
WA_OIJNOMIVB_STR-MATNR_I sy-vline 
WA_OIJNOMIVB_STR-MENGE sy-vline 
WA_OIJNOMIVB_STR-UNIT_I sy-vline 
WA_OIJNOMIVB_STR-UNIT_I_T sy-vline 
WA_OIJNOMIVB_STR-DOCIND sy-vline 
WA_OIJNOMIVB_STR-DOCNR sy-vline 
WA_OIJNOMIVB_STR-DOCITM sy-vline 
WA_OIJNOMIVB_STR-DOCSCHEDLN sy-vline 
WA_OIJNOMIVB_STR-QTYFCR sy-vline 
WA_OIJNOMIVB_STR-QTYFCR_UOM sy-vline 
WA_OIJNOMIVB_STR-WORKLIST_I sy-vline 
WA_OIJNOMIVB_STR-TANK sy-vline 
WA_OIJNOMIVB_STR-CONS sy-vline 
WA_OIJNOMIVB_STR-PARTNR sy-vline 
WA_OIJNOMIVB_STR-CONPAT sy-vline 
WA_OIJNOMIVB_STR-INSPE sy-vline 
WA_OIJNOMIVB_STR-IMPOEXPO sy-vline 
WA_OIJNOMIVB_STR-FLAG_IMEX sy-vline 
WA_OIJNOMIVB_STR-OWNER sy-vline 
WA_OIJNOMIVB_STR-CHARG_O sy-vline 
WA_OIJNOMIVB_STR-CHARG_D sy-vline 
WA_OIJNOMIVB_STR-RVP sy-vline 
WA_OIJNOMIVB_STR-VALUATIONTYPE_O sy-vline 
WA_OIJNOMIVB_STR-VALUATIONTYPE_D sy-vline 
WA_OIJNOMIVB_STR-SHNUM sy-vline 
WA_OIJNOMIVB_STR-SHITEM sy-vline 
WA_OIJNOMIVB_STR-ILOCK sy-vline 
WA_OIJNOMIVB_STR-PRORATEQTY sy-vline 
WA_OIJNOMIVB_STR-ASSIGNEDQTY sy-vline 
WA_OIJNOMIVB_STR-ACTDAT sy-vline 
WA_OIJNOMIVB_STR-ACTTIME sy-vline 
WA_OIJNOMIVB_STR-ACTUALS sy-vline 
WA_OIJNOMIVB_STR-ACTUALQTY sy-vline 
WA_OIJNOMIVB_STR-ACTUALUOM sy-vline 
WA_OIJNOMIVB_STR-ITBOTOL sy-vline 
WA_OIJNOMIVB_STR-ITBUTOL sy-vline 
WA_OIJNOMIVB_STR-ITBOTOLABS sy-vline 
WA_OIJNOMIVB_STR-ITBUTOLABS sy-vline 
WA_OIJNOMIVB_STR-ITTOLUNIT sy-vline 
WA_OIJNOMIVB_STR-UNLIMITED sy-vline 
WA_OIJNOMIVB_STR-BLOIND sy-vline 
WA_OIJNOMIVB_STR-DELIND sy-vline 
WA_OIJNOMIVB_STR-UPDATEXDOK sy-vline 
WA_OIJNOMIVB_STR-INCOMPLETE_FLAG sy-vline 
WA_OIJNOMIVB_STR-DOCTYP sy-vline 
WA_OIJNOMIVB_STR-LDRATE sy-vline 
WA_OIJNOMIVB_STR-LDQUOM sy-vline 
WA_OIJNOMIVB_STR-LDTUOM sy-vline 
WA_OIJNOMIVB_STR-THIRD_NOMNR sy-vline 
WA_OIJNOMIVB_STR-UPMAT sy-vline 
WA_OIJNOMIVB_STR-REFITEM sy-vline 
WA_OIJNOMIVB_STR-STLTY sy-vline 
WA_OIJNOMIVB_STR-STLKN sy-vline 
WA_OIJNOMIVB_STR-CHARG_D_CREATE sy-vline 
WA_OIJNOMIVB_STR-CHARG_O_CREATE sy-vline 
WA_OIJNOMIVB_STR-CO_CARR sy-vline 
WA_OIJNOMIVB_STR-CO_SHIP sy-vline 
WA_OIJNOMIVB_STR-CO_TSYST sy-vline 
WA_OIJNOMIVB_STR-COMMCTL sy-vline 
WA_OIJNOMIVB_STR-SOLDTO sy-vline 
WA_OIJNOMIVB_STR-PRORATE_ROUTINE sy-vline 
WA_OIJNOMIVB_STR-CHARG_L sy-vline 
WA_OIJNOMIVB_STR-CHARG_L_CREATE sy-vline 
WA_OIJNOMIVB_STR-TCNUM sy-vline 
WA_OIJNOMIVB_STR-TCITM sy-vline 
WA_OIJNOMIVB_STR-GA_NMSHIPPER sy-vline 
WA_OIJNOMIVB_STR-GA_CONF_QTY sy-vline 
WA_OIJNOMIVB_STR-GA_CONF_UOM sy-vline 
WA_OIJNOMIVB_STR-GA_TECHSCH_QTY sy-vline 
WA_OIJNOMIVB_STR-GA_TECHSCH_UOM sy-vline 
WA_OIJNOMIVB_STR-GA_CONF_QTY_CAL sy-vline 
WA_OIJNOMIVB_STR-GA_TSCH_QTY_CAL sy-vline 
WA_OIJNOMIVB_STR-GA_ALLOCATED_QTY sy-vline 
WA_OIJNOMIVB_STR-GA_ALLOCATED_UOM sy-vline 
WA_OIJNOMIVB_STR-GA_RANK sy-vline 
WA_OIJNOMIVB_STR-CYCLE_ITEM sy-vline 
WA_OIJNOMIVB_STR-LESSHNUM sy-vline 
WA_OIJNOMIVB_STR-LESTPNUM sy-vline 
WA_OIJNOMIVB_STR-ATL_DELV_NUMBER sy-vline 
WA_OIJNOMIVB_STR-ATL_DELV_ITM sy-vline 
WA_OIJNOMIVB_STR-ATL_CRDT_QTY sy-vline 
WA_OIJNOMIVB_STR-ATL_CRDT_UOM sy-vline 
WA_OIJNOMIVB_STR-ATL_CRDT_VAL sy-vline 
WA_OIJNOMIVB_STR-ATL_CRDT_CURR sy-vline 
WA_OIJNOMIVB_STR-PRE_EXIST_IND sy-vline 
WA_OIJNOMIVB_STR-PLANIND sy-vline 
WA_OIJNOMIVB_STR-LOCPT sy-vline 
WA_OIJNOMIVB_STR-LOCSL sy-vline 
WA_OIJNOMIVB_STR-QUICKCONF sy-vline 
WA_OIJNOMIVB_STR-ERDAT sy-vline 
WA_OIJNOMIVB_STR-ERZEIT sy-vline 
WA_OIJNOMIVB_STR-ERNAM sy-vline 
WA_OIJNOMIVB_STR-AEDAT sy-vline 
WA_OIJNOMIVB_STR-AEZEIT sy-vline 
WA_OIJNOMIVB_STR-AENAM sy-vline 
WA_OIJNOMIVB_STR-LOCNAM sy-vline 
WA_OIJNOMIVB_STR-VBELN sy-vline 
WA_OIJNOMIVB_STR-POSNR sy-vline 
WA_OIJNOMIVB_STR-NOMIT_CONS sy-vline 
WA_OIJNOMIVB_STR-ACTUALQTY_PAR sy-vline 
WA_OIJNOMIVB_STR-ACTUALUOM_PAR sy-vline 
WA_OIJNOMIVB_STR-LOV_IND sy-vline 
WA_OIJNOMIVB_STR-FERRYIND sy-vline 
WA_OIJNOMIVB_STR-RAILCARQTY sy-vline 
WA_OIJNOMIVB_STR-OITAXFROM sy-vline 
WA_OIJNOMIVB_STR-OIHANTYP sy-vline 
WA_OIJNOMIVB_STR-OITAXGRP sy-vline 
WA_OIJNOMIVB_STR-OITAXTO sy-vline 
WA_OIJNOMIVB_STR-OIOILCON sy-vline 
WA_OIJNOMIVB_STR-OIEDBAL sy-vline 
WA_OIJNOMIVB_STR-OIPRICIE sy-vline 
WA_OIJNOMIVB_STR-OIINEX sy-vline 
WA_OIJNOMIVB_STR-OIEDBALM sy-vline 
WA_OIJNOMIVB_STR-LOG_PROC sy-vline 
WA_OIJNOMIVB_STR-TAX_PROC sy-vline 
WA_OIJNOMIVB_STR-OICERTF1 sy-vline 
WA_OIJNOMIVB_STR-OIDATFM1 sy-vline 
WA_OIJNOMIVB_STR-OIDATTO1 sy-vline 
WA_OIJNOMIVB_STR-OIH_LICTP sy-vline 
WA_OIJNOMIVB_STR-OIH_LICIN sy-vline 
WA_OIJNOMIVB_STR-OIH_LCFOL sy-vline 
WA_OIJNOMIVB_STR-OIH_FOLQTY sy-vline 
WA_OIJNOMIVB_STR-OICERTF1_GI sy-vline 
WA_OIJNOMIVB_STR-OIDATFM1_GI sy-vline 
WA_OIJNOMIVB_STR-OIDATTO1_GI sy-vline 
WA_OIJNOMIVB_STR-OIH_LICTP_GI sy-vline 
WA_OIJNOMIVB_STR-OIH_LICIN_GI sy-vline 
WA_OIJNOMIVB_STR-OIH_LCFOL_GI sy-vline 
WA_OIJNOMIVB_STR-OIH_FOLQTY_GI sy-vline 
WA_OIJNOMIVB_STR-OIPIPEVAL sy-vline 
WA_OIJNOMIVB_STR-OIC_LIFNR sy-vline 
WA_OIJNOMIVB_STR-OIC_DCITYC sy-vline 
WA_OIJNOMIVB_STR-OIC_DCOUNC sy-vline 
WA_OIJNOMIVB_STR-OIC_DREGIO sy-vline 
WA_OIJNOMIVB_STR-OIC_DLAND1 sy-vline 
WA_OIJNOMIVB_STR-OIC_OCITYC sy-vline 
WA_OIJNOMIVB_STR-OIC_OCOUNC sy-vline 
WA_OIJNOMIVB_STR-OIC_OREGIO sy-vline 
WA_OIJNOMIVB_STR-OIC_OLAND1 sy-vline 
WA_OIJNOMIVB_STR-OIC_PORGIN sy-vline 
WA_OIJNOMIVB_STR-OIC_PDESTN sy-vline 
WA_OIJNOMIVB_STR-OIC_PTRIP sy-vline 
WA_OIJNOMIVB_STR-OIC_PBATCH sy-vline 
WA_OIJNOMIVB_STR-OIC_MOT sy-vline 
WA_OIJNOMIVB_STR-OIC_AORGIN sy-vline 
WA_OIJNOMIVB_STR-OIC_ADESTN sy-vline 
WA_OIJNOMIVB_STR-OIC_TRUCKN sy-vline 
WA_OIJNOMIVB_STR-OIA_BASELO sy-vline 
WA_OIJNOMIVB_STR-OIEDOK sy-vline 
WA_OIJNOMIVB_STR-OIEDOK_GI sy-vline 
WA_OIJNOMIVB_STR-OIEDBAL_GI sy-vline 
WA_OIJNOMIVB_STR-OIEDBALM_GI sy-vline 
WA_OIJNOMIVB_STR-OIHANTYP_GI sy-vline 
WA_OIJNOMIVB_STR-OIINEX_GI sy-vline 
WA_OIJNOMIVB_STR-OITAXGRP_GI sy-vline 
WA_OIJNOMIVB_STR-OITAXFROM_GI sy-vline 
WA_OIJNOMIVB_STR-OITAXTO_GI sy-vline 
WA_OIJNOMIVB_STR-BWTAR_INTRANSIT sy-vline 
WA_OIJNOMIVB_STR-HT_GL sy-vline 
WA_OIJNOMIVB_STR-HT_LOAD sy-vline 
WA_OIJNOMIVB_STR-HT_DIS sy-vline 
WA_OIJNOMIVB_STR-LICIN_NUM sy-vline 
WA_OIJNOMIVB_STR-LICEXT_NUM sy-vline 
WA_OIJNOMIVB_STR-OIH_DISTLIC sy-vline 
WA_OIJNOMIVB_STR-SHIP_FROM sy-vline 
WA_OIJNOMIVB_STR-DUTY_TO sy-vline 
WA_OIJNOMIVB_STR-_DATAAGING sy-vline 
WA_OIJNOMIVB_STR-DUMMY_NOMITM_INCL_EEW_PS sy-vline 
WA_OIJNOMIVB_STR-/DMBE/SMARTID sy-vline 
WA_OIJNOMIVB_STR-/DMBE/OPTIONALITYKEY sy-vline      INTO ld_text SEPARATED BY SPACE.

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