SAP ABAP Table FIAAPT_S_ASSETDATA (Asset data main structure)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AA (Application Component) Asset Accounting
     ⤷ ID-FIAA-PT (Package) FI-AA Localization (Portugal)

Basic Data

Table Category	INTTAB	Structure
Structure	FIAAPT_S_ASSETDATA	Table Relationship Diagram
Short Description	Asset data main structure

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	MAPA	☐	FIAAPT_MAPA	FIAAPT_MAPA	NUMC	4	0	Mapa Number
5	TIPO	☐	FIAAPT_TIPO	FIAAPT_TIPO	CHAR	4	0	Mapa Category
6	BWASL	☐	BWASL	BWASL	CHAR	3	0	Asset Transaction Type	*
7	ASS_CAT	☐	FIAAPT_ASS_CAT	FIAAPT_ASS_CAT	CHAR	15	0	Asset Category
8	ASS_SUB_CAT	☐	FIAAPT_ASS_CAT	FIAAPT_ASS_CAT	CHAR	15	0	Asset Category
9	SORT_ORDER	☐	FIAAPT_SORT_ORDER	FIAAPT_SORT	NUMC	2	0	Sorting of Asset
10	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
11	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
12	ORD41	☐	ORD41	ORD4X	CHAR	4	0	Evaluation group 1	*
13	ASSET_DESCRIPTION	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
14	ACQ_YEAR	☐	DZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
15	USE_START_MONTH	☐	FIAAPT_MONTHS	FIAAPT_MONTHS	NUMC	3	0	Months
16	USE_START_YEAR	☐	FIAAPT_USE_START_YEAR	GJAHR	NUMC	4	0	Year in which the use of asset started
17	USER_NAME	☐	UNAME	UNAME	CHAR	12	0	User Name
18	RUN_DATE	☐	DATUM	DATUM	DATS	8	0	Date
19	LINK_LAND_BUILD	☐	FIAAPT_LINK_LB	FIAAPT_ASS_LINK	CHAR	25	0	Land and Building Link
20	LINK_BG_REPAIR	☐	FIAAPT_LINK_REP	FIAAPT_ASS_LINK	CHAR	25	0	Repair Asset link
21	NO_LINK	☐	FIAAPT_NO_LINK	FIAAPT_ASS_LINK	CHAR	25	0	Asset with no Link
22	GROUP_ASSET	☐	FLAG	FLAG	CHAR	1	0	General Flag
23	VAL_APC_EDICT00	☐	FIAAPT_VAL_APC	FIAAPT_VAL_APC	DEC	15	2	Asset Acquisition and Production Cost
24	RE_VAL_EDICT00	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
25	RE_VAL_EDICT01	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
26	RE_VAL_EDICT02	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
27	RE_VAL_EDICT03	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
28	RE_VAL_EDICT04	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
29	RE_VAL_EDICT05	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
30	RE_VAL_EDICT06	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
31	RE_VAL_EDICT07	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
32	RE_VAL_EDICT08	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
33	RE_VAL_EDICT09	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
34	RE_VAL_EDICT10	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
35	RE_VAL_EDICT11	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
36	RE_VAL_EDICT12	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
37	RE_VAL_EDICT13	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
38	RE_VAL_EDICT14	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
39	ACC_DEP_EDICT00	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
40	CUR_YR_DEP_EDICT00	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
41	RVA	☐	FIAAPT_RVA	FIAAPT_RVA	DEC	15	2	Depreciation on Previos Value revaluation Excercise
42	TXPA_RATE	☐	FIAAPT_TXPA_RATE	FIAAPT_TXPA_RATE	DEC	5	2	Tax Rate
43	TXPA_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
44	LINE_TYPE	☐	FIAAPT_LINE_TYPE	FIAAPT_LINE_TYPE	CHAR	1	0	Line Type sorting Crieteria
45	AFABG	☐	AFABG	DATUM	DATS	8	0	Depreciation calculation start date
46	AFASL	☐	AFASL	AFASL	CHAR	4	0	Depreciation key	*
47	NDJAR	☐	NDJAR	JARAF	NUMC	3	0	Planned useful life in years
48	NDPER	☐	NDPER	PERAF	NUMC	3	0	Planned useful life in periods
49	MSFAK	☐	MSFAK	MSFAK	DEC	3	2	Multiple-shift factor for multiple shift operation
50	ABGDT	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
51	VEH_NO_LIMIT	☐	FIAAPT_VEH_NO_LIMIT	FIAAPT_VEH_NO_LIMIT	CHAR	1	0	Asset Vehicle Limit
52	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
53	DEAKT	☐	DEAKT	DATUM	DATS	8	0	Deactivation date
54	VEH_USE_ELEC	☐	FIAAPT_VEH_NO_LIMIT	FIAAPT_VEH_NO_LIMIT	CHAR	1	0	Asset Vehicle Limit
55	VEH_LIMIT	☐	IDPT_LMVEHELEC	ANLKWERT	CURR	13	2	Limit for vehicles which use electric energy
56	TAX_DEP	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
57	TAX_NDJAR	☐	NDJAR	JARAF	NUMC	3	0	Planned useful life in years
58	TAX_NDPER	☐	NDPER	PERAF	NUMC	3	0	Planned useful life in periods
59	TAX_AC_DEP	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
60	BOOK_AAFA	☐	FIAAPT_BOOK_AAFA	FIAAPT_DEP	DEC	15	2	Unplanned depreciation
61	BOOK_REVAL	☐	FIAAPT_BOOK_REVAL	FIAAPT_VAL_APC	DEC	15	2	Book Revaluation
62	UNPL_DEP	☐	FIAAPT_UNPL_DEP	FIAAPT_DEP	DEC	15	2	Unplanned Depreciation
63	BOOK_REVAL5	☐	FIAAPT_BOOK_REVAL	FIAAPT_VAL_APC	DEC	15	2	Book Revaluation
64	NAFAP	☐	NAFAP	ANLKWERT	CURR	13	2	Planned ordinary depreciation for the year
65	NDABJ	☐	NDABJ	JARAF	NUMC	3	0	Expired useful life in years at start of the fiscal year
66	FR_EDICT_199_DEP	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
67	FR_EDICT_199_REV	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
68	NDABP	☐	NDABP	PERAF	NUMC	3	0	Expired useful life in periods at start of fiscal year
69	ABAT_CHK	☐	FIAAPT_ABAT_CHK	FIAAPT_ABAT_CHK	CHAR	1	0	Retired asset sub Category Check
70	TIPO_ABAT	☐	FIAAPT_TIPO	FIAAPT_TIPO	CHAR	4	0	Mapa Category
71	FR_EDICT	☐	IDPT_A01DPORT	IDPT_A01DPORT	NUMC	4	0	Edict Number
72	FR_EDICT_99_REV	☐	FIAAPT_RE_VAL_EDICT	FIAAPT_RE_VAL_EDICT	DEC	15	2	Revaluation Amount Posted in a particular edict
73	FR_EDICT_99_DEP	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
74	FR_NAFAP	☐	NAFAP	ANLKWERT	CURR	13	2	Planned ordinary depreciation for the year
75	FR_NAFAL	☐	NAFAL	ANLKWERT	CURR	13	2	Proportional ordinary depreciation for the year
76	EXP_USE_LIFE	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
77	TAX_RATE_CHAR	☐			CHAR	20	0
78	BWASL_COL16	☐	BWASL	BWASL	CHAR	3	0	Asset Transaction Type	*
79	MAP31_COL02	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
80	BOOK_ACQUI	☐	FIAAPT_BOOK_ACQUI	FIAAPT_VAL_APC	DEC	15	2	Book Acquisition amount
81	TAX_ACQUI	☐	FIAAPT_TAX_ACQUI	FIAAPT_VAL_APC	DEC	15	2	Tax Acquisition Amount
82	PROP_DEP_31_ED00	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
83	SIGN1	☐			CHAR	1	0
84	ACC_CAPITAL_GAIN	☐	FIAAPT_CAP_GAIN	FIAAPT_CAP_GAIN	DEC	15	2	Capital gain
85	CAP_GAIN_NOT_TAXED	☐	FIAAPT_CAP_GAIN	FIAAPT_CAP_GAIN	DEC	15	2	Capital gain
86	MAP31_COL10	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
87	CDDMO	☐	FIAAPT_CDDMO	FIAAPT_CDDMO	DEC	15	2	Cooeficient
88	SIGN2	☐			CHAR	1	0
89	FIS_CAPITAL_GAIN	☐	FIAAPT_CAP_GAIN	FIAAPT_CAP_GAIN	DEC	15	2	Capital gain
90	USEFUL_LIFE_DEC	☐			DEC	6	2
91	CURR_YR_DEP_BOOK	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
92	ACC_DEP_TAX	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
93	APC_AFTER_RV_EDICT02	☐	FIAAPT_VAL_APC	FIAAPT_VAL_APC	DEC	15	2	Asset Acquisition and Production Cost
94	APC_AFTER_RV_PREV_EDICT	☐	FIAAPT_VAL_APC	FIAAPT_VAL_APC	DEC	15	2	Asset Acquisition and Production Cost
95	APC_AFTER_RV_EDICTXX	☐	FIAAPT_VAL_APC	FIAAPT_VAL_APC	DEC	15	2	Asset Acquisition and Production Cost
96	EXP_USE_LIFE_RVYR	☐	FIAAPT_USE_LIFE	JARAF	NUMC	3	0	Useful life (Expired, remaining, total)
97	REM_USE_LIFE_RVYR	☐	FIAAPT_USE_LIFE	JARAF	NUMC	3	0	Useful life (Expired, remaining, total)
98	COM_USE_LIFE	☐	FIAAPT_USE_LIFE	JARAF	NUMC	3	0	Useful life (Expired, remaining, total)
99	USEFUL_LIFE	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
100	TAX_RATE_33_COL10	☐	FIAAPT_TAX_RATE	FIAAPT_TXPA_RATE	DEC	5	2	Tax Rate
101	ACC_DEP	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
102	TAX_RATE	☐	FIAAPT_TAX_RATE	FIAAPT_TXPA_RATE	DEC	5	2	Tax Rate
103	TOT_DEP	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
104	VAL_AFTER_DEP	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
105	TAX_EXMPT_AMT	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
106	AMOUNT_FOREGONE	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
107	RV_DEP_AMT	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
108	REVAL_COEF	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
109	CURR_YR_DEP_TAX	☐	FIAAPT_DEP	FIAAPT_DEP	DEC	15	2	Depreciation
110	UNPL_DEP_IMPAIR	☐	FIAAPT_UNPL_DEP	FIAAPT_DEP	DEC	15	2	Unplanned Depreciation
111	TXPA_ACC_RATE	☐	FIAAPT_TXPA_RATE	FIAAPT_TXPA_RATE	DEC	5	2	Tax Rate
112	MAP32_COL15	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais
113	MAP32_COL16	☐	FIAAPT_VAL	FIAAPT_VAL_APC	DEC	15	2	Value field for mapas fiscais

History

Last changed by/on	SAP	20131127
SAP Release Created in