ABAP Select data from SAP table FAA_DC_S_TRACE_YEAR_AMOUNTS 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 FAA_DC_S_TRACE_YEAR_AMOUNTS 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 FAA_DC_S_TRACE_YEAR_AMOUNTS. 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 FAA_DC_S_TRACE_YEAR_AMOUNTS 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_FAA_DC_S_TRACE_YEAR_AMOUNTS TYPE STANDARD TABLE OF FAA_DC_S_TRACE_YEAR_AMOUNTS,
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS TYPE FAA_DC_S_TRACE_YEAR_AMOUNTS,
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: <FAA_DC_S_TRACE_YEAR_AMOUNTS> TYPE FAA_DC_S_TRACE_YEAR_AMOUNTS.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_FAA_DC_S_TRACE_YEAR_AMOUNTS.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM FAA_DC_S_TRACE_YEAR_AMOUNTS
INTO TABLE IT_FAA_DC_S_TRACE_YEAR_AMOUNTS.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM FAA_DC_S_TRACE_YEAR_AMOUNTS
* INTO TABLE @DATA(IT_FAA_DC_S_TRACE_YEAR_AMOUNTS2).
*--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_FAA_DC_S_TRACE_YEAR_AMOUNTS INDEX 1 INTO DATA(WA_FAA_DC_S_TRACE_YEAR_AMOUNTS2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FAA_DC_S_TRACE_YEAR_AMOUNTS ASSIGNING <FAA_DC_S_TRACE_YEAR_AMOUNTS>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<FAA_DC_S_TRACE_YEAR_AMOUNTS>-FYEAR = 1.
<FAA_DC_S_TRACE_YEAR_AMOUNTS>-AREA = 1.
<FAA_DC_S_TRACE_YEAR_AMOUNTS>-CURRENCY = 1.
<FAA_DC_S_TRACE_YEAR_AMOUNTS>-CUM_APC = 1.
<FAA_DC_S_TRACE_YEAR_AMOUNTS>-CUM_REVL = 1.
ENDLOOP. LOOP AT IT_FAA_DC_S_TRACE_YEAR_AMOUNTS INTO WA_FAA_DC_S_TRACE_YEAR_AMOUNTS. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_INVS, sy-vline,
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DEPR_O, sy-vline,
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DEPR_S, sy-vline,
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DEPR_U, sy-vline,
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_RESV, sy-vline,
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_INTR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FAA_DC_S_TRACE_YEAR_AMOUNTS 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_FAA_DC_S_TRACE_YEAR_AMOUNTS 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_FAA_DC_S_TRACE_YEAR_AMOUNTS INTO WA_FAA_DC_S_TRACE_YEAR_AMOUNTS. *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 AU162, internal->external for field CUM_APC CALL FUNCTION 'CONVERSION_EXIT_AU162_OUTPUT' EXPORTING input = WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUM_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-CUR_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_PREV_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_CUR_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_CUR_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_CUR_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_CUR_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_CUR_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_CUR_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-TOTAL_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_APC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_REVL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_INVS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_DEPR_U IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_RESV IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_INTR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_REVL_D IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-PREV_DOWNP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-SHORTENED_DEPR_O IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS-SHORTENED_DEPR_S IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_DC_S_TRACE_YEAR_AMOUNTS-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_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR,
FYEAR TYPE STRING,
AREA 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_FAA_DC_S_TRACE_YEAR_AMOUNTS_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_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-FYEAR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-AREA sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CURRENCY sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_APC sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_REVL sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_INVS sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_DEPR_S sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_DEPR_U sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_RESV sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_INTR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_REVL_D sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUM_DOWNP sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_APC sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_REVL sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_INVS sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_DEPR_S sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_DEPR_U sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_RESV sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_INTR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_REVL_D sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-CUR_DOWNP sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_APC sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_REVL sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_INVS sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_DEPR_S sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_DEPR_U sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_RESV sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_INTR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_REVL_D sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_PREV_DOWNP sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_CUR_REVL sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_CUR_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_CUR_DEPR_S sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_CUR_DEPR_U sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_CUR_INTR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_CUR_REVL_D sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_APC sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_REVL sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_INVS sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_DEPR_S sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_DEPR_U sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_RESV sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_INTR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_REVL_D sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-TOTAL_DOWNP sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_APC sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_REVL sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_INVS sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_DEPR_S sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_DEPR_U sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_RESV sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_INTR sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_REVL_D sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-PREV_DOWNP sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_STR-SHORTENED_DEPR_O sy-vline
WA_FAA_DC_S_TRACE_YEAR_AMOUNTS_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.