AUAK is a standard SAP table in SAP ERP (or) S/4HANA which stores Document Header for Settlement data. There are total 38 fields in AUAK table.This blog post provides key technical details of SAP table AUAK, including its availability across SAP S/4HANA versions and the list of CDS views for AUAK table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Appl. Development: R/3 Cost Accounting Order Settlement (KABR) |
| Technical Component | Overhead Cost Orders (CO-OM-OPA) |
SAP AUAK Table Fields
The following is the list of fields that are available in SAP AUAK table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| BELNR | Number of a Settlement Document | AA_BELNR | AA_BELNR | CHAR (10) | |
| KOKRS | Controlling Area | KOKRS | CACCD | TKA01 | CHAR (4) |
| BUDAT | Posting Date | CO_BUDAT | DATUM | DATS (8) | |
| BZDAT | Asset Value Date | BZDAT | DATUM | DATS (8) | |
| CPUDT | Date Document Was Created | CO_CPUDT | DATUM | DATS (8) | |
| WSDAT | Value Date for Currency Translation | WSDAT | DATUM | DATS (8) | |
| KURST | Exchange Rate Type | KURST | KURST | TCURV | CHAR (4) |
| GJAHR | Settlement Year | ABR_GJAHR | GJAHR | NUMC (4) | |
| PERIO | Settlement Period | ABR_PERIO | PERBL | NUMC (3) | |
| PERBZ | Settlement Type | PERBZ_LD | PERBZ_LD | CHAR (3) | |
| OBJNR | Object number | J_OBJNR | J_OBJNR | ONR00 | CHAR (22) |
| STFLG | Identifier for reversal document | CO_STFLG | FLAG | CHAR (1) | |
| STBEL | Document Number of Reversed Document | AA_STBEL | AA_BELNR | AUAK | CHAR (10) |
| STOKZ | Indicator: Document was reversed | CO_STOKZ | FLAG | CHAR (1) | |
| ABSCH | Allocation Structure for Settlement/Assessment | BRGABSCH | ABSCH | TKB5A | CHAR (6) |
| URSCH | Source Structure | URSCH | CO_SCNAM | TKB4A | CHAR (2) |
| GMENG | Total Quantity | BRGGMENG | MENGV8 | QUAN (15) | |
| GEINH | Unit of Measure of Total Quantity | GEINH | MEINS | T006 | UNIT (3) |
| ANALG | Identifier for “Proportional Settlement” | ANALG | XFELD | CHAR (1) | |
| ABRNR | Sequential Settlement Number | ABRNR | INT2 | INT2 (5) | |
| KSTAR | Settlement Cost Element for Receiver | ABRKSTAR | KSTAR | CSKA | CHAR (10) |
| ERSCH | PA Transfer Structure | ERSCH | ERSCH | TKB9A | CHAR (2) |
| SAPRL | SAP Release | SAPRL | SAPRL | CHAR (4) | |
| AWSYS | Logical System | LOGSYSTEM | LOGSYS | TBDLS | CHAR (10) |
| CO_VAART | CO Settlement: Processing Type | CO_VAART | CO_VAART | CHAR (3) | |
| BUPERIO | Posting Period | COBU_PERIO | PERBL | NUMC (3) | |
| BUGJAHR | Fiscal Year | GJAHR | GJAHR | NUMC (4) | |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | RKE_TSTMP | DEC (16) | |
| PERIO_F | From Period | CO_PERAB | PERBL | NUMC (3) | |
| PERIO_T | To period | CO_PERBI | PERBL | NUMC (3) | |
| VERSN | Version | VERSN | COVERSI | CHAR (3) | |
| WRTTP | Value Type | CO_WRTTP | CO_WRTTP | CHAR (2) | |
| BLDAT | Document Date | CO_BLDAT | DATUM | DATS (8) | |
| ADDCURR | Settlement of freely defined currencies & parallel ledgers | ABR_ADDCURR | ABR_ADDCURR | CHAR (1) | |
| LEDNR | Ledger in General Ledger Accounting | FINS_LEDGER | FINS_LEDGER | CHAR (2) | |
| LDGRP | Ledger Group | FAGL_LDGRP | FAGL_LDGRP | CHAR (4) | |
| PERIV | Fiscal Year Variant | PERIV | PERIV | CHAR (2) |
Availability
The SAP table AUAK is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AUAK table
The following is the list of AUAK CDS views, which can also be used instead of AUAK table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_CTRLGSETTLEMENTDOCUMENT | BASIC | Settlement Document Header |
| C_CTRLGSETTLEMENTDOCUMENT | CONSUMPTION | Display Settlement Documents |
| C_RUNSETTLEMENTACTUALPROJECT | CONSUMPTION | Project list for actual settlement |
| C_RUNSETTLMTACTLMAINTORDER | CONSUMPTION | Actual Settlement Maintenance Order |
| C_RUNSETTLMTACTUALSTATISTIC | CONSUMPTION | Run Settlement – Actual |
| C_RUNSETTLMTACTUALWBSELEMENT | CONSUMPTION | Actual Settlement WBS Element |
| C_SETTLEMENTACTUALSETTLEDVALUE | CONSUMPTION | Project list for actual settlement |
| C_SETTLMTACTLSETLDVALPUBSEC | CONSUMPTION | Settled values with public sector fields |
| P_CTRLGSETTLEMENTDOCUMENT | CONSUMPTION | Controlling Settlement Document |
| P_CTRLGSETTLMTDOCMAXDATE | CONSUMPTION | Possible senders for settled object |
| P_CTRLGSETTLMTDOCPROJMAXDATE | CONSUMPTION | Possible senders for settled object |
| P_CTRLGSETTLMTLASTDOC | CONSUMPTION | Possible senders for settled object |
| P_CTRLGSETTLMTLASTDOCNUMBER | CONSUMPTION | Possible senders for settled object |
| P_CTRLGSETTLMTLASTDOCPROJ | CONSUMPTION | Last settlement document for Project |
| P_CTRLGSETTLMTPROJLASTDOCNUMBR | CONSUMPTION | Possible senders for settled object |
| P_SETTLEMENTACTUALSETTLEDVALUE | CONSUMPTION | Possible senders for settled object |
| P_SETTLMTSNDRDOC | CONSUMPTION | Possible senders for settled object |
