FAAT_BSP_ASP_RL SAP (Results List for Asset Cockpit) Structure details
Description: Results List for Asset Cockpit
Related tables to FAAT_BSP_ASP_RL
Access table FAAT_BSP_ASP_RL
Structure field list including key, data, relationships and ABAP select examples
FAAT_BSP_ASP_RL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Results List for Asset Cockpit" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FAAT_BSP_ASP_RL TYPE FAAT_BSP_ASP_RL.
The FAAT_BSP_ASP_RL table consists of various fields, each holding specific information or linking keys about Results List for Asset Cockpit data available in SAP. These include RF_ASSET (), ORGUNIT (Leading Organizational Unit for Asset Accounting), ASSET (Main Asset Number), SUBNUMBER (Asset Subnumber).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP FAAT_BSP_ASP_RL structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
OBJECT_KEY | Object Key | CRMT_BSP_OBJECTKEY | CHAR | 100 | |||||
RF_ASSET | 0 | ||||||||
ORGUNIT | Leading Organizational Unit for Asset Accounting | FAA_ORG_CA | CHAR | 4 | Assigned to domain | BUKRS | |||
ASSET | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
SUBNUMBER | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
ASSETCLASS | Asset class | BF_ANLKL | CHAR | 8 | Assigned to domain | ALPHA | BF_ANLKL | ANK | |
DESCRIPT | Asset Description | BF_TXA50 | CHAR | 50 | TEXT50 | ||||
DESCRIPT2 | Additional asset description | TXA50_MORE | CHAR | 50 | TEXT50 | ||||
SERIAL_NO | Serial number | BF_AM_SERNR | CHAR | 18 | ALPHA | BF_GERNR | SER | ||
INVENT_NO | Inventory number | BF_INVNR_ANLA | CHAR | 25 | BF_INVNR_ANLA | ||||
ACCT_DETRM | Account determination | BF_KTOGR | CHAR | 8 | Assigned to domain | ALPHA | KTOGR | ||
QUANTITY | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
BASE_UOM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CAP_DATE | Asset capitalization date | BF_AKTIVD | DATS | 8 | DATUM | ||||
DEACT_DATE | Deactivation date | BF_DEAKT | DATS | 8 | DATUM | ||||
INITIAL_ACQ | Asset value date of the first posting | BF_ZUGDAT | DATS | 8 | DATUM | ||||
INITIAL_ACQ_YR | Fiscal year in which first acquisition was posted | BF_ZUJAHR | NUMC | 4 | GJAHR | GJAHR | |||
INITIAL_ACQ_PRD | Period in which first acquisition was posted | BF_ZUPER | NUMC | 3 | POPER | ||||
PLRET_DATE | Planned retirement date | BF_GPLAB | DATS | 8 | DATUM | ||||
LAST_RET_DATE | Asset value date for the last retirement | ABGDAT | DATS | 8 | DATUM | ||||
PO_DATE | Asset purchase order date | BF_BSTDT | DATS | 8 | DATUM | ||||
CAP_KEY | Results Analysis Key | ABGR_SCHL | CHAR | 6 | Assigned to domain | ABGR_SCHL | ACS | ||
LAST_REV_DATE | Date of last revaluation | AM_LRVDAT | DATS | 8 | DATUM | ||||
BUS_AREA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
COSTCENTER | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
ACTTYPE | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
INTERN_ORD | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
MAINT_ORD | Maintenance order | IAUFN | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
FUND | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
FUNC_AREA_LONG | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
FUNDS_CTR | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FUND_APC | Fund for APC Account Assignments | BP_GEBER2 | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FUNC_AREA_APC | Functional Area for APC Account Assignments | FKBER2 | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GRANT_NBR_APC | Grant for APC Account Assignments | GM_GRANT_NBR2 | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
FUNDS_CTR_APC | Funds Center for APC Account Assignments | FISTL2 | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
WBS_ELEMENT_COST | WBS Element (Costs) | PS_PSP_PNR2 | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
TAXJURCODE | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
RL_EST_KEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
INVEST_ORD | Investment Order | BF_AM_AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
WBS_ELEM | WBS Element | PS_POSNR | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
RESP_CCTR | Cost center responsible for asset | BF_KOSTLV | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | ||
PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LOCATION | Asset location | STORT | CHAR | 10 | Assigned to domain | AP_STAND | |||
ROOM | Room | BF_RAUMNR | CHAR | 8 | CHAR8 | ||||
PLATE_NO | License plate no. of vehichle | BF_AM_KFZKZ | CHAR | 15 | BF_AM_KFZKZ | ||||
PERSON_NO | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
EVALGROUP1 | Evaluation Group 1 | BF_ORD41 | CHAR | 4 | BF_ORD4X | ||||
EVALGROUP2 | Evaluation Group 2 | BF_ORD42 | CHAR | 4 | BF_ORD4X | ||||
EVALGROUP3 | Evaluation Group 3 | BF_ORD43 | CHAR | 4 | BF_ORD4X | ||||
EVALGROUP4 | Evaluation Group 4 | BF_ORD44 | CHAR | 4 | BF_ORD4X | ||||
EVALGROUP5 | Sort Key 5 | BF_GDLGRP | CHAR | 8 | BF_GDLGRP | ||||
INV_REASON | Reason for investment | BF_IZWEK | CHAR | 2 | BF_IZWEK | ||||
ENVIR_INVEST | Reason for environmental investment | BF_AM_UMWKZ | CHAR | 5 | BF_AM_UMWKZ | ||||
ASSETSUPNO | Asset super number | BF_ANLUE | CHAR | 12 | BF_ANLUE | ||||
VENDOR_NO | Account number of vendor (other key word) | BF_AM_LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
VENDOR | Name of asset supplier | BF_LIEFE | CHAR | 30 | TEXT30 | ||||
MANUFACTURER | Manufacturer of asset | BF_HERST | CHAR | 30 | TEXT30 | ||||
PURCH_NEW | Indicator: Asset purchased new | XNEU_AM | CHAR | 1 | XFELD | ||||
TRADE_ID | Company ID of trading partner | BF_RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | ||
COUNTRY | Asset's country of origin | BF_AM_LAND1 | CHAR | 3 | T005 | LAND1 | |||
TYPE_NAME | Asset type name | BF_TYPBZ_ANLA | CHAR | 15 | BF_TYPBZ_ANLA | ||||
ORIG_ASSET | Original asset that was transferred | BF_AIBN1 | CHAR | 12 | ALPHA | BF_ANLN1 | |||
ORIG_ASSET_SUBNO | Original asset that was transferred | BF_AIBN2 | CHAR | 4 | ALPHA | BF_ANLN2 | |||
ORIG_ACQ_DATE | Original acquisition date of AuC/ transferred asset | BF_AIBDT | DATS | 8 | DATUM | ||||
ORIG_ACQ_YR | Fiscal year of original acquisition | BF_URJHR | NUMC | 4 | GJAHR | GJAHR | |||
ORIG_VALUE | Original acquisition value | BF_URWRT | DEC | 23(4) | BAPICURR | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
INHOUSE_PROD_PRC | In-house production percentage | BF_ANTEI | DEC | 5(2) | BF_PRZ32 | ||||
COMPLETENESS | Completeness indicator for the asset | ANEQS | NUMC | 1 | ANEQS | ||||
HISTORY | Asset is managed historically | XHIST_AM | CHAR | 1 | XFELD | ||||
IS_GROUP_ASSET | Indicator: Asset is a group asset | XANLGR_1 | CHAR | 1 | XFELD | ||||
IS_INVSTMNT_MSR | Asset under Construction for Investment Measures | IM_XINVM | CHAR | 1 | XFELD | ||||
LINE_ITEM_SETTL | Asset under construct. with line item settlement | OPVWA | CHAR | 1 | XFELD | ||||
IGNORE_MEMVAL | Indicator: Ignore memo value | XERWRT | CHAR | 1 | XFELD | ||||
PLND_FOR_DELETN | Indicator: Account marked for deletion? | XLOEV | CHAR | 1 | XFELD | ||||
LOCKED_FOR_PSTNG | Indicator: Asset Locked to Acquisition Postings | XSPEB_ANLA | CHAR | 1 | XFELD | ||||
IS_REAL_ESTATE | Indicator: real estate | AIMMO | NUMC | 1 | AIMMO | ||||
INCL_IN_INV_LIST | Inventory indicator | BF_INKEN | CHAR | 1 | BF_XFELD | ||||
HAS_TDDP | Asset Has Time-Dependent Valuation Parameters in ANLBZA | HAS_TDDP | CHAR | 1 | BOOLE | ||||
MAIN_DESCRIPT | Asset main number text | ANLHTXT | CHAR | 50 | TEXT50 | ||||
SUBNO_OF_MAIN | First subnumber assigned | FUNTN | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | ||
LAST_SUBNO | Last subnumber assigned to this main number | LUNTN | CHAR | 4 | ALPHA | ANLN2_4 | |||
TO_DATE | Date validity ends | BF_BDATU | DATS | 8 | DATUM | ||||
FROM_DATE | Date for beginning of validity | BF_ADATU | DATS | 8 | DATUM | ADT |
Key field | Non-key field |
How do I retrieve data from SAP structure FAAT_BSP_ASP_RL using ABAP code?
As FAAT_BSP_ASP_RL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FAAT_BSP_ASP_RL as there is no data to select.How to access SAP table FAAT_BSP_ASP_RL
Within an ECC or HANA version of SAP you can also view further information about FAAT_BSP_ASP_RL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects