SAP ABAP Table FAAT_BSP_ASP_RL (Results List for Asset Cockpit)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-AA (Application Component) Asset Accounting
     ⤷ FAA_UI_BSP (Package) User Interface for BSP

Basic Data

Table Category	INTTAB	Structure
Structure	FAAT_BSP_ASP_RL	Table Relationship Diagram
Short Description	Results List for Asset Cockpit

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	RF_ASSET	☐	IF_FAA_ASSET		REF	0	0
3	.INCLUDE	☐				0	0	Basic Data of Asset
4	.INCLUDE	☐				0	0	General Data for Asset
5	.INCLUDE	☐				0	0	Key Fields for an Asset ID
6	.INCLUDE	☐				0	0	Key Fields for Identifying Main Asset Number
7	ORGUNIT	☐	FAA_ORG_CA	BUKRS	CHAR	4	0	Leading Organizational Unit for Asset Accounting	*
8	ASSET	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
9	SUBNUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
10	.INCLUDE	☐				0	0	Key of Asset Class
11	ASSETCLASS	☐	BF_ANLKL	BF_ANLKL	CHAR	8	0	Asset class	*
12	DESCRIPT	☐	BF_TXA50	TEXT50	CHAR	50	0	Asset Description
13	DESCRIPT2	☐	TXA50_MORE	TEXT50	CHAR	50	0	Additional asset description
14	SERIAL_NO	☐	BF_AM_SERNR	BF_GERNR	CHAR	18	0	Serial number
15	INVENT_NO	☐	BF_INVNR_ANLA	BF_INVNR_ANLA	CHAR	25	0	Inventory number
16	.INCLUDE	☐				0	0	Information Relevant for Posting on Asset
17	ACCT_DETRM	☐	BF_KTOGR	KTOGR	CHAR	8	0	Account determination	*
18	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
19	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
20	CAP_DATE	☐	BF_AKTIVD	DATUM	DATS	8	0	Asset capitalization date
21	DEACT_DATE	☐	BF_DEAKT	DATUM	DATS	8	0	Deactivation date
22	INITIAL_ACQ	☐	BF_ZUGDAT	DATUM	DATS	8	0	Asset value date of the first posting
23	INITIAL_ACQ_YR	☐	BF_ZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
24	INITIAL_ACQ_PRD	☐	BF_ZUPER	POPER	NUMC	3	0	Period in which first acquisition was posted
25	PLRET_DATE	☐	BF_GPLAB	DATUM	DATS	8	0	Planned retirement date
26	LAST_RET_DATE	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
27	PO_DATE	☐	BF_BSTDT	DATUM	DATS	8	0	Asset purchase order date
28	CAP_KEY	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	*
29	LAST_REV_DATE	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
30	.INCLUDE	☐				0	0	Assignment of Asset to Postable Objects
31	.INCLUDE	☐				0	0	Time-Dependent, Postable Objects for Asset
32	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
33	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
34	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
35	INTERN_ORD	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
36	MAINT_ORD	☐	IAUFN	AUFNR	CHAR	12	0	Maintenance order	*
37	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
38	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
39	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
40	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
41	FUND_APC	☐	BP_GEBER2	BP_GEBER	CHAR	10	0	Fund for APC Account Assignments	*
42	FUNC_AREA_APC	☐	FKBER2	FKBER	CHAR	16	0	Functional Area for APC Account Assignments	*
43	GRANT_NBR_APC	☐	GM_GRANT_NBR2	GM_GRANT_NBR	CHAR	20	0	Grant for APC Account Assignments
44	FUNDS_CTR_APC	☐	FISTL2	FISTL	CHAR	16	0	Funds Center for APC Account Assignments	*
45	WBS_ELEMENT_COST	☐	PS_PSP_PNR2	PS_POSNR	NUMC	8	0	WBS Element (Costs)	*
46	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
47	RL_EST_KEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
48	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
49	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
50	.INCLUDE	☐				0	0	Account Assignment for Investment
51	INVEST_ORD	☐	BF_AM_AUFNR	AUFNR	CHAR	12	0	Investment Order	AUFK
52	WBS_ELEM	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
53	.INCLUDE	☐				0	0	Organizational Assignments of Asset
54	RESP_CCTR	☐	BF_KOSTLV	KOSTL	CHAR	10	0	Cost center responsible for asset	*
55	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
56	LOCATION	☐	STORT	AP_STAND	CHAR	10	0	Asset location	*
57	ROOM	☐	BF_RAUMNR	CHAR8	CHAR	8	0	Room
58	PLATE_NO	☐	BF_AM_KFZKZ	BF_AM_KFZKZ	CHAR	15	0	License plate no. of vehichle
59	PERSON_NO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
60	.INCLUDE	☐				0	0	Allocations
61	EVALGROUP1	☐	BF_ORD41	BF_ORD4X	CHAR	4	0	Evaluation Group 1
62	EVALGROUP2	☐	BF_ORD42	BF_ORD4X	CHAR	4	0	Evaluation Group 2
63	EVALGROUP3	☐	BF_ORD43	BF_ORD4X	CHAR	4	0	Evaluation Group 3
64	EVALGROUP4	☐	BF_ORD44	BF_ORD4X	CHAR	4	0	Evaluation Group 4
65	EVALGROUP5	☐	BF_GDLGRP	BF_GDLGRP	CHAR	8	0	Sort Key 5
66	INV_REASON	☐	BF_IZWEK	BF_IZWEK	CHAR	2	0	Reason for investment
67	ENVIR_INVEST	☐	BF_AM_UMWKZ	BF_AM_UMWKZ	CHAR	5	0	Reason for environmental investment
68	ASSETSUPNO	☐	BF_ANLUE	BF_ANLUE	CHAR	12	0	Asset super number
69	.INCLUDE	☐				0	0	Entries on Origin of Asset
70	VENDOR_NO	☐	BF_AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
71	VENDOR	☐	BF_LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
72	MANUFACTURER	☐	BF_HERST	TEXT30	CHAR	30	0	Manufacturer of asset
73	PURCH_NEW	☐	XNEU_AM	XFELD	CHAR	1	0	Indicator: Asset purchased new
74	TRADE_ID	☐	BF_RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
75	COUNTRY	☐	BF_AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
76	TYPE_NAME	☐	BF_TYPBZ_ANLA	BF_TYPBZ_ANLA	CHAR	15	0	Asset type name
77	ORIG_ASSET	☐	BF_AIBN1	BF_ANLN1	CHAR	12	0	Original asset that was transferred
78	ORIG_ASSET_SUBNO	☐	BF_AIBN2	BF_ANLN2	CHAR	4	0	Original asset that was transferred
79	ORIG_ACQ_DATE	☐	BF_AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
80	ORIG_ACQ_YR	☐	BF_URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
81	ORIG_VALUE	☐	BF_URWRT	BAPICURR	DEC	23	4	Original acquisition value
82	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
83	INHOUSE_PROD_PRC	☐	BF_ANTEI	BF_PRZ32	DEC	5	2	In-house production percentage
84	.INCLUDE	☐				0	0	Status Fields of Asset
85	COMPLETENESS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
86	HISTORY	☐	XHIST_AM	XFELD	CHAR	1	0	Asset is managed historically
87	IS_GROUP_ASSET	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
88	IS_INVSTMNT_MSR	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
89	LINE_ITEM_SETTL	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
90	IGNORE_MEMVAL	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
91	PLND_FOR_DELETN	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
92	LOCKED_FOR_PSTNG	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
93	IS_REAL_ESTATE	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
94	INCL_IN_INV_LIST	☐	BF_INKEN	BF_XFELD	CHAR	1	0	Inventory indicator
95	HAS_TDDP	☐	HAS_TDDP	BOOLE	CHAR	1	0	Asset Has Time-Dependent Valuation Parameters in ANLBZA
96	.INCLUDE	☐				0	0	Data of the Asset Main Number
97	MAIN_DESCRIPT	☐	ANLHTXT	TEXT50	CHAR	50	0	Asset main number text
98	SUBNO_OF_MAIN	☐	FUNTN	ANLN2	CHAR	4	0	First subnumber assigned	*
99	LAST_SUBNO	☐	LUNTN	ANLN2_4	CHAR	4	0	Last subnumber assigned to this main number
100	.INCLUDE	☐				0	0	Key for Identifying a Time Interval
101	TO_DATE	☐	BF_BDATU	DATUM	DATS	8	0	Date validity ends
102	FROM_DATE	☐	BF_ADATU	DATUM	DATS	8	0	Date for beginning of validity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAAT_BSP_ASP_RL	COUNTRY	T005	LAND1
2	FAAT_BSP_ASP_RL	CURRENCY	TCURC	WAERS
3	FAAT_BSP_ASP_RL	INVEST_ORD	AUFK	AUFNR
4	FAAT_BSP_ASP_RL	TRADE_ID	T880	RCOMP
5	FAAT_BSP_ASP_RL	VENDOR_NO	LFA1	LIFNR
6	FAAT_BSP_ASP_RL	WBS_ELEM	PRPS	PSPNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	500