ABAP Select data from SAP table OIB_V_UOM_AGG into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP OIB_V_UOM_AGG 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 OIB_V_UOM_AGG. 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 OIB_V_UOM_AGG 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_OIB_V_UOM_AGG TYPE STANDARD TABLE OF OIB_V_UOM_AGG, WA_OIB_V_UOM_AGG TYPE OIB_V_UOM_AGG, 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: <OIB_V_UOM_AGG> TYPE OIB_V_UOM_AGG. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_OIB_V_UOM_AGG. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM OIB_V_UOM_AGG INTO TABLE IT_OIB_V_UOM_AGG. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM OIB_V_UOM_AGG * INTO TABLE @DATA(IT_OIB_V_UOM_AGG2). *--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_OIB_V_UOM_AGG INDEX 1 INTO DATA(WA_OIB_V_UOM_AGG2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_OIB_V_UOM_AGG ASSIGNING <OIB_V_UOM_AGG>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<OIB_V_UOM_AGG>-MANDT = 1.
<OIB_V_UOM_AGG>-BUKRS = 1.
<OIB_V_UOM_AGG>-MATBF = 1.
<OIB_V_UOM_AGG>-WERKS = 1.
<OIB_V_UOM_AGG>-LGORT_SID = 1.
ENDLOOP. LOOP AT IT_OIB_V_UOM_AGG INTO WA_OIB_V_UOM_AGG. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_OIB_V_UOM_AGG-CHARG_SID, sy-vline,
WA_OIB_V_UOM_AGG-LIFNR_SID, sy-vline,
WA_OIB_V_UOM_AGG-MAT_KDAUF, sy-vline,
WA_OIB_V_UOM_AGG-MAT_KDPOS, sy-vline,
WA_OIB_V_UOM_AGG-MAT_PSPNR, sy-vline,
WA_OIB_V_UOM_AGG-KUNNR_SID, sy-vline.
ENDLOOP. *Add any further fields from structure WA_OIB_V_UOM_AGG 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_OIB_V_UOM_AGG 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_OIB_V_UOM_AGG INTO WA_OIB_V_UOM_AGG. *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 MATN1, internal->external for field MATBF CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_OIB_V_UOM_AGG-MATBF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIB_V_UOM_AGG-MATBF.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LIFNR_SID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIB_V_UOM_AGG-LIFNR_SID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIB_V_UOM_AGG-LIFNR_SID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field MAT_KDAUF CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIB_V_UOM_AGG-MAT_KDAUF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIB_V_UOM_AGG-MAT_KDAUF.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ABPSP, internal->external for field MAT_PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_OIB_V_UOM_AGG-MAT_PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIB_V_UOM_AGG-MAT_PSPNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field KUNNR_SID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIB_V_UOM_AGG-KUNNR_SID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIB_V_UOM_AGG-KUNNR_SID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field DISUB_OWNER_SID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIB_V_UOM_AGG-DISUB_OWNER_SID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIB_V_UOM_AGG-DISUB_OWNER_SID.
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_OIB_V_UOM_AGG_STR,
MANDT TYPE STRING,
BUKRS TYPE STRING,
MATBF TYPE STRING,
WERKS TYPE STRING,
LGORT_SID TYPE STRING,
CHARG_SID TYPE STRING,
LIFNR_SID TYPE STRING,
MAT_KDAUF TYPE STRING,
MAT_KDPOS TYPE STRING,
MAT_PSPNR TYPE STRING,
KUNNR_SID TYPE STRING,
SOBKZ TYPE STRING,
LBBSA_SID TYPE STRING,
DISUB_OWNER_SID TYPE STRING,
ADQNTP1L1 TYPE STRING,
ADQNTP1L2 TYPE STRING,
ADQNTP2L1 TYPE STRING,
ADQNTP2L2 TYPE STRING,
ADQNTP3L1 TYPE STRING,
ADQNTP3L2 TYPE STRING,
ADQNTP4L1 TYPE STRING,
ADQNTP4L2 TYPE STRING,
ADQNTP5L1 TYPE STRING,
ADQNTP5L2 TYPE STRING,
ADQNTP6L1 TYPE STRING,
ADQNTP6L2 TYPE STRING,
ADQNTP7L1 TYPE STRING,
ADQNTP7L2 TYPE STRING,
ADQNTP8L1 TYPE STRING,
ADQNTP8L2 TYPE STRING,
ADQNTP9L1 TYPE STRING,
ADQNTP9L2 TYPE STRING,
ADQNTP10L1 TYPE STRING,
ADQNTP10L2 TYPE STRING,
ADQNTP11L1 TYPE STRING,
ADQNTP11L2 TYPE STRING,
ADQNTP12L1 TYPE STRING,
ADQNTP12L2 TYPE STRING,
ADQNTP13L1 TYPE STRING,
ADQNTP13L2 TYPE STRING,
ADQNTP14L1 TYPE STRING,
ADQNTP14L2 TYPE STRING,
ADQNTP15L1 TYPE STRING,
ADQNTP15L2 TYPE STRING,
ADQNTP16L1 TYPE STRING,
ADQNTP16L2 TYPE STRING,
ADQNTP17L1 TYPE STRING,
ADQNTP17L2 TYPE STRING,
ADQNTP18L1 TYPE STRING,
ADQNTP18L2 TYPE STRING,
ADQNTP19L1 TYPE STRING,
ADQNTP19L2 TYPE STRING,
ADQNTP20L1 TYPE STRING,
ADQNTP20L2 TYPE STRING,
ADQNTP21L1 TYPE STRING,
ADQNTP21L2 TYPE STRING,
ADQNTP22L1 TYPE STRING,
ADQNTP22L2 TYPE STRING,
ADQNTP23L1 TYPE STRING,
ADQNTP23L2 TYPE STRING,
ADQNTP24L1 TYPE STRING,
ADQNTP24L2 TYPE STRING,
ADQNTP25L1 TYPE STRING,
ADQNTP25L2 TYPE STRING,
ADQNTP26L1 TYPE STRING,
ADQNTP26L2 TYPE STRING,
ADQNTP27L1 TYPE STRING,
ADQNTP27L2 TYPE STRING,
ADQNTP28L1 TYPE STRING,
ADQNTP28L2 TYPE STRING,
ADQNTP29L1 TYPE STRING,
ADQNTP29L2 TYPE STRING,
ADQNTP30L1 TYPE STRING,
ADQNTP30L2 TYPE STRING,
ADQNTP31L1 TYPE STRING,
ADQNTP31L2 TYPE STRING,
ADQNTP32L1 TYPE STRING,
ADQNTP32L2 TYPE STRING,
ADQNTP33L1 TYPE STRING,
ADQNTP33L2 TYPE STRING,
ADQNTP34L1 TYPE STRING,
ADQNTP34L2 TYPE STRING,
ADQNTP35L1 TYPE STRING,
ADQNTP35L2 TYPE STRING,
ADQNTP36L1 TYPE STRING,
ADQNTP36L2 TYPE STRING,
ADQNTP37L1 TYPE STRING,
ADQNTP37L2 TYPE STRING,
ADQNTP38L1 TYPE STRING,
ADQNTP38L2 TYPE STRING,
ADQNTP39L1 TYPE STRING,
ADQNTP39L2 TYPE STRING,
ADQNTP40L1 TYPE STRING,
ADQNTP40L2 TYPE STRING,
ADQNTP41L1 TYPE STRING,
ADQNTP41L2 TYPE STRING,
ADQNTP42L1 TYPE STRING,
ADQNTP42L2 TYPE STRING,
ADQNTP43L1 TYPE STRING,
ADQNTP43L2 TYPE STRING,
ADQNTP44L1 TYPE STRING,
ADQNTP44L2 TYPE STRING,
ADQNTP45L1 TYPE STRING,
ADQNTP45L2 TYPE STRING,
ADQNTP46L1 TYPE STRING,
ADQNTP46L2 TYPE STRING,
ADQNTP47L1 TYPE STRING,
ADQNTP47L2 TYPE STRING,
ADQNTP48L1 TYPE STRING,
ADQNTP48L2 TYPE STRING,
ADQNTP49L1 TYPE STRING,
ADQNTP49L2 TYPE STRING,
ADQNTP50L1 TYPE STRING,
ADQNTP50L2 TYPE STRING,
ADQNTP51L1 TYPE STRING,
ADQNTP51L2 TYPE STRING,
ADQNTP52L1 TYPE STRING,
ADQNTP52L2 TYPE STRING,
ADQNTP53L1 TYPE STRING,
ADQNTP53L2 TYPE STRING,
ADQNTP54L1 TYPE STRING,
ADQNTP54L2 TYPE STRING,
ADQNTP55L1 TYPE STRING,
ADQNTP55L2 TYPE STRING,
ADQNTP56L1 TYPE STRING,
ADQNTP56L2 TYPE STRING,
ADQNTP57L1 TYPE STRING,
ADQNTP57L2 TYPE STRING,
ADQNTP58L1 TYPE STRING,
ADQNTP58L2 TYPE STRING,
ADQNTP59L1 TYPE STRING,
ADQNTP59L2 TYPE STRING,
ADQNTP60L1 TYPE STRING,
ADQNTP60L2 TYPE STRING,END OF T_EKKO_STR. DATA: WA_OIB_V_UOM_AGG_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_OIB_V_UOM_AGG_STR-MANDT sy-vline
WA_OIB_V_UOM_AGG_STR-BUKRS sy-vline
WA_OIB_V_UOM_AGG_STR-MATBF sy-vline
WA_OIB_V_UOM_AGG_STR-WERKS sy-vline
WA_OIB_V_UOM_AGG_STR-LGORT_SID sy-vline
WA_OIB_V_UOM_AGG_STR-CHARG_SID sy-vline
WA_OIB_V_UOM_AGG_STR-LIFNR_SID sy-vline
WA_OIB_V_UOM_AGG_STR-MAT_KDAUF sy-vline
WA_OIB_V_UOM_AGG_STR-MAT_KDPOS sy-vline
WA_OIB_V_UOM_AGG_STR-MAT_PSPNR sy-vline
WA_OIB_V_UOM_AGG_STR-KUNNR_SID sy-vline
WA_OIB_V_UOM_AGG_STR-SOBKZ sy-vline
WA_OIB_V_UOM_AGG_STR-LBBSA_SID sy-vline
WA_OIB_V_UOM_AGG_STR-DISUB_OWNER_SID sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP1L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP1L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP2L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP2L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP3L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP3L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP4L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP4L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP5L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP5L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP6L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP6L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP7L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP7L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP8L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP8L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP9L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP9L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP10L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP10L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP11L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP11L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP12L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP12L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP13L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP13L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP14L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP14L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP15L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP15L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP16L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP16L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP17L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP17L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP18L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP18L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP19L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP19L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP20L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP20L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP21L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP21L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP22L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP22L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP23L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP23L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP24L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP24L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP25L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP25L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP26L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP26L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP27L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP27L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP28L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP28L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP29L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP29L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP30L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP30L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP31L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP31L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP32L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP32L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP33L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP33L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP34L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP34L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP35L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP35L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP36L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP36L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP37L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP37L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP38L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP38L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP39L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP39L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP40L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP40L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP41L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP41L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP42L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP42L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP43L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP43L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP44L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP44L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP45L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP45L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP46L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP46L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP47L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP47L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP48L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP48L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP49L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP49L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP50L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP50L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP51L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP51L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP52L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP52L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP53L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP53L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP54L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP54L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP55L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP55L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP56L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP56L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP57L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP57L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP58L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP58L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP59L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP59L2 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP60L1 sy-vline
WA_OIB_V_UOM_AGG_STR-ADQNTP60L2 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.