ABAP Select data from SAP table ENT5248 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 ENT5248 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 ENT5248. 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 ENT5248 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_ENT5248 TYPE STANDARD TABLE OF ENT5248,
      WA_ENT5248 TYPE ENT5248,
      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: <ENT5248> TYPE ENT5248.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ENT5248
*  INTO TABLE @DATA(IT_ENT52482).
*--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_ENT5248 INDEX 1 INTO DATA(WA_ENT52482).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ENT5248 ASSIGNING <ENT5248>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ENT5248>-MANDT = 1.
<ENT5248>-AUFPL = 1.
<ENT5248>-APLZL = 1.
<ENT5248>-PLNFL = 1.
<ENT5248>-PLNKN = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ENT5248-PLNAL, sy-vline,
WA_ENT5248-PLNTY, sy-vline,
WA_ENT5248-VINTV, sy-vline,
WA_ENT5248-PLNNR, sy-vline,
WA_ENT5248-ZAEHL, sy-vline,
WA_ENT5248-VORNR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ENT5248 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_ENT5248 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_ENT5248 INTO WA_ENT5248. *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 PLNFL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ENT5248-PLNFL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ENT5248-PLNFL.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ISOLA, internal->external for field TXTSP CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_ENT5248-TXTSP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ENT5248-TXTSP.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field BEAZP CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ENT5248-BEAZP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ENT5248-BEAZP.
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_ENT5248_STR,
MANDT TYPE STRING,
AUFPL TYPE STRING,
APLZL TYPE STRING,
PLNFL TYPE STRING,
PLNKN TYPE STRING,
PLNAL TYPE STRING,
PLNTY TYPE STRING,
VINTV TYPE STRING,
PLNNR TYPE STRING,
ZAEHL TYPE STRING,
VORNR TYPE STRING,
STEUS TYPE STRING,
LTXA1 TYPE STRING,
LTXA2 TYPE STRING,
TXTSP TYPE STRING,
ZERMA TYPE STRING,
ZGDAT TYPE STRING,
ZCODE TYPE STRING,
ZULNR TYPE STRING,
LOANZ TYPE STRING,
LOART TYPE STRING,
RSANZ TYPE STRING,
QUALF TYPE STRING,
ANZMA TYPE STRING,
RFGRP TYPE STRING,
RFSCH TYPE STRING,
RASCH TYPE STRING,
AUFAK TYPE STRING,
LOGRP TYPE STRING,
UEMUS TYPE STRING,
UEKAN TYPE STRING,
FLIES TYPE STRING,
SPMUS TYPE STRING,
SPLIM TYPE STRING,
ABLIPKZ TYPE STRING,
RSTRA TYPE STRING,
SUMNR TYPE STRING,
SORTL TYPE STRING,
LIFNR TYPE STRING,
PREIS TYPE STRING,
PEINH TYPE STRING,
SAKTO TYPE STRING,
WAERS TYPE STRING,
INFNR TYPE STRING,
ESOKZ TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
KZLGF TYPE STRING,
KZWRTF TYPE STRING,
MATKL TYPE STRING,
DDEHN TYPE STRING,
ANZZL TYPE STRING,
PRZNT TYPE STRING,
MLSTN TYPE STRING,
PPRIO TYPE STRING,
BUKRS TYPE STRING,
ANFKO TYPE STRING,
ANFKOKRS TYPE STRING,
INDET TYPE STRING,
LARNT TYPE STRING,
PRKST TYPE STRING,
APLFL TYPE STRING,
RUECK TYPE STRING,
BEDID TYPE STRING,
BEDZL TYPE STRING,
BANFN TYPE STRING,
BNFPO TYPE STRING,
LEK01 TYPE STRING,
LEK02 TYPE STRING,
LEK03 TYPE STRING,
LEK04 TYPE STRING,
LEK05 TYPE STRING,
LEK06 TYPE STRING,
SLWID TYPE STRING,
USR00 TYPE STRING,
USR01 TYPE STRING,
USR02 TYPE STRING,
USR03 TYPE STRING,
USR04 TYPE STRING,
USE04 TYPE STRING,
USR05 TYPE STRING,
USE05 TYPE STRING,
USR06 TYPE STRING,
USE06 TYPE STRING,
USR07 TYPE STRING,
USE07 TYPE STRING,
USR08 TYPE STRING,
USR09 TYPE STRING,
USR10 TYPE STRING,
USR11 TYPE STRING,
MEINH TYPE STRING,
UMREN TYPE STRING,
UMREZ TYPE STRING,
BMSCH TYPE STRING,
ZMERH TYPE STRING,
ZEIER TYPE STRING,
VGE01 TYPE STRING,
VGW01 TYPE STRING,
VGE02 TYPE STRING,
VGW02 TYPE STRING,
VGE03 TYPE STRING,
VGW03 TYPE STRING,
VGE04 TYPE STRING,
VGW04 TYPE STRING,
VGE05 TYPE STRING,
VGW05 TYPE STRING,
VGE06 TYPE STRING,
VGW06 TYPE STRING,
ZEIMU TYPE STRING,
ZMINU TYPE STRING,
MINWE TYPE STRING,
ZEIMB TYPE STRING,
ZMINB TYPE STRING,
ZEILM TYPE STRING,
ZLMAX TYPE STRING,
ZEILP TYPE STRING,
ZLPRO TYPE STRING,
ZEIWN TYPE STRING,
ZWNOR TYPE STRING,
ZEIWM TYPE STRING,
ZWMIN TYPE STRING,
ZEITN TYPE STRING,
ZTNOR TYPE STRING,
ZEITM TYPE STRING,
ZTMIN TYPE STRING,
PLIFZ TYPE STRING,
DAUNO TYPE STRING,
DAUNE TYPE STRING,
DAUMI TYPE STRING,
DAUME TYPE STRING,
EINSA TYPE STRING,
EINSE TYPE STRING,
ARBEI TYPE STRING,
ARBEH TYPE STRING,
MGVRG TYPE STRING,
ASVRG TYPE STRING,
LMNGA TYPE STRING,
XMNGA TYPE STRING,
GMNGA TYPE STRING,
ISM01 TYPE STRING,
ISM02 TYPE STRING,
ISM03 TYPE STRING,
ISM04 TYPE STRING,
ISM05 TYPE STRING,
ISM06 TYPE STRING,
ISMNW TYPE STRING,
FSAVD TYPE STRING,
FSAVZ TYPE STRING,
FSSBD TYPE STRING,
FSSBZ TYPE STRING,
FSSAD TYPE STRING,
FSSAZ TYPE STRING,
FSEDD TYPE STRING,
FSEDZ TYPE STRING,
FSSLD TYPE STRING,
FSSLZ TYPE STRING,
FSELD TYPE STRING,
FSELZ TYPE STRING,
SSAVD TYPE STRING,
SSAVZ TYPE STRING,
SSSBD TYPE STRING,
SSSBZ TYPE STRING,
SSSAD TYPE STRING,
SSSAZ TYPE STRING,
SSEDD TYPE STRING,
SSEDZ TYPE STRING,
SSSLD TYPE STRING,
SSSLZ TYPE STRING,
SSELD TYPE STRING,
SSELZ TYPE STRING,
ISAVD TYPE STRING,
IEAVD TYPE STRING,
ISDD TYPE STRING,
ISDZ TYPE STRING,
IERD TYPE STRING,
IERZ TYPE STRING,
ISBD TYPE STRING,
ISBZ TYPE STRING,
IEBD TYPE STRING,
IEBZ TYPE STRING,
ISAD TYPE STRING,
ISAZ TYPE STRING,
IEDD TYPE STRING,
IEDZ TYPE STRING,
PEDD TYPE STRING,
PEDZ TYPE STRING,
PUFFR TYPE STRING,
PUFGS TYPE STRING,
NTANF TYPE STRING,
NTANZ TYPE STRING,
NTEND TYPE STRING,
NTENZ TYPE STRING,
EWSTD TYPE STRING,
EWSTZ TYPE STRING,
EWEND TYPE STRING,
EWENZ TYPE STRING,
EWDAN TYPE STRING,
EWDNE TYPE STRING,
EWDAM TYPE STRING,
EWDME TYPE STRING,
EWSTE TYPE STRING,
EWSTA TYPE STRING,
WARTZ TYPE STRING,
WRTZE TYPE STRING,
RUEST TYPE STRING,
RSTZE TYPE STRING,
BEARZ TYPE STRING,
BEAZE TYPE STRING,
ABRUE TYPE STRING,
ARUZE TYPE STRING,
LIEGZ TYPE STRING,
LIGZE TYPE STRING,
TRANZ TYPE STRING,
TRAZE TYPE STRING,
ISERH TYPE STRING,
OFM01 TYPE STRING,
OFM02 TYPE STRING,
OFM03 TYPE STRING,
OFM04 TYPE STRING,
OFM05 TYPE STRING,
OFM06 TYPE STRING,
OFMNW TYPE STRING,
BZOFFB TYPE STRING,
EHOFFB TYPE STRING,
OFFSTB TYPE STRING,
OFFSTE TYPE STRING,
BZOFFE TYPE STRING,
EHOFFE TYPE STRING,
FPAVD TYPE STRING,
FPAVZ TYPE STRING,
FPEDD TYPE STRING,
FPEDZ TYPE STRING,
SPAVD TYPE STRING,
SPAVZ TYPE STRING,
SPEDD TYPE STRING,
SPEDZ TYPE STRING,
BEAZP TYPE STRING,
PUFGP TYPE STRING,
PUFFP TYPE STRING,
BEARP TYPE STRING,END OF T_EKKO_STR. DATA: WA_ENT5248_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_ENT5248_STR-MANDT sy-vline
WA_ENT5248_STR-AUFPL sy-vline
WA_ENT5248_STR-APLZL sy-vline
WA_ENT5248_STR-PLNFL sy-vline
WA_ENT5248_STR-PLNKN sy-vline
WA_ENT5248_STR-PLNAL sy-vline
WA_ENT5248_STR-PLNTY sy-vline
WA_ENT5248_STR-VINTV sy-vline
WA_ENT5248_STR-PLNNR sy-vline
WA_ENT5248_STR-ZAEHL sy-vline
WA_ENT5248_STR-VORNR sy-vline
WA_ENT5248_STR-STEUS sy-vline
WA_ENT5248_STR-LTXA1 sy-vline
WA_ENT5248_STR-LTXA2 sy-vline
WA_ENT5248_STR-TXTSP sy-vline
WA_ENT5248_STR-ZERMA sy-vline
WA_ENT5248_STR-ZGDAT sy-vline
WA_ENT5248_STR-ZCODE sy-vline
WA_ENT5248_STR-ZULNR sy-vline
WA_ENT5248_STR-LOANZ sy-vline
WA_ENT5248_STR-LOART sy-vline
WA_ENT5248_STR-RSANZ sy-vline
WA_ENT5248_STR-QUALF sy-vline
WA_ENT5248_STR-ANZMA sy-vline
WA_ENT5248_STR-RFGRP sy-vline
WA_ENT5248_STR-RFSCH sy-vline
WA_ENT5248_STR-RASCH sy-vline
WA_ENT5248_STR-AUFAK sy-vline
WA_ENT5248_STR-LOGRP sy-vline
WA_ENT5248_STR-UEMUS sy-vline
WA_ENT5248_STR-UEKAN sy-vline
WA_ENT5248_STR-FLIES sy-vline
WA_ENT5248_STR-SPMUS sy-vline
WA_ENT5248_STR-SPLIM sy-vline
WA_ENT5248_STR-ABLIPKZ sy-vline
WA_ENT5248_STR-RSTRA sy-vline
WA_ENT5248_STR-SUMNR sy-vline
WA_ENT5248_STR-SORTL sy-vline
WA_ENT5248_STR-LIFNR sy-vline
WA_ENT5248_STR-PREIS sy-vline
WA_ENT5248_STR-PEINH sy-vline
WA_ENT5248_STR-SAKTO sy-vline
WA_ENT5248_STR-WAERS sy-vline
WA_ENT5248_STR-INFNR sy-vline
WA_ENT5248_STR-ESOKZ sy-vline
WA_ENT5248_STR-EKORG sy-vline
WA_ENT5248_STR-EKGRP sy-vline
WA_ENT5248_STR-KZLGF sy-vline
WA_ENT5248_STR-KZWRTF sy-vline
WA_ENT5248_STR-MATKL sy-vline
WA_ENT5248_STR-DDEHN sy-vline
WA_ENT5248_STR-ANZZL sy-vline
WA_ENT5248_STR-PRZNT sy-vline
WA_ENT5248_STR-MLSTN sy-vline
WA_ENT5248_STR-PPRIO sy-vline
WA_ENT5248_STR-BUKRS sy-vline
WA_ENT5248_STR-ANFKO sy-vline
WA_ENT5248_STR-ANFKOKRS sy-vline
WA_ENT5248_STR-INDET sy-vline
WA_ENT5248_STR-LARNT sy-vline
WA_ENT5248_STR-PRKST sy-vline
WA_ENT5248_STR-APLFL sy-vline
WA_ENT5248_STR-RUECK sy-vline
WA_ENT5248_STR-BEDID sy-vline
WA_ENT5248_STR-BEDZL sy-vline
WA_ENT5248_STR-BANFN sy-vline
WA_ENT5248_STR-BNFPO sy-vline
WA_ENT5248_STR-LEK01 sy-vline
WA_ENT5248_STR-LEK02 sy-vline
WA_ENT5248_STR-LEK03 sy-vline
WA_ENT5248_STR-LEK04 sy-vline
WA_ENT5248_STR-LEK05 sy-vline
WA_ENT5248_STR-LEK06 sy-vline
WA_ENT5248_STR-SLWID sy-vline
WA_ENT5248_STR-USR00 sy-vline
WA_ENT5248_STR-USR01 sy-vline
WA_ENT5248_STR-USR02 sy-vline
WA_ENT5248_STR-USR03 sy-vline
WA_ENT5248_STR-USR04 sy-vline
WA_ENT5248_STR-USE04 sy-vline
WA_ENT5248_STR-USR05 sy-vline
WA_ENT5248_STR-USE05 sy-vline
WA_ENT5248_STR-USR06 sy-vline
WA_ENT5248_STR-USE06 sy-vline
WA_ENT5248_STR-USR07 sy-vline
WA_ENT5248_STR-USE07 sy-vline
WA_ENT5248_STR-USR08 sy-vline
WA_ENT5248_STR-USR09 sy-vline
WA_ENT5248_STR-USR10 sy-vline
WA_ENT5248_STR-USR11 sy-vline
WA_ENT5248_STR-MEINH sy-vline
WA_ENT5248_STR-UMREN sy-vline
WA_ENT5248_STR-UMREZ sy-vline
WA_ENT5248_STR-BMSCH sy-vline
WA_ENT5248_STR-ZMERH sy-vline
WA_ENT5248_STR-ZEIER sy-vline
WA_ENT5248_STR-VGE01 sy-vline
WA_ENT5248_STR-VGW01 sy-vline
WA_ENT5248_STR-VGE02 sy-vline
WA_ENT5248_STR-VGW02 sy-vline
WA_ENT5248_STR-VGE03 sy-vline
WA_ENT5248_STR-VGW03 sy-vline
WA_ENT5248_STR-VGE04 sy-vline
WA_ENT5248_STR-VGW04 sy-vline
WA_ENT5248_STR-VGE05 sy-vline
WA_ENT5248_STR-VGW05 sy-vline
WA_ENT5248_STR-VGE06 sy-vline
WA_ENT5248_STR-VGW06 sy-vline
WA_ENT5248_STR-ZEIMU sy-vline
WA_ENT5248_STR-ZMINU sy-vline
WA_ENT5248_STR-MINWE sy-vline
WA_ENT5248_STR-ZEIMB sy-vline
WA_ENT5248_STR-ZMINB sy-vline
WA_ENT5248_STR-ZEILM sy-vline
WA_ENT5248_STR-ZLMAX sy-vline
WA_ENT5248_STR-ZEILP sy-vline
WA_ENT5248_STR-ZLPRO sy-vline
WA_ENT5248_STR-ZEIWN sy-vline
WA_ENT5248_STR-ZWNOR sy-vline
WA_ENT5248_STR-ZEIWM sy-vline
WA_ENT5248_STR-ZWMIN sy-vline
WA_ENT5248_STR-ZEITN sy-vline
WA_ENT5248_STR-ZTNOR sy-vline
WA_ENT5248_STR-ZEITM sy-vline
WA_ENT5248_STR-ZTMIN sy-vline
WA_ENT5248_STR-PLIFZ sy-vline
WA_ENT5248_STR-DAUNO sy-vline
WA_ENT5248_STR-DAUNE sy-vline
WA_ENT5248_STR-DAUMI sy-vline
WA_ENT5248_STR-DAUME sy-vline
WA_ENT5248_STR-EINSA sy-vline
WA_ENT5248_STR-EINSE sy-vline
WA_ENT5248_STR-ARBEI sy-vline
WA_ENT5248_STR-ARBEH sy-vline
WA_ENT5248_STR-MGVRG sy-vline
WA_ENT5248_STR-ASVRG sy-vline
WA_ENT5248_STR-LMNGA sy-vline
WA_ENT5248_STR-XMNGA sy-vline
WA_ENT5248_STR-GMNGA sy-vline
WA_ENT5248_STR-ISM01 sy-vline
WA_ENT5248_STR-ISM02 sy-vline
WA_ENT5248_STR-ISM03 sy-vline
WA_ENT5248_STR-ISM04 sy-vline
WA_ENT5248_STR-ISM05 sy-vline
WA_ENT5248_STR-ISM06 sy-vline
WA_ENT5248_STR-ISMNW sy-vline
WA_ENT5248_STR-FSAVD sy-vline
WA_ENT5248_STR-FSAVZ sy-vline
WA_ENT5248_STR-FSSBD sy-vline
WA_ENT5248_STR-FSSBZ sy-vline
WA_ENT5248_STR-FSSAD sy-vline
WA_ENT5248_STR-FSSAZ sy-vline
WA_ENT5248_STR-FSEDD sy-vline
WA_ENT5248_STR-FSEDZ sy-vline
WA_ENT5248_STR-FSSLD sy-vline
WA_ENT5248_STR-FSSLZ sy-vline
WA_ENT5248_STR-FSELD sy-vline
WA_ENT5248_STR-FSELZ sy-vline
WA_ENT5248_STR-SSAVD sy-vline
WA_ENT5248_STR-SSAVZ sy-vline
WA_ENT5248_STR-SSSBD sy-vline
WA_ENT5248_STR-SSSBZ sy-vline
WA_ENT5248_STR-SSSAD sy-vline
WA_ENT5248_STR-SSSAZ sy-vline
WA_ENT5248_STR-SSEDD sy-vline
WA_ENT5248_STR-SSEDZ sy-vline
WA_ENT5248_STR-SSSLD sy-vline
WA_ENT5248_STR-SSSLZ sy-vline
WA_ENT5248_STR-SSELD sy-vline
WA_ENT5248_STR-SSELZ sy-vline
WA_ENT5248_STR-ISAVD sy-vline
WA_ENT5248_STR-IEAVD sy-vline
WA_ENT5248_STR-ISDD sy-vline
WA_ENT5248_STR-ISDZ sy-vline
WA_ENT5248_STR-IERD sy-vline
WA_ENT5248_STR-IERZ sy-vline
WA_ENT5248_STR-ISBD sy-vline
WA_ENT5248_STR-ISBZ sy-vline
WA_ENT5248_STR-IEBD sy-vline
WA_ENT5248_STR-IEBZ sy-vline
WA_ENT5248_STR-ISAD sy-vline
WA_ENT5248_STR-ISAZ sy-vline
WA_ENT5248_STR-IEDD sy-vline
WA_ENT5248_STR-IEDZ sy-vline
WA_ENT5248_STR-PEDD sy-vline
WA_ENT5248_STR-PEDZ sy-vline
WA_ENT5248_STR-PUFFR sy-vline
WA_ENT5248_STR-PUFGS sy-vline
WA_ENT5248_STR-NTANF sy-vline
WA_ENT5248_STR-NTANZ sy-vline
WA_ENT5248_STR-NTEND sy-vline
WA_ENT5248_STR-NTENZ sy-vline
WA_ENT5248_STR-EWSTD sy-vline
WA_ENT5248_STR-EWSTZ sy-vline
WA_ENT5248_STR-EWEND sy-vline
WA_ENT5248_STR-EWENZ sy-vline
WA_ENT5248_STR-EWDAN sy-vline
WA_ENT5248_STR-EWDNE sy-vline
WA_ENT5248_STR-EWDAM sy-vline
WA_ENT5248_STR-EWDME sy-vline
WA_ENT5248_STR-EWSTE sy-vline
WA_ENT5248_STR-EWSTA sy-vline
WA_ENT5248_STR-WARTZ sy-vline
WA_ENT5248_STR-WRTZE sy-vline
WA_ENT5248_STR-RUEST sy-vline
WA_ENT5248_STR-RSTZE sy-vline
WA_ENT5248_STR-BEARZ sy-vline
WA_ENT5248_STR-BEAZE sy-vline
WA_ENT5248_STR-ABRUE sy-vline
WA_ENT5248_STR-ARUZE sy-vline
WA_ENT5248_STR-LIEGZ sy-vline
WA_ENT5248_STR-LIGZE sy-vline
WA_ENT5248_STR-TRANZ sy-vline
WA_ENT5248_STR-TRAZE sy-vline
WA_ENT5248_STR-ISERH sy-vline
WA_ENT5248_STR-OFM01 sy-vline
WA_ENT5248_STR-OFM02 sy-vline
WA_ENT5248_STR-OFM03 sy-vline
WA_ENT5248_STR-OFM04 sy-vline
WA_ENT5248_STR-OFM05 sy-vline
WA_ENT5248_STR-OFM06 sy-vline
WA_ENT5248_STR-OFMNW sy-vline
WA_ENT5248_STR-BZOFFB sy-vline
WA_ENT5248_STR-EHOFFB sy-vline
WA_ENT5248_STR-OFFSTB sy-vline
WA_ENT5248_STR-OFFSTE sy-vline
WA_ENT5248_STR-BZOFFE sy-vline
WA_ENT5248_STR-EHOFFE sy-vline
WA_ENT5248_STR-FPAVD sy-vline
WA_ENT5248_STR-FPAVZ sy-vline
WA_ENT5248_STR-FPEDD sy-vline
WA_ENT5248_STR-FPEDZ sy-vline
WA_ENT5248_STR-SPAVD sy-vline
WA_ENT5248_STR-SPAVZ sy-vline
WA_ENT5248_STR-SPEDD sy-vline
WA_ENT5248_STR-SPEDZ sy-vline
WA_ENT5248_STR-BEAZP sy-vline
WA_ENT5248_STR-PUFGP sy-vline
WA_ENT5248_STR-PUFFP sy-vline
WA_ENT5248_STR-BEARP sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.