ABAP Select data from SAP table REIS_CN_L 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 REIS_CN_L 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 REIS_CN_L. 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 REIS_CN_L 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_REIS_CN_L TYPE STANDARD TABLE OF REIS_CN_L,
      WA_REIS_CN_L TYPE REIS_CN_L,
      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: <REIS_CN_L> TYPE REIS_CN_L.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM REIS_CN_L
*  INTO TABLE @DATA(IT_REIS_CN_L2).
*--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_REIS_CN_L INDEX 1 INTO DATA(WA_REIS_CN_L2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_REIS_CN_L ASSIGNING <REIS_CN_L>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<REIS_CN_L>-MANDT = 1.
<REIS_CN_L>-INTRENO = 1.
<REIS_CN_L>-BUKRS = 1.
<REIS_CN_L>-RECNNR = 1.
<REIS_CN_L>-OBJNR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_REIS_CN_L-IMKEY, sy-vline,
WA_REIS_CN_L-CREATIONTYPE, sy-vline,
WA_REIS_CN_L-RERF, sy-vline,
WA_REIS_CN_L-DERF, sy-vline,
WA_REIS_CN_L-TERF, sy-vline,
WA_REIS_CN_L-REHER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_REIS_CN_L 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_REIS_CN_L 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_REIS_CN_L INTO WA_REIS_CN_L. *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 RECNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_CN_L-RECNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-RECNNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit IMKEY, internal->external for field IMKEY CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT' EXPORTING input = WA_REIS_CN_L-IMKEY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-IMKEY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field RECNENDABS CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-RECNENDABS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-RECNENDABS.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit SWENR, internal->external for field BENOCN CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT' EXPORTING input = WA_REIS_CN_L-BENOCN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-BENOCN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field TRANSPOSSTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-TRANSPOSSTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-TRANSPOSSTO.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ABPSP, internal->external for field PSPNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_REIS_CN_L-PSPNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-PSPNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit FMCIL, internal->external for field COMMITMENTITEM CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT' EXPORTING input = WA_REIS_CN_L-COMMITMENTITEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-COMMITMENTITEM.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit SXIDN, internal->external for field SMTP_ADDR_BP1 CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT' EXPORTING input = WA_REIS_CN_L-SMTP_ADDR_BP1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-SMTP_ADDR_BP1.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit SXIDN, internal->external for field SMTP_ADDR_BP2 CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT' EXPORTING input = WA_REIS_CN_L-SMTP_ADDR_BP2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-SMTP_ADDR_BP2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN01 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN01 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN01.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN02 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN02 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN02.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN03 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN03 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN03.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN04 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN04 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN04.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN05 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN05 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN05.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN06 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN06 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN06.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN07 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN07 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN07.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CONDVALIDTO_CN08 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-CONDVALIDTO_CN08 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-CONDVALIDTO_CN08.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO01 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-MEASVALIDTO01 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-MEASVALIDTO01.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO02 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-MEASVALIDTO02 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-MEASVALIDTO02.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO03 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-MEASVALIDTO03 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-MEASVALIDTO03.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO04 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-MEASVALIDTO04 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-MEASVALIDTO04.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field MEASVALIDTO05 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-MEASVALIDTO05 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-MEASVALIDTO05.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit REDAT, internal->external for field RNENDMAX CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_CN_L-RNENDMAX IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_L-RNENDMAX.
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_REIS_CN_L_STR,
MANDT TYPE STRING,
INTRENO TYPE STRING,
BUKRS TYPE STRING,
RECNNR TYPE STRING,
OBJNR TYPE STRING,
IMKEY TYPE STRING,
CREATIONTYPE TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
RESPONSIBLE TYPE STRING,
USEREXCLUSIVE TYPE STRING,
AUTHGRP TYPE STRING,
RECNTYPE TYPE STRING,
RECNBEG TYPE STRING,
RECNENDABS TYPE STRING,
RECNTXT TYPE STRING,
RECNDACTIV TYPE STRING,
RECNTLAW TYPE STRING,
RECNTXTOLD TYPE STRING,
RECNBUKRSCOLLECT TYPE STRING,
RECNNRCOLLECT TYPE STRING,
RECNCNCURR TYPE STRING,
INDUSTRY TYPE STRING,
SRRELEVANT TYPE STRING,
DPTARGETTYPE TYPE STRING,
RECNDAT TYPE STRING,
RECN2DAT TYPE STRING,
RECNDPO TYPE STRING,
RECNEND1ST TYPE STRING,
RECNNOTPER TYPE STRING,
RECNNOTRECEIPT TYPE STRING,
RECNNOTREASON TYPE STRING,
RECNDAKTKU TYPE STRING,
CFARCHIVEDTO TYPE STRING,
CFLOCKEDTO TYPE STRING,
CFPOSTINGFROM TYPE STRING,
BENOCN TYPE STRING,
TRANSPOSSFROM TYPE STRING,
TRANSPOSSTO TYPE STRING,
HASMULTIASSIGN TYPE STRING,
POSSDATEFROM TYPE STRING,
POSSDATETO TYPE STRING,
RELEVANTEVAL TYPE STRING,
DUMMY_REC_PS TYPE STRING,
SECDEPRELEVANT TYPE STRING,
NOTADJSDCN TYPE STRING,
XRECNNRCOL TYPE STRING,
XBUKRS TYPE STRING,
XRECNTYPE TYPE STRING,
GSBER TYPE STRING,
PRCTR TYPE STRING,
KOSTL TYPE STRING,
AUFNR TYPE STRING,
XTENANCYLAW TYPE STRING,
XCOLLECT TYPE STRING,
XAUTHGRP TYPE STRING,
XINDUSTRY TYPE STRING,
XTRANSPOSSPERIOD TYPE STRING,
PSPNR TYPE STRING,
XRELEVANTEVAL TYPE STRING,
KOSTLX TYPE STRING,
AUFNRX TYPE STRING,
PSPNRX TYPE STRING,
FUND TYPE STRING,
FUNDSCENTER TYPE STRING,
COMMITMENTITEM TYPE STRING,
FUNCTIONALAREA TYPE STRING,
GRANTNUMBER TYPE STRING,
MEASURE TYPE STRING,
BUDGETPERIOD TYPE STRING,
NTTYPE TYPE STRING,
XNTTYPE TYPE STRING,
NTPROC TYPE STRING,
XNTPROC TYPE STRING,
XTERMNT TYPE STRING,
ROLE_BP1 TYPE STRING,
XROLE_BP1 TYPE STRING,
PARTNER_BP1 TYPE STRING,
XPARTNER_BP1 TYPE STRING,
TEL_NUMBER_LONG_BP1 TYPE STRING,
FAX_NUMBER_LONG_BP1 TYPE STRING,
SMTP_ADDR_BP1 TYPE STRING,
XNAME_BP1 TYPE STRING,
STREET_BP1 TYPE STRING,
HOUSE_NUM1_BP1 TYPE STRING,
POST_CODE1_BP1 TYPE STRING,
CITY1_BP1 TYPE STRING,
CITY2_BP1 TYPE STRING,
REGION_BP1 TYPE STRING,
PO_BOX_BP1 TYPE STRING,
POST_CODE2_BP1 TYPE STRING,
ROLECAT_BP1 TYPE STRING,
ADDRTYPE_BP1 TYPE STRING,
HOUSE_NUM2_BP1 TYPE STRING,
ROLE_BP2 TYPE STRING,
XROLE_BP2 TYPE STRING,
PARTNER_BP2 TYPE STRING,
XPARTNER_BP2 TYPE STRING,
TEL_NUMBER_LONG_BP2 TYPE STRING,
FAX_NUMBER_LONG_BP2 TYPE STRING,
SMTP_ADDR_BP2 TYPE STRING,
XNAME_BP2 TYPE STRING,
STREET_BP2 TYPE STRING,
HOUSE_NUM1_BP2 TYPE STRING,
POST_CODE1_BP2 TYPE STRING,
CITY1_BP2 TYPE STRING,
CITY2_BP2 TYPE STRING,
REGION_BP2 TYPE STRING,
PO_BOX_BP2 TYPE STRING,
POST_CODE2_BP2 TYPE STRING,
ROLECAT_BP2 TYPE STRING,
ADDRTYPE_BP2 TYPE STRING,
HOUSE_NUM2_BP2 TYPE STRING,
CONDVALUE_CN01 TYPE STRING,
CONDCURR_CN01 TYPE STRING,
FREQUENCY_CN01 TYPE STRING,
CONDVALIDFROM_CN01 TYPE STRING,
CONDVALIDTO_CN01 TYPE STRING,
UNITPRICE_CN01 TYPE STRING,
CONDVALUENET_CN01 TYPE STRING,
CONDVALUEGROSS_CN01 TYPE STRING,
CONDVALUE_CN02 TYPE STRING,
CONDCURR_CN02 TYPE STRING,
FREQUENCY_CN02 TYPE STRING,
CONDVALIDFROM_CN02 TYPE STRING,
CONDVALIDTO_CN02 TYPE STRING,
UNITPRICE_CN02 TYPE STRING,
CONDVALUENET_CN02 TYPE STRING,
CONDVALUEGROSS_CN02 TYPE STRING,
CONDVALUE_CN03 TYPE STRING,
CONDCURR_CN03 TYPE STRING,
FREQUENCY_CN03 TYPE STRING,
CONDVALIDFROM_CN03 TYPE STRING,
CONDVALIDTO_CN03 TYPE STRING,
UNITPRICE_CN03 TYPE STRING,
CONDVALUENET_CN03 TYPE STRING,
CONDVALUEGROSS_CN03 TYPE STRING,
CONDVALUE_CN04 TYPE STRING,
CONDCURR_CN04 TYPE STRING,
FREQUENCY_CN04 TYPE STRING,
CONDVALIDFROM_CN04 TYPE STRING,
CONDVALIDTO_CN04 TYPE STRING,
UNITPRICE_CN04 TYPE STRING,
CONDVALUENET_CN04 TYPE STRING,
CONDVALUEGROSS_CN04 TYPE STRING,
CONDVALUE_CN05 TYPE STRING,
CONDCURR_CN05 TYPE STRING,
FREQUENCY_CN05 TYPE STRING,
CONDVALIDFROM_CN05 TYPE STRING,
CONDVALIDTO_CN05 TYPE STRING,
UNITPRICE_CN05 TYPE STRING,
CONDVALUENET_CN05 TYPE STRING,
CONDVALUEGROSS_CN05 TYPE STRING,
CONDVALUE_CN06 TYPE STRING,
CONDCURR_CN06 TYPE STRING,
FREQUENCY_CN06 TYPE STRING,
CONDVALIDFROM_CN06 TYPE STRING,
CONDVALIDTO_CN06 TYPE STRING,
UNITPRICE_CN06 TYPE STRING,
CONDVALUENET_CN06 TYPE STRING,
CONDVALUEGROSS_CN06 TYPE STRING,
CONDVALUE_CN07 TYPE STRING,
CONDCURR_CN07 TYPE STRING,
FREQUENCY_CN07 TYPE STRING,
CONDVALIDFROM_CN07 TYPE STRING,
CONDVALIDTO_CN07 TYPE STRING,
UNITPRICE_CN07 TYPE STRING,
CONDVALUENET_CN07 TYPE STRING,
CONDVALUEGROSS_CN07 TYPE STRING,
CONDVALUE_CN08 TYPE STRING,
CONDCURR_CN08 TYPE STRING,
FREQUENCY_CN08 TYPE STRING,
CONDVALIDFROM_CN08 TYPE STRING,
CONDVALIDTO_CN08 TYPE STRING,
UNITPRICE_CN08 TYPE STRING,
CONDVALUENET_CN08 TYPE STRING,
CONDVALUEGROSS_CN08 TYPE STRING,
CONDVALUEFURTHER_CN TYPE STRING,
TAXVALUE_CN TYPE STRING,
CDCNISVALIDFROM TYPE STRING,
CDCNISVALIDTO TYPE STRING,
MEASVALUE01 TYPE STRING,
MEASVALUECMPL01 TYPE STRING,
MEASUNIT01 TYPE STRING,
MEASVALIDFROM01 TYPE STRING,
MEASVALIDTO01 TYPE STRING,
MEASVALUE02 TYPE STRING,
MEASVALUECMPL02 TYPE STRING,
MEASUNIT02 TYPE STRING,
MEASVALIDFROM02 TYPE STRING,
MEASVALIDTO02 TYPE STRING,
MEASVALUE03 TYPE STRING,
MEASVALUECMPL03 TYPE STRING,
MEASUNIT03 TYPE STRING,
MEASVALIDFROM03 TYPE STRING,
MEASVALIDTO03 TYPE STRING,
MEASVALUE04 TYPE STRING,
MEASVALUECMPL04 TYPE STRING,
MEASUNIT04 TYPE STRING,
MEASVALIDFROM04 TYPE STRING,
MEASVALIDTO04 TYPE STRING,
MEASVALUE05 TYPE STRING,
MEASVALUECMPL05 TYPE STRING,
MEASUNIT05 TYPE STRING,
MEASVALIDFROM05 TYPE STRING,
MEASVALIDTO05 TYPE STRING,
MEASISVALIDFROM TYPE STRING,
MEASISVALIDTO TYPE STRING,
RECISVALIDFROM TYPE STRING,
RECISVALIDTO TYPE STRING,
GEN_OBJTYPE TYPE STRING,
GEN_OBJNR TYPE STRING,
GEN_CONTRACT TYPE STRING,
GEN_PARTNER1 TYPE STRING,
GEN_PARTNER2 TYPE STRING,
ALVROWS TYPE STRING,
XNTREASON TYPE STRING,
RECNTERMMONTHS TYPE STRING,
PESTATE TYPE STRING,
XPESTATE TYPE STRING,
RNEND1ST TYPE STRING,
RNENDMAX TYPE STRING,
RNENDNEW TYPE STRING,
NTPER TYPE STRING,END OF T_EKKO_STR. DATA: WA_REIS_CN_L_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_REIS_CN_L_STR-MANDT sy-vline
WA_REIS_CN_L_STR-INTRENO sy-vline
WA_REIS_CN_L_STR-BUKRS sy-vline
WA_REIS_CN_L_STR-RECNNR sy-vline
WA_REIS_CN_L_STR-OBJNR sy-vline
WA_REIS_CN_L_STR-IMKEY sy-vline
WA_REIS_CN_L_STR-CREATIONTYPE sy-vline
WA_REIS_CN_L_STR-RERF sy-vline
WA_REIS_CN_L_STR-DERF sy-vline
WA_REIS_CN_L_STR-TERF sy-vline
WA_REIS_CN_L_STR-REHER sy-vline
WA_REIS_CN_L_STR-RBEAR sy-vline
WA_REIS_CN_L_STR-DBEAR sy-vline
WA_REIS_CN_L_STR-TBEAR sy-vline
WA_REIS_CN_L_STR-RBHER sy-vline
WA_REIS_CN_L_STR-RESPONSIBLE sy-vline
WA_REIS_CN_L_STR-USEREXCLUSIVE sy-vline
WA_REIS_CN_L_STR-AUTHGRP sy-vline
WA_REIS_CN_L_STR-RECNTYPE sy-vline
WA_REIS_CN_L_STR-RECNBEG sy-vline
WA_REIS_CN_L_STR-RECNENDABS sy-vline
WA_REIS_CN_L_STR-RECNTXT sy-vline
WA_REIS_CN_L_STR-RECNDACTIV sy-vline
WA_REIS_CN_L_STR-RECNTLAW sy-vline
WA_REIS_CN_L_STR-RECNTXTOLD sy-vline
WA_REIS_CN_L_STR-RECNBUKRSCOLLECT sy-vline
WA_REIS_CN_L_STR-RECNNRCOLLECT sy-vline
WA_REIS_CN_L_STR-RECNCNCURR sy-vline
WA_REIS_CN_L_STR-INDUSTRY sy-vline
WA_REIS_CN_L_STR-SRRELEVANT sy-vline
WA_REIS_CN_L_STR-DPTARGETTYPE sy-vline
WA_REIS_CN_L_STR-RECNDAT sy-vline
WA_REIS_CN_L_STR-RECN2DAT sy-vline
WA_REIS_CN_L_STR-RECNDPO sy-vline
WA_REIS_CN_L_STR-RECNEND1ST sy-vline
WA_REIS_CN_L_STR-RECNNOTPER sy-vline
WA_REIS_CN_L_STR-RECNNOTRECEIPT sy-vline
WA_REIS_CN_L_STR-RECNNOTREASON sy-vline
WA_REIS_CN_L_STR-RECNDAKTKU sy-vline
WA_REIS_CN_L_STR-CFARCHIVEDTO sy-vline
WA_REIS_CN_L_STR-CFLOCKEDTO sy-vline
WA_REIS_CN_L_STR-CFPOSTINGFROM sy-vline
WA_REIS_CN_L_STR-BENOCN sy-vline
WA_REIS_CN_L_STR-TRANSPOSSFROM sy-vline
WA_REIS_CN_L_STR-TRANSPOSSTO sy-vline
WA_REIS_CN_L_STR-HASMULTIASSIGN sy-vline
WA_REIS_CN_L_STR-POSSDATEFROM sy-vline
WA_REIS_CN_L_STR-POSSDATETO sy-vline
WA_REIS_CN_L_STR-RELEVANTEVAL sy-vline
WA_REIS_CN_L_STR-DUMMY_REC_PS sy-vline
WA_REIS_CN_L_STR-SECDEPRELEVANT sy-vline
WA_REIS_CN_L_STR-NOTADJSDCN sy-vline
WA_REIS_CN_L_STR-XRECNNRCOL sy-vline
WA_REIS_CN_L_STR-XBUKRS sy-vline
WA_REIS_CN_L_STR-XRECNTYPE sy-vline
WA_REIS_CN_L_STR-GSBER sy-vline
WA_REIS_CN_L_STR-PRCTR sy-vline
WA_REIS_CN_L_STR-KOSTL sy-vline
WA_REIS_CN_L_STR-AUFNR sy-vline
WA_REIS_CN_L_STR-XTENANCYLAW sy-vline
WA_REIS_CN_L_STR-XCOLLECT sy-vline
WA_REIS_CN_L_STR-XAUTHGRP sy-vline
WA_REIS_CN_L_STR-XINDUSTRY sy-vline
WA_REIS_CN_L_STR-XTRANSPOSSPERIOD sy-vline
WA_REIS_CN_L_STR-PSPNR sy-vline
WA_REIS_CN_L_STR-XRELEVANTEVAL sy-vline
WA_REIS_CN_L_STR-KOSTLX sy-vline
WA_REIS_CN_L_STR-AUFNRX sy-vline
WA_REIS_CN_L_STR-PSPNRX sy-vline
WA_REIS_CN_L_STR-FUND sy-vline
WA_REIS_CN_L_STR-FUNDSCENTER sy-vline
WA_REIS_CN_L_STR-COMMITMENTITEM sy-vline
WA_REIS_CN_L_STR-FUNCTIONALAREA sy-vline
WA_REIS_CN_L_STR-GRANTNUMBER sy-vline
WA_REIS_CN_L_STR-MEASURE sy-vline
WA_REIS_CN_L_STR-BUDGETPERIOD sy-vline
WA_REIS_CN_L_STR-NTTYPE sy-vline
WA_REIS_CN_L_STR-XNTTYPE sy-vline
WA_REIS_CN_L_STR-NTPROC sy-vline
WA_REIS_CN_L_STR-XNTPROC sy-vline
WA_REIS_CN_L_STR-XTERMNT sy-vline
WA_REIS_CN_L_STR-ROLE_BP1 sy-vline
WA_REIS_CN_L_STR-XROLE_BP1 sy-vline
WA_REIS_CN_L_STR-PARTNER_BP1 sy-vline
WA_REIS_CN_L_STR-XPARTNER_BP1 sy-vline
WA_REIS_CN_L_STR-TEL_NUMBER_LONG_BP1 sy-vline
WA_REIS_CN_L_STR-FAX_NUMBER_LONG_BP1 sy-vline
WA_REIS_CN_L_STR-SMTP_ADDR_BP1 sy-vline
WA_REIS_CN_L_STR-XNAME_BP1 sy-vline
WA_REIS_CN_L_STR-STREET_BP1 sy-vline
WA_REIS_CN_L_STR-HOUSE_NUM1_BP1 sy-vline
WA_REIS_CN_L_STR-POST_CODE1_BP1 sy-vline
WA_REIS_CN_L_STR-CITY1_BP1 sy-vline
WA_REIS_CN_L_STR-CITY2_BP1 sy-vline
WA_REIS_CN_L_STR-REGION_BP1 sy-vline
WA_REIS_CN_L_STR-PO_BOX_BP1 sy-vline
WA_REIS_CN_L_STR-POST_CODE2_BP1 sy-vline
WA_REIS_CN_L_STR-ROLECAT_BP1 sy-vline
WA_REIS_CN_L_STR-ADDRTYPE_BP1 sy-vline
WA_REIS_CN_L_STR-HOUSE_NUM2_BP1 sy-vline
WA_REIS_CN_L_STR-ROLE_BP2 sy-vline
WA_REIS_CN_L_STR-XROLE_BP2 sy-vline
WA_REIS_CN_L_STR-PARTNER_BP2 sy-vline
WA_REIS_CN_L_STR-XPARTNER_BP2 sy-vline
WA_REIS_CN_L_STR-TEL_NUMBER_LONG_BP2 sy-vline
WA_REIS_CN_L_STR-FAX_NUMBER_LONG_BP2 sy-vline
WA_REIS_CN_L_STR-SMTP_ADDR_BP2 sy-vline
WA_REIS_CN_L_STR-XNAME_BP2 sy-vline
WA_REIS_CN_L_STR-STREET_BP2 sy-vline
WA_REIS_CN_L_STR-HOUSE_NUM1_BP2 sy-vline
WA_REIS_CN_L_STR-POST_CODE1_BP2 sy-vline
WA_REIS_CN_L_STR-CITY1_BP2 sy-vline
WA_REIS_CN_L_STR-CITY2_BP2 sy-vline
WA_REIS_CN_L_STR-REGION_BP2 sy-vline
WA_REIS_CN_L_STR-PO_BOX_BP2 sy-vline
WA_REIS_CN_L_STR-POST_CODE2_BP2 sy-vline
WA_REIS_CN_L_STR-ROLECAT_BP2 sy-vline
WA_REIS_CN_L_STR-ADDRTYPE_BP2 sy-vline
WA_REIS_CN_L_STR-HOUSE_NUM2_BP2 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN01 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN01 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN01 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN01 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN01 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN01 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN01 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN01 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN02 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN02 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN02 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN02 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN02 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN02 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN02 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN02 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN03 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN03 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN03 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN03 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN03 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN03 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN03 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN03 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN04 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN04 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN04 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN04 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN04 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN04 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN04 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN04 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN05 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN05 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN05 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN05 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN05 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN05 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN05 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN05 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN06 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN06 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN06 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN06 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN06 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN06 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN06 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN06 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN07 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN07 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN07 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN07 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN07 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN07 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN07 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN07 sy-vline
WA_REIS_CN_L_STR-CONDVALUE_CN08 sy-vline
WA_REIS_CN_L_STR-CONDCURR_CN08 sy-vline
WA_REIS_CN_L_STR-FREQUENCY_CN08 sy-vline
WA_REIS_CN_L_STR-CONDVALIDFROM_CN08 sy-vline
WA_REIS_CN_L_STR-CONDVALIDTO_CN08 sy-vline
WA_REIS_CN_L_STR-UNITPRICE_CN08 sy-vline
WA_REIS_CN_L_STR-CONDVALUENET_CN08 sy-vline
WA_REIS_CN_L_STR-CONDVALUEGROSS_CN08 sy-vline
WA_REIS_CN_L_STR-CONDVALUEFURTHER_CN sy-vline
WA_REIS_CN_L_STR-TAXVALUE_CN sy-vline
WA_REIS_CN_L_STR-CDCNISVALIDFROM sy-vline
WA_REIS_CN_L_STR-CDCNISVALIDTO sy-vline
WA_REIS_CN_L_STR-MEASVALUE01 sy-vline
WA_REIS_CN_L_STR-MEASVALUECMPL01 sy-vline
WA_REIS_CN_L_STR-MEASUNIT01 sy-vline
WA_REIS_CN_L_STR-MEASVALIDFROM01 sy-vline
WA_REIS_CN_L_STR-MEASVALIDTO01 sy-vline
WA_REIS_CN_L_STR-MEASVALUE02 sy-vline
WA_REIS_CN_L_STR-MEASVALUECMPL02 sy-vline
WA_REIS_CN_L_STR-MEASUNIT02 sy-vline
WA_REIS_CN_L_STR-MEASVALIDFROM02 sy-vline
WA_REIS_CN_L_STR-MEASVALIDTO02 sy-vline
WA_REIS_CN_L_STR-MEASVALUE03 sy-vline
WA_REIS_CN_L_STR-MEASVALUECMPL03 sy-vline
WA_REIS_CN_L_STR-MEASUNIT03 sy-vline
WA_REIS_CN_L_STR-MEASVALIDFROM03 sy-vline
WA_REIS_CN_L_STR-MEASVALIDTO03 sy-vline
WA_REIS_CN_L_STR-MEASVALUE04 sy-vline
WA_REIS_CN_L_STR-MEASVALUECMPL04 sy-vline
WA_REIS_CN_L_STR-MEASUNIT04 sy-vline
WA_REIS_CN_L_STR-MEASVALIDFROM04 sy-vline
WA_REIS_CN_L_STR-MEASVALIDTO04 sy-vline
WA_REIS_CN_L_STR-MEASVALUE05 sy-vline
WA_REIS_CN_L_STR-MEASVALUECMPL05 sy-vline
WA_REIS_CN_L_STR-MEASUNIT05 sy-vline
WA_REIS_CN_L_STR-MEASVALIDFROM05 sy-vline
WA_REIS_CN_L_STR-MEASVALIDTO05 sy-vline
WA_REIS_CN_L_STR-MEASISVALIDFROM sy-vline
WA_REIS_CN_L_STR-MEASISVALIDTO sy-vline
WA_REIS_CN_L_STR-RECISVALIDFROM sy-vline
WA_REIS_CN_L_STR-RECISVALIDTO sy-vline
WA_REIS_CN_L_STR-GEN_OBJTYPE sy-vline
WA_REIS_CN_L_STR-GEN_OBJNR sy-vline
WA_REIS_CN_L_STR-GEN_CONTRACT sy-vline
WA_REIS_CN_L_STR-GEN_PARTNER1 sy-vline
WA_REIS_CN_L_STR-GEN_PARTNER2 sy-vline
WA_REIS_CN_L_STR-ALVROWS sy-vline
WA_REIS_CN_L_STR-XNTREASON sy-vline
WA_REIS_CN_L_STR-RECNTERMMONTHS sy-vline
WA_REIS_CN_L_STR-PESTATE sy-vline
WA_REIS_CN_L_STR-XPESTATE sy-vline
WA_REIS_CN_L_STR-RNEND1ST sy-vline
WA_REIS_CN_L_STR-RNENDMAX sy-vline
WA_REIS_CN_L_STR-RNENDNEW sy-vline
WA_REIS_CN_L_STR-NTPER sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.