P_MPJournalEntry

Master Project Journal Entry Item | view: PMPJRNLENTY | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Tables used: ACDOCAFINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
ValuationQuantity Valuation Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
WBSElement WBS Element FIS_WBS
PersonnelNumber Personnel Number PERNR
SalesOrderItem Sales Order Item POSNR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MPJOURNALENTRY.MANDT == T006.MANDT
  • P_MPJOURNALENTRY.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_MPJOURNALENTRY.BUSINESSAREA == TGSB.GSBER
  • P_MPJOURNALENTRY.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • P_MPJOURNALENTRY.MANDT == T001.MANDT
  • P_MPJOURNALENTRY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MPJOURNALENTRY.MANDT == TCURC.MANDT
  • P_MPJOURNALENTRY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_MPJOURNALENTRY.MANDT == TKA01.MANDT
  • P_MPJOURNALENTRY.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • Client
  • CO Object Currency
  • P_MPJOURNALENTRY.MANDT == TCURC.MANDT
  • P_MPJOURNALENTRY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_MPJOURNALENTRY.MANDT == SKB1.MANDT
  • P_MPJOURNALENTRY.GLACCOUNT == SKB1.SAKNR
  • P_MPJOURNALENTRY.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_MPJOURNALENTRY.MANDT == TCURC.MANDT
  • P_MPJOURNALENTRY.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Material Number
  • Material Number
  • Client
  • P_MPJOURNALENTRY.MATERIAL == MARA.MATNR
  • P_MPJOURNALENTRY.MANDT == MARA.MANDT
Origin Cost Center Activity Type
  • ?
  • Client
  • Controlling Area
  • Origin Cost Center Activity Type
  • P_MPJOURNALENTRY.[column in domain "DATBI"] == CSLA.DATBI
  • P_MPJOURNALENTRY.MANDT == CSLA.MANDT
  • P_MPJOURNALENTRY.CONTROLLINGAREA == CSLA.KOKRS
  • P_MPJOURNALENTRY.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Plant
  • Client
  • Plant
  • P_MPJOURNALENTRY.MANDT == T001W.MANDT
  • P_MPJOURNALENTRY.PLANT == T001W.WERKS
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Transaction Currency
  • Client
  • Transaction Currency
  • P_MPJOURNALENTRY.MANDT == TCURC.MANDT
  • P_MPJOURNALENTRY.TRANSACTIONCURRENCY == TCURC.WAERS