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

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPAPO/RPT_OPRLIST_STR ASSIGNING </SAPAPO/RPT_OPRLIST_STR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPAPO/RPT_OPRLIST_STR>-MANDT = 1.
</SAPAPO/RPT_OPRLIST_STR>-ORDERID = 1.
</SAPAPO/RPT_OPRLIST_STR>-OPRCOUNTER = 1.
</SAPAPO/RPT_OPRLIST_STR>-OPRNR = 1.
</SAPAPO/RPT_OPRLIST_STR>-SUBOPRNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPAPO/RPT_OPRLIST_STR-OPRQUAN, sy-vline,
WA_/SAPAPO/RPT_OPRLIST_STR-OPRQUANU, sy-vline,
WA_/SAPAPO/RPT_OPRLIST_STR-ORIGINALQUAN, sy-vline,
WA_/SAPAPO/RPT_OPRLIST_STR-LAST_STEXT, sy-vline,
WA_/SAPAPO/RPT_OPRLIST_STR-STARTTI, sy-vline,
WA_/SAPAPO/RPT_OPRLIST_STR-ENDTI, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SAPAPO/RPT_OPRLIST_STR 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_/SAPAPO/RPT_OPRLIST_STR 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_/SAPAPO/RPT_OPRLIST_STR INTO WA_/SAPAPO/RPT_OPRLIST_STR. *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 CUNIT, internal->external for field OPRQUANU CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SAPAPO/RPT_OPRLIST_STR-OPRQUANU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/RPT_OPRLIST_STR-OPRQUANU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field IO_TIME CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_/SAPAPO/RPT_OPRLIST_STR-IO_TIME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/RPT_OPRLIST_STR-IO_TIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field IO_END_TIME CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_/SAPAPO/RPT_OPRLIST_STR-IO_END_TIME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/RPT_OPRLIST_STR-IO_END_TIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMSP, internal->external for field OPR_DURATION CALL FUNCTION 'CONVERSION_EXIT_TIMSP_OUTPUT' EXPORTING input = WA_/SAPAPO/RPT_OPRLIST_STR-OPR_DURATION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/RPT_OPRLIST_STR-OPR_DURATION.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TIMSP, internal->external for field OPR_DURATION_NET CALL FUNCTION 'CONVERSION_EXIT_TIMSP_OUTPUT' EXPORTING input = WA_/SAPAPO/RPT_OPRLIST_STR-OPR_DURATION_NET IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/RPT_OPRLIST_STR-OPR_DURATION_NET.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CUNIT, internal->external for field STOCK_UNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SAPAPO/RPT_OPRLIST_STR-STOCK_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/RPT_OPRLIST_STR-STOCK_UNIT.
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_/SAPAPO/RPT_OPRLIST_STR_STR,
MANDT TYPE STRING,
ORDERID TYPE STRING,
OPRCOUNTER TYPE STRING,
OPRNR TYPE STRING,
SUBOPRNR TYPE STRING,
OPRQUAN TYPE STRING,
OPRQUANU TYPE STRING,
ORIGINALQUAN TYPE STRING,
LAST_STEXT TYPE STRING,
STARTTI TYPE STRING,
ENDTI TYPE STRING,
ORDERNR TYPE STRING,
MASTER_IO TYPE STRING,
SUBORDERID TYPE STRING,
ACTID TYPE STRING,
PEGID TYPE STRING,
SUBLOC TYPE STRING,
VERSION TYPE STRING,
CATEGORY TYPE STRING,
CATEGORY_TYPE TYPE STRING,
CHARID TYPE STRING,
POSITION_NO TYPE STRING,
LINE_NO TYPE STRING,
IS_INPUT_NODE TYPE STRING,
PARENT_POS TYPE STRING,
QUANTITY TYPE STRING,
REAL_QUANTITY TYPE STRING,
ORIGINAL_QUANTITY TYPE STRING,
CONF_QUANTITY TYPE STRING,
IS_MASTER TYPE STRING,
IGNORE_PEGGING TYPE STRING,
PENALTY_GROUP TYPE STRING,
EXT_FIXED TYPE STRING,
BOMID TYPE STRING,
BOMID_TYPE TYPE STRING,
INC_FLAG TYPE STRING,
ADVCODE TYPE STRING,
PRIO_REQ TYPE STRING,
CUOBJ TYPE STRING,
CONTI_SCHEDULING TYPE STRING,
OFFSET_VALUE TYPE STRING,
UNPLAN_OFFSET_VALUE TYPE STRING,
HAS_UNPLAN_OFFSET TYPE STRING,
OFFSET_RELATION TYPE STRING,
OFFSET_IN_PERCENT TYPE STRING,
SCHEDULE_OFFSET TYPE STRING,
HAS_CHARACTS TYPE STRING,
SHLF_MIN TYPE STRING,
SHLF_MAX TYPE STRING,
USE_SHLF TYPE STRING,
ATP_MERGE_FLAG TYPE STRING,
IONODE_TYPE TYPE STRING,
ORDERID TYPE STRING,
IO_TIME TYPE STRING,
IO_END_TIME TYPE STRING,
NETCHG_FLAG TYPE STRING,
CHANGE_FLAG TYPE STRING,
HAS_DESC_CHARACTS TYPE STRING,
ATPCMPSTAT TYPE STRING,
RESERVED_INT4_1 TYPE STRING,
RESERVED_INT4_2 TYPE STRING,
RESERVED_BOOL_1 TYPE STRING,
RESERVED_BOOL_2 TYPE STRING,
AFS_CAT TYPE STRING,
UNPLANNED TYPE STRING,
RELEASED TYPE STRING,
DATE_FIXED TYPE STRING,
STARTED TYPE STRING,
PART_CONFIRMED TYPE STRING,
FINAL_CONFIRMED TYPE STRING,
INTERRUPTED TYPE STRING,
COMBINED_ORDER TYPE STRING,
D_START TYPE STRING,
T_START TYPE STRING,
D_END TYPE STRING,
T_END TYPE STRING,
PROD_D_START TYPE STRING,
PROD_T_START TYPE STRING,
ACT_TEXT TYPE STRING,
ACT_TEXT_HANDLE TYPE STRING,
SETUP_GROUP TYPE STRING,
SETUP_ITEM TYPE STRING,
SETUP_DURATION TYPE STRING,
OPR_DURATION TYPE STRING,
OPR_DURATION_NET TYPE STRING,
ALERTS TYPE STRING,
OVERLAP TYPE STRING,
INTERSECTION TYPE STRING,
LINETYPE TYPE STRING,
LINETYPE_TECH TYPE STRING,
LINETYPE_TEXT TYPE STRING,
PCMOBJNO TYPE STRING,
PCMTEXT TYPE STRING,
BLOCK_ID TYPE STRING,
PRIORITY TYPE STRING,
CATTEXT TYPE STRING,
MATID TYPE STRING,
MATNR TYPE STRING,
MAKTX TYPE STRING,
LOCNO TYPE STRING,
LOCTXT TYPE STRING,
RES_DOWNTIME_TYPE TYPE STRING,
ROWEXT TYPE STRING,
MAX_STOCK TYPE STRING,
SAFETY_STOCK TYPE STRING,
PROJ_STOCK TYPE STRING,
PROJ_ON_HAND_STK_STAT TYPE STRING,
REORDER_POINT TYPE STRING,
STOCK_UNIT TYPE STRING,
AVL_RQDAT TYPE STRING,
AVL_RQTIM TYPE STRING,
SCOPEDESC TYPE STRING,
SCOPEPRFLID TYPE STRING,
COLORS TYPE STRING,
DDTAB TYPE STRING,
STYLE TYPE STRING,
LINECOLOR TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SAPAPO/RPT_OPRLIST_STR_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_/SAPAPO/RPT_OPRLIST_STR_STR-MANDT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ORDERID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OPRCOUNTER sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OPRNR sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SUBOPRNR sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OPRQUAN sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OPRQUANU sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ORIGINALQUAN sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LAST_STEXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-STARTTI sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ENDTI sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ORDERNR sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-MASTER_IO sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SUBORDERID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ACTID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PEGID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SUBLOC sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-VERSION sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CATEGORY sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CATEGORY_TYPE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CHARID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-POSITION_NO sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LINE_NO sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-IS_INPUT_NODE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PARENT_POS sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-QUANTITY sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-REAL_QUANTITY sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ORIGINAL_QUANTITY sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CONF_QUANTITY sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-IS_MASTER sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-IGNORE_PEGGING sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PENALTY_GROUP sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-EXT_FIXED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-BOMID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-BOMID_TYPE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-INC_FLAG sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ADVCODE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PRIO_REQ sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CUOBJ sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CONTI_SCHEDULING sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OFFSET_VALUE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-UNPLAN_OFFSET_VALUE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-HAS_UNPLAN_OFFSET sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OFFSET_RELATION sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OFFSET_IN_PERCENT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SCHEDULE_OFFSET sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-HAS_CHARACTS sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SHLF_MIN sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SHLF_MAX sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-USE_SHLF sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ATP_MERGE_FLAG sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-IONODE_TYPE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ORDERID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-IO_TIME sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-IO_END_TIME sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-NETCHG_FLAG sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CHANGE_FLAG sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-HAS_DESC_CHARACTS sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ATPCMPSTAT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-RESERVED_INT4_1 sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-RESERVED_INT4_2 sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-RESERVED_BOOL_1 sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-RESERVED_BOOL_2 sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-AFS_CAT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-UNPLANNED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-RELEASED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-DATE_FIXED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-STARTED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PART_CONFIRMED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-FINAL_CONFIRMED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-INTERRUPTED sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-COMBINED_ORDER sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-D_START sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-T_START sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-D_END sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-T_END sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PROD_D_START sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PROD_T_START sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ACT_TEXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ACT_TEXT_HANDLE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SETUP_GROUP sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SETUP_ITEM sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SETUP_DURATION sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OPR_DURATION sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OPR_DURATION_NET sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ALERTS sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-OVERLAP sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-INTERSECTION sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LINETYPE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LINETYPE_TECH sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LINETYPE_TEXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PCMOBJNO sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PCMTEXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-BLOCK_ID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PRIORITY sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-CATTEXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-MATID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-MATNR sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-MAKTX sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LOCNO sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LOCTXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-RES_DOWNTIME_TYPE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-ROWEXT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-MAX_STOCK sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SAFETY_STOCK sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PROJ_STOCK sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-PROJ_ON_HAND_STK_STAT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-REORDER_POINT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-STOCK_UNIT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-AVL_RQDAT sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-AVL_RQTIM sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SCOPEDESC sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-SCOPEPRFLID sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-COLORS sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-DDTAB sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-STYLE sy-vline
WA_/SAPAPO/RPT_OPRLIST_STR_STR-LINECOLOR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.