ABAP Select data from SAP table SBEFU 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 SBEFU 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 SBEFU. 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 SBEFU 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_SBEFU TYPE STANDARD TABLE OF SBEFU, WA_SBEFU TYPE SBEFU, 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: <SBEFU> TYPE SBEFU. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_SBEFU. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM SBEFU INTO TABLE IT_SBEFU. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM SBEFU * INTO TABLE @DATA(IT_SBEFU2). *--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_SBEFU INDEX 1 INTO DATA(WA_SBEFU2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_SBEFU ASSIGNING <SBEFU>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<SBEFU>-STUFE = 1.
<SBEFU>-WEGXX = 1.
<SBEFU>-MATNR = 1.
<SBEFU>-EQUNR = 1.
<SBEFU>-VWEGX = 1.
ENDLOOP. LOOP AT IT_SBEFU INTO WA_SBEFU. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_SBEFU-OJTXB, sy-vline,
WA_SBEFU-BAUSF, sy-vline,
WA_SBEFU-STLAN, sy-vline,
WA_SBEFU-STLAL, sy-vline,
WA_SBEFU-ALTST, sy-vline,
WA_SBEFU-VARST, sy-vline.
ENDLOOP. *Add any further fields from structure WA_SBEFU 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_SBEFU 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_SBEFU INTO WA_SBEFU. *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 MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_SBEFU-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-MATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field EQUNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-EQUNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-EQUNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field STLAL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-STLAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-STLAL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MMEIN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_SBEFU-MMEIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-MMEIN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field NFMAT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_SBEFU-NFMAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-NFMAT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field REVLV CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_SBEFU-REVLV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-REVLV.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field STLNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_SBEFU-STLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-STLNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AENNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-AENNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-AENNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field IDNRK CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_SBEFU-IDNRK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-IDNRK.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field POSNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_SBEFU-POSNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-POSNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_SBEFU-MEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-MEINS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LIFNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-LIFNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-LIFNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SAKTO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-SAKTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-SAKTO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field ROMEI CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_SBEFU-ROMEI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-ROMEI.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ISOLA, internal->external for field LTXSP CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_SBEFU-LTXSP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-LTXSP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field DOKNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-DOKNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-DOKNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field AENRA CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-AENRA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-AENRA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field XTLNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_SBEFU-XTLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-XTLNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field XTLAL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_SBEFU-XTLAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-XTLAL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field KSTNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_SBEFU-KSTNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-KSTNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field NLFMV CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_SBEFU-NLFMV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_SBEFU-NLFMV.
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_SBEFU_STR,
STUFE TYPE STRING,
WEGXX TYPE STRING,
MATNR TYPE STRING,
EQUNR TYPE STRING,
VWEGX TYPE STRING,
OJTXB TYPE STRING,
BAUSF TYPE STRING,
STLAN TYPE STRING,
STLAL TYPE STRING,
ALTST TYPE STRING,
VARST TYPE STRING,
KBAUS TYPE STRING,
LOEKZ TYPE STRING,
OJTXP TYPE STRING,
WERKS TYPE STRING,
VPSTA TYPE STRING,
FSTAT TYPE STRING,
MMEIN TYPE STRING,
BWTTY TYPE STRING,
VPRSV TYPE STRING,
STPRS TYPE STRING,
VERPR TYPE STRING,
SBDKZ TYPE STRING,
XCHAR TYPE STRING,
MMSTA TYPE STRING,
ZEINR TYPE STRING,
DISST TYPE STRING,
MNGLG TYPE STRING,
MNGKO TYPE STRING,
MSIGN TYPE STRING,
AUSSS TYPE STRING,
KAUSF TYPE STRING,
SOBSL TYPE STRING,
SOBSK TYPE STRING,
KZAUS TYPE STRING,
AUSDT TYPE STRING,
NFMAT TYPE STRING,
RGEKZ TYPE STRING,
KZDKZ TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
LGPRO TYPE STRING,
REVLV TYPE STRING,
KZKFG TYPE STRING,
FBSKZ TYPE STRING,
STABK TYPE STRING,
DOSTX TYPE STRING,
STLTY TYPE STRING,
STLNR TYPE STRING,
STLKN TYPE STRING,
STPOZ TYPE STRING,
DATUV TYPE STRING,
AENNR TYPE STRING,
ANDAT TYPE STRING,
ANNAM TYPE STRING,
AEDAT TYPE STRING,
AENAM TYPE STRING,
IDNRK TYPE STRING,
PSWRK TYPE STRING,
POSTP TYPE STRING,
POSNR TYPE STRING,
SORTF TYPE STRING,
MEINS TYPE STRING,
MENGE TYPE STRING,
FMENG TYPE STRING,
AUSCH TYPE STRING,
AVOAU TYPE STRING,
NETAU TYPE STRING,
SCHGT TYPE STRING,
BEIKZ TYPE STRING,
ERSKZ TYPE STRING,
RVREL TYPE STRING,
SANFE TYPE STRING,
SANIN TYPE STRING,
SANKA TYPE STRING,
SANKO TYPE STRING,
SANVS TYPE STRING,
STKKZ TYPE STRING,
REKRI TYPE STRING,
REKRS TYPE STRING,
CADPO TYPE STRING,
NLFZT TYPE STRING,
VERTI TYPE STRING,
ALPOS TYPE STRING,
EWAHR TYPE STRING,
EKGRP TYPE STRING,
LIFZT TYPE STRING,
LIFNR TYPE STRING,
PREIS TYPE STRING,
PEINH TYPE STRING,
WAERS TYPE STRING,
SAKTO TYPE STRING,
ROANZ TYPE STRING,
ROMS1 TYPE STRING,
ROMS2 TYPE STRING,
ROMS3 TYPE STRING,
ROMEI TYPE STRING,
ROMEN TYPE STRING,
RFORM TYPE STRING,
UPSKZ TYPE STRING,
LTXSP TYPE STRING,
POTX1 TYPE STRING,
POTX2 TYPE STRING,
OBJTY TYPE STRING,
MATKL TYPE STRING,
WEBAZ TYPE STRING,
DOKAR TYPE STRING,
DOKNR TYPE STRING,
DOKVR TYPE STRING,
DOKTL TYPE STRING,
CLASS TYPE STRING,
KLART TYPE STRING,
POTPR TYPE STRING,
EKORG TYPE STRING,
KNOBJ TYPE STRING,
LGORT TYPE STRING,
KZKUP TYPE STRING,
DATUB TYPE STRING,
AENRA TYPE STRING,
AENKZ TYPE STRING,
AMGLG TYPE STRING,
AMGKO TYPE STRING,
DUMPS TYPE STRING,
XTLTY TYPE STRING,
XTLNR TYPE STRING,
XTLAN TYPE STRING,
XTLAL TYPE STRING,
XISDT TYPE STRING,
XISSR TYPE STRING,
XMENG TYPE STRING,
XALTS TYPE STRING,
XVARS TYPE STRING,
XKBAU TYPE STRING,
XLOEK TYPE STRING,
AUSNM TYPE STRING,
HDNFO TYPE STRING,
AFFLG TYPE STRING,
LTFLG TYPE STRING,
NLFLG TYPE STRING,
INDEX TYPE STRING,
SUMKZ TYPE STRING,
AUFST TYPE STRING,
AUFWG TYPE STRING,
BAUST TYPE STRING,
BAUWG TYPE STRING,
STVKN TYPE STRING,
DSPST TYPE STRING,
ALPST TYPE STRING,
ALPRF TYPE STRING,
ALPGR TYPE STRING,
KZNFP TYPE STRING,
NFGRP TYPE STRING,
NFEAG TYPE STRING,
KSTTY TYPE STRING,
KSTNR TYPE STRING,
KSTKN TYPE STRING,
KSTPZ TYPE STRING,
CLSZU TYPE STRING,
KZCLB TYPE STRING,
PRVBE TYPE STRING,
NLFZV TYPE STRING,
NLFMV TYPE STRING,END OF T_EKKO_STR. DATA: WA_SBEFU_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_SBEFU_STR-STUFE sy-vline
WA_SBEFU_STR-WEGXX sy-vline
WA_SBEFU_STR-MATNR sy-vline
WA_SBEFU_STR-EQUNR sy-vline
WA_SBEFU_STR-VWEGX sy-vline
WA_SBEFU_STR-OJTXB sy-vline
WA_SBEFU_STR-BAUSF sy-vline
WA_SBEFU_STR-STLAN sy-vline
WA_SBEFU_STR-STLAL sy-vline
WA_SBEFU_STR-ALTST sy-vline
WA_SBEFU_STR-VARST sy-vline
WA_SBEFU_STR-KBAUS sy-vline
WA_SBEFU_STR-LOEKZ sy-vline
WA_SBEFU_STR-OJTXP sy-vline
WA_SBEFU_STR-WERKS sy-vline
WA_SBEFU_STR-VPSTA sy-vline
WA_SBEFU_STR-FSTAT sy-vline
WA_SBEFU_STR-MMEIN sy-vline
WA_SBEFU_STR-BWTTY sy-vline
WA_SBEFU_STR-VPRSV sy-vline
WA_SBEFU_STR-STPRS sy-vline
WA_SBEFU_STR-VERPR sy-vline
WA_SBEFU_STR-SBDKZ sy-vline
WA_SBEFU_STR-XCHAR sy-vline
WA_SBEFU_STR-MMSTA sy-vline
WA_SBEFU_STR-ZEINR sy-vline
WA_SBEFU_STR-DISST sy-vline
WA_SBEFU_STR-MNGLG sy-vline
WA_SBEFU_STR-MNGKO sy-vline
WA_SBEFU_STR-MSIGN sy-vline
WA_SBEFU_STR-AUSSS sy-vline
WA_SBEFU_STR-KAUSF sy-vline
WA_SBEFU_STR-SOBSL sy-vline
WA_SBEFU_STR-SOBSK sy-vline
WA_SBEFU_STR-KZAUS sy-vline
WA_SBEFU_STR-AUSDT sy-vline
WA_SBEFU_STR-NFMAT sy-vline
WA_SBEFU_STR-RGEKZ sy-vline
WA_SBEFU_STR-KZDKZ sy-vline
WA_SBEFU_STR-UMREZ sy-vline
WA_SBEFU_STR-UMREN sy-vline
WA_SBEFU_STR-LGPRO sy-vline
WA_SBEFU_STR-REVLV sy-vline
WA_SBEFU_STR-KZKFG sy-vline
WA_SBEFU_STR-FBSKZ sy-vline
WA_SBEFU_STR-STABK sy-vline
WA_SBEFU_STR-DOSTX sy-vline
WA_SBEFU_STR-STLTY sy-vline
WA_SBEFU_STR-STLNR sy-vline
WA_SBEFU_STR-STLKN sy-vline
WA_SBEFU_STR-STPOZ sy-vline
WA_SBEFU_STR-DATUV sy-vline
WA_SBEFU_STR-AENNR sy-vline
WA_SBEFU_STR-ANDAT sy-vline
WA_SBEFU_STR-ANNAM sy-vline
WA_SBEFU_STR-AEDAT sy-vline
WA_SBEFU_STR-AENAM sy-vline
WA_SBEFU_STR-IDNRK sy-vline
WA_SBEFU_STR-PSWRK sy-vline
WA_SBEFU_STR-POSTP sy-vline
WA_SBEFU_STR-POSNR sy-vline
WA_SBEFU_STR-SORTF sy-vline
WA_SBEFU_STR-MEINS sy-vline
WA_SBEFU_STR-MENGE sy-vline
WA_SBEFU_STR-FMENG sy-vline
WA_SBEFU_STR-AUSCH sy-vline
WA_SBEFU_STR-AVOAU sy-vline
WA_SBEFU_STR-NETAU sy-vline
WA_SBEFU_STR-SCHGT sy-vline
WA_SBEFU_STR-BEIKZ sy-vline
WA_SBEFU_STR-ERSKZ sy-vline
WA_SBEFU_STR-RVREL sy-vline
WA_SBEFU_STR-SANFE sy-vline
WA_SBEFU_STR-SANIN sy-vline
WA_SBEFU_STR-SANKA sy-vline
WA_SBEFU_STR-SANKO sy-vline
WA_SBEFU_STR-SANVS sy-vline
WA_SBEFU_STR-STKKZ sy-vline
WA_SBEFU_STR-REKRI sy-vline
WA_SBEFU_STR-REKRS sy-vline
WA_SBEFU_STR-CADPO sy-vline
WA_SBEFU_STR-NLFZT sy-vline
WA_SBEFU_STR-VERTI sy-vline
WA_SBEFU_STR-ALPOS sy-vline
WA_SBEFU_STR-EWAHR sy-vline
WA_SBEFU_STR-EKGRP sy-vline
WA_SBEFU_STR-LIFZT sy-vline
WA_SBEFU_STR-LIFNR sy-vline
WA_SBEFU_STR-PREIS sy-vline
WA_SBEFU_STR-PEINH sy-vline
WA_SBEFU_STR-WAERS sy-vline
WA_SBEFU_STR-SAKTO sy-vline
WA_SBEFU_STR-ROANZ sy-vline
WA_SBEFU_STR-ROMS1 sy-vline
WA_SBEFU_STR-ROMS2 sy-vline
WA_SBEFU_STR-ROMS3 sy-vline
WA_SBEFU_STR-ROMEI sy-vline
WA_SBEFU_STR-ROMEN sy-vline
WA_SBEFU_STR-RFORM sy-vline
WA_SBEFU_STR-UPSKZ sy-vline
WA_SBEFU_STR-LTXSP sy-vline
WA_SBEFU_STR-POTX1 sy-vline
WA_SBEFU_STR-POTX2 sy-vline
WA_SBEFU_STR-OBJTY sy-vline
WA_SBEFU_STR-MATKL sy-vline
WA_SBEFU_STR-WEBAZ sy-vline
WA_SBEFU_STR-DOKAR sy-vline
WA_SBEFU_STR-DOKNR sy-vline
WA_SBEFU_STR-DOKVR sy-vline
WA_SBEFU_STR-DOKTL sy-vline
WA_SBEFU_STR-CLASS sy-vline
WA_SBEFU_STR-KLART sy-vline
WA_SBEFU_STR-POTPR sy-vline
WA_SBEFU_STR-EKORG sy-vline
WA_SBEFU_STR-KNOBJ sy-vline
WA_SBEFU_STR-LGORT sy-vline
WA_SBEFU_STR-KZKUP sy-vline
WA_SBEFU_STR-DATUB sy-vline
WA_SBEFU_STR-AENRA sy-vline
WA_SBEFU_STR-AENKZ sy-vline
WA_SBEFU_STR-AMGLG sy-vline
WA_SBEFU_STR-AMGKO sy-vline
WA_SBEFU_STR-DUMPS sy-vline
WA_SBEFU_STR-XTLTY sy-vline
WA_SBEFU_STR-XTLNR sy-vline
WA_SBEFU_STR-XTLAN sy-vline
WA_SBEFU_STR-XTLAL sy-vline
WA_SBEFU_STR-XISDT sy-vline
WA_SBEFU_STR-XISSR sy-vline
WA_SBEFU_STR-XMENG sy-vline
WA_SBEFU_STR-XALTS sy-vline
WA_SBEFU_STR-XVARS sy-vline
WA_SBEFU_STR-XKBAU sy-vline
WA_SBEFU_STR-XLOEK sy-vline
WA_SBEFU_STR-AUSNM sy-vline
WA_SBEFU_STR-HDNFO sy-vline
WA_SBEFU_STR-AFFLG sy-vline
WA_SBEFU_STR-LTFLG sy-vline
WA_SBEFU_STR-NLFLG sy-vline
WA_SBEFU_STR-INDEX sy-vline
WA_SBEFU_STR-SUMKZ sy-vline
WA_SBEFU_STR-AUFST sy-vline
WA_SBEFU_STR-AUFWG sy-vline
WA_SBEFU_STR-BAUST sy-vline
WA_SBEFU_STR-BAUWG sy-vline
WA_SBEFU_STR-STVKN sy-vline
WA_SBEFU_STR-DSPST sy-vline
WA_SBEFU_STR-ALPST sy-vline
WA_SBEFU_STR-ALPRF sy-vline
WA_SBEFU_STR-ALPGR sy-vline
WA_SBEFU_STR-KZNFP sy-vline
WA_SBEFU_STR-NFGRP sy-vline
WA_SBEFU_STR-NFEAG sy-vline
WA_SBEFU_STR-KSTTY sy-vline
WA_SBEFU_STR-KSTNR sy-vline
WA_SBEFU_STR-KSTKN sy-vline
WA_SBEFU_STR-KSTPZ sy-vline
WA_SBEFU_STR-CLSZU sy-vline
WA_SBEFU_STR-KZCLB sy-vline
WA_SBEFU_STR-PRVBE sy-vline
WA_SBEFU_STR-NLFZV sy-vline
WA_SBEFU_STR-NLFMV sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.