SAP ANLQ Period values from dep. posting run per posting level Table
Overview
ANLQ is a standard SAP S/4HANA table that stores Period values from dep. posting run per posting level data. There are total 35 fields in the ANLQ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ANLQ belongs to Basic Functions (FI-AA-AA) module and is located in the package Assets: Master Data (AA).
In addition, following links provide an overview of foreign key relationships, if any, that link ANLQ to other SAP tables and standard CDS views available based on ANLQ table in S/4HANA 2020.
Techincal Settings of ANLQ
Below are technical details of the table ANLQ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ANLQ Fields
The following table gives you an overview of the fields available in ANLQ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| BUKRS | Company Code | BUKRS | FAAV_COMP_CODE | CHAR | 4 |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| PERAF | Posting Period of Depreciation | PERAF | NUMC | 3 | |
| KTOGR | Account Determination | KTOGR | T095A | CHAR | 8 |
| FKBER | Functional Area | FKBER | TFKB | CHAR | 16 |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| CAUFN | Internal Order | CAUFN | AUFK | CHAR | 12 |
| LSTAR | Activity Type | LSTAR | CSLA | CHAR | 6 |
| AFBNR | Sequence Number of Depreciation Posting Run in the Period | AFBNR | NUMC | 2 | |
| AFABER | Depreciation Area Real or Derived | AFABER | FAAV_DEPR_AREA | NUMC | 2 |
| AUFWP | Planned Revaluation on Replacement Value | AUFWP | CURR | 23 | |
| AUFWB | Revaluation Posted on Replacement Value | AUFWB | CURR | 23 | |
| AUFWZ | Revaluation on Replacement Value to Be Posted | AUFWZ | CURR | 23 | |
| NAFAP | Planned Ordinary Depreciation for the Year | NAFAP | CURR | 23 | |
| NAFAG | Ordinary Depreciation Posted in the Current Year | NAFAG | CURR | 23 | |
| NAFAZ | Ordinary Depreciation to Be Posted | NAFAZ | CURR | 23 | |
| SAFAP | Planned Special Depreciation for the Year | SAFAP | CURR | 23 | |
| SAFAG | Special Depreciation Posted in the Current Fiscal Year | SAFAG | CURR | 23 | |
| SAFAZ | Special Depreciation to Be Posted | SAFAZ | CURR | 23 | |
| AAFAP | Scheduled Unplanned Depreciation for the Year | AAFAP | CURR | 23 | |
| AAFAG | Unplanned Depreciation Posted for the Year | AAFAG | CURR | 23 | |
| AAFAZ | Unplanned Depreciation to Be Posted | AAFAZ | CURR | 23 | |
| MAFAP | Planned Transfer of Reserves for the Year | MAFAP | CURR | 23 | |
| MAFAG | Acquisition Value Reducing Depreciation Posted for the Year | MAFAG | CURR | 23 | |
| MAFAZ | Transferred Reserves to Be Posted for the Year | MAFAZ | CURR | 23 | |
| ZINSP | Interest Planned for the Year | DZINSP | CURR | 23 | |
| ZINSG | Interest Posted for the Year | DZINSG | CURR | 23 | |
| ZINSZ | Interest for the Year to Be Posted | DZINZB | CURR | 23 | |
| AUFNP | Planned Revaluation of Accumulated Ordinary Depreciation | AUFNP | CURR | 23 | |
| AUFNG | Posted Revaluation of Accumulated Ordinary Depreciation | AUFNG | CURR | 23 | |
| AUFNZ | Revaluation to Be Posted on Cum. Ordinary Depreciation | AUFNZ | CURR | 23 | |
| BELNR | Document number of a depreciation posting document | AFA_BLNR | CHAR | 10 | |
| ANUPD | Indicator: Type of change to table | ANUPD | CHAR | 1 |
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 ANLQ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ANLQ | AFABER | 1: CN | FAAV_DEPR_AREA |
| ANLQ | BUKRS | 1: CN | FAAV_COMP_CODE |
| ANLQ | CAUFN | C: CN | AUFK |
| ANLQ | FKBER | C: CN | TFKB |
| ANLQ | GSBER | C: CN | TGSB |
| ANLQ | KOSTL | : | CSKS |
| ANLQ | KTOGR | 1: CN | T095A |
| ANLQ | LSTAR | : | CSLA |