_ACDOCA

_ACDOCA is an SAP database table in S/4HANA. It contains 50 fields.

Fields (50)

KeyField CDS FieldsUsed in Views
aufnr aufnr 1
augbl augbl,ClearingAccountingDocument 2
augdt augdt,ClearingDate 2
awref ReferenceDocument 1
awtyp awtyp 1
belnr AccountingDocument 2
brsch brsch 1
bstat bstat 1
budat budat 1
bzirk bzirk 1
docln LedgerGLLineItem 2
fkart fkart 1
gjahr FiscalYear 2
glaccount_type glaccount_type 1
kdgrp kdgrp 1
koart FinancialAccountType 1
kokrs kokrs 1
konzs konzs 1
ktosl ktosl 1
kunnr kunnr 1
kunre kunre 1
kunwe kunwe 1
land1 land1 1
lifnr lifnr 1
matkl matkl 1
matkl_mm matkl_mm 1
matnr matnr 1
matnr_copa matnr_copa 1
netdt NetDueDate 1
poper poper 1
pprctr pprctr 1
ps_posid ps_posid 1
ps_psp_pnr ps_psp_pnr 1
ps_pspid ps_pspid 1
psegment psegment 1
rassc rassc 1
rbukrs SourceCompanyCode 2
rldnr Ledger,SourceLedger 2
sbusa sbusa 1
scntr scntr 1
sfarea sfarea 1
slalittype slalittype 1
spart spart 1
timestamp Timestamp 3
vkorg vkorg 1
vorgn vorgn 1
vornr vornr 1
vtweg vtweg 1
werks werks 1
zuonr zuonr 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ACDOCA (
    AUFNR,
    AUGBL,
    AUGDT,
    AWREF,
    AWTYP,
    BELNR,
    BRSCH,
    BSTAT,
    BUDAT,
    BZIRK,
    DOCLN,
    FKART,
    GJAHR,
    GLACCOUNT_TYPE,
    KDGRP,
    KOART,
    KOKRS,
    KONZS,
    KTOSL,
    KUNNR,
    KUNRE,
    KUNWE,
    LAND1,
    LIFNR,
    MATKL,
    MATKL_MM,
    MATNR,
    MATNR_COPA,
    NETDT,
    POPER,
    PPRCTR,
    PS_POSID,
    PS_PSP_PNR,
    PS_PSPID,
    PSEGMENT,
    RASSC,
    RBUKRS,
    RLDNR,
    SBUSA,
    SCNTR,
    SFAREA,
    SLALITTYPE,
    SPART,
    TIMESTAMP,
    VKORG,
    VORGN,
    VORNR,
    VTWEG,
    WERKS,
    ZUONR
);