ABAP Select data from SAP table BIW_MARC_S 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 BIW_MARC_S 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 BIW_MARC_S. 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 BIW_MARC_S 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_BIW_MARC_S TYPE STANDARD TABLE OF BIW_MARC_S,
      WA_BIW_MARC_S TYPE BIW_MARC_S,
      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: <BIW_MARC_S> TYPE BIW_MARC_S.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BIW_MARC_S
*  INTO TABLE @DATA(IT_BIW_MARC_S2).
*--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_BIW_MARC_S INDEX 1 INTO DATA(WA_BIW_MARC_S2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_BIW_MARC_S ASSIGNING <BIW_MARC_S>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<BIW_MARC_S>-MANDT = 1.
<BIW_MARC_S>-MATNR = 1.
<BIW_MARC_S>-WERKS = 1.
<BIW_MARC_S>-PSTAT = 1.
<BIW_MARC_S>-LVORM = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BIW_MARC_S-BWTTY, sy-vline,
WA_BIW_MARC_S-XCHAR, sy-vline,
WA_BIW_MARC_S-MMSTA, sy-vline,
WA_BIW_MARC_S-MMSTD, sy-vline,
WA_BIW_MARC_S-MAABC, sy-vline,
WA_BIW_MARC_S-KZKRI, sy-vline.
ENDLOOP. *Add any further fields from structure WA_BIW_MARC_S 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_BIW_MARC_S 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_BIW_MARC_S INTO WA_BIW_MARC_S. *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_BIW_MARC_S-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_BIW_MARC_S-MATNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit MATN1, internal->external for field NFMAT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_BIW_MARC_S-NFMAT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_BIW_MARC_S-NFMAT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field STDPD CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_BIW_MARC_S-STDPD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_BIW_MARC_S-STDPD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field VRBMT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_BIW_MARC_S-VRBMT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_BIW_MARC_S-VRBMT.
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_BIW_MARC_S_STR,
MANDT TYPE STRING,
MATNR TYPE STRING,
WERKS TYPE STRING,
PSTAT TYPE STRING,
LVORM TYPE STRING,
BWTTY TYPE STRING,
XCHAR TYPE STRING,
MMSTA TYPE STRING,
MMSTD TYPE STRING,
MAABC TYPE STRING,
KZKRI TYPE STRING,
EKGRP TYPE STRING,
AUSME TYPE STRING,
DISPR TYPE STRING,
DISMM TYPE STRING,
DISPO TYPE STRING,
KZDIE TYPE STRING,
PLIFZ TYPE STRING,
WEBAZ TYPE STRING,
PERKZ TYPE STRING,
AUSSS TYPE STRING,
DISLS TYPE STRING,
BESKZ TYPE STRING,
SOBSL TYPE STRING,
MINBE TYPE STRING,
EISBE TYPE STRING,
BSTMI TYPE STRING,
BSTMA TYPE STRING,
BSTFE TYPE STRING,
BSTRF TYPE STRING,
MABST TYPE STRING,
LOSFX TYPE STRING,
SBDKZ TYPE STRING,
LAGPR TYPE STRING,
ALTSL TYPE STRING,
KZAUS TYPE STRING,
AUSDT TYPE STRING,
NFMAT TYPE STRING,
KZBED TYPE STRING,
MISKZ TYPE STRING,
FHORI TYPE STRING,
PFREI TYPE STRING,
FFREI TYPE STRING,
RGEKZ TYPE STRING,
FEVOR TYPE STRING,
BEARZ TYPE STRING,
RUEZT TYPE STRING,
TRANZ TYPE STRING,
BASMG TYPE STRING,
DZEIT TYPE STRING,
MAXLZ TYPE STRING,
LZEIH TYPE STRING,
KZPRO TYPE STRING,
GPMKZ TYPE STRING,
UEETO TYPE STRING,
UEETK TYPE STRING,
UNETO TYPE STRING,
WZEIT TYPE STRING,
ATPKZ TYPE STRING,
VZUSL TYPE STRING,
HERBL TYPE STRING,
INSMK TYPE STRING,
SPROZ TYPE STRING,
QUAZT TYPE STRING,
SSQSS TYPE STRING,
MPDAU TYPE STRING,
KZPPV TYPE STRING,
KZDKZ TYPE STRING,
WSTGH TYPE STRING,
PRFRQ TYPE STRING,
NKMPR TYPE STRING,
UMLMC TYPE STRING,
LADGR TYPE STRING,
XCHPF TYPE STRING,
USEQU TYPE STRING,
LGRAD TYPE STRING,
AUFTL TYPE STRING,
PLVAR TYPE STRING,
OTYPE TYPE STRING,
OBJID TYPE STRING,
MTVFP TYPE STRING,
PERIV TYPE STRING,
KZKFK TYPE STRING,
VRVEZ TYPE STRING,
VBAMG TYPE STRING,
VBEAZ TYPE STRING,
LIZYK TYPE STRING,
BWSCL TYPE STRING,
KAUTB TYPE STRING,
KORDB TYPE STRING,
STAWN TYPE STRING,
HERKL TYPE STRING,
HERKR TYPE STRING,
EXPME TYPE STRING,
MTVER TYPE STRING,
PRCTR TYPE STRING,
TRAME TYPE STRING,
MRPPP TYPE STRING,
SAUFT TYPE STRING,
FXHOR TYPE STRING,
VRMOD TYPE STRING,
VINT1 TYPE STRING,
VINT2 TYPE STRING,
VERKZ TYPE STRING,
STLAL TYPE STRING,
STLAN TYPE STRING,
PLNNR TYPE STRING,
APLAL TYPE STRING,
LOSGR TYPE STRING,
SOBSK TYPE STRING,
FRTME TYPE STRING,
LGPRO TYPE STRING,
DISGR TYPE STRING,
KAUSF TYPE STRING,
QZGTP TYPE STRING,
QMATV TYPE STRING,
TAKZT TYPE STRING,
RWPRO TYPE STRING,
COPAM TYPE STRING,
ABCIN TYPE STRING,
AWSLS TYPE STRING,
SERNP TYPE STRING,
CUOBJ TYPE STRING,
STDPD TYPE STRING,
SFEPR TYPE STRING,
XMCNG TYPE STRING,
QSSYS TYPE STRING,
LFRHY TYPE STRING,
RDPRF TYPE STRING,
VRBMT TYPE STRING,
VRBWK TYPE STRING,
VRBDT TYPE STRING,
VRBFK TYPE STRING,
AUTRU TYPE STRING,
PREFE TYPE STRING,
PRENC TYPE STRING,
PRENO TYPE STRING,
PREND TYPE STRING,
PRENE TYPE STRING,
PRENG TYPE STRING,
ITARK TYPE STRING,
SERVG TYPE STRING,
KZKUP TYPE STRING,
STRGR TYPE STRING,
CUOBV TYPE STRING,
LGFSB TYPE STRING,
SCHGT TYPE STRING,
CCFIX TYPE STRING,
EPRIO TYPE STRING,
QMATA TYPE STRING,
RESVP TYPE STRING,
PLNTY TYPE STRING,
UOMGR TYPE STRING,
UMRSL TYPE STRING,
ABFAC TYPE STRING,
SFCPF TYPE STRING,
SHFLG TYPE STRING,
SHZET TYPE STRING,
MDACH TYPE STRING,
KZECH TYPE STRING,
KOKRS TYPE STRING,END OF T_EKKO_STR. DATA: WA_BIW_MARC_S_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_BIW_MARC_S_STR-MANDT sy-vline
WA_BIW_MARC_S_STR-MATNR sy-vline
WA_BIW_MARC_S_STR-WERKS sy-vline
WA_BIW_MARC_S_STR-PSTAT sy-vline
WA_BIW_MARC_S_STR-LVORM sy-vline
WA_BIW_MARC_S_STR-BWTTY sy-vline
WA_BIW_MARC_S_STR-XCHAR sy-vline
WA_BIW_MARC_S_STR-MMSTA sy-vline
WA_BIW_MARC_S_STR-MMSTD sy-vline
WA_BIW_MARC_S_STR-MAABC sy-vline
WA_BIW_MARC_S_STR-KZKRI sy-vline
WA_BIW_MARC_S_STR-EKGRP sy-vline
WA_BIW_MARC_S_STR-AUSME sy-vline
WA_BIW_MARC_S_STR-DISPR sy-vline
WA_BIW_MARC_S_STR-DISMM sy-vline
WA_BIW_MARC_S_STR-DISPO sy-vline
WA_BIW_MARC_S_STR-KZDIE sy-vline
WA_BIW_MARC_S_STR-PLIFZ sy-vline
WA_BIW_MARC_S_STR-WEBAZ sy-vline
WA_BIW_MARC_S_STR-PERKZ sy-vline
WA_BIW_MARC_S_STR-AUSSS sy-vline
WA_BIW_MARC_S_STR-DISLS sy-vline
WA_BIW_MARC_S_STR-BESKZ sy-vline
WA_BIW_MARC_S_STR-SOBSL sy-vline
WA_BIW_MARC_S_STR-MINBE sy-vline
WA_BIW_MARC_S_STR-EISBE sy-vline
WA_BIW_MARC_S_STR-BSTMI sy-vline
WA_BIW_MARC_S_STR-BSTMA sy-vline
WA_BIW_MARC_S_STR-BSTFE sy-vline
WA_BIW_MARC_S_STR-BSTRF sy-vline
WA_BIW_MARC_S_STR-MABST sy-vline
WA_BIW_MARC_S_STR-LOSFX sy-vline
WA_BIW_MARC_S_STR-SBDKZ sy-vline
WA_BIW_MARC_S_STR-LAGPR sy-vline
WA_BIW_MARC_S_STR-ALTSL sy-vline
WA_BIW_MARC_S_STR-KZAUS sy-vline
WA_BIW_MARC_S_STR-AUSDT sy-vline
WA_BIW_MARC_S_STR-NFMAT sy-vline
WA_BIW_MARC_S_STR-KZBED sy-vline
WA_BIW_MARC_S_STR-MISKZ sy-vline
WA_BIW_MARC_S_STR-FHORI sy-vline
WA_BIW_MARC_S_STR-PFREI sy-vline
WA_BIW_MARC_S_STR-FFREI sy-vline
WA_BIW_MARC_S_STR-RGEKZ sy-vline
WA_BIW_MARC_S_STR-FEVOR sy-vline
WA_BIW_MARC_S_STR-BEARZ sy-vline
WA_BIW_MARC_S_STR-RUEZT sy-vline
WA_BIW_MARC_S_STR-TRANZ sy-vline
WA_BIW_MARC_S_STR-BASMG sy-vline
WA_BIW_MARC_S_STR-DZEIT sy-vline
WA_BIW_MARC_S_STR-MAXLZ sy-vline
WA_BIW_MARC_S_STR-LZEIH sy-vline
WA_BIW_MARC_S_STR-KZPRO sy-vline
WA_BIW_MARC_S_STR-GPMKZ sy-vline
WA_BIW_MARC_S_STR-UEETO sy-vline
WA_BIW_MARC_S_STR-UEETK sy-vline
WA_BIW_MARC_S_STR-UNETO sy-vline
WA_BIW_MARC_S_STR-WZEIT sy-vline
WA_BIW_MARC_S_STR-ATPKZ sy-vline
WA_BIW_MARC_S_STR-VZUSL sy-vline
WA_BIW_MARC_S_STR-HERBL sy-vline
WA_BIW_MARC_S_STR-INSMK sy-vline
WA_BIW_MARC_S_STR-SPROZ sy-vline
WA_BIW_MARC_S_STR-QUAZT sy-vline
WA_BIW_MARC_S_STR-SSQSS sy-vline
WA_BIW_MARC_S_STR-MPDAU sy-vline
WA_BIW_MARC_S_STR-KZPPV sy-vline
WA_BIW_MARC_S_STR-KZDKZ sy-vline
WA_BIW_MARC_S_STR-WSTGH sy-vline
WA_BIW_MARC_S_STR-PRFRQ sy-vline
WA_BIW_MARC_S_STR-NKMPR sy-vline
WA_BIW_MARC_S_STR-UMLMC sy-vline
WA_BIW_MARC_S_STR-LADGR sy-vline
WA_BIW_MARC_S_STR-XCHPF sy-vline
WA_BIW_MARC_S_STR-USEQU sy-vline
WA_BIW_MARC_S_STR-LGRAD sy-vline
WA_BIW_MARC_S_STR-AUFTL sy-vline
WA_BIW_MARC_S_STR-PLVAR sy-vline
WA_BIW_MARC_S_STR-OTYPE sy-vline
WA_BIW_MARC_S_STR-OBJID sy-vline
WA_BIW_MARC_S_STR-MTVFP sy-vline
WA_BIW_MARC_S_STR-PERIV sy-vline
WA_BIW_MARC_S_STR-KZKFK sy-vline
WA_BIW_MARC_S_STR-VRVEZ sy-vline
WA_BIW_MARC_S_STR-VBAMG sy-vline
WA_BIW_MARC_S_STR-VBEAZ sy-vline
WA_BIW_MARC_S_STR-LIZYK sy-vline
WA_BIW_MARC_S_STR-BWSCL sy-vline
WA_BIW_MARC_S_STR-KAUTB sy-vline
WA_BIW_MARC_S_STR-KORDB sy-vline
WA_BIW_MARC_S_STR-STAWN sy-vline
WA_BIW_MARC_S_STR-HERKL sy-vline
WA_BIW_MARC_S_STR-HERKR sy-vline
WA_BIW_MARC_S_STR-EXPME sy-vline
WA_BIW_MARC_S_STR-MTVER sy-vline
WA_BIW_MARC_S_STR-PRCTR sy-vline
WA_BIW_MARC_S_STR-TRAME sy-vline
WA_BIW_MARC_S_STR-MRPPP sy-vline
WA_BIW_MARC_S_STR-SAUFT sy-vline
WA_BIW_MARC_S_STR-FXHOR sy-vline
WA_BIW_MARC_S_STR-VRMOD sy-vline
WA_BIW_MARC_S_STR-VINT1 sy-vline
WA_BIW_MARC_S_STR-VINT2 sy-vline
WA_BIW_MARC_S_STR-VERKZ sy-vline
WA_BIW_MARC_S_STR-STLAL sy-vline
WA_BIW_MARC_S_STR-STLAN sy-vline
WA_BIW_MARC_S_STR-PLNNR sy-vline
WA_BIW_MARC_S_STR-APLAL sy-vline
WA_BIW_MARC_S_STR-LOSGR sy-vline
WA_BIW_MARC_S_STR-SOBSK sy-vline
WA_BIW_MARC_S_STR-FRTME sy-vline
WA_BIW_MARC_S_STR-LGPRO sy-vline
WA_BIW_MARC_S_STR-DISGR sy-vline
WA_BIW_MARC_S_STR-KAUSF sy-vline
WA_BIW_MARC_S_STR-QZGTP sy-vline
WA_BIW_MARC_S_STR-QMATV sy-vline
WA_BIW_MARC_S_STR-TAKZT sy-vline
WA_BIW_MARC_S_STR-RWPRO sy-vline
WA_BIW_MARC_S_STR-COPAM sy-vline
WA_BIW_MARC_S_STR-ABCIN sy-vline
WA_BIW_MARC_S_STR-AWSLS sy-vline
WA_BIW_MARC_S_STR-SERNP sy-vline
WA_BIW_MARC_S_STR-CUOBJ sy-vline
WA_BIW_MARC_S_STR-STDPD sy-vline
WA_BIW_MARC_S_STR-SFEPR sy-vline
WA_BIW_MARC_S_STR-XMCNG sy-vline
WA_BIW_MARC_S_STR-QSSYS sy-vline
WA_BIW_MARC_S_STR-LFRHY sy-vline
WA_BIW_MARC_S_STR-RDPRF sy-vline
WA_BIW_MARC_S_STR-VRBMT sy-vline
WA_BIW_MARC_S_STR-VRBWK sy-vline
WA_BIW_MARC_S_STR-VRBDT sy-vline
WA_BIW_MARC_S_STR-VRBFK sy-vline
WA_BIW_MARC_S_STR-AUTRU sy-vline
WA_BIW_MARC_S_STR-PREFE sy-vline
WA_BIW_MARC_S_STR-PRENC sy-vline
WA_BIW_MARC_S_STR-PRENO sy-vline
WA_BIW_MARC_S_STR-PREND sy-vline
WA_BIW_MARC_S_STR-PRENE sy-vline
WA_BIW_MARC_S_STR-PRENG sy-vline
WA_BIW_MARC_S_STR-ITARK sy-vline
WA_BIW_MARC_S_STR-SERVG sy-vline
WA_BIW_MARC_S_STR-KZKUP sy-vline
WA_BIW_MARC_S_STR-STRGR sy-vline
WA_BIW_MARC_S_STR-CUOBV sy-vline
WA_BIW_MARC_S_STR-LGFSB sy-vline
WA_BIW_MARC_S_STR-SCHGT sy-vline
WA_BIW_MARC_S_STR-CCFIX sy-vline
WA_BIW_MARC_S_STR-EPRIO sy-vline
WA_BIW_MARC_S_STR-QMATA sy-vline
WA_BIW_MARC_S_STR-RESVP sy-vline
WA_BIW_MARC_S_STR-PLNTY sy-vline
WA_BIW_MARC_S_STR-UOMGR sy-vline
WA_BIW_MARC_S_STR-UMRSL sy-vline
WA_BIW_MARC_S_STR-ABFAC sy-vline
WA_BIW_MARC_S_STR-SFCPF sy-vline
WA_BIW_MARC_S_STR-SHFLG sy-vline
WA_BIW_MARC_S_STR-SHZET sy-vline
WA_BIW_MARC_S_STR-MDACH sy-vline
WA_BIW_MARC_S_STR-KZECH sy-vline
WA_BIW_MARC_S_STR-KOKRS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.