ABAP Select data from SAP table FAGL_FC_DOCS 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 FAGL_FC_DOCS 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 FAGL_FC_DOCS. 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 FAGL_FC_DOCS 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_FAGL_FC_DOCS TYPE STANDARD TABLE OF FAGL_FC_DOCS,
      WA_FAGL_FC_DOCS TYPE FAGL_FC_DOCS,
      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: <FAGL_FC_DOCS> TYPE FAGL_FC_DOCS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FAGL_FC_DOCS
*  INTO TABLE @DATA(IT_FAGL_FC_DOCS2).
*--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_FAGL_FC_DOCS INDEX 1 INTO DATA(WA_FAGL_FC_DOCS2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FAGL_FC_DOCS ASSIGNING <FAGL_FC_DOCS>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FAGL_FC_DOCS>-TARGET_CCODE = 1.
<FAGL_FC_DOCS>-CCODE = 1.
<FAGL_FC_DOCS>-SORT_DUEGRID_DATE = 1.
<FAGL_FC_DOCS>-VALUATION_GROUP = 1.
<FAGL_FC_DOCS>-SORT_ACCOUNT_TYPE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FAGL_FC_DOCS-SORT_GL_ACCOUNT, sy-vline,
WA_FAGL_FC_DOCS-SORT_PARTNER, sy-vline,
WA_FAGL_FC_DOCS-SORT_ACCOUNT, sy-vline,
WA_FAGL_FC_DOCS-SORT_CURRENCY, sy-vline,
WA_FAGL_FC_DOCS-LEDGER_GROUP, sy-vline,
WA_FAGL_FC_DOCS-LEDGER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FAGL_FC_DOCS 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_FAGL_FC_DOCS 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_FAGL_FC_DOCS INTO WA_FAGL_FC_DOCS. *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 SORT_GL_ACCOUNT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-SORT_GL_ACCOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-SORT_GL_ACCOUNT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field JA CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-JA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-JA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field FISCAL_YEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-FISCAL_YEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-FISCAL_YEAR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AC172, internal->external for field SOURCE_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-SOURCE_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-SOURCE_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field TARGET_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-TARGET_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-TARGET_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field HEDGED_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-HEDGED_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-HEDGED_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field VALUATION_RATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALUATION_RATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALUATION_RATE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRX, internal->external for field VALUATION_MD_RATEX CALL FUNCTION 'CONVERSION_EXIT_EXCRX_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALUATION_MD_RATEX IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALUATION_MD_RATEX.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field HEDGED_RATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-HEDGED_RATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-HEDGED_RATE.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AC132, internal->external for field REAL_DIFF_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-REAL_DIFF_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-REAL_DIFF_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field REAL_DIFF_NEW CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-REAL_DIFF_NEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-REAL_DIFF_NEW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_NEW CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_NEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_NEW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field REAL_DIFF1_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-REAL_DIFF1_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-REAL_DIFF1_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field REAL_DIFF1_NEW CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-REAL_DIFF1_NEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-REAL_DIFF1_NEW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field VALU_DIFF1_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF1_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF1_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field VALU_DIFF1_NEW CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF1_NEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF1_NEW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM2 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM3 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM3 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM3.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM4 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM4 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM4.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM5 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM5 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM5.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM6 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM6 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM6.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM7 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM7 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM7.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM8 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM8 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM8.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM9 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM9 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM9.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM10 CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM10 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM10.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM2_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM2_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM2_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM3_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM3_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM3_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM4_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM4_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM4_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM5_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM5_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM5_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM6_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM6_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM6_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM7_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM7_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM7_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM8_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM8_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM8_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM9_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM9_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM9_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field VALU_DIFF_REM10_OLD CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF_REM10_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF_REM10_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field TC_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-TC_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-TC_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC1_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC1_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC1_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC2_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC2_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC2_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC3_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC3_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC3_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC4_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC4_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC4_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC5_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC5_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC5_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC6_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC6_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC6_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC7_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC7_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC7_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC8_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC8_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC8_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC9_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC9_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC9_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field LC10_AMOUNT CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-LC10_AMOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-LC10_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field VALU_DIFF2_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF2_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF2_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field VALU_DIFF2_NEW CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF2_NEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF2_NEW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field VALU_DIFF3_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF3_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF3_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field VALU_DIFF3_NEW CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-VALU_DIFF3_NEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-VALU_DIFF3_NEW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field REAL_DIFF2_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-REAL_DIFF2_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-REAL_DIFF2_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field REAL_DIFF3_OLD CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-REAL_DIFF3_OLD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-REAL_DIFF3_OLD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field HIST_RATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-HIST_RATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-HIST_RATE.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field SEGMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FAGL_FC_DOCS-SEGMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAGL_FC_DOCS-SEGMENT.
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_FAGL_FC_DOCS_STR,
TARGET_CCODE TYPE STRING,
CCODE TYPE STRING,
SORT_DUEGRID_DATE TYPE STRING,
VALUATION_GROUP TYPE STRING,
SORT_ACCOUNT_TYPE TYPE STRING,
SORT_GL_ACCOUNT TYPE STRING,
SORT_PARTNER TYPE STRING,
SORT_ACCOUNT TYPE STRING,
SORT_CURRENCY TYPE STRING,
LEDGER_GROUP TYPE STRING,
LEDGER TYPE STRING,
ACCOUNT_TYPE TYPE STRING,
CURRENCY TYPE STRING,
GL_ACCOUNT TYPE STRING,
PARTNER TYPE STRING,
ACCOUNT TYPE STRING,
GROUPING_REFERENCE TYPE STRING,
NR TYPE STRING,
JA TYPE STRING,
BUZ TYPE STRING,
FISCAL_YEAR TYPE STRING,
DOC_NUMBER TYPE STRING,
DOC_LINE TYPE STRING,
DEBCRED_IND TYPE STRING,
SOURCE_AMOUNT TYPE STRING,
TARGET_AMOUNT TYPE STRING,
HEDGED_AMOUNT TYPE STRING,
VALUATION_RATE TYPE STRING,
VALUATION_MD_RATEX TYPE STRING,
VALU_XUSE_MD_FXR TYPE STRING,
ORIG_XUSE_MD_FXR TYPE STRING,
ERTYPE TYPE STRING,
VALU_RATE_TYPE TYPE STRING,
HEDGED_RATE TYPE STRING,
SPECIAL_GL_IND TYPE STRING,
DOC_TYPE TYPE STRING,
POSTING_DATE TYPE STRING,
DOCUMENT_DATE TYPE STRING,
GRIR_ITEM TYPE STRING,
CLEARING_DOCUMENT TYPE STRING,
CLEARING_DATE TYPE STRING,
REAL_DIFF_OLD TYPE STRING,
REAL_DIFF_NEW TYPE STRING,
VALU_DIFF_OLD TYPE STRING,
VALU_DIFF_NEW TYPE STRING,
REAL_DIFF1_OLD TYPE STRING,
REAL_DIFF1_NEW TYPE STRING,
VALU_DIFF1_OLD TYPE STRING,
VALU_DIFF1_NEW TYPE STRING,
ORIG_TA_CURR TYPE STRING,
XRESET_VAL TYPE STRING,
VALU_DIFF_REM2 TYPE STRING,
VALU_DIFF_REM3 TYPE STRING,
VALU_DIFF_REM4 TYPE STRING,
VALU_DIFF_REM5 TYPE STRING,
VALU_DIFF_REM6 TYPE STRING,
VALU_DIFF_REM7 TYPE STRING,
VALU_DIFF_REM8 TYPE STRING,
VALU_DIFF_REM9 TYPE STRING,
VALU_DIFF_REM10 TYPE STRING,
VALU_DIFF_REM2_OLD TYPE STRING,
VALU_DIFF_REM3_OLD TYPE STRING,
VALU_DIFF_REM4_OLD TYPE STRING,
VALU_DIFF_REM5_OLD TYPE STRING,
VALU_DIFF_REM6_OLD TYPE STRING,
VALU_DIFF_REM7_OLD TYPE STRING,
VALU_DIFF_REM8_OLD TYPE STRING,
VALU_DIFF_REM9_OLD TYPE STRING,
VALU_DIFF_REM10_OLD TYPE STRING,
TARGET_LC_FIELDNR TYPE STRING,
TARGET_LC_CURTP TYPE STRING,
TARGET_CURRENCY TYPE STRING,
TC_AMOUNT TYPE STRING,
LC1_AMOUNT TYPE STRING,
LC2_AMOUNT TYPE STRING,
LC3_AMOUNT TYPE STRING,
LC4_AMOUNT TYPE STRING,
LC5_AMOUNT TYPE STRING,
LC6_AMOUNT TYPE STRING,
LC7_AMOUNT TYPE STRING,
LC8_AMOUNT TYPE STRING,
LC9_AMOUNT TYPE STRING,
LC10_AMOUNT TYPE STRING,
VALU_DIFF2_OLD TYPE STRING,
VALU_DIFF2_NEW TYPE STRING,
VALU_DIFF3_OLD TYPE STRING,
VALU_DIFF3_NEW TYPE STRING,
REAL_DIFF2_OLD TYPE STRING,
REAL_DIFF3_OLD TYPE STRING,
HIST_RATE TYPE STRING,
HIST_RATE_TEXT TYPE STRING,
DUEGRID_DATE TYPE STRING,
NETDUE_DATE TYPE STRING,
TARGET_PLTYPE TYPE STRING,
XRESET_WITH_REV TYPE STRING,
XLGCLR TYPE STRING,
LGOI_LDGRP TYPE STRING,
LGOI_BSTAT TYPE STRING,
LGOI_LDGRP_VALPOST TYPE STRING,
ACCASTY TYPE STRING,
ACCAS TYPE STRING,
PPRCTR TYPE STRING,
PRCTR TYPE STRING,
PSEGMENT TYPE STRING,
RBUSA TYPE STRING,
SBUSA TYPE STRING,
SEGMENT TYPE STRING,
VALOBJTYPE TYPE STRING,
VALOBJ_ID TYPE STRING,
VALSOBJ_ID TYPE STRING,END OF T_EKKO_STR. DATA: WA_FAGL_FC_DOCS_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_FAGL_FC_DOCS_STR-TARGET_CCODE sy-vline
WA_FAGL_FC_DOCS_STR-CCODE sy-vline
WA_FAGL_FC_DOCS_STR-SORT_DUEGRID_DATE sy-vline
WA_FAGL_FC_DOCS_STR-VALUATION_GROUP sy-vline
WA_FAGL_FC_DOCS_STR-SORT_ACCOUNT_TYPE sy-vline
WA_FAGL_FC_DOCS_STR-SORT_GL_ACCOUNT sy-vline
WA_FAGL_FC_DOCS_STR-SORT_PARTNER sy-vline
WA_FAGL_FC_DOCS_STR-SORT_ACCOUNT sy-vline
WA_FAGL_FC_DOCS_STR-SORT_CURRENCY sy-vline
WA_FAGL_FC_DOCS_STR-LEDGER_GROUP sy-vline
WA_FAGL_FC_DOCS_STR-LEDGER sy-vline
WA_FAGL_FC_DOCS_STR-ACCOUNT_TYPE sy-vline
WA_FAGL_FC_DOCS_STR-CURRENCY sy-vline
WA_FAGL_FC_DOCS_STR-GL_ACCOUNT sy-vline
WA_FAGL_FC_DOCS_STR-PARTNER sy-vline
WA_FAGL_FC_DOCS_STR-ACCOUNT sy-vline
WA_FAGL_FC_DOCS_STR-GROUPING_REFERENCE sy-vline
WA_FAGL_FC_DOCS_STR-NR sy-vline
WA_FAGL_FC_DOCS_STR-JA sy-vline
WA_FAGL_FC_DOCS_STR-BUZ sy-vline
WA_FAGL_FC_DOCS_STR-FISCAL_YEAR sy-vline
WA_FAGL_FC_DOCS_STR-DOC_NUMBER sy-vline
WA_FAGL_FC_DOCS_STR-DOC_LINE sy-vline
WA_FAGL_FC_DOCS_STR-DEBCRED_IND sy-vline
WA_FAGL_FC_DOCS_STR-SOURCE_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-TARGET_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-HEDGED_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-VALUATION_RATE sy-vline
WA_FAGL_FC_DOCS_STR-VALUATION_MD_RATEX sy-vline
WA_FAGL_FC_DOCS_STR-VALU_XUSE_MD_FXR sy-vline
WA_FAGL_FC_DOCS_STR-ORIG_XUSE_MD_FXR sy-vline
WA_FAGL_FC_DOCS_STR-ERTYPE sy-vline
WA_FAGL_FC_DOCS_STR-VALU_RATE_TYPE sy-vline
WA_FAGL_FC_DOCS_STR-HEDGED_RATE sy-vline
WA_FAGL_FC_DOCS_STR-SPECIAL_GL_IND sy-vline
WA_FAGL_FC_DOCS_STR-DOC_TYPE sy-vline
WA_FAGL_FC_DOCS_STR-POSTING_DATE sy-vline
WA_FAGL_FC_DOCS_STR-DOCUMENT_DATE sy-vline
WA_FAGL_FC_DOCS_STR-GRIR_ITEM sy-vline
WA_FAGL_FC_DOCS_STR-CLEARING_DOCUMENT sy-vline
WA_FAGL_FC_DOCS_STR-CLEARING_DATE sy-vline
WA_FAGL_FC_DOCS_STR-REAL_DIFF_OLD sy-vline
WA_FAGL_FC_DOCS_STR-REAL_DIFF_NEW sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_NEW sy-vline
WA_FAGL_FC_DOCS_STR-REAL_DIFF1_OLD sy-vline
WA_FAGL_FC_DOCS_STR-REAL_DIFF1_NEW sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF1_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF1_NEW sy-vline
WA_FAGL_FC_DOCS_STR-ORIG_TA_CURR sy-vline
WA_FAGL_FC_DOCS_STR-XRESET_VAL sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM2 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM3 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM4 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM5 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM6 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM7 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM8 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM9 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM10 sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM2_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM3_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM4_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM5_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM6_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM7_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM8_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM9_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF_REM10_OLD sy-vline
WA_FAGL_FC_DOCS_STR-TARGET_LC_FIELDNR sy-vline
WA_FAGL_FC_DOCS_STR-TARGET_LC_CURTP sy-vline
WA_FAGL_FC_DOCS_STR-TARGET_CURRENCY sy-vline
WA_FAGL_FC_DOCS_STR-TC_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC1_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC2_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC3_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC4_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC5_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC6_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC7_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC8_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC9_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-LC10_AMOUNT sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF2_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF2_NEW sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF3_OLD sy-vline
WA_FAGL_FC_DOCS_STR-VALU_DIFF3_NEW sy-vline
WA_FAGL_FC_DOCS_STR-REAL_DIFF2_OLD sy-vline
WA_FAGL_FC_DOCS_STR-REAL_DIFF3_OLD sy-vline
WA_FAGL_FC_DOCS_STR-HIST_RATE sy-vline
WA_FAGL_FC_DOCS_STR-HIST_RATE_TEXT sy-vline
WA_FAGL_FC_DOCS_STR-DUEGRID_DATE sy-vline
WA_FAGL_FC_DOCS_STR-NETDUE_DATE sy-vline
WA_FAGL_FC_DOCS_STR-TARGET_PLTYPE sy-vline
WA_FAGL_FC_DOCS_STR-XRESET_WITH_REV sy-vline
WA_FAGL_FC_DOCS_STR-XLGCLR sy-vline
WA_FAGL_FC_DOCS_STR-LGOI_LDGRP sy-vline
WA_FAGL_FC_DOCS_STR-LGOI_BSTAT sy-vline
WA_FAGL_FC_DOCS_STR-LGOI_LDGRP_VALPOST sy-vline
WA_FAGL_FC_DOCS_STR-ACCASTY sy-vline
WA_FAGL_FC_DOCS_STR-ACCAS sy-vline
WA_FAGL_FC_DOCS_STR-PPRCTR sy-vline
WA_FAGL_FC_DOCS_STR-PRCTR sy-vline
WA_FAGL_FC_DOCS_STR-PSEGMENT sy-vline
WA_FAGL_FC_DOCS_STR-RBUSA sy-vline
WA_FAGL_FC_DOCS_STR-SBUSA sy-vline
WA_FAGL_FC_DOCS_STR-SEGMENT sy-vline
WA_FAGL_FC_DOCS_STR-VALOBJTYPE sy-vline
WA_FAGL_FC_DOCS_STR-VALOBJ_ID sy-vline
WA_FAGL_FC_DOCS_STR-VALSOBJ_ID sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.