ABAP Select data from SAP table FIAAPT_S_FSCLMAPS_DATA into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP FIAAPT_S_FSCLMAPS_DATA 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 FIAAPT_S_FSCLMAPS_DATA. 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 FIAAPT_S_FSCLMAPS_DATA 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_FIAAPT_S_FSCLMAPS_DATA TYPE STANDARD TABLE OF FIAAPT_S_FSCLMAPS_DATA,
      WA_FIAAPT_S_FSCLMAPS_DATA TYPE FIAAPT_S_FSCLMAPS_DATA,
      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: <FIAAPT_S_FSCLMAPS_DATA> TYPE FIAAPT_S_FSCLMAPS_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FIAAPT_S_FSCLMAPS_DATA
*  INTO TABLE @DATA(IT_FIAAPT_S_FSCLMAPS_DATA2).
*--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_FIAAPT_S_FSCLMAPS_DATA INDEX 1 INTO DATA(WA_FIAAPT_S_FSCLMAPS_DATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FIAAPT_S_FSCLMAPS_DATA ASSIGNING <FIAAPT_S_FSCLMAPS_DATA>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FIAAPT_S_FSCLMAPS_DATA>-COMPANYCODE = 1.
<FIAAPT_S_FSCLMAPS_DATA>-FISCALYEAR = 1.
<FIAAPT_S_FSCLMAPS_DATA>-ASSETREPORTFORMCLASS = 1.
<FIAAPT_S_FSCLMAPS_DATA>-ASSETREPORTFORM = 1.
<FIAAPT_S_FSCLMAPS_DATA>-ASSETREPORTFORMCATEGORYNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FIAAPT_S_FSCLMAPS_DATA-ASSETRPTFORMRTRMTCATEGORYNAME, sy-vline,
  WA_FIAAPT_S_FSCLMAPS_DATA-SEQUENCENUMBER, sy-vline,
  WA_FIAAPT_S_FSCLMAPS_DATA-MASTERFIXEDASSET, sy-vline,
  WA_FIAAPT_S_FSCLMAPS_DATA-FIXEDASSET, sy-vline,
  WA_FIAAPT_S_FSCLMAPS_DATA-ASSETTRANSACTIONTYPE, sy-vline,
  WA_FIAAPT_S_FSCLMAPS_DATA-ASSETREPORTFORMTYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FIAAPT_S_FSCLMAPS_DATA 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_FIAAPT_S_FSCLMAPS_DATA 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_FIAAPT_S_FSCLMAPS_DATA INTO WA_FIAAPT_S_FSCLMAPS_DATA.


*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 GJAHR, internal->external for field FISCALYEAR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-FISCALYEAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-FISCALYEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit AD152, internal->external for field BOOKREVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-BOOKREVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-BOOKREVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field BOOKUNPLANNEDDEPRAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-BOOKUNPLANNEDDEPRAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-BOOKUNPLANNEDDEPRAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field TAXREVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-TAXREVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-TAXREVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field REVALASSETYEARLYDEPRAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-REVALASSETYEARLYDEPRAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-REVALASSETYEARLYDEPRAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT000REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT000REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT000REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT001REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT001REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT001REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT002REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT002REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT002REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT003REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT003REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT003REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT004REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT004REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT004REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT005REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT005REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT005REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT006REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT006REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT006REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT007REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT007REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT007REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT008REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT008REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT008REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT009REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT009REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT009REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT010REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT010REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT010REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT011REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT011REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT011REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT012REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT012REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT012REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT013REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT013REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT013REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT014REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT014REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT014REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT099REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT099REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT099REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit AD152, internal->external for field EDICT199REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT199REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT199REVALUATIONAMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AD152, internal->external for field EDICT299REVALUATIONAMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AD152_OUTPUT'
  EXPORTING
    input =                      WA_FIAAPT_S_FSCLMAPS_DATA-EDICT299REVALUATIONAMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FIAAPT_S_FSCLMAPS_DATA-EDICT299REVALUATIONAMOUNT.
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_FIAAPT_S_FSCLMAPS_DATA_STR, 
COMPANYCODE TYPE STRING,
FISCALYEAR TYPE STRING,
ASSETREPORTFORMCLASS TYPE STRING,
ASSETREPORTFORM TYPE STRING,
ASSETREPORTFORMCATEGORYNAME TYPE STRING,
ASSETRPTFORMRTRMTCATEGORYNAME TYPE STRING,
SEQUENCENUMBER TYPE STRING,
MASTERFIXEDASSET TYPE STRING,
FIXEDASSET TYPE STRING,
ASSETTRANSACTIONTYPE TYPE STRING,
ASSETREPORTFORMTYPE TYPE STRING,
ADDITIONALASSETREPORTFORMTYPE TYPE STRING,
ASSETEVALUATIONGROUP TYPE STRING,
FIXEDASSETDESCRIPTION TYPE STRING,
FIRSTACQUISITIONFISCALYEAR TYPE STRING,
DEPRECIATIONSTARTPERIOD TYPE STRING,
DEPRECIATIONSTARTYEAR TYPE STRING,
LANDASSETLINK TYPE STRING,
BIGREPAIRASSETLINK TYPE STRING,
ASSETREALIZATIONAMOUNT TYPE STRING,
BOOKACQUISITIONAMOUNT TYPE STRING,
TAXACQUISITIONAMOUNT TYPE STRING,
BOOKVALUEADJUSTMENTAMOUNT TYPE STRING,
BOOKCAPITALGAINAMOUNTSIGN TYPE STRING,
BOOKCAPITALGAINAMOUNT TYPE STRING,
NOTTAXEDCAPITALGAINAMOUNT TYPE STRING,
TAXVALUEADJUSTMENTAMOUNT TYPE STRING,
DEVALUATIONCOEFFICIENT TYPE STRING,
TAXCAPITALGAINAMOUNTSIGN TYPE STRING,
TAXCAPITALGAINAMOUNT TYPE STRING,
PLANNEDUSEFULLIFEINDCMLYEARS TYPE STRING,
REPORTEDBOOKDEPRECIATIONAMOUNT TYPE STRING,
REPORTEDCUMULATIVETAXDEPRAMT TYPE STRING,
PLANNEDUSEFULLIFEINYEARS TYPE STRING,
TAXDEPRECIATIONRATE TYPE STRING,
REVISEDTAXDEPRECIATIONRATE TYPE STRING,
REPORTEDTAXDEPRECIATIONAMOUNT TYPE STRING,
ACCEPTEDIMPAIRMENTLOSSAMOUNT TYPE STRING,
CUMULATIVELOSSTAXDEPRRATE TYPE STRING,
NOTACCEPTEDDEPRECIATIONAMOUNT TYPE STRING,
RECOVEREDIMPRMTLOSSANDDEPRAMT TYPE STRING,
ACQNPRODNCOSTANDREVALAMOUNT TYPE STRING,
PREVACQNPRODNCOSTANDREVALAMT TYPE STRING,
TOTALACQNPRODNCOSTANDREVALAMT TYPE STRING,
RLTVEXPIREDUSEFULLIFEINYEARS TYPE STRING,
RLTVREMAININGUSEFULLIFEINYEARS TYPE STRING,
ADDLPLANNEDUSEFULLIFEINYEARS TYPE STRING,
ADDITIONALTAXDEPRECIATIONRATE TYPE STRING,
CUMULATIVEDEPRECIATIONAMOUNT TYPE STRING,
TOTALDEPRECIATIONAMOUNT TYPE STRING,
NETBOOKVALUEAMOUNT TYPE STRING,
TAXEXEMPTIONAMOUNT TYPE STRING,
FOREGONEAMOUNT TYPE STRING,
REEVALUATEDASSETDEPRAMOUNT TYPE STRING,
SORTINGNUMBER TYPE STRING,
RECORDTYPE TYPE STRING,
NUMBEROFASSETREPORTFORMS TYPE STRING,
ISASSETGROUPED TYPE STRING,
ISVEHICLEWITHOUTLIMIT TYPE STRING,
VEHICLETYPE TYPE STRING,
ISELECTRICVEHICLE TYPE STRING,
VEHICLELIMITAMOUNT TYPE STRING,
LASTRETIREMENTVALUEDATE TYPE STRING,
ASSETDEACTIVATIONDATE TYPE STRING,
ASSETVALUEDATE TYPE STRING,
ISASSETRETIRED TYPE STRING,
EXPECTEDUSEFULLIFEINYEARS TYPE STRING,
BOOKDEPRECIATIONSTARTDATE TYPE STRING,
BOOKDEPRECIATIONKEY TYPE STRING,
BOOKPLANNEDUSEFULLIFEINYEARS TYPE STRING,
BOOKPLANNEDUSEFULLIFEINPERIODS TYPE STRING,
BOOKACQUISITIONPRODNCOSTAMOUNT TYPE STRING,
BOOKREVALUATIONAMOUNT TYPE STRING,
BOOKDEPRECIATIONAMOUNT TYPE STRING,
BOOKUNPLANNEDDEPRAMOUNT TYPE STRING,
BOOKCUMULATIVEDEPRECIATIONAMT TYPE STRING,
IMPAIRMENTRSDLVALUERTRMTAMOUNT TYPE STRING,
TAXPLANNEDUSEFULLIFEINYEARS TYPE STRING,
TAXPLANNEDUSEFULLIFEINPERIODS TYPE STRING,
TAXEXPIREDUSEFULLIFEINYEARS TYPE STRING,
TAXEXPIREDUSEFULLIFEINPERIODS TYPE STRING,
TAXDEPRECIATIONSTARTDATE TYPE STRING,
TAXRATESUMMARY TYPE STRING,
TAXACQUISITIONPRODNCOSTAMOUNT TYPE STRING,
TAXREVALUATIONAMOUNT TYPE STRING,
TAXCURRENTYEARDEPRECIATIONAMT TYPE STRING,
CUMULATIVETAXDEPRECIATIONAMT TYPE STRING,
EDICT101UNPLANNEDDEPRAMOUNT TYPE STRING,
ASSETREPORTEDICT TYPE STRING,
REVALASSETYEARLYDEPRAMOUNT TYPE STRING,
EDICT000REVALUATIONAMOUNT TYPE STRING,
EDICT001REVALUATIONAMOUNT TYPE STRING,
EDICT002REVALUATIONAMOUNT TYPE STRING,
EDICT003REVALUATIONAMOUNT TYPE STRING,
EDICT004REVALUATIONAMOUNT TYPE STRING,
EDICT005REVALUATIONAMOUNT TYPE STRING,
EDICT006REVALUATIONAMOUNT TYPE STRING,
EDICT007REVALUATIONAMOUNT TYPE STRING,
EDICT008REVALUATIONAMOUNT TYPE STRING,
EDICT009REVALUATIONAMOUNT TYPE STRING,
EDICT010REVALUATIONAMOUNT TYPE STRING,
EDICT011REVALUATIONAMOUNT TYPE STRING,
EDICT012REVALUATIONAMOUNT TYPE STRING,
EDICT013REVALUATIONAMOUNT TYPE STRING,
EDICT014REVALUATIONAMOUNT TYPE STRING,
EDICT099REVALUATIONAMOUNT TYPE STRING,
EDICT099CURRENTYEARDEPRAMOUNT TYPE STRING,
EDICT099ORDINARYDEPRAMOUNT TYPE STRING,
EDICT099ORDNRYDEPRVALADJMTAMT TYPE STRING,
EDICT199REVALUATIONAMOUNT TYPE STRING,
EDICT199CURRENTYEARDEPRAMOUNT TYPE STRING,
EDICT299REVALUATIONAMOUNT TYPE STRING,
EDICT299CURRENTYEARDEPRAMOUNT TYPE STRING,
EDICT299CUMULATIVEDEPRAMOUNT TYPE STRING,
UUID TYPE STRING,
TAXDEPRECIATIONKEY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FIAAPT_S_FSCLMAPS_DATA_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_FIAAPT_S_FSCLMAPS_DATA_STR-COMPANYCODE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-FISCALYEAR sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETREPORTFORMCLASS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETREPORTFORM sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETREPORTFORMCATEGORYNAME sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETRPTFORMRTRMTCATEGORYNAME sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-SEQUENCENUMBER sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-MASTERFIXEDASSET sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-FIXEDASSET sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETTRANSACTIONTYPE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETREPORTFORMTYPE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ADDITIONALASSETREPORTFORMTYPE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETEVALUATIONGROUP sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-FIXEDASSETDESCRIPTION sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-FIRSTACQUISITIONFISCALYEAR sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-DEPRECIATIONSTARTPERIOD sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-DEPRECIATIONSTARTYEAR sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-LANDASSETLINK sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BIGREPAIRASSETLINK sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETREALIZATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKACQUISITIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXACQUISITIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKVALUEADJUSTMENTAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKCAPITALGAINAMOUNTSIGN sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKCAPITALGAINAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-NOTTAXEDCAPITALGAINAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXVALUEADJUSTMENTAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-DEVALUATIONCOEFFICIENT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXCAPITALGAINAMOUNTSIGN sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXCAPITALGAINAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-PLANNEDUSEFULLIFEINDCMLYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-REPORTEDBOOKDEPRECIATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-REPORTEDCUMULATIVETAXDEPRAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-PLANNEDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXDEPRECIATIONRATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-REVISEDTAXDEPRECIATIONRATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-REPORTEDTAXDEPRECIATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ACCEPTEDIMPAIRMENTLOSSAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-CUMULATIVELOSSTAXDEPRRATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-NOTACCEPTEDDEPRECIATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-RECOVEREDIMPRMTLOSSANDDEPRAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ACQNPRODNCOSTANDREVALAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-PREVACQNPRODNCOSTANDREVALAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TOTALACQNPRODNCOSTANDREVALAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-RLTVEXPIREDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-RLTVREMAININGUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ADDLPLANNEDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ADDITIONALTAXDEPRECIATIONRATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-CUMULATIVEDEPRECIATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TOTALDEPRECIATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-NETBOOKVALUEAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXEXEMPTIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-FOREGONEAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-REEVALUATEDASSETDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-SORTINGNUMBER sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-RECORDTYPE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-NUMBEROFASSETREPORTFORMS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ISASSETGROUPED sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ISVEHICLEWITHOUTLIMIT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-VEHICLETYPE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ISELECTRICVEHICLE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-VEHICLELIMITAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-LASTRETIREMENTVALUEDATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETDEACTIVATIONDATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETVALUEDATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ISASSETRETIRED sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EXPECTEDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKDEPRECIATIONSTARTDATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKDEPRECIATIONKEY sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKPLANNEDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKPLANNEDUSEFULLIFEINPERIODS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKACQUISITIONPRODNCOSTAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKREVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKDEPRECIATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKUNPLANNEDDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-BOOKCUMULATIVEDEPRECIATIONAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-IMPAIRMENTRSDLVALUERTRMTAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXPLANNEDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXPLANNEDUSEFULLIFEINPERIODS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXEXPIREDUSEFULLIFEINYEARS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXEXPIREDUSEFULLIFEINPERIODS sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXDEPRECIATIONSTARTDATE sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXRATESUMMARY sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXACQUISITIONPRODNCOSTAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXREVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXCURRENTYEARDEPRECIATIONAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-CUMULATIVETAXDEPRECIATIONAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT101UNPLANNEDDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-ASSETREPORTEDICT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-REVALASSETYEARLYDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT000REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT001REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT002REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT003REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT004REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT005REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT006REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT007REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT008REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT009REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT010REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT011REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT012REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT013REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT014REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT099REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT099CURRENTYEARDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT099ORDINARYDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT099ORDNRYDEPRVALADJMTAMT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT199REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT199CURRENTYEARDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT299REVALUATIONAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT299CURRENTYEARDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-EDICT299CUMULATIVEDEPRAMOUNT sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-UUID sy-vline 
WA_FIAAPT_S_FSCLMAPS_DATA_STR-TAXDEPRECIATIONKEY sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.