P_MPJOURNALENTRY

CDS View
27 Fields 4 CDS Views

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_MstrProjActualRevCost view inner COMPOSITE
P_MstrProjCtrlgObjActlRevCost view left_outer COMPOSITE
P_MstrProjHierActlCostRev view inner COMPOSITE
P_MstrProjSalesOrdActuals view inner COMPOSITE

Fields (27)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 4
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 4
AmountInGlobalCurrency AmountInGlobalCurrency 4
BaseUnit BaseUnit 4
BusinessArea BusinessArea 4
CompanyCode CompanyCode 4
CompanyCodeCurrency CompanyCodeCurrency 4
ControllingArea ControllingArea 4
ControllingObjectCurrency ControllingObjectCurrency 4
ControllingObjectDebitType ControllingObjectDebitType 4
DocumentDate DocumentDate 2
FiscalPeriod FiscalPeriod 4
FiscalYear FiscalYear 4
FiscalYearPeriod FiscalYearPeriod 4
GLAccount GLAccount 4
GlobalCurrency GlobalCurrency 4
IsReversed IsReversed 2
LedgerGLLineItem LedgerGLLineItem 1
Material Material 2
OriginCostCtrActivityType OriginCostCtrActivityType 2
PersonnelNumber PersonnelNumber 4
Plant Plant 2
PostingDate PostingDate 4
Quantity Quantity 4
SalesOrder SalesOrder 4
SalesOrderItem SalesOrderItem 4
TransactionCurrency TransactionCurrency 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_MPJOURNALENTRY (
    ACCOUNTINGDOCUMENT,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    BASEUNIT,
    BUSINESSAREA,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLLINGOBJECTDEBITTYPE,
    DOCUMENTDATE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    GLACCOUNT,
    GLOBALCURRENCY,
    ISREVERSED,
    LEDGERGLLINEITEM,
    MATERIAL,
    ORIGINCOSTCTRACTIVITYTYPE,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    QUANTITY,
    SALESORDER,
    SALESORDERITEM,
    TRANSACTIONCURRENCY
);

Learn More