P_MX_JOURNALENTRYGRHISTORY2

CDS View
2 Fields 2 CDS Views

P_MX_JOURNALENTRYGRHISTORY2 is a CDS View in S/4HANA. It contains 2 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MX_JrnlEntrItmInvcCompType view inner CONSUMPTION
P_MX_JrnlEntrNationalCompDets view inner CONSUMPTION

Fields (2)

KeyField CDS FieldsUsed in Views
KEY MaterialDocumentNumber AccountingDocument 2
KEY MaterialDocumentYear FiscalYear 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MX_JOURNALENTRYGRHISTORY2 (
    MATERIALDOCUMENTNUMBER,
    MATERIALDOCUMENTYEAR,
    PRIMARY KEY (MATERIALDOCUMENTNUMBER, MATERIALDOCUMENTYEAR)
);

Learn More