P_ACDOCA_CUBE

CDS View
55 Fields 3 CDS Views

P_ACDOCA_CUBE

P_ACDOCA_CUBE is a CDS View in S/4HANA. P_ACDOCA_CUBE. It contains 55 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_EngmntProjJournalEntryItem view from BASIC Engagement Project Journal Entry Item
P_Materialledger_CurTP view from COMPOSITE P_MATERIALLEDGER_CURTP
P_Materialledgercurtp_Bal view from COMPOSITE Curtps , distinct years for balance Summary

Fields (55)

KeyField CDS FieldsUsed in Views
KEY belnr belnr 2
KEY docln docln 2
KEY gjahr gjahr 2
KEY matnr matnr 2
KEY racct racct 2
KEY rbukrs rbukrs 2
KEY rldnr rldnr 2
aufnr aufnr 2
awref awref 2
awtyp awtyp 2
blart blart 2
bldat bldat 2
bstat bstat 1
bttype bttype 2
budat budat 2
bwkey bwkey 2
bwtar bwtar 2
ebeln ebeln 2
fiscyearper fiscyearper 2
hsl hsl 1
hvkwrt hvkwrt 1
kalnr kalnr 2
kokrs kokrs 2
ktopl ktopl 2
ktosl ktosl 2
kzbws kzbws 2
mat_kdauf mat_kdauf 2
mat_kdpos mat_kdpos 2
mat_lifnr mat_lifnr 2
mat_pspnr mat_pspnr 2
mlcateg mlcateg 2
mlptyp mlptyp 2
periv periv 2
poper poper 2
prctr prctr 2
rbcur rbcur 1
rccur rccur 1
rcntr rcntr 2
rdcur rdcur 1
recur recur 1
rfcur rfcur 1
rgcur rgcur 1
rhcur rhcur 2
rkcur rkcur 2
rocur rocur 2
rvcur rvcur 2
rvunit rvunit 2
ryear ryear 2
segment segment 2
sobkz sobkz 2
timestamp timestamp 2
usnam usnam 2
vmsl vmsl 2
werks werks 1
xobew xobew 2

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.

-- P_ACDOCA_CUBE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACDOCA_CUBE (
    BELNR,
    DOCLN,
    GJAHR,
    MATNR,
    RACCT,
    RBUKRS,
    RLDNR,
    AUFNR,
    AWREF,
    AWTYP,
    BLART,
    BLDAT,
    BSTAT,
    BTTYPE,
    BUDAT,
    BWKEY,
    BWTAR,
    EBELN,
    FISCYEARPER,
    HSL,
    HVKWRT,
    KALNR,
    KOKRS,
    KTOPL,
    KTOSL,
    KZBWS,
    MAT_KDAUF,
    MAT_KDPOS,
    MAT_LIFNR,
    MAT_PSPNR,
    MLCATEG,
    MLPTYP,
    PERIV,
    POPER,
    PRCTR,
    RBCUR,
    RCCUR,
    RCNTR,
    RDCUR,
    RECUR,
    RFCUR,
    RGCUR,
    RHCUR,
    RKCUR,
    ROCUR,
    RVCUR,
    RVUNIT,
    RYEAR,
    SEGMENT,
    SOBKZ,
    TIMESTAMP,
    USNAM,
    VMSL,
    WERKS,
    XOBEW,
    PRIMARY KEY (BELNR, DOCLN, GJAHR, MATNR, RACCT, RBUKRS, RLDNR)
);

Learn More