ABAP Select data from SAP table /BIC/CCQC0MAT_PLANT_ATTR 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 /BIC/CCQC0MAT_PLANT_ATTR 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 /BIC/CCQC0MAT_PLANT_ATTR. 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 /BIC/CCQC0MAT_PLANT_ATTR 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_/BIC/CCQC0MAT_PLANT_ATTR TYPE STANDARD TABLE OF /BIC/CCQC0MAT_PLANT_ATTR,
      WA_/BIC/CCQC0MAT_PLANT_ATTR TYPE /BIC/CCQC0MAT_PLANT_ATTR,
      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: </BIC/CCQC0MAT_PLANT_ATTR> TYPE /BIC/CCQC0MAT_PLANT_ATTR.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /BIC/CCQC0MAT_PLANT_ATTR
  INTO TABLE IT_/BIC/CCQC0MAT_PLANT_ATTR.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /BIC/CCQC0MAT_PLANT_ATTR
*  INTO TABLE @DATA(IT_/BIC/CCQC0MAT_PLANT_ATTR2).
*--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_/BIC/CCQC0MAT_PLANT_ATTR INDEX 1 INTO DATA(WA_/BIC/CCQC0MAT_PLANT_ATTR2).


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

LOOP AT IT_/BIC/CCQC0MAT_PLANT_ATTR INTO WA_/BIC/CCQC0MAT_PLANT_ATTR.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/BIC/CCQC0MAT_PLANT_ATTR-XCHAR, sy-vline,
WA_/BIC/CCQC0MAT_PLANT_ATTR-MMSTA, sy-vline,
WA_/BIC/CCQC0MAT_PLANT_ATTR-MMSTD, sy-vline,
WA_/BIC/CCQC0MAT_PLANT_ATTR-MAABC, sy-vline,
WA_/BIC/CCQC0MAT_PLANT_ATTR-KZKRI, sy-vline,
WA_/BIC/CCQC0MAT_PLANT_ATTR-EKGRP, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/BIC/CCQC0MAT_PLANT_ATTR 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_/BIC/CCQC0MAT_PLANT_ATTR 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_/BIC/CCQC0MAT_PLANT_ATTR INTO WA_/BIC/CCQC0MAT_PLANT_ATTR. *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.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_/BIC/CCQC0MAT_PLANT_ATTR_STR,
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,
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,
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,
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,
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,
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,
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_/BIC/CCQC0MAT_PLANT_ATTR_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_/BIC/CCQC0MAT_PLANT_ATTR_STR-MATNR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-WERKS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PSTAT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LVORM sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-BWTTY sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-XCHAR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MMSTA sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MMSTD sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MAABC sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZKRI sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-EKGRP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-AUSME sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-DISPR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-DISMM sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-DISPO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZDIE sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PLIFZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-WEBAZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PERKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-AUSSS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-DISLS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-BESKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SOBSL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SBDKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LAGPR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-ALTSL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZAUS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-AUSDT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-NFMAT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZBED sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MISKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-FHORI sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PFREI sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-FFREI sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-RGEKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-FEVOR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-BEARZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-RUEZT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-TRANZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-DZEIT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MAXLZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LZEIH sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZPRO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-GPMKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-UEETO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-UEETK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-UNETO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-WZEIT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-ATPKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VZUSL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-HERBL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-INSMK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SPROZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-QUAZT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SSQSS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MPDAU sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZPPV sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZDKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-WSTGH sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PRFRQ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-NKMPR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LADGR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-XCHPF sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-USEQU sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LGRAD sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-AUFTL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PLVAR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-OTYPE sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-OBJID sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MTVFP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PERIV sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZKFK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VRVEZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VBEAZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LIZYK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-BWSCL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KAUTB sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KORDB sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-STAWN sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-HERKL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-HERKR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-EXPME sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MTVER sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PRCTR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MRPPP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SAUFT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-FXHOR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VRMOD sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VINT1 sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VINT2 sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VERKZ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-STLAL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-STLAN sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PLNNR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-APLAL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SOBSK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-FRTME sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LGPRO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-DISGR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KAUSF sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-QZGTP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-QMATV sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-TAKZT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-RWPRO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-COPAM sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-ABCIN sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-AWSLS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SERNP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-CUOBJ sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-STDPD sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SFEPR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-XMCNG sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-QSSYS sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LFRHY sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-RDPRF sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VRBMT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VRBWK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VRBDT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-VRBFK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-AUTRU sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PREFE sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PRENC sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PRENO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PREND sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PRENE sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PRENG sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-ITARK sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SERVG sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZKUP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-STRGR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-CUOBV sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-LGFSB sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SCHGT sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-CCFIX sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-EPRIO sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-QMATA sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-RESVP sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-PLNTY sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-UOMGR sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-UMRSL sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-ABFAC sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SFCPF sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SHFLG sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-SHZET sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-MDACH sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_STR-KZECH sy-vline
WA_/BIC/CCQC0MAT_PLANT_ATTR_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.