AUAK
Document Header for Settlement
AUAK is an SAP database table in S/4HANA. Document Header for Settlement. It contains 38 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCO_ABR_SETLDOCTOTAL | view_entity | from | Settlement documents total | |
| I_CtrlgSettlementDocument | view | from | BASIC | Settlement Document Header |
Fields (38)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | belnr | AA_BELNR | Document Number | |||
| kokrs | KOKRS | CO Area | ||||
| budat | CO_BUDAT | Posting Date | ||||
| bzdat | BZDAT | Asset Val. Date | ||||
| cpudt | CO_CPUDT | Created on | ||||
| wsdat | WSDAT | Value Date | ||||
| kurst | KURST | Exch. Rate Type | ||||
| gjahr | ABR_GJAHR | Settlement Year | ||||
| perio | ABR_PERIO | Settlement Period | ||||
| perbz | PERBZ_LD | Settlement Type | ||||
| objnr | J_OBJNR | Object number | ||||
| stflg | CO_STFLG | Reversal doc. | ||||
| stbel | AA_STBEL | Reversed Doc. | ||||
| stokz | CO_STOKZ | Reversed | ||||
| absch | BRGABSCH | Alloc.Structure | ||||
| ursch | URSCH | Source Struct. | ||||
| gmeng | BRGGMENG | Total Quantity | ||||
| geinh | GEINH | Total Qty Unit | ||||
| analg | ANALG | PropSettlement | ||||
| abrnr | ABRNR | Settlement No. | ||||
| kstar | ABRKSTAR | S. Cost Element | ||||
| ersch | ERSCH | PA Trans. Str. | ||||
| saprl | SAPRL | SAP Release | ||||
| awsys | LOGSYSTEM | Logical System | ||||
| co_vaart | CO_VAART | Processing Type | ||||
| buperio | COBU_PERIO | Posting Period | ||||
| bugjahr | GJAHR | Fiscal Year | ||||
| timestmp | RKE_HZSTMP | Time created | ||||
| perio_f | CO_PERAB | From Period | ||||
| perio_t | CO_PERBI | to | ||||
| versn | VERSN | Version | ||||
| wrttp | CO_WRTTP | Value Type | ||||
| bldat | CO_BLDAT | Document Date | ||||
| addcurr | ABR_ADDCURR | Currencies/Ldgs | ||||
| lednr | FINS_LEDGER | Ledger | ||||
| ldgrp | FAGL_LDGRP | Ledger Group | ||||
| periv | PERIV | FY Variant |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Document Header for Settlement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUAK (
MANDT, -- Client [MANDT]
BELNR, -- Document Number [AA_BELNR]
KOKRS, -- CO Area [KOKRS]
BUDAT, -- Posting Date [CO_BUDAT]
BZDAT, -- Asset Val. Date [BZDAT]
CPUDT, -- Created on [CO_CPUDT]
WSDAT, -- Value Date [WSDAT]
KURST, -- Exch. Rate Type [KURST]
GJAHR, -- Settlement Year [ABR_GJAHR]
PERIO, -- Settlement Period [ABR_PERIO]
PERBZ, -- Settlement Type [PERBZ_LD]
OBJNR, -- Object number [J_OBJNR]
STFLG, -- Reversal doc. [CO_STFLG]
STBEL, -- Reversed Doc. [AA_STBEL]
STOKZ, -- Reversed [CO_STOKZ]
ABSCH, -- Alloc.Structure [BRGABSCH]
URSCH, -- Source Struct. [URSCH]
GMENG, -- Total Quantity [BRGGMENG]
GEINH, -- Total Qty Unit [GEINH]
ANALG, -- PropSettlement [ANALG]
ABRNR, -- Settlement No. [ABRNR]
KSTAR, -- S. Cost Element [ABRKSTAR]
ERSCH, -- PA Trans. Str. [ERSCH]
SAPRL, -- SAP Release [SAPRL]
AWSYS, -- Logical System [LOGSYSTEM]
CO_VAART, -- Processing Type [CO_VAART]
BUPERIO, -- Posting Period [COBU_PERIO]
BUGJAHR, -- Fiscal Year [GJAHR]
TIMESTMP, -- Time created [RKE_HZSTMP]
PERIO_F, -- From Period [CO_PERAB]
PERIO_T, -- to [CO_PERBI]
VERSN, -- Version [VERSN]
WRTTP, -- Value Type [CO_WRTTP]
BLDAT, -- Document Date [CO_BLDAT]
ADDCURR, -- Currencies/Ldgs [ABR_ADDCURR]
LEDNR, -- Ledger [FINS_LEDGER]
LDGRP, -- Ledger Group [FAGL_LDGRP]
PERIV, -- FY Variant [PERIV]
PRIMARY KEY (MANDT, BELNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA