ABAP Select data from SAP table CPRODBUFLVLMNGTP 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 CPRODBUFLVLMNGTP 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 CPRODBUFLVLMNGTP. 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 CPRODBUFLVLMNGTP 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_CPRODBUFLVLMNGTP TYPE STANDARD TABLE OF CPRODBUFLVLMNGTP,
      WA_CPRODBUFLVLMNGTP TYPE CPRODBUFLVLMNGTP,
      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: <CPRODBUFLVLMNGTP> TYPE CPRODBUFLVLMNGTP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CPRODBUFLVLMNGTP
*  INTO TABLE @DATA(IT_CPRODBUFLVLMNGTP2).
*--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_CPRODBUFLVLMNGTP INDEX 1 INTO DATA(WA_CPRODBUFLVLMNGTP2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CPRODBUFLVLMNGTP ASSIGNING <CPRODBUFLVLMNGTP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<CPRODBUFLVLMNGTP>-MANDT = 1.
<CPRODBUFLVLMNGTP>-MRPAREA = 1.
<CPRODBUFLVLMNGTP>-PLANT = 1.
<CPRODBUFLVLMNGTP>-MATERIAL = 1.
<CPRODBUFLVLMNGTP>-PROPOSALSTARTDATE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CPRODBUFLVLMNGTP-PROPOSALVERSION, sy-vline,
WA_CPRODBUFLVLMNGTP-PROPOSALSTATUSCHANGEDATE, sy-vline,
WA_CPRODBUFLVLMNGTP-MEMOLINE, sy-vline,
WA_CPRODBUFLVLMNGTP-USERID, sy-vline,
WA_CPRODBUFLVLMNGTP-MATERIALNAME, sy-vline,
WA_CPRODBUFLVLMNGTP-PLANTNAME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CPRODBUFLVLMNGTP 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_CPRODBUFLVLMNGTP 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_CPRODBUFLVLMNGTP INTO WA_CPRODBUFLVLMNGTP. *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 MATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_CPRODBUFLVLMNGTP-MATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CPRODBUFLVLMNGTP-MATERIAL.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CUNIT, internal->external for field UNITOFMEASURE CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CPRODBUFLVLMNGTP-UNITOFMEASURE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CPRODBUFLVLMNGTP-UNITOFMEASURE.
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_CPRODBUFLVLMNGTP_STR,
MANDT TYPE STRING,
MRPAREA TYPE STRING,
PLANT TYPE STRING,
MATERIAL TYPE STRING,
PROPOSALSTARTDATE TYPE STRING,
PROPOSALVERSION TYPE STRING,
PROPOSALSTATUSCHANGEDATE TYPE STRING,
MEMOLINE TYPE STRING,
USERID TYPE STRING,
MATERIALNAME TYPE STRING,
PLANTNAME TYPE STRING,
MRPAREATEXT TYPE STRING,
BASEUNIT TYPE STRING,
STOCKLEVELPROPOSALID TYPE STRING,
STOCKLEVELPROPOSALSTATUS TYPE STRING,
PROPOSALRUNISSUSPENDED TYPE STRING,
PROPOSALRUNISNOTSUSPENDED TYPE STRING,
PROPOSALRUNSUSPENDEDFROMDATE TYPE STRING,
PROPOSALRUNSUSPENDEDTODATE TYPE STRING,
PROPOSALMODE TYPE STRING,
PROPOSALMODEDESCRIPTION TYPE STRING,
PROPOSALSTATUSDESCRIPTION TYPE STRING,
PLANTNAME2 TYPE STRING,
ISMINORDERQTYCONSIDERED TYPE STRING,
MINORDERQUANTITYHASCHANGED TYPE STRING,
MINORDERQTYHASCHANGEDSTSTEXT TYPE STRING,
ADJUSTMENTTYPE TYPE STRING,
CURRENTREDZONE TYPE STRING,
REDZONEDIFFERENCE TYPE STRING,
PROPOSEDREDZONE TYPE STRING,
CURRENTYELLOWZONE TYPE STRING,
YELLOWZONEDIFFERENCE TYPE STRING,
PROPOSEDYELLOWZONE TYPE STRING,
CURRENTGREENZONE TYPE STRING,
GREENZONEDIFFERENCE TYPE STRING,
PROPOSEDGREENZONE TYPE STRING,
MAXSTOCKDIFFERENCE TYPE STRING,
MAXSTOCKDEVIATIONRATE TYPE STRING,
MATERIALMAXSTOCKLEVELQUANTITY TYPE STRING,
MATLCURRENTMAXSTOCK TYPE STRING,
MATLPROPOSEDMAXSTOCK TYPE STRING,
UNITOFMEASURE TYPE STRING,
CURRENTAVERAGEDAILYUSAGE TYPE STRING,
PROPOSEDAVERAGEDAILYUSAGE TYPE STRING,
AVERAGEDAILYUSAGEMODE TYPE STRING,
AVERAGEDAILYUSAGEMODEDESC TYPE STRING,
AVGDAILYUSAGEDIFFERENCE TYPE STRING,
AVGDAILYUSAGEDEVIATIONRATE TYPE STRING,
CURRENTVARIABILITYFACTOR TYPE STRING,
PROPOSEDVARIABILITYFACTOR TYPE STRING,
VARIABILITYFACTORDEVIATIONRATE TYPE STRING,
VARIABILITYFACTORDIFFERENCE TYPE STRING,
CURRENTLEADTIME TYPE STRING,
PROPOSEDLEADTIME TYPE STRING,
LEADTIMEDEVIATIONRATE TYPE STRING,
LEADTIMEDIFFERENCE TYPE STRING,
DIFFERENCEINDAYS TYPE STRING,
DIFFERENCEINDAYSDESC TYPE STRING,
MATERIALGROUP TYPE STRING,
MRPCONTROLLER TYPE STRING,
MRPCONTROLLERNAME TYPE STRING,
PURCHASINGGROUP TYPE STRING,
MRPGROUP TYPE STRING,
MATLPRPSLADJMTFCTRISAPPLIED TYPE STRING,
NORMALIZEDCURRENTGREENZONE TYPE STRING,
NORMALIZEDCURRENTYELLOWZONE TYPE STRING,
NORMALIZEDCURRENTREDZONE TYPE STRING,
NORMALIZEDPROPOSEDGREENZONE TYPE STRING,
NORMALIZEDPROPOSEDYELLOWZONE TYPE STRING,
NORMALIZEDPROPOSEDREDZONE TYPE STRING,
MRPAREACATEGORY TYPE STRING,
HORIZONDAYSINPAST TYPE STRING,
HORIZONDAYSINFUTURE TYPE STRING,
PRODUCTPROFILEHASCHANGED TYPE STRING,
CHARTZOOMHORIZONSTARTDATE TYPE STRING,
CHARTZOOMHORIZONENDDATE TYPE STRING,
PRODUCTPROFILEHASCHANGEDTEXT TYPE STRING,
MAXIMUMAVERAGEDAILYUSAGE TYPE STRING,
MINIMUMAVERAGEDAILYUSAGE TYPE STRING,
MAXIMUMMATLMAXSTOCKLEVELQTY TYPE STRING,
MINIMUMMATLMAXSTOCKLEVELQTY TYPE STRING,
PROPOSEDMATERIALBUFFERPROFILE TYPE STRING,
PROPOSEDMATLBUFFERPROFILETEXT TYPE STRING,
CONSUMPTIONCODE TYPE STRING,
CONSUMPTIONDESCRIPTION TYPE STRING,
REPLENISHMENTLEADTIMECODE TYPE STRING,
REPLENISHMENTLEADTIMEVALUE TYPE STRING,
REPLENISHMENTLEADTIMEDESC TYPE STRING,
BOMUSAGECODE TYPE STRING,
BOMUSAGEDESCRIPTION TYPE STRING,
VARIABILITYCODE TYPE STRING,
VARIABILITYQUANTITY TYPE STRING,
VARIABILITYDESCRIPTION TYPE STRING,
PROCUREMENTTYPE TYPE STRING,
PROCUREMENTTYPEDESCRIPTION TYPE STRING,
PRODUCTPROFILECHANGECATEGORY TYPE STRING,
PRODUCTPROFILECHANGECATTXT TYPE STRING,
BOMEXPLOSIONDATE TYPE STRING,
BUFLVLPROPOSALHORIZONSTARTDATE TYPE STRING,
HORIZONSTARTDATE TYPE STRING,
HORIZONENDDATE TYPE STRING,
ISPROPOSALADOPTED TYPE STRING,
ISINPROCESS TYPE STRING,
PRODUCTAUTHORIZATIONGROUP TYPE STRING,
PRODUCTTYPEAUTHORIZATIONGROUP TYPE STRING,
PRODUCTGROUPAUTHORIZATIONGROUP TYPE STRING,
UXFCSTOCKLEVELPROPOSALSTATUS TYPE STRING,
UXFCPROPOSALMODE TYPE STRING,END OF T_EKKO_STR. DATA: WA_CPRODBUFLVLMNGTP_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_CPRODBUFLVLMNGTP_STR-MANDT sy-vline
WA_CPRODBUFLVLMNGTP_STR-MRPAREA sy-vline
WA_CPRODBUFLVLMNGTP_STR-PLANT sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATERIAL sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALSTARTDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALVERSION sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALSTATUSCHANGEDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MEMOLINE sy-vline
WA_CPRODBUFLVLMNGTP_STR-USERID sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATERIALNAME sy-vline
WA_CPRODBUFLVLMNGTP_STR-PLANTNAME sy-vline
WA_CPRODBUFLVLMNGTP_STR-MRPAREATEXT sy-vline
WA_CPRODBUFLVLMNGTP_STR-BASEUNIT sy-vline
WA_CPRODBUFLVLMNGTP_STR-STOCKLEVELPROPOSALID sy-vline
WA_CPRODBUFLVLMNGTP_STR-STOCKLEVELPROPOSALSTATUS sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALRUNISSUSPENDED sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALRUNISNOTSUSPENDED sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALRUNSUSPENDEDFROMDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALRUNSUSPENDEDTODATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALMODE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALMODEDESCRIPTION sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSALSTATUSDESCRIPTION sy-vline
WA_CPRODBUFLVLMNGTP_STR-PLANTNAME2 sy-vline
WA_CPRODBUFLVLMNGTP_STR-ISMINORDERQTYCONSIDERED sy-vline
WA_CPRODBUFLVLMNGTP_STR-MINORDERQUANTITYHASCHANGED sy-vline
WA_CPRODBUFLVLMNGTP_STR-MINORDERQTYHASCHANGEDSTSTEXT sy-vline
WA_CPRODBUFLVLMNGTP_STR-ADJUSTMENTTYPE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CURRENTREDZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-REDZONEDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDREDZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CURRENTYELLOWZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-YELLOWZONEDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDYELLOWZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CURRENTGREENZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-GREENZONEDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDGREENZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MAXSTOCKDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MAXSTOCKDEVIATIONRATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATERIALMAXSTOCKLEVELQUANTITY sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATLCURRENTMAXSTOCK sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATLPROPOSEDMAXSTOCK sy-vline
WA_CPRODBUFLVLMNGTP_STR-UNITOFMEASURE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CURRENTAVERAGEDAILYUSAGE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDAVERAGEDAILYUSAGE sy-vline
WA_CPRODBUFLVLMNGTP_STR-AVERAGEDAILYUSAGEMODE sy-vline
WA_CPRODBUFLVLMNGTP_STR-AVERAGEDAILYUSAGEMODEDESC sy-vline
WA_CPRODBUFLVLMNGTP_STR-AVGDAILYUSAGEDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-AVGDAILYUSAGEDEVIATIONRATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CURRENTVARIABILITYFACTOR sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDVARIABILITYFACTOR sy-vline
WA_CPRODBUFLVLMNGTP_STR-VARIABILITYFACTORDEVIATIONRATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-VARIABILITYFACTORDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CURRENTLEADTIME sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDLEADTIME sy-vline
WA_CPRODBUFLVLMNGTP_STR-LEADTIMEDEVIATIONRATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-LEADTIMEDIFFERENCE sy-vline
WA_CPRODBUFLVLMNGTP_STR-DIFFERENCEINDAYS sy-vline
WA_CPRODBUFLVLMNGTP_STR-DIFFERENCEINDAYSDESC sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATERIALGROUP sy-vline
WA_CPRODBUFLVLMNGTP_STR-MRPCONTROLLER sy-vline
WA_CPRODBUFLVLMNGTP_STR-MRPCONTROLLERNAME sy-vline
WA_CPRODBUFLVLMNGTP_STR-PURCHASINGGROUP sy-vline
WA_CPRODBUFLVLMNGTP_STR-MRPGROUP sy-vline
WA_CPRODBUFLVLMNGTP_STR-MATLPRPSLADJMTFCTRISAPPLIED sy-vline
WA_CPRODBUFLVLMNGTP_STR-NORMALIZEDCURRENTGREENZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-NORMALIZEDCURRENTYELLOWZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-NORMALIZEDCURRENTREDZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-NORMALIZEDPROPOSEDGREENZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-NORMALIZEDPROPOSEDYELLOWZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-NORMALIZEDPROPOSEDREDZONE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MRPAREACATEGORY sy-vline
WA_CPRODBUFLVLMNGTP_STR-HORIZONDAYSINPAST sy-vline
WA_CPRODBUFLVLMNGTP_STR-HORIZONDAYSINFUTURE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTPROFILEHASCHANGED sy-vline
WA_CPRODBUFLVLMNGTP_STR-CHARTZOOMHORIZONSTARTDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CHARTZOOMHORIZONENDDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTPROFILEHASCHANGEDTEXT sy-vline
WA_CPRODBUFLVLMNGTP_STR-MAXIMUMAVERAGEDAILYUSAGE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MINIMUMAVERAGEDAILYUSAGE sy-vline
WA_CPRODBUFLVLMNGTP_STR-MAXIMUMMATLMAXSTOCKLEVELQTY sy-vline
WA_CPRODBUFLVLMNGTP_STR-MINIMUMMATLMAXSTOCKLEVELQTY sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDMATERIALBUFFERPROFILE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROPOSEDMATLBUFFERPROFILETEXT sy-vline
WA_CPRODBUFLVLMNGTP_STR-CONSUMPTIONCODE sy-vline
WA_CPRODBUFLVLMNGTP_STR-CONSUMPTIONDESCRIPTION sy-vline
WA_CPRODBUFLVLMNGTP_STR-REPLENISHMENTLEADTIMECODE sy-vline
WA_CPRODBUFLVLMNGTP_STR-REPLENISHMENTLEADTIMEVALUE sy-vline
WA_CPRODBUFLVLMNGTP_STR-REPLENISHMENTLEADTIMEDESC sy-vline
WA_CPRODBUFLVLMNGTP_STR-BOMUSAGECODE sy-vline
WA_CPRODBUFLVLMNGTP_STR-BOMUSAGEDESCRIPTION sy-vline
WA_CPRODBUFLVLMNGTP_STR-VARIABILITYCODE sy-vline
WA_CPRODBUFLVLMNGTP_STR-VARIABILITYQUANTITY sy-vline
WA_CPRODBUFLVLMNGTP_STR-VARIABILITYDESCRIPTION sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROCUREMENTTYPE sy-vline
WA_CPRODBUFLVLMNGTP_STR-PROCUREMENTTYPEDESCRIPTION sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTPROFILECHANGECATEGORY sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTPROFILECHANGECATTXT sy-vline
WA_CPRODBUFLVLMNGTP_STR-BOMEXPLOSIONDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-BUFLVLPROPOSALHORIZONSTARTDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-HORIZONSTARTDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-HORIZONENDDATE sy-vline
WA_CPRODBUFLVLMNGTP_STR-ISPROPOSALADOPTED sy-vline
WA_CPRODBUFLVLMNGTP_STR-ISINPROCESS sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTAUTHORIZATIONGROUP sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTTYPEAUTHORIZATIONGROUP sy-vline
WA_CPRODBUFLVLMNGTP_STR-PRODUCTGROUPAUTHORIZATIONGROUP sy-vline
WA_CPRODBUFLVLMNGTP_STR-UXFCSTOCKLEVELPROPOSALSTATUS sy-vline
WA_CPRODBUFLVLMNGTP_STR-UXFCPROPOSALMODE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.