ABAP Select data from SAP table FAA_ES_S_MD_DATA_FOR_MAP 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_ES_S_MD_DATA_FOR_MAP 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_ES_S_MD_DATA_FOR_MAP. 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_ES_S_MD_DATA_FOR_MAP 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_ES_S_MD_DATA_FOR_MAP TYPE STANDARD TABLE OF FAA_ES_S_MD_DATA_FOR_MAP,
      WA_FAA_ES_S_MD_DATA_FOR_MAP TYPE FAA_ES_S_MD_DATA_FOR_MAP,
      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_ES_S_MD_DATA_FOR_MAP> TYPE FAA_ES_S_MD_DATA_FOR_MAP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FAA_ES_S_MD_DATA_FOR_MAP
*  INTO TABLE @DATA(IT_FAA_ES_S_MD_DATA_FOR_MAP2).
*--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_ES_S_MD_DATA_FOR_MAP INDEX 1 INTO DATA(WA_FAA_ES_S_MD_DATA_FOR_MAP2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FAA_ES_S_MD_DATA_FOR_MAP ASSIGNING <FAA_ES_S_MD_DATA_FOR_MAP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FAA_ES_S_MD_DATA_FOR_MAP>-UNIQUEASSETIDENTIFIER = 1.
<FAA_ES_S_MD_DATA_FOR_MAP>-COMPANYCODE = 1.
<FAA_ES_S_MD_DATA_FOR_MAP>-MASTERFIXEDASSET = 1.
<FAA_ES_S_MD_DATA_FOR_MAP>-FIXEDASSET = 1.
<FAA_ES_S_MD_DATA_FOR_MAP>-GENERAL = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FAA_ES_S_MD_DATA_FOR_MAP-FIXEDASSETDESCRIPTION, sy-vline,
WA_FAA_ES_S_MD_DATA_FOR_MAP-ASSETADDITIONALDESCRIPTION, sy-vline,
WA_FAA_ES_S_MD_DATA_FOR_MAP-ASSETSERIALNUMBER, sy-vline,
WA_FAA_ES_S_MD_DATA_FOR_MAP-INVENTORY, sy-vline,
WA_FAA_ES_S_MD_DATA_FOR_MAP-FIXEDASSETORDERDATE, sy-vline,
WA_FAA_ES_S_MD_DATA_FOR_MAP-HASHISTORY, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FAA_ES_S_MD_DATA_FOR_MAP 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_ES_S_MD_DATA_FOR_MAP 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_ES_S_MD_DATA_FOR_MAP INTO WA_FAA_ES_S_MD_DATA_FOR_MAP. *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 MASTERFIXEDASSET CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-MASTERFIXEDASSET IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-MASTERFIXEDASSET.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GERNR, internal->external for field ASSETSERIALNUMBER CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-ASSETSERIALNUMBER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-ASSETSERIALNUMBER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BASEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-BASEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-BASEUNIT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ABPSP, internal->external for field INVESTMENTPROJECTWBSELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-INVESTMENTPROJECTWBSELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-INVESTMENTPROJECTWBSELEMENT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CUNIT, internal->external for field AREASIZEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-AREASIZEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-AREASIZEUNIT.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit MATN1, internal->external for field RU_WORKWEARMATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-RU_WORKWEARMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-RU_WORKWEARMATERIAL.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field RU_PROPERTYADDRESS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FAA_ES_S_MD_DATA_FOR_MAP-RU_PROPERTYADDRESS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FAA_ES_S_MD_DATA_FOR_MAP-RU_PROPERTYADDRESS.
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_ES_S_MD_DATA_FOR_MAP_STR,
UNIQUEASSETIDENTIFIER TYPE STRING,
COMPANYCODE TYPE STRING,
MASTERFIXEDASSET TYPE STRING,
FIXEDASSET TYPE STRING,
GENERAL TYPE STRING,
FIXEDASSETDESCRIPTION TYPE STRING,
ASSETADDITIONALDESCRIPTION TYPE STRING,
ASSETSERIALNUMBER TYPE STRING,
INVENTORY TYPE STRING,
FIXEDASSETORDERDATE TYPE STRING,
HASHISTORY TYPE STRING,
BASEUNIT TYPE STRING,
ORIGIN TYPE STRING,
SUPPLIER TYPE STRING,
ASSETCOUNTRYOFORIGIN TYPE STRING,
ASSETMANUFACTURERNAME TYPE STRING,
ORIGINALMASTERFIXEDASSET TYPE STRING,
ORIGINALFIXEDASSET TYPE STRING,
ORIGINALFIXEDASSETVALUEDATE TYPE STRING,
ORIGINALACQUISITIONFISCALYEAR TYPE STRING,
ORIGINALACQUISITIONAMOUNT TYPE STRING,
ORIGINALACQUISITIONCURRENCY TYPE STRING,
INHOUSEPRODNPERCENT TYPE STRING,
ASSETTYPENAME TYPE STRING,
PARTNERCOMPANY TYPE STRING,
ASSETISACQUIREDUSED TYPE STRING,
INVESTMENTPROJECTWBSELEMENT TYPE STRING,
INVESTMENTORDER TYPE STRING,
INVENTORY TYPE STRING,
LASTINVENTORYDATE TYPE STRING,
INVENTORYNOTE TYPE STRING,
INVENTORYISCOUNTED TYPE STRING,
ALLOCATIONS TYPE STRING,
INVESTMENTREASON TYPE STRING,
ENVRNMTLINVESTMENTREASON TYPE STRING,
FIXEDASSETGROUP TYPE STRING,
REALESTATE TYPE STRING,
LOCALTAXOFFICE TYPE STRING,
NOTICEOFASSESSMENTTAXID TYPE STRING,
LASTASSESSMENTNOTICEDATE TYPE STRING,
MUNICIPALITY TYPE STRING,
LANDREGISTERDATE TYPE STRING,
LANDREGISTERENTRYSEQUENCE TYPE STRING,
LANDREGISTERENTRYDATE TYPE STRING,
LANDREGISTERVOLUME TYPE STRING,
LANDREGISTERPAGE TYPE STRING,
LANDREGISTERMAP TYPE STRING,
LANDPLOT TYPE STRING,
CONVEYANCEDATE TYPE STRING,
AREASIZE TYPE STRING,
AREASIZEUNIT TYPE STRING,
LEASING TYPE STRING,
LEASESUPPLIER TYPE STRING,
LEASEAGREEMENT TYPE STRING,
LEASEAGREEMENTDATE TYPE STRING,
LEASETERMENDDATE TYPE STRING,
LEASETERMSTARTDATE TYPE STRING,
LEASEDURATIONINFISCALYEARS TYPE STRING,
LEASEDURATIONINFISCALPERIODS TYPE STRING,
LEASETYPE TYPE STRING,
LEASEDASSETNOTE TYPE STRING,
PROPERTY TYPE STRING,
PROPERTYCLASS TYPE STRING,
FIXEDASSETPROPERTYTYPE TYPE STRING,
ACCOUNTASSIGNMENT TYPE STRING,
LEDGER TYPE STRING,
VALUATION TYPE STRING,
TIMEBASEDVALUATION TYPE STRING,
RUGENERAL TYPE STRING,
RU_LONGSERIALNUMBER TYPE STRING,
RU_WORKWEARMATERIAL TYPE STRING,
RU_RETIREDMASTERFIXEDASSET TYPE STRING,
RU_RETIREDFIXEDASSET TYPE STRING,
RUTRANSPORTTAX TYPE STRING,
RU_ASSETTRANSPORTTYPE TYPE STRING,
RU_VEHICLEIDNUMBER TYPE STRING,
RU_MANUFACTURINGDATE TYPE STRING,
RU_VEHICLEECOLOGICALCLASS TYPE STRING,
RUPROPERTYADDRESS TYPE STRING,
RU_PROPERTYADDRESS TYPE STRING,
JPANNEX16 TYPE STRING,
JP_ANNEX16ASSETSTRUCTURE TYPE STRING,
JP_ANNEX16ASSETITEM TYPE STRING,
JP_ANNEX16LEASINGAGRMTDATE TYPE STRING,
JPPROPERTYTAX TYPE STRING,
JP_PRPTYTXRPTCITY TYPE STRING,
JP_PRPTYTXRPTCLASSFCTNKEY TYPE STRING,
JP_PRPTYTXRPTSPCLDEPR TYPE STRING,
JP_PRPTYTXRPTADDLDEPR TYPE STRING,
INGENERAL TYPE STRING,
IN_ASSETBLOCK TYPE STRING,
IN_ASSETPUTTOUSEDATE TYPE STRING,
IN_ADDITIONALASSETBLOCK TYPE STRING,
IN_ASSETISRESEARCHANDDEV TYPE STRING,
IN_ASSETISPRIORYEAR TYPE STRING,
PTFISCALMAPS TYPE STRING,
PT_VEHICLETYPEBYENERGY TYPE STRING,
PT_VEHICLEISWITHOUTLIMIT TYPE STRING,
PT_BIGREPAIRASSETLINK TYPE STRING,
PT_LANDASSETLINK TYPE STRING,
PT_ASSETREPORTFORMCATEGORY TYPE STRING,
PT_AMORTIZEDASSETISREEVALUATED TYPE STRING,
NATIONALCLASSIFICATION TYPE STRING,
NATIONALCLASSIFICATION TYPE STRING,
TAXDEPRECIATIONGROUP TYPE STRING,
GLOPRECIOUSMATERIALS TYPE STRING,
GLOACCOUNTASSIGNMENT TYPE STRING,
GLOTIMEBASEDVALUATION TYPE STRING,END OF T_EKKO_STR. DATA: WA_FAA_ES_S_MD_DATA_FOR_MAP_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_ES_S_MD_DATA_FOR_MAP_STR-UNIQUEASSETIDENTIFIER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-COMPANYCODE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-MASTERFIXEDASSET sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-FIXEDASSET sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-GENERAL sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-FIXEDASSETDESCRIPTION sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ASSETADDITIONALDESCRIPTION sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ASSETSERIALNUMBER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVENTORY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-FIXEDASSETORDERDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-HASHISTORY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-BASEUNIT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGIN sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-SUPPLIER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ASSETCOUNTRYOFORIGIN sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ASSETMANUFACTURERNAME sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGINALMASTERFIXEDASSET sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGINALFIXEDASSET sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGINALFIXEDASSETVALUEDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGINALACQUISITIONFISCALYEAR sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGINALACQUISITIONAMOUNT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ORIGINALACQUISITIONCURRENCY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INHOUSEPRODNPERCENT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ASSETTYPENAME sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PARTNERCOMPANY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ASSETISACQUIREDUSED sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVESTMENTPROJECTWBSELEMENT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVESTMENTORDER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVENTORY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LASTINVENTORYDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVENTORYNOTE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVENTORYISCOUNTED sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ALLOCATIONS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INVESTMENTREASON sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ENVRNMTLINVESTMENTREASON sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-FIXEDASSETGROUP sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-REALESTATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LOCALTAXOFFICE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-NOTICEOFASSESSMENTTAXID sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LASTASSESSMENTNOTICEDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-MUNICIPALITY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDREGISTERDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDREGISTERENTRYSEQUENCE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDREGISTERENTRYDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDREGISTERVOLUME sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDREGISTERPAGE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDREGISTERMAP sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LANDPLOT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-CONVEYANCEDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-AREASIZE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-AREASIZEUNIT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASING sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASESUPPLIER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASEAGREEMENT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASEAGREEMENTDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASETERMENDDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASETERMSTARTDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASEDURATIONINFISCALYEARS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASEDURATIONINFISCALPERIODS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASETYPE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEASEDASSETNOTE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PROPERTY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PROPERTYCLASS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-FIXEDASSETPROPERTYTYPE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-ACCOUNTASSIGNMENT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-LEDGER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-VALUATION sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-TIMEBASEDVALUATION sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RUGENERAL sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_LONGSERIALNUMBER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_WORKWEARMATERIAL sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_RETIREDMASTERFIXEDASSET sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_RETIREDFIXEDASSET sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RUTRANSPORTTAX sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_ASSETTRANSPORTTYPE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_VEHICLEIDNUMBER sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_MANUFACTURINGDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_VEHICLEECOLOGICALCLASS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RUPROPERTYADDRESS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-RU_PROPERTYADDRESS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JPANNEX16 sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_ANNEX16ASSETSTRUCTURE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_ANNEX16ASSETITEM sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_ANNEX16LEASINGAGRMTDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JPPROPERTYTAX sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_PRPTYTXRPTCITY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_PRPTYTXRPTCLASSFCTNKEY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_PRPTYTXRPTSPCLDEPR sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-JP_PRPTYTXRPTADDLDEPR sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-INGENERAL sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-IN_ASSETBLOCK sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-IN_ASSETPUTTOUSEDATE sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-IN_ADDITIONALASSETBLOCK sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-IN_ASSETISRESEARCHANDDEV sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-IN_ASSETISPRIORYEAR sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PTFISCALMAPS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PT_VEHICLETYPEBYENERGY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PT_VEHICLEISWITHOUTLIMIT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PT_BIGREPAIRASSETLINK sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PT_LANDASSETLINK sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PT_ASSETREPORTFORMCATEGORY sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-PT_AMORTIZEDASSETISREEVALUATED sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-NATIONALCLASSIFICATION sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-NATIONALCLASSIFICATION sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-TAXDEPRECIATIONGROUP sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-GLOPRECIOUSMATERIALS sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-GLOACCOUNTASSIGNMENT sy-vline
WA_FAA_ES_S_MD_DATA_FOR_MAP_STR-GLOTIMEBASEDVALUATION sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.