ABAP Select data from SAP table WTDY 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 WTDY 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 WTDY. 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 WTDY 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_WTDY TYPE STANDARD TABLE OF WTDY, WA_WTDY TYPE WTDY, 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: <WTDY> TYPE WTDY. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_WTDY. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM WTDY INTO TABLE IT_WTDY. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM WTDY * INTO TABLE @DATA(IT_WTDY2). *--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_WTDY INDEX 1 INTO DATA(WA_WTDY2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_WTDY ASSIGNING <WTDY>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<WTDY>-W_TEXT006 = 1.
<WTDY>-W_TEXT001 = 1.
<WTDY>-W_TEXT002 = 1.
<WTDY>-W_TEXT003 = 1.
<WTDY>-W_TEXT004 = 1.
ENDLOOP. LOOP AT IT_WTDY INTO WA_WTDY. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_WTDY-W_PUSH001, sy-vline,
WA_WTDY-W_PUSH002, sy-vline,
WA_WTDY-W_PUSH003, sy-vline,
WA_WTDY-W_PUSH004, sy-vline,
WA_WTDY-W_PUSH005, sy-vline,
WA_WTDY-W_PUSH006, sy-vline.
ENDLOOP. *Add any further fields from structure WA_WTDY 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_WTDY 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_WTDY INTO WA_WTDY. *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 AKTION CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WTDY-AKTION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-AKTION.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BAUSTEIN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WTDY-BAUSTEIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-BAUSTEIN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field SORTIMT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-SORTIMT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-SORTIMT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field BPROFIL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-BPROFIL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-BPROFIL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field XEMATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-XEMATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-XEMATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field XBMATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-XBMATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-XBMATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field QUELL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WTDY-QUELL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-QUELL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field ZIEL1 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WTDY-ZIEL1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-ZIEL1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field ARTNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-ARTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-ARTNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field AKTBAU CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-AKTBAU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-AKTBAU.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field REFBAU CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WTDY-REFBAU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-REFBAU.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field REFSORT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-REFSORT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-REFSORT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEEIN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-MEEIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-MEEIN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field SATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-SATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-SATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field VATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-VATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-VATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field CPDNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-CPDNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-CPDNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field DEPNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-DEPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-DEPNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field STRNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-STRNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-STRNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field SAISJ CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_WTDY-SAISJ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-SAISJ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field ERSAR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-ERSAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-ERSAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field VERME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-VERME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-VERME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field LIFME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-LIFME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-LIFME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field JAGNG CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_WTDY-JAGNG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-JAGNG.
WRITE:/ 'New Value:', ld_input.
*Conversion exit EAN11, internal->external for field PLUNR CALL FUNCTION 'CONVERSION_EXIT_EAN11_OUTPUT' EXPORTING input = WA_WTDY-PLUNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-PLUNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field LOTNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-LOTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-LOTNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MXBME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-MXBME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-MXBME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MNBME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-MNBME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-MNBME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MNLME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-MNLME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-MNLME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field NOLME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-NOLME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-NOLME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field EGMEE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-EGMEE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-EGMEE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field ETIARTIKEL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-ETIARTIKEL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-ETIARTIKEL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field ETIMEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-ETIMEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-ETIMEINS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field LOGME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WTDY-LOGME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-LOGME.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field WWGDA CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-WWGDA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-WWGDA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field WWGPA CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WTDY-WWGPA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-WWGPA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LIFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WTDY-LIFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WTDY-LIFNR.
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_WTDY_STR,
W_TEXT006 TYPE STRING,
W_TEXT001 TYPE STRING,
W_TEXT002 TYPE STRING,
W_TEXT003 TYPE STRING,
W_TEXT004 TYPE STRING,
W_PUSH001 TYPE STRING,
W_PUSH002 TYPE STRING,
W_PUSH003 TYPE STRING,
W_PUSH004 TYPE STRING,
W_PUSH005 TYPE STRING,
W_PUSH006 TYPE STRING,
MANDT TYPE STRING,
WKFIL TYPE STRING,
ZUFIL TYPE STRING,
LOKAL TYPE STRING,
W_MATKL TYPE STRING,
WERKB TYPE STRING,
WERKSEL TYPE STRING,
WERKQ TYPE STRING,
WERKZ TYPE STRING,
TEXT1 TYPE STRING,
TEXT01 TYPE STRING,
TEXT02 TYPE STRING,
MSG TYPE STRING,
XWERTEA TYPE STRING,
XWERTBA TYPE STRING,
XDIFF TYPE STRING,
XABW TYPE STRING,
TEXT07 TYPE STRING,
TEXT08 TYPE STRING,
TEXT10 TYPE STRING,
TEXT09 TYPE STRING,
AKTION TYPE STRING,
BAUSTEIN TYPE STRING,
WWSDATU1 TYPE STRING,
WWSDATU2 TYPE STRING,
DATUM_AM TYPE STRING,
BEZEI_40 TYPE STRING,
BAUSTYP TYPE STRING,
SORTIMT TYPE STRING,
BPROFIL TYPE STRING,
XEMATNR TYPE STRING,
XBMATNR TYPE STRING,
XVKORG TYPE STRING,
XVTWEG TYPE STRING,
XEMATBEZ TYPE STRING,
XBMATBEZ TYPE STRING,
XBWKEY TYPE STRING,
XBWTAR TYPE STRING,
XWAGRP TYPE STRING,
XMTART TYPE STRING,
XBVTWEG TYPE STRING,
FLAG1 TYPE STRING,
LFDI1 TYPE STRING,
QUELL TYPE STRING,
ZIEL1 TYPE STRING,
BEZQUEL TYPE STRING,
BEZZIEL TYPE STRING,
XBVKORG TYPE STRING,
ARTNR TYPE STRING,
LFDNR1 TYPE STRING,
AKTBAU TYPE STRING,
WERKS TYPE STRING,
REFBAU TYPE STRING,
REFSORT TYPE STRING,
REFTXT TYPE STRING,
WERKSS TYPE STRING,
TYP01 TYPE STRING,
DATAB TYPE STRING,
DATBI TYPE STRING,
AUSWAHL1 TYPE STRING,
AUSWAHL2 TYPE STRING,
EANSEL1 TYPE STRING,
EANSEL2 TYPE STRING,
EANSEL3 TYPE STRING,
EAN01 TYPE STRING,
EAN TYPE STRING,
EANNR TYPE STRING,
ITFPF TYPE STRING,
NUMTP TYPE STRING,
MEEINH TYPE STRING,
MEEIN TYPE STRING,
KMENGE TYPE STRING,
VKSET TYPE STRING,
EANUKTR TYPE STRING,
WTDY8_1 TYPE STRING,
WTDY8_2 TYPE STRING,
WTDY8_3 TYPE STRING,
WTDY8_4 TYPE STRING,
AKTPAGE TYPE STRING,
MAXPAGE TYPE STRING,
DATUMW TYPE STRING,
UMAMEW TYPE STRING,
UZEITW TYPE STRING,
DATVON TYPE STRING,
DATBIS TYPE STRING,
WTDY22 TYPE STRING,
WTDY23 TYPE STRING,
WTDY24 TYPE STRING,
WTDY25 TYPE STRING,
WTDY26 TYPE STRING,
DATUM_B TYPE STRING,
DATUM_AE TYPE STRING,
VBDIR TYPE STRING,
VBBDC TYPE STRING,
ANZMA TYPE STRING,
ANZME TYPE STRING,
ANZMN TYPE STRING,
VBUMA TYPE STRING,
VBUMS TYPE STRING,
ETIJN TYPE STRING,
ETIME TYPE STRING,
KZJA TYPE STRING,
KZNEIN TYPE STRING,
OBJ_EXIST TYPE STRING,
OBJ_MARK TYPE STRING,
FOLGE_EX TYPE STRING,
OBJ_K TYPE STRING,
SSTUF TYPE STRING,
SATNR TYPE STRING,
SAKTX TYPE STRING,
VATNR TYPE STRING,
VAKTX TYPE STRING,
CPDNR TYPE STRING,
DEPNR TYPE STRING,
STRNR TYPE STRING,
STTPX TYPE STRING,
STRTP TYPE STRING,
SAISJ TYPE STRING,
LIQDT TYPE STRING,
ERSAR TYPE STRING,
WABWV TYPE STRING,
AEGUL TYPE STRING,
ERSCD TYPE STRING,
SPRCD TYPE STRING,
PFLKS TYPE STRING,
LSTFL TYPE STRING,
LSTVZ TYPE STRING,
LSTAK TYPE STRING,
BBTYP TYPE STRING,
PLGTP TYPE STRING,
MHDGS TYPE STRING,
MHDFL TYPE STRING,
MHTYP TYPE STRING,
ENTBW TYPE STRING,
ABVAR TYPE STRING,
ERSDT TYPE STRING,
VERME TYPE STRING,
LIFME TYPE STRING,
LAYGR TYPE STRING,
SORF1 TYPE STRING,
LATX1 TYPE STRING,
JAGNG TYPE STRING,
FILGP TYPE STRING,
FLGTX TYPE STRING,
VZ_ZL TYPE STRING,
VZZLT TYPE STRING,
FILTX TYPE STRING,
METYP TYPE STRING,
KWDHT TYPE STRING,
KPART TYPE STRING,
KETAT TYPE STRING,
KETTP TYPE STRING,
KETAN TYPE STRING,
NEGAT TYPE STRING,
ARTNA TYPE STRING,
PRIMW TYPE STRING,
BNTX1 TYPE STRING,
BNTX2 TYPE STRING,
PLUNR TYPE STRING,
PRERF TYPE STRING,
LOTNR TYPE STRING,
LIFAT TYPE STRING,
WGLIF TYPE STRING,
LTSNR TYPE STRING,
LTSSF TYPE STRING,
KPGAB TYPE STRING,
MNBSW TYPE STRING,
VKBGH TYPE STRING,
VKBEH TYPE STRING,
NETMG TYPE STRING,
NETM2 TYPE STRING,
VKDAB TYPE STRING,
VKBIS TYPE STRING,
PHFIL TYPE STRING,
RBZUL TYPE STRING,
MARAB TYPE STRING,
VKWAE TYPE STRING,
FSLIF TYPE STRING,
PERDP TYPE STRING,
ALSTA TYPE STRING,
STNKZ TYPE STRING,
MXBME TYPE STRING,
MNBME TYPE STRING,
BSTAB TYPE STRING,
BSTBI TYPE STRING,
STRAB TYPE STRING,
DPTAG TYPE STRING,
LFTAG TYPE STRING,
DPTPR TYPE STRING,
CREAS TYPE STRING,
BSTHH TYPE STRING,
DPHFL TYPE STRING,
RUEPL TYPE STRING,
MNLME TYPE STRING,
NOLME TYPE STRING,
KMAUW TYPE STRING,
KMHER TYPE STRING,
KTYPS TYPE STRING,
KPFLM TYPE STRING,
KMERK TYPE STRING,
KBEWR TYPE STRING,
ETFAK TYPE STRING,
EPFLZ TYPE STRING,
EPRLO TYPE STRING,
EBRME TYPE STRING,
ENEME TYPE STRING,
ETRME TYPE STRING,
EGRME TYPE STRING,
EGMEE TYPE STRING,
EGRPR TYPE STRING,
ETEX1 TYPE STRING,
ETEX2 TYPE STRING,
AKBSM TYPE STRING,
SNORM TYPE STRING,
SAUFT TYPE STRING,
SAUFV TYPE STRING,
SGRU1 TYPE STRING,
SGRU2 TYPE STRING,
SCLSF TYPE STRING,
SEINK TYPE STRING,
SVERK TYPE STRING,
SCALC TYPE STRING,
SLOGV TYPE STRING,
SLOGF TYPE STRING,
SIPOS TYPE STRING,
SETIK TYPE STRING,
SIAUF TYPE STRING,
SGRUA TYPE STRING,
SEKVK TYPE STRING,
SLOGA TYPE STRING,
WMIXDT TYPE STRING,
ATART TYPE STRING,
ATFSA TYPE STRING,
ATFEI TYPE STRING,
ATFCP TYPE STRING,
ATFDP TYPE STRING,
ATFST TYPE STRING,
ATTCP TYPE STRING,
ATTDP TYPE STRING,
ATTST TYPE STRING,
LIEFERER TYPE STRING,
VTSCH TYPE STRING,
ETPRF TYPE STRING,
ATFBZ TYPE STRING,
SEQVA TYPE STRING,
SEQV2 TYPE STRING,
ETIFIL TYPE STRING,
ETIARTIKEL TYPE STRING,
ETIMEINS TYPE STRING,
BESTH TYPE STRING,
SAMBZ TYPE STRING,
CODC1 TYPE STRING,
LOGME TYPE STRING,
MHPRD TYPE STRING,
ARTZAL TYPE STRING,
SEITE TYPE STRING,
BESTX TYPE STRING,
GEFKL TYPE STRING,
BEDGR TYPE STRING,
LAYOU TYPE STRING,
ETIZL TYPE STRING,
ETIZU TYPE STRING,
ETIAU TYPE STRING,
ROTPR TYPE STRING,
RUECV TYPE STRING,
SERVG TYPE STRING,
SERVV TYPE STRING,
GEWAT TYPE STRING,
BIGTK TYPE STRING,
URVKP TYPE STRING,
MLGUT TYPE STRING,
TAXKM TYPE STRING,
ETIAT TYPE STRING,
ZUGDT TYPE STRING,
BSTHT TYPE STRING,
WWGDA TYPE STRING,
WWGPA TYPE STRING,
ABTNR TYPE STRING,
FILIALE TYPE STRING,
ALLVR TYPE STRING,
W_TEXT005 TYPE STRING,
W_TEXT007 TYPE STRING,
W_PUSH003A TYPE STRING,
W_PUSH002A TYPE STRING,
W_PUSH001A TYPE STRING,
W_LSTFL TYPE STRING,
W_LSTVZ TYPE STRING,
LIFNR TYPE STRING,
LSTVF TYPE STRING,END OF T_EKKO_STR. DATA: WA_WTDY_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_WTDY_STR-W_TEXT006 sy-vline
WA_WTDY_STR-W_TEXT001 sy-vline
WA_WTDY_STR-W_TEXT002 sy-vline
WA_WTDY_STR-W_TEXT003 sy-vline
WA_WTDY_STR-W_TEXT004 sy-vline
WA_WTDY_STR-W_PUSH001 sy-vline
WA_WTDY_STR-W_PUSH002 sy-vline
WA_WTDY_STR-W_PUSH003 sy-vline
WA_WTDY_STR-W_PUSH004 sy-vline
WA_WTDY_STR-W_PUSH005 sy-vline
WA_WTDY_STR-W_PUSH006 sy-vline
WA_WTDY_STR-MANDT sy-vline
WA_WTDY_STR-WKFIL sy-vline
WA_WTDY_STR-ZUFIL sy-vline
WA_WTDY_STR-LOKAL sy-vline
WA_WTDY_STR-W_MATKL sy-vline
WA_WTDY_STR-WERKB sy-vline
WA_WTDY_STR-WERKSEL sy-vline
WA_WTDY_STR-WERKQ sy-vline
WA_WTDY_STR-WERKZ sy-vline
WA_WTDY_STR-TEXT1 sy-vline
WA_WTDY_STR-TEXT01 sy-vline
WA_WTDY_STR-TEXT02 sy-vline
WA_WTDY_STR-MSG sy-vline
WA_WTDY_STR-XWERTEA sy-vline
WA_WTDY_STR-XWERTBA sy-vline
WA_WTDY_STR-XDIFF sy-vline
WA_WTDY_STR-XABW sy-vline
WA_WTDY_STR-TEXT07 sy-vline
WA_WTDY_STR-TEXT08 sy-vline
WA_WTDY_STR-TEXT10 sy-vline
WA_WTDY_STR-TEXT09 sy-vline
WA_WTDY_STR-AKTION sy-vline
WA_WTDY_STR-BAUSTEIN sy-vline
WA_WTDY_STR-WWSDATU1 sy-vline
WA_WTDY_STR-WWSDATU2 sy-vline
WA_WTDY_STR-DATUM_AM sy-vline
WA_WTDY_STR-BEZEI_40 sy-vline
WA_WTDY_STR-BAUSTYP sy-vline
WA_WTDY_STR-SORTIMT sy-vline
WA_WTDY_STR-BPROFIL sy-vline
WA_WTDY_STR-XEMATNR sy-vline
WA_WTDY_STR-XBMATNR sy-vline
WA_WTDY_STR-XVKORG sy-vline
WA_WTDY_STR-XVTWEG sy-vline
WA_WTDY_STR-XEMATBEZ sy-vline
WA_WTDY_STR-XBMATBEZ sy-vline
WA_WTDY_STR-XBWKEY sy-vline
WA_WTDY_STR-XBWTAR sy-vline
WA_WTDY_STR-XWAGRP sy-vline
WA_WTDY_STR-XMTART sy-vline
WA_WTDY_STR-XBVTWEG sy-vline
WA_WTDY_STR-FLAG1 sy-vline
WA_WTDY_STR-LFDI1 sy-vline
WA_WTDY_STR-QUELL sy-vline
WA_WTDY_STR-ZIEL1 sy-vline
WA_WTDY_STR-BEZQUEL sy-vline
WA_WTDY_STR-BEZZIEL sy-vline
WA_WTDY_STR-XBVKORG sy-vline
WA_WTDY_STR-ARTNR sy-vline
WA_WTDY_STR-LFDNR1 sy-vline
WA_WTDY_STR-AKTBAU sy-vline
WA_WTDY_STR-WERKS sy-vline
WA_WTDY_STR-REFBAU sy-vline
WA_WTDY_STR-REFSORT sy-vline
WA_WTDY_STR-REFTXT sy-vline
WA_WTDY_STR-WERKSS sy-vline
WA_WTDY_STR-TYP01 sy-vline
WA_WTDY_STR-DATAB sy-vline
WA_WTDY_STR-DATBI sy-vline
WA_WTDY_STR-AUSWAHL1 sy-vline
WA_WTDY_STR-AUSWAHL2 sy-vline
WA_WTDY_STR-EANSEL1 sy-vline
WA_WTDY_STR-EANSEL2 sy-vline
WA_WTDY_STR-EANSEL3 sy-vline
WA_WTDY_STR-EAN01 sy-vline
WA_WTDY_STR-EAN sy-vline
WA_WTDY_STR-EANNR sy-vline
WA_WTDY_STR-ITFPF sy-vline
WA_WTDY_STR-NUMTP sy-vline
WA_WTDY_STR-MEEINH sy-vline
WA_WTDY_STR-MEEIN sy-vline
WA_WTDY_STR-KMENGE sy-vline
WA_WTDY_STR-VKSET sy-vline
WA_WTDY_STR-EANUKTR sy-vline
WA_WTDY_STR-WTDY8_1 sy-vline
WA_WTDY_STR-WTDY8_2 sy-vline
WA_WTDY_STR-WTDY8_3 sy-vline
WA_WTDY_STR-WTDY8_4 sy-vline
WA_WTDY_STR-AKTPAGE sy-vline
WA_WTDY_STR-MAXPAGE sy-vline
WA_WTDY_STR-DATUMW sy-vline
WA_WTDY_STR-UMAMEW sy-vline
WA_WTDY_STR-UZEITW sy-vline
WA_WTDY_STR-DATVON sy-vline
WA_WTDY_STR-DATBIS sy-vline
WA_WTDY_STR-WTDY22 sy-vline
WA_WTDY_STR-WTDY23 sy-vline
WA_WTDY_STR-WTDY24 sy-vline
WA_WTDY_STR-WTDY25 sy-vline
WA_WTDY_STR-WTDY26 sy-vline
WA_WTDY_STR-DATUM_B sy-vline
WA_WTDY_STR-DATUM_AE sy-vline
WA_WTDY_STR-VBDIR sy-vline
WA_WTDY_STR-VBBDC sy-vline
WA_WTDY_STR-ANZMA sy-vline
WA_WTDY_STR-ANZME sy-vline
WA_WTDY_STR-ANZMN sy-vline
WA_WTDY_STR-VBUMA sy-vline
WA_WTDY_STR-VBUMS sy-vline
WA_WTDY_STR-ETIJN sy-vline
WA_WTDY_STR-ETIME sy-vline
WA_WTDY_STR-KZJA sy-vline
WA_WTDY_STR-KZNEIN sy-vline
WA_WTDY_STR-OBJ_EXIST sy-vline
WA_WTDY_STR-OBJ_MARK sy-vline
WA_WTDY_STR-FOLGE_EX sy-vline
WA_WTDY_STR-OBJ_K sy-vline
WA_WTDY_STR-SSTUF sy-vline
WA_WTDY_STR-SATNR sy-vline
WA_WTDY_STR-SAKTX sy-vline
WA_WTDY_STR-VATNR sy-vline
WA_WTDY_STR-VAKTX sy-vline
WA_WTDY_STR-CPDNR sy-vline
WA_WTDY_STR-DEPNR sy-vline
WA_WTDY_STR-STRNR sy-vline
WA_WTDY_STR-STTPX sy-vline
WA_WTDY_STR-STRTP sy-vline
WA_WTDY_STR-SAISJ sy-vline
WA_WTDY_STR-LIQDT sy-vline
WA_WTDY_STR-ERSAR sy-vline
WA_WTDY_STR-WABWV sy-vline
WA_WTDY_STR-AEGUL sy-vline
WA_WTDY_STR-ERSCD sy-vline
WA_WTDY_STR-SPRCD sy-vline
WA_WTDY_STR-PFLKS sy-vline
WA_WTDY_STR-LSTFL sy-vline
WA_WTDY_STR-LSTVZ sy-vline
WA_WTDY_STR-LSTAK sy-vline
WA_WTDY_STR-BBTYP sy-vline
WA_WTDY_STR-PLGTP sy-vline
WA_WTDY_STR-MHDGS sy-vline
WA_WTDY_STR-MHDFL sy-vline
WA_WTDY_STR-MHTYP sy-vline
WA_WTDY_STR-ENTBW sy-vline
WA_WTDY_STR-ABVAR sy-vline
WA_WTDY_STR-ERSDT sy-vline
WA_WTDY_STR-VERME sy-vline
WA_WTDY_STR-LIFME sy-vline
WA_WTDY_STR-LAYGR sy-vline
WA_WTDY_STR-SORF1 sy-vline
WA_WTDY_STR-LATX1 sy-vline
WA_WTDY_STR-JAGNG sy-vline
WA_WTDY_STR-FILGP sy-vline
WA_WTDY_STR-FLGTX sy-vline
WA_WTDY_STR-VZ_ZL sy-vline
WA_WTDY_STR-VZZLT sy-vline
WA_WTDY_STR-FILTX sy-vline
WA_WTDY_STR-METYP sy-vline
WA_WTDY_STR-KWDHT sy-vline
WA_WTDY_STR-KPART sy-vline
WA_WTDY_STR-KETAT sy-vline
WA_WTDY_STR-KETTP sy-vline
WA_WTDY_STR-KETAN sy-vline
WA_WTDY_STR-NEGAT sy-vline
WA_WTDY_STR-ARTNA sy-vline
WA_WTDY_STR-PRIMW sy-vline
WA_WTDY_STR-BNTX1 sy-vline
WA_WTDY_STR-BNTX2 sy-vline
WA_WTDY_STR-PLUNR sy-vline
WA_WTDY_STR-PRERF sy-vline
WA_WTDY_STR-LOTNR sy-vline
WA_WTDY_STR-LIFAT sy-vline
WA_WTDY_STR-WGLIF sy-vline
WA_WTDY_STR-LTSNR sy-vline
WA_WTDY_STR-LTSSF sy-vline
WA_WTDY_STR-KPGAB sy-vline
WA_WTDY_STR-MNBSW sy-vline
WA_WTDY_STR-VKBGH sy-vline
WA_WTDY_STR-VKBEH sy-vline
WA_WTDY_STR-NETMG sy-vline
WA_WTDY_STR-NETM2 sy-vline
WA_WTDY_STR-VKDAB sy-vline
WA_WTDY_STR-VKBIS sy-vline
WA_WTDY_STR-PHFIL sy-vline
WA_WTDY_STR-RBZUL sy-vline
WA_WTDY_STR-MARAB sy-vline
WA_WTDY_STR-VKWAE sy-vline
WA_WTDY_STR-FSLIF sy-vline
WA_WTDY_STR-PERDP sy-vline
WA_WTDY_STR-ALSTA sy-vline
WA_WTDY_STR-STNKZ sy-vline
WA_WTDY_STR-MXBME sy-vline
WA_WTDY_STR-MNBME sy-vline
WA_WTDY_STR-BSTAB sy-vline
WA_WTDY_STR-BSTBI sy-vline
WA_WTDY_STR-STRAB sy-vline
WA_WTDY_STR-DPTAG sy-vline
WA_WTDY_STR-LFTAG sy-vline
WA_WTDY_STR-DPTPR sy-vline
WA_WTDY_STR-CREAS sy-vline
WA_WTDY_STR-BSTHH sy-vline
WA_WTDY_STR-DPHFL sy-vline
WA_WTDY_STR-RUEPL sy-vline
WA_WTDY_STR-MNLME sy-vline
WA_WTDY_STR-NOLME sy-vline
WA_WTDY_STR-KMAUW sy-vline
WA_WTDY_STR-KMHER sy-vline
WA_WTDY_STR-KTYPS sy-vline
WA_WTDY_STR-KPFLM sy-vline
WA_WTDY_STR-KMERK sy-vline
WA_WTDY_STR-KBEWR sy-vline
WA_WTDY_STR-ETFAK sy-vline
WA_WTDY_STR-EPFLZ sy-vline
WA_WTDY_STR-EPRLO sy-vline
WA_WTDY_STR-EBRME sy-vline
WA_WTDY_STR-ENEME sy-vline
WA_WTDY_STR-ETRME sy-vline
WA_WTDY_STR-EGRME sy-vline
WA_WTDY_STR-EGMEE sy-vline
WA_WTDY_STR-EGRPR sy-vline
WA_WTDY_STR-ETEX1 sy-vline
WA_WTDY_STR-ETEX2 sy-vline
WA_WTDY_STR-AKBSM sy-vline
WA_WTDY_STR-SNORM sy-vline
WA_WTDY_STR-SAUFT sy-vline
WA_WTDY_STR-SAUFV sy-vline
WA_WTDY_STR-SGRU1 sy-vline
WA_WTDY_STR-SGRU2 sy-vline
WA_WTDY_STR-SCLSF sy-vline
WA_WTDY_STR-SEINK sy-vline
WA_WTDY_STR-SVERK sy-vline
WA_WTDY_STR-SCALC sy-vline
WA_WTDY_STR-SLOGV sy-vline
WA_WTDY_STR-SLOGF sy-vline
WA_WTDY_STR-SIPOS sy-vline
WA_WTDY_STR-SETIK sy-vline
WA_WTDY_STR-SIAUF sy-vline
WA_WTDY_STR-SGRUA sy-vline
WA_WTDY_STR-SEKVK sy-vline
WA_WTDY_STR-SLOGA sy-vline
WA_WTDY_STR-WMIXDT sy-vline
WA_WTDY_STR-ATART sy-vline
WA_WTDY_STR-ATFSA sy-vline
WA_WTDY_STR-ATFEI sy-vline
WA_WTDY_STR-ATFCP sy-vline
WA_WTDY_STR-ATFDP sy-vline
WA_WTDY_STR-ATFST sy-vline
WA_WTDY_STR-ATTCP sy-vline
WA_WTDY_STR-ATTDP sy-vline
WA_WTDY_STR-ATTST sy-vline
WA_WTDY_STR-LIEFERER sy-vline
WA_WTDY_STR-VTSCH sy-vline
WA_WTDY_STR-ETPRF sy-vline
WA_WTDY_STR-ATFBZ sy-vline
WA_WTDY_STR-SEQVA sy-vline
WA_WTDY_STR-SEQV2 sy-vline
WA_WTDY_STR-ETIFIL sy-vline
WA_WTDY_STR-ETIARTIKEL sy-vline
WA_WTDY_STR-ETIMEINS sy-vline
WA_WTDY_STR-BESTH sy-vline
WA_WTDY_STR-SAMBZ sy-vline
WA_WTDY_STR-CODC1 sy-vline
WA_WTDY_STR-LOGME sy-vline
WA_WTDY_STR-MHPRD sy-vline
WA_WTDY_STR-ARTZAL sy-vline
WA_WTDY_STR-SEITE sy-vline
WA_WTDY_STR-BESTX sy-vline
WA_WTDY_STR-GEFKL sy-vline
WA_WTDY_STR-BEDGR sy-vline
WA_WTDY_STR-LAYOU sy-vline
WA_WTDY_STR-ETIZL sy-vline
WA_WTDY_STR-ETIZU sy-vline
WA_WTDY_STR-ETIAU sy-vline
WA_WTDY_STR-ROTPR sy-vline
WA_WTDY_STR-RUECV sy-vline
WA_WTDY_STR-SERVG sy-vline
WA_WTDY_STR-SERVV sy-vline
WA_WTDY_STR-GEWAT sy-vline
WA_WTDY_STR-BIGTK sy-vline
WA_WTDY_STR-URVKP sy-vline
WA_WTDY_STR-MLGUT sy-vline
WA_WTDY_STR-TAXKM sy-vline
WA_WTDY_STR-ETIAT sy-vline
WA_WTDY_STR-ZUGDT sy-vline
WA_WTDY_STR-BSTHT sy-vline
WA_WTDY_STR-WWGDA sy-vline
WA_WTDY_STR-WWGPA sy-vline
WA_WTDY_STR-ABTNR sy-vline
WA_WTDY_STR-FILIALE sy-vline
WA_WTDY_STR-ALLVR sy-vline
WA_WTDY_STR-W_TEXT005 sy-vline
WA_WTDY_STR-W_TEXT007 sy-vline
WA_WTDY_STR-W_PUSH003A sy-vline
WA_WTDY_STR-W_PUSH002A sy-vline
WA_WTDY_STR-W_PUSH001A sy-vline
WA_WTDY_STR-W_LSTFL sy-vline
WA_WTDY_STR-W_LSTVZ sy-vline
WA_WTDY_STR-LIFNR sy-vline
WA_WTDY_STR-LSTVF sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.