ABAP Select data from SAP table /PRA/CI_CHK_LINEITEMS 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 /PRA/CI_CHK_LINEITEMS 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 /PRA/CI_CHK_LINEITEMS. 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 /PRA/CI_CHK_LINEITEMS 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_/PRA/CI_CHK_LINEITEMS TYPE STANDARD TABLE OF /PRA/CI_CHK_LINEITEMS,
WA_/PRA/CI_CHK_LINEITEMS TYPE /PRA/CI_CHK_LINEITEMS,
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: </PRA/CI_CHK_LINEITEMS> TYPE /PRA/CI_CHK_LINEITEMS.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/PRA/CI_CHK_LINEITEMS.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /PRA/CI_CHK_LINEITEMS
INTO TABLE IT_/PRA/CI_CHK_LINEITEMS.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /PRA/CI_CHK_LINEITEMS
* INTO TABLE @DATA(IT_/PRA/CI_CHK_LINEITEMS2).
*--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_/PRA/CI_CHK_LINEITEMS INDEX 1 INTO DATA(WA_/PRA/CI_CHK_LINEITEMS2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/PRA/CI_CHK_LINEITEMS ASSIGNING </PRA/CI_CHK_LINEITEMS>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</PRA/CI_CHK_LINEITEMS>-LINE_NUMBER = 1.
</PRA/CI_CHK_LINEITEMS>-GROUP_NUMBER = 1.
</PRA/CI_CHK_LINEITEMS>-LINE_STATUS = 1.
</PRA/CI_CHK_LINEITEMS>-CALC_PRICE = 1.
</PRA/CI_CHK_LINEITEMS>-SUSP_NOTE = 1.
ENDLOOP. LOOP AT IT_/PRA/CI_CHK_LINEITEMS INTO WA_/PRA/CI_CHK_LINEITEMS. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/PRA/CI_CHK_LINEITEMS-EDIT_CODE, sy-vline,
WA_/PRA/CI_CHK_LINEITEMS-REMITTER_PROP, sy-vline,
WA_/PRA/CI_CHK_LINEITEMS-REMITTER_PROD, sy-vline,
WA_/PRA/CI_CHK_LINEITEMS-NET_AMOUNT, sy-vline,
WA_/PRA/CI_CHK_LINEITEMS-SALES_MONTH, sy-vline,
WA_/PRA/CI_CHK_LINEITEMS-SALES_DT_FROM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/PRA/CI_CHK_LINEITEMS 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_/PRA/CI_CHK_LINEITEMS 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_/PRA/CI_CHK_LINEITEMS INTO WA_/PRA/CI_CHK_LINEITEMS. *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 PERI, internal->external for field SALES_MONTH CALL FUNCTION 'CONVERSION_EXIT_PERI_OUTPUT' EXPORTING input = WA_/PRA/CI_CHK_LINEITEMS-SALES_MONTH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/PRA/CI_CHK_LINEITEMS-SALES_MONTH.
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_/PRA/CI_CHK_LINEITEMS_STR,
LINE_NUMBER TYPE STRING,
GROUP_NUMBER TYPE STRING,
LINE_STATUS TYPE STRING,
CALC_PRICE TYPE STRING,
SUSP_NOTE TYPE STRING,
EDIT_CODE TYPE STRING,
REMITTER_PROP TYPE STRING,
REMITTER_PROD TYPE STRING,
NET_AMOUNT TYPE STRING,
SALES_MONTH TYPE STRING,
SALES_DT_FROM TYPE STRING,
SALES_DT_TO TYPE STRING,
CONTRACT_NO TYPE STRING,
DED_INC_TYP1 TYPE STRING,
DED_INC_AMT1 TYPE STRING,
UNCLAS_MKTG_AMT TYPE STRING,
UNCLAS_MKTG_RMB TYPE STRING,
COMPRESSION_DED TYPE STRING,
DEHYDRATION_DED TYPE STRING,
PROCESSING_DED TYPE STRING,
TREATING_DED TYPE STRING,
TRANSP_GATH_DED TYPE STRING,
INVENT_STOR_DED TYPE STRING,
FUEL_DED TYPE STRING,
METERING_FEE TYPE STRING,
MULTIPLE_FEE TYPE STRING,
OTH_MKTG_DED TYPE STRING,
COMPRESSION_RMB TYPE STRING,
DEHYDRATION_RMB TYPE STRING,
PROCESSING_RMB TYPE STRING,
TREATING_RMB TYPE STRING,
TRANSP_GATH_RMB TYPE STRING,
INVENT_STOR_RMB TYPE STRING,
FUEL_RMB TYPE STRING,
METERING_FEE_RMB TYPE STRING,
MULTIPLE_FEE_RMB TYPE STRING,
OTH_MKTG_RMB TYPE STRING,
DED_INC_TYP2 TYPE STRING,
DED_INC_AMT2 TYPE STRING,
UNCLAS_TAX_AMT TYPE STRING,
UNCLAS_TAX_RMB TYPE STRING,
TAX_AMT_1 TYPE STRING,
TAX_AMT_2 TYPE STRING,
TAX_AMT_3 TYPE STRING,
TAX_AMT_4 TYPE STRING,
TAX_AMT_5 TYPE STRING,
TAX_AMT_6 TYPE STRING,
TAX_AMT_7 TYPE STRING,
TAX_AMT_8 TYPE STRING,
TAX_AMT_9 TYPE STRING,
DEC_INT_TYPE TYPE STRING,
RUN_MTR_TKT_NO TYPE STRING,
TAX_RMB_1 TYPE STRING,
TAX_RMB_2 TYPE STRING,
TAX_RMB_3 TYPE STRING,
TAX_RMB_4 TYPE STRING,
TAX_RMB_5 TYPE STRING,
TAX_RMB_6 TYPE STRING,
TAX_RMB_7 TYPE STRING,
TAX_RMB_8 TYPE STRING,
TAX_RMB_9 TYPE STRING,
CALC_DECIMAL TYPE STRING,
INTEREST_TYPE TYPE STRING,
GROSS_VOLUME TYPE STRING,
BTU_FACTOR TYPE STRING,
GRAVITY TYPE STRING,
LEASE_GR_VALUE TYPE STRING,
OWNER_GR_VOLUME TYPE STRING,
OWNER_GR_VALUE TYPE STRING,
NET_COMPRES_DED TYPE STRING,
NET_DEHYD_DED TYPE STRING,
NET_PROCS_DED TYPE STRING,
NET_TREATING_DED TYPE STRING,
NET_TRN_GATH_DED TYPE STRING,
NET_INV_STOR_DED TYPE STRING,
NET_FUEL_DED TYPE STRING,
NET_METERING_FEE TYPE STRING,
NET_MULTIPLE_FEE TYPE STRING,
NET_OTH_MKTG_DED TYPE STRING,
NET_COMPRES_RMB TYPE STRING,
NET_DEHYD_RMB TYPE STRING,
NET_PROCS_RMB TYPE STRING,
NET_TREATING_RMB TYPE STRING,
NET_TRN_GATH_RMB TYPE STRING,
NET_INV_STOR_RMB TYPE STRING,
NET_FUEL_RMB TYPE STRING,
NET_MTRNGFEE_RMB TYPE STRING,
NET_MULTPFEE_RMB TYPE STRING,
NET_OTH_MKTG_RMB TYPE STRING,
NET_TAX_AMT1 TYPE STRING,
NET_TAX_AMT2 TYPE STRING,
NET_TAX_AMT3 TYPE STRING,
NET_TAX_AMT4 TYPE STRING,
NET_TAX_AMT5 TYPE STRING,
NET_TAX_AMT6 TYPE STRING,
NET_TAX_AMT7 TYPE STRING,
NET_TAX_AMT8 TYPE STRING,
NET_TAX_AMT9 TYPE STRING,
NET_TAX_AMT_UNCL TYPE STRING,
NET_TAXRMB_AMT1 TYPE STRING,
NET_TAXRMB_AMT2 TYPE STRING,
NET_TAXRMB_AMT3 TYPE STRING,
NET_TAXRMB_AMT4 TYPE STRING,
NET_TAXRMB_AMT5 TYPE STRING,
NET_TAXRMB_AMT6 TYPE STRING,
NET_TAXRMB_AMT7 TYPE STRING,
NET_TAXRMB_AMT8 TYPE STRING,
NET_TAXRMB_AMT9 TYPE STRING,
NET_TAXRMB_UNCL TYPE STRING,
STATE_PRESR_BASE TYPE STRING,
CONTR_PRESR_BASE TYPE STRING,
SALES_PRICE TYPE STRING,
DED_INC_TYP3 TYPE STRING,
DED_INC_AMT3 TYPE STRING,
DED_INC_TYP4 TYPE STRING,
DED_INC_AMT4 TYPE STRING,
RCVBL_DECIMAL TYPE STRING,
OWNER_DECIMAL TYPE STRING,
OWNER_CONTR_DECM TYPE STRING,
MMBTU_VOLUME TYPE STRING,
MISC_DEDUCT_1 TYPE STRING,
MISC_DEDUCT_2 TYPE STRING,
MISC_DEDUCT_3 TYPE STRING,
MISC_DEDUCT_4 TYPE STRING,
MISC_DEDUCT_5 TYPE STRING,
MISC_DEDUCT_6 TYPE STRING,
MISC_DEDUCT_7 TYPE STRING,
MISC_DEDUCT_8 TYPE STRING,
MISC_DEDUCT_9 TYPE STRING,
MISC_DEDUCT_10 TYPE STRING,
MISC_INCOME_1 TYPE STRING,
MISC_INCOME_2 TYPE STRING,
MISC_INCOME_3 TYPE STRING,
MISC_INCOME_4 TYPE STRING,
MISC_INCOME_5 TYPE STRING,
MISC_INCOME_6 TYPE STRING,
MISC_INCOME_7 TYPE STRING,
MISC_INCOME_8 TYPE STRING,
MISC_INCOME_9 TYPE STRING,
MISC_INCOME_10 TYPE STRING,
LEASE_NET_VALUE TYPE STRING,
WP_TAX TYPE STRING,
NET_WP_TAX TYPE STRING,
TAX_WITHHOLDING TYPE STRING,
NET_BEFOR_WP_TAX TYPE STRING,
NET_AFTER_TAX TYPE STRING,
PPA_REASON TYPE STRING,
TRANS_CODE_1 TYPE STRING,
XCHK_NO TYPE STRING,
XLINE_NO TYPE STRING,
XOPR TYPE STRING,
GUI1 TYPE STRING,
GUI2 TYPE STRING,END OF T_EKKO_STR. DATA: WA_/PRA/CI_CHK_LINEITEMS_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_/PRA/CI_CHK_LINEITEMS_STR-LINE_NUMBER sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-GROUP_NUMBER sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-LINE_STATUS sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-CALC_PRICE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-SUSP_NOTE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-EDIT_CODE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-REMITTER_PROP sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-REMITTER_PROD sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_AMOUNT sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-SALES_MONTH sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-SALES_DT_FROM sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-SALES_DT_TO sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-CONTRACT_NO sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_TYP1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_AMT1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-UNCLAS_MKTG_AMT sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-UNCLAS_MKTG_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-COMPRESSION_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DEHYDRATION_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-PROCESSING_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TREATING_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TRANSP_GATH_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-INVENT_STOR_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-FUEL_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-METERING_FEE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MULTIPLE_FEE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-OTH_MKTG_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-COMPRESSION_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DEHYDRATION_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-PROCESSING_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TREATING_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TRANSP_GATH_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-INVENT_STOR_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-FUEL_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-METERING_FEE_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MULTIPLE_FEE_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-OTH_MKTG_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_TYP2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_AMT2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-UNCLAS_TAX_AMT sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-UNCLAS_TAX_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_5 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_6 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_7 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_8 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_AMT_9 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DEC_INT_TYPE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-RUN_MTR_TKT_NO sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_5 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_6 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_7 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_8 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_RMB_9 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-CALC_DECIMAL sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-INTEREST_TYPE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-GROSS_VOLUME sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-BTU_FACTOR sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-GRAVITY sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-LEASE_GR_VALUE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-OWNER_GR_VOLUME sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-OWNER_GR_VALUE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_COMPRES_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_DEHYD_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_PROCS_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TREATING_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TRN_GATH_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_INV_STOR_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_FUEL_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_METERING_FEE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_MULTIPLE_FEE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_OTH_MKTG_DED sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_COMPRES_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_DEHYD_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_PROCS_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TREATING_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TRN_GATH_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_INV_STOR_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_FUEL_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_MTRNGFEE_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_MULTPFEE_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_OTH_MKTG_RMB sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT5 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT6 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT7 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT8 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT9 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAX_AMT_UNCL sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT5 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT6 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT7 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT8 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_AMT9 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_TAXRMB_UNCL sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-STATE_PRESR_BASE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-CONTR_PRESR_BASE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-SALES_PRICE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_TYP3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_AMT3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_TYP4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-DED_INC_AMT4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-RCVBL_DECIMAL sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-OWNER_DECIMAL sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-OWNER_CONTR_DECM sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MMBTU_VOLUME sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_5 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_6 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_7 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_8 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_9 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_DEDUCT_10 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_2 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_3 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_4 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_5 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_6 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_7 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_8 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_9 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-MISC_INCOME_10 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-LEASE_NET_VALUE sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-WP_TAX sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_WP_TAX sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TAX_WITHHOLDING sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_BEFOR_WP_TAX sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-NET_AFTER_TAX sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-PPA_REASON sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-TRANS_CODE_1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-XCHK_NO sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-XLINE_NO sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-XOPR sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-GUI1 sy-vline
WA_/PRA/CI_CHK_LINEITEMS_STR-GUI2 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
