ABAP Select data from SAP table KNC1_BAK 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 KNC1_BAK 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 KNC1_BAK. 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 KNC1_BAK 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_KNC1_BAK TYPE STANDARD TABLE OF KNC1_BAK,
      WA_KNC1_BAK TYPE KNC1_BAK,
      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: <KNC1_BAK> TYPE KNC1_BAK.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM KNC1_BAK
*  INTO TABLE @DATA(IT_KNC1_BAK2).
*--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_KNC1_BAK INDEX 1 INTO DATA(WA_KNC1_BAK2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_KNC1_BAK ASSIGNING <KNC1_BAK>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<KNC1_BAK>-MANDT = 1.
<KNC1_BAK>-KUNNR = 1.
<KNC1_BAK>-BUKRS = 1.
<KNC1_BAK>-GJAHR = 1.
<KNC1_BAK>-ERDAT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_KNC1_BAK-USNAM, sy-vline,
WA_KNC1_BAK-UMSAV, sy-vline,
WA_KNC1_BAK-UM01S, sy-vline,
WA_KNC1_BAK-UM01H, sy-vline,
WA_KNC1_BAK-UM01U, sy-vline,
WA_KNC1_BAK-UM02S, sy-vline.
ENDLOOP. *Add any further fields from structure WA_KNC1_BAK 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_KNC1_BAK 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_KNC1_BAK INTO WA_KNC1_BAK. *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 KUNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_KNC1_BAK-KUNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-KUNNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AC152, internal->external for field UMSAV CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UMSAV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UMSAV.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM01S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM01S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM01S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM01H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM01H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM01H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM01U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM01U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM01U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM02S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM02S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM02S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM02H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM02H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM02H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM02U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM02U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM02U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM03S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM03S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM03S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM03H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM03H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM03H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM03U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM03U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM03U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM04S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM04S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM04S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM04H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM04H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM04H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM04U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM04U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM04U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM05S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM05S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM05S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM05H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM05H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM05H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM05U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM05U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM05U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM06S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM06S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM06S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM06H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM06H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM06H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM06U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM06U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM06U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM07S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM07S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM07S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM07H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM07H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM07H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM07U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM07U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM07U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM08S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM08S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM08S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM08H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM08H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM08H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM08U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM08U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM08U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM09S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM09S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM09S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM09H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM09H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM09H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM09U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM09U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM09U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM10S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM10S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM10S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM10H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM10H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM10H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM10U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM10U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM10U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM11S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM11S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM11S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM11H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM11H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM11H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM11U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM11U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM11U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM12S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM12S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM12S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM12H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM12H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM12H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM12U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM12U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM12U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM13S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM13S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM13S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM13H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM13H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM13H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM13U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM13U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM13U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM14S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM14S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM14S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM14H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM14H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM14H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM14U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM14U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM14U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM15S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM15S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM15S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM15H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM15H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM15H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM15U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM15U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM15U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM16S CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM16S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM16S.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM16H CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM16H IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM16H.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UM16U CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UM16U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UM16U.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field BABZG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-BABZG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-BABZG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field UABZG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-UABZG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-UABZG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KZINS CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-KZINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-KZINS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field KUMAG CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_KNC1_BAK-KUMAG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_KNC1_BAK-KUMAG.
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_KNC1_BAK_STR,
MANDT TYPE STRING,
KUNNR TYPE STRING,
BUKRS TYPE STRING,
GJAHR TYPE STRING,
ERDAT TYPE STRING,
USNAM TYPE STRING,
UMSAV TYPE STRING,
UM01S TYPE STRING,
UM01H TYPE STRING,
UM01U TYPE STRING,
UM02S TYPE STRING,
UM02H TYPE STRING,
UM02U TYPE STRING,
UM03S TYPE STRING,
UM03H TYPE STRING,
UM03U TYPE STRING,
UM04S TYPE STRING,
UM04H TYPE STRING,
UM04U TYPE STRING,
UM05S TYPE STRING,
UM05H TYPE STRING,
UM05U TYPE STRING,
UM06S TYPE STRING,
UM06H TYPE STRING,
UM06U TYPE STRING,
UM07S TYPE STRING,
UM07H TYPE STRING,
UM07U TYPE STRING,
UM08S TYPE STRING,
UM08H TYPE STRING,
UM08U TYPE STRING,
UM09S TYPE STRING,
UM09H TYPE STRING,
UM09U TYPE STRING,
UM10S TYPE STRING,
UM10H TYPE STRING,
UM10U TYPE STRING,
UM11S TYPE STRING,
UM11H TYPE STRING,
UM11U TYPE STRING,
UM12S TYPE STRING,
UM12H TYPE STRING,
UM12U TYPE STRING,
UM13S TYPE STRING,
UM13H TYPE STRING,
UM13U TYPE STRING,
UM14S TYPE STRING,
UM14H TYPE STRING,
UM14U TYPE STRING,
UM15S TYPE STRING,
UM15H TYPE STRING,
UM15U TYPE STRING,
UM16S TYPE STRING,
UM16H TYPE STRING,
UM16U TYPE STRING,
BABZG TYPE STRING,
UABZG TYPE STRING,
KZINS TYPE STRING,
KUMAG TYPE STRING,END OF T_EKKO_STR. DATA: WA_KNC1_BAK_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_KNC1_BAK_STR-MANDT sy-vline
WA_KNC1_BAK_STR-KUNNR sy-vline
WA_KNC1_BAK_STR-BUKRS sy-vline
WA_KNC1_BAK_STR-GJAHR sy-vline
WA_KNC1_BAK_STR-ERDAT sy-vline
WA_KNC1_BAK_STR-USNAM sy-vline
WA_KNC1_BAK_STR-UMSAV sy-vline
WA_KNC1_BAK_STR-UM01S sy-vline
WA_KNC1_BAK_STR-UM01H sy-vline
WA_KNC1_BAK_STR-UM01U sy-vline
WA_KNC1_BAK_STR-UM02S sy-vline
WA_KNC1_BAK_STR-UM02H sy-vline
WA_KNC1_BAK_STR-UM02U sy-vline
WA_KNC1_BAK_STR-UM03S sy-vline
WA_KNC1_BAK_STR-UM03H sy-vline
WA_KNC1_BAK_STR-UM03U sy-vline
WA_KNC1_BAK_STR-UM04S sy-vline
WA_KNC1_BAK_STR-UM04H sy-vline
WA_KNC1_BAK_STR-UM04U sy-vline
WA_KNC1_BAK_STR-UM05S sy-vline
WA_KNC1_BAK_STR-UM05H sy-vline
WA_KNC1_BAK_STR-UM05U sy-vline
WA_KNC1_BAK_STR-UM06S sy-vline
WA_KNC1_BAK_STR-UM06H sy-vline
WA_KNC1_BAK_STR-UM06U sy-vline
WA_KNC1_BAK_STR-UM07S sy-vline
WA_KNC1_BAK_STR-UM07H sy-vline
WA_KNC1_BAK_STR-UM07U sy-vline
WA_KNC1_BAK_STR-UM08S sy-vline
WA_KNC1_BAK_STR-UM08H sy-vline
WA_KNC1_BAK_STR-UM08U sy-vline
WA_KNC1_BAK_STR-UM09S sy-vline
WA_KNC1_BAK_STR-UM09H sy-vline
WA_KNC1_BAK_STR-UM09U sy-vline
WA_KNC1_BAK_STR-UM10S sy-vline
WA_KNC1_BAK_STR-UM10H sy-vline
WA_KNC1_BAK_STR-UM10U sy-vline
WA_KNC1_BAK_STR-UM11S sy-vline
WA_KNC1_BAK_STR-UM11H sy-vline
WA_KNC1_BAK_STR-UM11U sy-vline
WA_KNC1_BAK_STR-UM12S sy-vline
WA_KNC1_BAK_STR-UM12H sy-vline
WA_KNC1_BAK_STR-UM12U sy-vline
WA_KNC1_BAK_STR-UM13S sy-vline
WA_KNC1_BAK_STR-UM13H sy-vline
WA_KNC1_BAK_STR-UM13U sy-vline
WA_KNC1_BAK_STR-UM14S sy-vline
WA_KNC1_BAK_STR-UM14H sy-vline
WA_KNC1_BAK_STR-UM14U sy-vline
WA_KNC1_BAK_STR-UM15S sy-vline
WA_KNC1_BAK_STR-UM15H sy-vline
WA_KNC1_BAK_STR-UM15U sy-vline
WA_KNC1_BAK_STR-UM16S sy-vline
WA_KNC1_BAK_STR-UM16H sy-vline
WA_KNC1_BAK_STR-UM16U sy-vline
WA_KNC1_BAK_STR-BABZG sy-vline
WA_KNC1_BAK_STR-UABZG sy-vline
WA_KNC1_BAK_STR-KZINS sy-vline
WA_KNC1_BAK_STR-KUMAG sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.