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

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_/1FE/0CSAP0IT.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /1FE/0CSAP0IT
  INTO TABLE IT_/1FE/0CSAP0IT.

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/1FE/0CSAP0IT ASSIGNING </1FE/0CSAP0IT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</1FE/0CSAP0IT>-MANDT = 1.
</1FE/0CSAP0IT>-SRCTATYPE = 1.
</1FE/0CSAP0IT>-SRCTAID = 1.
</1FE/0CSAP0IT>-BITPACKUUID = 1.
</1FE/0CSAP0IT>-BITPACKCNO = 1.
ENDLOOP.

LOOP AT IT_/1FE/0CSAP0IT INTO WA_/1FE/0CSAP0IT.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/1FE/0CSAP0IT-SRCTASUBID, sy-vline,
WA_/1FE/0CSAP0IT-BITPACKNUM, sy-vline,
WA_/1FE/0CSAP0IT-BITCAT, sy-vline,
WA_/1FE/0CSAP0IT-BITSTATUS, sy-vline,
WA_/1FE/0CSAP0IT-SUBPROCESS, sy-vline,
WA_/1FE/0CSAP0IT-BITTYPE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/1FE/0CSAP0IT 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_/1FE/0CSAP0IT 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_/1FE/0CSAP0IT INTO WA_/1FE/0CSAP0IT. *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 ALPHA, internal->external for field SRCTAID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-SRCTAID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-SRCTAID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VKONT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-VKONT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-VKONT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field GPART CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-GPART IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-GPART.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VTREF CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-VTREF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-VTREF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BIT_QTY_UNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-BIT_QTY_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-BIT_QTY_UNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SEGMT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-SEGMT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-SEGMT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field GPART_PRIMARY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-GPART_PRIMARY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-GPART_PRIMARY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SRCTAID_CORR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-SRCTAID_CORR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-SRCTAID_CORR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SRCTAID_PRIMARY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-SRCTAID_PRIMARY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-SRCTAID_PRIMARY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VKONT_PRIMARY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-VKONT_PRIMARY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-VKONT_PRIMARY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VTREF_PRIMARY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/1FE/0CSAP0IT-VTREF_PRIMARY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/1FE/0CSAP0IT-VTREF_PRIMARY.
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_/1FE/0CSAP0IT_STR,
MANDT TYPE STRING,
SRCTATYPE TYPE STRING,
SRCTAID TYPE STRING,
BITPACKUUID TYPE STRING,
BITPACKCNO TYPE STRING,
SRCTASUBID TYPE STRING,
BITPACKNUM TYPE STRING,
BITCAT TYPE STRING,
BITSTATUS TYPE STRING,
SUBPROCESS TYPE STRING,
BITTYPE TYPE STRING,
PREPAID TYPE STRING,
XPRIMARY TYPE STRING,
RELTYPE_PRIMARY TYPE STRING,
CITCAT TYPE STRING,
APPLK TYPE STRING,
VKONT TYPE STRING,
VKONA TYPE STRING,
GPART TYPE STRING,
BPEXT TYPE STRING,
MDCAT TYPE STRING,
VTREF TYPE STRING,
VTPOS TYPE STRING,
SUBAP TYPE STRING,
BILL_BASEDATE TYPE STRING,
BILL_FIRST TYPE STRING,
BITDATE TYPE STRING,
BITTIME TYPE STRING,
BITDATE_FROM TYPE STRING,
BITDATE_TO TYPE STRING,
BITCRDATE TYPE STRING,
BITCRTIME TYPE STRING,
BITCRMODE TYPE STRING,
BITDATAPACKID TYPE STRING,
BIT_AMOUNT TYPE STRING,
BIT_CURR TYPE STRING,
BIT_QUANTITY TYPE STRING,
BIT_QTY_UNIT TYPE STRING,
KEYPP TYPE STRING,
EXCHIST TYPE STRING,
CHHIST TYPE STRING,
BITREVERSAL TYPE STRING,
BITREVERSED TYPE STRING,
SRCTA_CORRCAT TYPE STRING,
POSTREL TYPE STRING,
PRINTREL TYPE STRING,
NOT_BPREL TYPE STRING,
PRINT_SUBSTITUTE TYPE STRING,
SPART TYPE STRING,
BUKRS TYPE STRING,
GSBER TYPE STRING,
SEGMT TYPE STRING,
PRCTR TYPE STRING,
HVORG TYPE STRING,
TVORG TYPE STRING,
KOFIZ TYPE STRING,
SERVICE_TYPE TYPE STRING,
TAX_INCLUDED TYPE STRING,
TAX_DET_TYPE TYPE STRING,
TAX_DATE_TYPE TYPE STRING,
EXT_TAX_DATE TYPE STRING,
EXT_TAX_ID TYPE STRING,
ERMWSKZ TYPE STRING,
MWSKZ TYPE STRING,
STRKZ TYPE STRING,
TXJCD TYPE STRING,
XANZA TYPE STRING,
STAKZ TYPE STRING,
PYMET TYPE STRING,
BITREF32 TYPE STRING,
PY_GROUP TYPE STRING,
TAX_GROUP TYPE STRING,
TXT_GROUP TYPE STRING,
BILLAC_TYPE TYPE STRING,
EXTN_TYPE TYPE STRING,
SEPARATE_INV TYPE STRING,
SIMULATED TYPE STRING,
OFFSET_PROC TYPE STRING,
EXCREASON TYPE STRING,
ALLOWANCE TYPE STRING,
ALLOWANCE_ID TYPE STRING,
BILLREQRSN TYPE STRING,
BITPKCNO_PRIMARY TYPE STRING,
BITPKID_PRIMARY TYPE STRING,
BITTEXT50 TYPE STRING,
BITTIME_FROM TYPE STRING,
BITTIME_TO TYPE STRING,
CITID TYPE STRING,
CITIDTYPE TYPE STRING,
CONTRACTITEMID TYPE STRING,
CO_SUBTYPE TYPE STRING,
CO_TYPE TYPE STRING,
DISCKEY TYPE STRING,
DISCKEY_VERSNO TYPE STRING,
DISC_BASE_AMT TYPE STRING,
DISC_BASGR TYPE STRING,
DISC_BIT_NUMBER TYPE STRING,
DISC_CALC_REL TYPE STRING,
DISC_COND_REL TYPE STRING,
DISC_GRNUM TYPE STRING,
DISC_LEVEL TYPE STRING,
DISC_NUM TYPE STRING,
DITRSN TYPE STRING,
DITTYPE TYPE STRING,
ERMWSKZ_B2B TYPE STRING,
EXTN_ID TYPE STRING,
EXTN_SUBID TYPE STRING,
GPART_PRIMARY TYPE STRING,
MWSKZ_B2B TYPE STRING,
OFFSET_ACTION TYPE STRING,
OFFSET_CAT TYPE STRING,
OFFSET_GROUP TYPE STRING,
OFFSET_REFID TYPE STRING,
PA8120_POS_ID1 TYPE STRING,
PA8120_POS_ID2 TYPE STRING,
PA8120_POS_ID3 TYPE STRING,
PA8120_POS_ID4 TYPE STRING,
PA8121_POS_ID1 TYPE STRING,
PA8121_POS_ID2 TYPE STRING,
PA8121_POS_ID3 TYPE STRING,
PA8121_POS_ID4 TYPE STRING,
RAREL TYPE STRING,
RATINGDATE TYPE STRING,
RATINGID TYPE STRING,
SRCTAID_CORR TYPE STRING,
SRCTAID_PRIMARY TYPE STRING,
SRCTASUBID_CORR TYPE STRING,
SRCTATYPE_CORR TYPE STRING,
SRCTATY_PRIMARY TYPE STRING,
SUBAP_PRIMARY TYPE STRING,
TAX_COUNTRY TYPE STRING,
VKONT_PRIMARY TYPE STRING,
VTREF_PRIMARY TYPE STRING,END OF T_EKKO_STR. DATA: WA_/1FE/0CSAP0IT_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_/1FE/0CSAP0IT_STR-MANDT sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTATYPE sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTAID sy-vline
WA_/1FE/0CSAP0IT_STR-BITPACKUUID sy-vline
WA_/1FE/0CSAP0IT_STR-BITPACKCNO sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTASUBID sy-vline
WA_/1FE/0CSAP0IT_STR-BITPACKNUM sy-vline
WA_/1FE/0CSAP0IT_STR-BITCAT sy-vline
WA_/1FE/0CSAP0IT_STR-BITSTATUS sy-vline
WA_/1FE/0CSAP0IT_STR-SUBPROCESS sy-vline
WA_/1FE/0CSAP0IT_STR-BITTYPE sy-vline
WA_/1FE/0CSAP0IT_STR-PREPAID sy-vline
WA_/1FE/0CSAP0IT_STR-XPRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-RELTYPE_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-CITCAT sy-vline
WA_/1FE/0CSAP0IT_STR-APPLK sy-vline
WA_/1FE/0CSAP0IT_STR-VKONT sy-vline
WA_/1FE/0CSAP0IT_STR-VKONA sy-vline
WA_/1FE/0CSAP0IT_STR-GPART sy-vline
WA_/1FE/0CSAP0IT_STR-BPEXT sy-vline
WA_/1FE/0CSAP0IT_STR-MDCAT sy-vline
WA_/1FE/0CSAP0IT_STR-VTREF sy-vline
WA_/1FE/0CSAP0IT_STR-VTPOS sy-vline
WA_/1FE/0CSAP0IT_STR-SUBAP sy-vline
WA_/1FE/0CSAP0IT_STR-BILL_BASEDATE sy-vline
WA_/1FE/0CSAP0IT_STR-BILL_FIRST sy-vline
WA_/1FE/0CSAP0IT_STR-BITDATE sy-vline
WA_/1FE/0CSAP0IT_STR-BITTIME sy-vline
WA_/1FE/0CSAP0IT_STR-BITDATE_FROM sy-vline
WA_/1FE/0CSAP0IT_STR-BITDATE_TO sy-vline
WA_/1FE/0CSAP0IT_STR-BITCRDATE sy-vline
WA_/1FE/0CSAP0IT_STR-BITCRTIME sy-vline
WA_/1FE/0CSAP0IT_STR-BITCRMODE sy-vline
WA_/1FE/0CSAP0IT_STR-BITDATAPACKID sy-vline
WA_/1FE/0CSAP0IT_STR-BIT_AMOUNT sy-vline
WA_/1FE/0CSAP0IT_STR-BIT_CURR sy-vline
WA_/1FE/0CSAP0IT_STR-BIT_QUANTITY sy-vline
WA_/1FE/0CSAP0IT_STR-BIT_QTY_UNIT sy-vline
WA_/1FE/0CSAP0IT_STR-KEYPP sy-vline
WA_/1FE/0CSAP0IT_STR-EXCHIST sy-vline
WA_/1FE/0CSAP0IT_STR-CHHIST sy-vline
WA_/1FE/0CSAP0IT_STR-BITREVERSAL sy-vline
WA_/1FE/0CSAP0IT_STR-BITREVERSED sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTA_CORRCAT sy-vline
WA_/1FE/0CSAP0IT_STR-POSTREL sy-vline
WA_/1FE/0CSAP0IT_STR-PRINTREL sy-vline
WA_/1FE/0CSAP0IT_STR-NOT_BPREL sy-vline
WA_/1FE/0CSAP0IT_STR-PRINT_SUBSTITUTE sy-vline
WA_/1FE/0CSAP0IT_STR-SPART sy-vline
WA_/1FE/0CSAP0IT_STR-BUKRS sy-vline
WA_/1FE/0CSAP0IT_STR-GSBER sy-vline
WA_/1FE/0CSAP0IT_STR-SEGMT sy-vline
WA_/1FE/0CSAP0IT_STR-PRCTR sy-vline
WA_/1FE/0CSAP0IT_STR-HVORG sy-vline
WA_/1FE/0CSAP0IT_STR-TVORG sy-vline
WA_/1FE/0CSAP0IT_STR-KOFIZ sy-vline
WA_/1FE/0CSAP0IT_STR-SERVICE_TYPE sy-vline
WA_/1FE/0CSAP0IT_STR-TAX_INCLUDED sy-vline
WA_/1FE/0CSAP0IT_STR-TAX_DET_TYPE sy-vline
WA_/1FE/0CSAP0IT_STR-TAX_DATE_TYPE sy-vline
WA_/1FE/0CSAP0IT_STR-EXT_TAX_DATE sy-vline
WA_/1FE/0CSAP0IT_STR-EXT_TAX_ID sy-vline
WA_/1FE/0CSAP0IT_STR-ERMWSKZ sy-vline
WA_/1FE/0CSAP0IT_STR-MWSKZ sy-vline
WA_/1FE/0CSAP0IT_STR-STRKZ sy-vline
WA_/1FE/0CSAP0IT_STR-TXJCD sy-vline
WA_/1FE/0CSAP0IT_STR-XANZA sy-vline
WA_/1FE/0CSAP0IT_STR-STAKZ sy-vline
WA_/1FE/0CSAP0IT_STR-PYMET sy-vline
WA_/1FE/0CSAP0IT_STR-BITREF32 sy-vline
WA_/1FE/0CSAP0IT_STR-PY_GROUP sy-vline
WA_/1FE/0CSAP0IT_STR-TAX_GROUP sy-vline
WA_/1FE/0CSAP0IT_STR-TXT_GROUP sy-vline
WA_/1FE/0CSAP0IT_STR-BILLAC_TYPE sy-vline
WA_/1FE/0CSAP0IT_STR-EXTN_TYPE sy-vline
WA_/1FE/0CSAP0IT_STR-SEPARATE_INV sy-vline
WA_/1FE/0CSAP0IT_STR-SIMULATED sy-vline
WA_/1FE/0CSAP0IT_STR-OFFSET_PROC sy-vline
WA_/1FE/0CSAP0IT_STR-EXCREASON sy-vline
WA_/1FE/0CSAP0IT_STR-ALLOWANCE sy-vline
WA_/1FE/0CSAP0IT_STR-ALLOWANCE_ID sy-vline
WA_/1FE/0CSAP0IT_STR-BILLREQRSN sy-vline
WA_/1FE/0CSAP0IT_STR-BITPKCNO_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-BITPKID_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-BITTEXT50 sy-vline
WA_/1FE/0CSAP0IT_STR-BITTIME_FROM sy-vline
WA_/1FE/0CSAP0IT_STR-BITTIME_TO sy-vline
WA_/1FE/0CSAP0IT_STR-CITID sy-vline
WA_/1FE/0CSAP0IT_STR-CITIDTYPE sy-vline
WA_/1FE/0CSAP0IT_STR-CONTRACTITEMID sy-vline
WA_/1FE/0CSAP0IT_STR-CO_SUBTYPE sy-vline
WA_/1FE/0CSAP0IT_STR-CO_TYPE sy-vline
WA_/1FE/0CSAP0IT_STR-DISCKEY sy-vline
WA_/1FE/0CSAP0IT_STR-DISCKEY_VERSNO sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_BASE_AMT sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_BASGR sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_BIT_NUMBER sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_CALC_REL sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_COND_REL sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_GRNUM sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_LEVEL sy-vline
WA_/1FE/0CSAP0IT_STR-DISC_NUM sy-vline
WA_/1FE/0CSAP0IT_STR-DITRSN sy-vline
WA_/1FE/0CSAP0IT_STR-DITTYPE sy-vline
WA_/1FE/0CSAP0IT_STR-ERMWSKZ_B2B sy-vline
WA_/1FE/0CSAP0IT_STR-EXTN_ID sy-vline
WA_/1FE/0CSAP0IT_STR-EXTN_SUBID sy-vline
WA_/1FE/0CSAP0IT_STR-GPART_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-MWSKZ_B2B sy-vline
WA_/1FE/0CSAP0IT_STR-OFFSET_ACTION sy-vline
WA_/1FE/0CSAP0IT_STR-OFFSET_CAT sy-vline
WA_/1FE/0CSAP0IT_STR-OFFSET_GROUP sy-vline
WA_/1FE/0CSAP0IT_STR-OFFSET_REFID sy-vline
WA_/1FE/0CSAP0IT_STR-PA8120_POS_ID1 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8120_POS_ID2 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8120_POS_ID3 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8120_POS_ID4 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8121_POS_ID1 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8121_POS_ID2 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8121_POS_ID3 sy-vline
WA_/1FE/0CSAP0IT_STR-PA8121_POS_ID4 sy-vline
WA_/1FE/0CSAP0IT_STR-RAREL sy-vline
WA_/1FE/0CSAP0IT_STR-RATINGDATE sy-vline
WA_/1FE/0CSAP0IT_STR-RATINGID sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTAID_CORR sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTAID_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTASUBID_CORR sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTATYPE_CORR sy-vline
WA_/1FE/0CSAP0IT_STR-SRCTATY_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-SUBAP_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-TAX_COUNTRY sy-vline
WA_/1FE/0CSAP0IT_STR-VKONT_PRIMARY sy-vline
WA_/1FE/0CSAP0IT_STR-VTREF_PRIMARY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.