P_JRNLENTRADDLCLRGINFORMATION

CDS View
3 Fields 6 CDS Views

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

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_MX_JournalEntryPaymentItem view inner CONSUMPTION
P_MX_JrnlEntrForeignCompDets view union_all CONSUMPTION
P_MX_JrnlEntrItmInvcCompType view from CONSUMPTION
P_MX_JrnlEntrItmInvcCompType view union_all CONSUMPTION
P_MX_JrnlEntrNationalCompDets view union_all CONSUMPTION
P_MX_JrnlEntrOtherCompDets view union_all CONSUMPTION

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ClearingAccountingDocument AccountingDocument 4
KEY ClearingCompanyCode CompanyCode 4
KEY ClearingDocFiscalYear ClearingDocFiscalYear,FiscalYear 4

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_JRNLENTRADDLCLRGINFORMATION (
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGCOMPANYCODE,
    CLEARINGDOCFISCALYEAR,
    PRIMARY KEY (CLEARINGACCOUNTINGDOCUMENT, CLEARINGCOMPANYCODE, CLEARINGDOCFISCALYEAR)
);

Learn More