P_MX_JRNLENTRITMINVCDETAILS

CDS View
3 Fields 9 CDS Views

OperationalAcct with mexico invoice data

P_MX_JRNLENTRITMINVCDETAILS is a CDS View in S/4HANA. OperationalAcct with mexico invoice data. It contains 3 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
P_MX_InvcDescAmt view from CONSUMPTION Amount and description
P_MX_JrnlEntrForeignCompDets view from CONSUMPTION MX JE Foreign Compensation Details
P_MX_JrnlEntrForeignCompDets view inner CONSUMPTION MX JE Foreign Compensation Details
P_MX_JrnlEntrItmInvcCompType view inner CONSUMPTION Select Compesantion type for the document
P_MX_JrnlEntrItmInvcCompType view union_all CONSUMPTION Select Compesantion type for the document
P_MX_JrnlEntrNationalCompDets view from CONSUMPTION MX JE National Compensation Details
P_MX_JrnlEntrNationalCompDets view inner CONSUMPTION MX JE National Compensation Details
P_MX_JrnlEntrNationalCompDets view union_all CONSUMPTION MX JE National Compensation Details
P_MX_PaytDescAmt view from CONSUMPTION Amount and description

Fields (3)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 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.

-- OperationalAcct with mexico invoice data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MX_JRNLENTRITMINVCDETAILS (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More