Friday, May 24, 2024

SAP Table AUAK – Document Header for Settlement

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