ABAP Select data from SAP table FAAT_DCTR_YRAMT 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 FAAT_DCTR_YRAMT 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 FAAT_DCTR_YRAMT. 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 FAAT_DCTR_YRAMT 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_FAAT_DCTR_YRAMT TYPE STANDARD TABLE OF FAAT_DCTR_YRAMT,
WA_FAAT_DCTR_YRAMT TYPE FAAT_DCTR_YRAMT,
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: <FAAT_DCTR_YRAMT> TYPE FAAT_DCTR_YRAMT.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_FAAT_DCTR_YRAMT.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM FAAT_DCTR_YRAMT
INTO TABLE IT_FAAT_DCTR_YRAMT.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM FAAT_DCTR_YRAMT
* INTO TABLE @DATA(IT_FAAT_DCTR_YRAMT2).
*--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_FAAT_DCTR_YRAMT INDEX 1 INTO DATA(WA_FAAT_DCTR_YRAMT2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FAAT_DCTR_YRAMT ASSIGNING <FAAT_DCTR_YRAMT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<FAAT_DCTR_YRAMT>-CLIENT = 1.
<FAAT_DCTR_YRAMT>-COMP_CODE = 1.
<FAAT_DCTR_YRAMT>-ASSET_NO = 1.
<FAAT_DCTR_YRAMT>-ASSET_SUBNO = 1.
<FAAT_DCTR_YRAMT>-DEPR_AREA = 1.
ENDLOOP. LOOP AT IT_FAAT_DCTR_YRAMT INTO WA_FAAT_DCTR_YRAMT. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_FAAT_DCTR_YRAMT-FISC_YEAR, sy-vline,
WA_FAAT_DCTR_YRAMT-CURR_TYPE, sy-vline,
WA_FAAT_DCTR_YRAMT-CURRENCY, sy-vline,
WA_FAAT_DCTR_YRAMT-CUM_APC, sy-vline,
WA_FAAT_DCTR_YRAMT-CUM_REVL, sy-vline,
WA_FAAT_DCTR_YRAMT-CUM_INVS, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FAAT_DCTR_YRAMT 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_FAAT_DCTR_YRAMT 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_FAAT_DCTR_YRAMT INTO WA_FAAT_DCTR_YRAMT. *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 ASSET_NO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-ASSET_NO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-ASSET_NO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field ASSET_SUBNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-ASSET_SUBNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-ASSET_SUBNO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_APC CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_APC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_REVL CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_REVL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_INVS CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_INVS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_DEPR_S.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_DEPR_U CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_DEPR_U.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_RESV CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_RESV.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_INTR CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_INTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_REVL_D CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_REVL_D.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUM_DOWNP CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUM_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUM_DOWNP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_APC CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_APC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_REVL CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_REVL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_INVS CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_INVS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_DEPR_S.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_DEPR_U CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_DEPR_U.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_RESV CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_RESV.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_INTR CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_INTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_REVL_D CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_REVL_D.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field CUR_DOWNP CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-CUR_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-CUR_DOWNP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_APC CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_APC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_REVL CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_REVL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_INVS CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_INVS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_DEPR_S.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_DEPR_U CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_DEPR_U.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_RESV CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_RESV.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_INTR CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_INTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_REVL_D CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_REVL_D.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_PREV_DOWNP CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_PREV_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_PREV_DOWNP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_CUR_REVL CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_CUR_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_CUR_REVL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_CUR_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_CUR_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_CUR_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_CUR_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_CUR_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_CUR_DEPR_S.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_CUR_DEPR_U CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_CUR_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_CUR_DEPR_U.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_CUR_INTR CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_CUR_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_CUR_INTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_CUR_REVL_D CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_CUR_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_CUR_REVL_D.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_APC CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_APC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_REVL CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_REVL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_INVS CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_INVS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_DEPR_S.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_DEPR_U CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_DEPR_U.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_RESV CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_RESV.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_INTR CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_INTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_REVL_D CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_REVL_D.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field TOTAL_DOWNP CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-TOTAL_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-TOTAL_DOWNP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_APC CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_APC.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_REVL CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_REVL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_INVS CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_INVS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_DEPR_S.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_DEPR_U CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_DEPR_U.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_RESV CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_RESV.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_INTR CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_INTR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_REVL_D CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_REVL_D.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field PREV_DOWNP CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-PREV_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-PREV_DOWNP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field SHORTENED_DEPR_O CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-SHORTENED_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-SHORTENED_DEPR_O.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AU162, internal->external for field SHORTENED_DEPR_S CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAAT_DCTR_YRAMT-SHORTENED_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAAT_DCTR_YRAMT-SHORTENED_DEPR_S.
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_FAAT_DCTR_YRAMT_STR,
CLIENT TYPE STRING,
COMP_CODE TYPE STRING,
ASSET_NO TYPE STRING,
ASSET_SUBNO TYPE STRING,
DEPR_AREA TYPE STRING,
FISC_YEAR TYPE STRING,
CURR_TYPE TYPE STRING,
CURRENCY TYPE STRING,
CUM_APC TYPE STRING,
CUM_REVL TYPE STRING,
CUM_INVS TYPE STRING,
CUM_DEPR_O TYPE STRING,
CUM_DEPR_S TYPE STRING,
CUM_DEPR_U TYPE STRING,
CUM_RESV TYPE STRING,
CUM_INTR TYPE STRING,
CUM_REVL_D TYPE STRING,
CUM_DOWNP TYPE STRING,
CUR_APC TYPE STRING,
CUR_REVL TYPE STRING,
CUR_INVS TYPE STRING,
CUR_DEPR_O TYPE STRING,
CUR_DEPR_S TYPE STRING,
CUR_DEPR_U TYPE STRING,
CUR_RESV TYPE STRING,
CUR_INTR TYPE STRING,
CUR_REVL_D TYPE STRING,
CUR_DOWNP TYPE STRING,
PREV_PREV_APC TYPE STRING,
PREV_PREV_REVL TYPE STRING,
PREV_PREV_INVS TYPE STRING,
PREV_PREV_DEPR_O TYPE STRING,
PREV_PREV_DEPR_S TYPE STRING,
PREV_PREV_DEPR_U TYPE STRING,
PREV_PREV_RESV TYPE STRING,
PREV_PREV_INTR TYPE STRING,
PREV_PREV_REVL_D TYPE STRING,
PREV_PREV_DOWNP TYPE STRING,
PREV_CUR_REVL TYPE STRING,
PREV_CUR_DEPR_O TYPE STRING,
PREV_CUR_DEPR_S TYPE STRING,
PREV_CUR_DEPR_U TYPE STRING,
PREV_CUR_INTR TYPE STRING,
PREV_CUR_REVL_D TYPE STRING,
TOTAL_APC TYPE STRING,
TOTAL_REVL TYPE STRING,
TOTAL_INVS TYPE STRING,
TOTAL_DEPR_O TYPE STRING,
TOTAL_DEPR_S TYPE STRING,
TOTAL_DEPR_U TYPE STRING,
TOTAL_RESV TYPE STRING,
TOTAL_INTR TYPE STRING,
TOTAL_REVL_D TYPE STRING,
TOTAL_DOWNP TYPE STRING,
PREV_APC TYPE STRING,
PREV_REVL TYPE STRING,
PREV_INVS TYPE STRING,
PREV_DEPR_O TYPE STRING,
PREV_DEPR_S TYPE STRING,
PREV_DEPR_U TYPE STRING,
PREV_RESV TYPE STRING,
PREV_INTR TYPE STRING,
PREV_REVL_D TYPE STRING,
PREV_DOWNP TYPE STRING,
SHORTENED_DEPR_O TYPE STRING,
SHORTENED_DEPR_S TYPE STRING,END OF T_EKKO_STR. DATA: WA_FAAT_DCTR_YRAMT_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_FAAT_DCTR_YRAMT_STR-CLIENT sy-vline
WA_FAAT_DCTR_YRAMT_STR-COMP_CODE sy-vline
WA_FAAT_DCTR_YRAMT_STR-ASSET_NO sy-vline
WA_FAAT_DCTR_YRAMT_STR-ASSET_SUBNO sy-vline
WA_FAAT_DCTR_YRAMT_STR-DEPR_AREA sy-vline
WA_FAAT_DCTR_YRAMT_STR-FISC_YEAR sy-vline
WA_FAAT_DCTR_YRAMT_STR-CURR_TYPE sy-vline
WA_FAAT_DCTR_YRAMT_STR-CURRENCY sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_APC sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_REVL sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_INVS sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_DEPR_S sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_DEPR_U sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_RESV sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_INTR sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_REVL_D sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUM_DOWNP sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_APC sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_REVL sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_INVS sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_DEPR_S sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_DEPR_U sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_RESV sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_INTR sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_REVL_D sy-vline
WA_FAAT_DCTR_YRAMT_STR-CUR_DOWNP sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_APC sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_REVL sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_INVS sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_DEPR_S sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_DEPR_U sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_RESV sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_INTR sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_REVL_D sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_PREV_DOWNP sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_CUR_REVL sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_CUR_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_CUR_DEPR_S sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_CUR_DEPR_U sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_CUR_INTR sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_CUR_REVL_D sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_APC sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_REVL sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_INVS sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_DEPR_S sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_DEPR_U sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_RESV sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_INTR sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_REVL_D sy-vline
WA_FAAT_DCTR_YRAMT_STR-TOTAL_DOWNP sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_APC sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_REVL sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_INVS sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_DEPR_S sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_DEPR_U sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_RESV sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_INTR sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_REVL_D sy-vline
WA_FAAT_DCTR_YRAMT_STR-PREV_DOWNP sy-vline
WA_FAAT_DCTR_YRAMT_STR-SHORTENED_DEPR_O sy-vline
WA_FAAT_DCTR_YRAMT_STR-SHORTENED_DEPR_S sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
