AUAK

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
FCO_ABR_SETLDOCTOTAL view_entity from Settlement documents total
I_CtrlgSettlementDocument view from BASIC Settlement Document Header

Fields (38)

KeyField Data ElementDescription DomainTypeLength
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)
);