SAP table ANKL (Generation table for generating asset classes from accounts)

SAP table ANKL has 4 primary key fields being MANDT,KTOPL,AFAPL,KTO_I.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
AFAPL Chart of Depreciaton for Asset Valuation CHAR 4 0 T096 AFAPL
KTO_I Account Number CHAR 10 0 KTNR_I
STAT_KTOGR Processing Status NUMC 1 0 KZ_STATUS
1 Not processed
2 Partially processed
3 Processed
4 Generated
KTOGR Account Determination CHAR 8 0 KTOGR
KTGRTX Name of Account Determination CHAR 50 0 KTGRTX
KTANSW Bal. Sheet Account: Acquisition and Production Costs CHAR 10 0 SKA1 KTANSW
KTNAFB Accumulated Depreciation Account for Ordinary Depreciation CHAR 10 0 SKA1 KTNAFB
KTNAFG Expense Account for Ordinary Depreciation to Book Val. 0 CHAR 10 0 SKA1 KTNAFG
KTERLW Clearing Account for Revenue from Asset Sale CHAR 10 0 SKA1 KTERLW
KTMIND G/L Account for Asset Retirement Loss CHAR 10 0 SKA1 KTMIND
KTMEHR G/L Account: Asset Retirement Gain CHAR 10 0 SKA1 KTMEHR
STAT_NRKRS Processing Status NUMC 1 0 KZ_STATUS
1 Not processed
2 Partially processed
3 Processed
4 Generated
NRRANGENR Number range number CHAR 2 0 NRNR
FROMNUMBER From number CHAR 20 0 NRFROM
TONUMBER To number CHAR 20 0 NRTO
EXTERNIND Internal (' ') or external ('X') number range flag CHAR 1 0 NRIND
STAT_FELEI Processing Status NUMC 1 0 KZ_STATUS
1 Not processed
2 Partially processed
3 Processed
4 Generated
FELEI Screen Layout for Asset Accounting CHAR 4 0 FELEI
FELEITXT30 Text CHAR 30 0 TXT30
FKANN001 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN002 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN003 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN004 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN005 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN006 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN007 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN008 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN009 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN010 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN011 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN012 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
FKANN013 Flag for Structure CHAR 1 0 FLG_FELEI
Fields in the logical field group are suppressed
X Fields in the logical field group are ready for input
STAT_ANLKL Processing Status NUMC 1 0 KZ_STATUS
1 Not processed
2 Partially processed
3 Processed
4 Generated
ANLKL Asset Class CHAR 8 0 ANLKL
ANLKLTXT50 Asset class description CHAR 50 0 TXT50_ANKT
B1_AFASL Depreciation key CHAR 4 0 T090NA AFASL
B1_NDJAR Planned Useful Life in Years NUMC 3 0 NDJAR
B2_AFASL Depreciation key CHAR 4 0 T090NA AFASL
B2_NDJAR Planned Useful Life in Years NUMC 3 0 NDJAR
B2_WBIND Index series for replacement values CHAR 5 0 T094A WBIND
TYP_ANLKL Type of Asset Class NUMC 1 0 TYP_ANLKL
0 Asset class without AuC/LVA/CLVA
1 AuC Asset class for assets under construction
2 LVA Asset class for low value assets
3 CLVA Asset class for collective low value assets

ANKL foreign key relationships

Table Field Check Table Check Field
0 ANKL AFAPL T096 Chart of depreciation MANDT
1 ANKL B1_AFASL T090NA Depreciation Keys MANDT
1 ANKL B1_AFASL T090NA Depreciation Keys AFAPL
1 ANKL B1_AFASL T090NA Depreciation Keys AFASL
0 ANKL B2_AFASL T090NA Depreciation Keys MANDT
0 ANKL B2_AFASL T090NA Depreciation Keys AFAPL
0 ANKL B2_AFASL T090NA Depreciation Keys AFASL
1 ANKL KTANSW SKA1 G/L Account Master (Chart of Accounts) MANDT
1 ANKL KTANSW SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 ANKL KTANSW SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 ANKL KTERLW SKA1 G/L Account Master (Chart of Accounts) MANDT
0 ANKL KTERLW SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 ANKL KTERLW SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 ANKL KTMEHR SKA1 G/L Account Master (Chart of Accounts) MANDT
1 ANKL KTMEHR SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 ANKL KTMEHR SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 ANKL KTMIND SKA1 G/L Account Master (Chart of Accounts) MANDT
0 ANKL KTMIND SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 ANKL KTMIND SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 ANKL KTNAFB SKA1 G/L Account Master (Chart of Accounts) MANDT
1 ANKL KTNAFB SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 ANKL KTNAFB SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 ANKL KTNAFG SKA1 G/L Account Master (Chart of Accounts) MANDT
0 ANKL KTNAFG SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 ANKL KTNAFG SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 ANKL KTOPL T004 Directory of Charts of Accounts MANDT
0 ANKL MANDT T000 Clients MANDT