SAP ANKL Generation table for generating asset classes from accounts Table

Overview

ANKL is a standard SAP S/4HANA table that stores Generation table for generating asset classes from accounts data. There are total 43 fields in the ANKL table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ANKL belongs to Basic Functions (FI-AA-AA) module and is located in the package Asset Accounting: Customizing (AC).

In addition, following links provide an overview of foreign key relationships, if any, that link ANKL to other SAP tables and standard CDS views available based on ANKL table in S/4HANA 2020.

Techincal Settings of ANKL

Below are technical details of the table ANKL

  • Buffering allowed but switched off
  • Full table is passed to buffer
  • Storage type is Column Store

List of ANKL Fields

The following table gives you an overview of the fields available in ANKL

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
KTOPLChart of AccountsKTOPLT004CHAR4
AFAPLChart of depreciaton for asset valuationAFAPLT096CHAR4
KTO_IAccount NumberKTNR_I*CHAR10
STAT_KTOGRProcessing StatusKZ_STATUSNUMC1
KTOGRAccount DeterminationKTOGR*CHAR8
KTGRTXName of Account DeterminationKTGRTXCHAR50
KTANSWBal. Sheet Account: Acquisition and Production CostsKTANSWSKA1CHAR10
KTNAFBAccumulated Depreciation Account for Ordinary DepreciationKTNAFBSKA1CHAR10
KTNAFGExpense Account for Ordinary Depreciation to Book Val. 0KTNAFGSKA1CHAR10
KTERLWClearing Account for Revenue from Asset SaleKTERLWSKA1CHAR10
KTMINDG/L Account for Asset Retirement LossKTMINDSKA1CHAR10
KTMEHRG/L Account: Asset Retirement GainKTMEHRSKA1CHAR10
STAT_NRKRSProcessing StatusKZ_STATUSNUMC1
NRRANGENRNumber range numberNRNRCHAR2
FROMNUMBERFrom numberNRFROMCHAR20
TONUMBERTo numberNRTOCHAR20
EXTERNINDInternal (' ') or external ('X') number range flagNRINDCHAR1
STAT_FELEIProcessing StatusKZ_STATUSNUMC1
FELEIScreen Layout for Asset AccountingFELEI*CHAR4
FELEITXT30TextTXT30CHAR30
FKANN001Flag for StructureFLG_FELEICHAR1
FKANN002Flag for StructureFLG_FELEICHAR1
FKANN003Flag for StructureFLG_FELEICHAR1
FKANN004Flag for StructureFLG_FELEICHAR1
FKANN005Flag for StructureFLG_FELEICHAR1
FKANN006Flag for StructureFLG_FELEICHAR1
FKANN007Flag for StructureFLG_FELEICHAR1
FKANN008Flag for StructureFLG_FELEICHAR1
FKANN009Flag for StructureFLG_FELEICHAR1
FKANN010Flag for StructureFLG_FELEICHAR1
FKANN011Flag for StructureFLG_FELEICHAR1
FKANN012Flag for StructureFLG_FELEICHAR1
FKANN013Flag for StructureFLG_FELEICHAR1
STAT_ANLKLProcessing StatusKZ_STATUSNUMC1
ANLKLAsset ClassANLKL*CHAR8
ANLKLTXT50Asset class descriptionTXT50_ANKTCHAR50
B1_AFASLDepreciation keyAFASLT090NACHAR4
B1_NDJARPlanned Useful Life in YearsNDJARNUMC3
B2_AFASLDepreciation keyAFASLT090NACHAR4
B2_NDJARPlanned Useful Life in YearsNDJARNUMC3
B2_WBINDIndex series for replacement valuesWBINDT094ACHAR5
TYP_ANLKLType of Asset ClassTYP_ANLKLNUMC1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ANKL

Table NameFieldCardinalityCheck Table
ANKLAFAPL1: CNT096
ANKLB1_AFASL1: CNT090NA
ANKLB2_AFASL1: CNT090NA
ANKLB2_WBIND1: CNT094A
ANKLKTANSWC: CNSKA1
ANKLKTERLWC: CNSKA1
ANKLKTMEHRC: CNSKA1
ANKLKTMINDC: CNSKA1
ANKLKTNAFBC: CNSKA1
ANKLKTNAFGC: CNSKA1
ANKLKTOPL1: CNT004
ANKLMANDT1: CNT000

Other References