P_MstrProjHierActlCostRev

Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
AccountingDocumentStatus null
ActualRevenueAmount Amount in Company Code Currency
ActualCostAmount Amount in Company Code Currency
ActlRevnInCoCodeCrcy Amount in Company Code Currency
ActlCostInCoCodeCrcy Amount in Company Code Currency
ActualRevenueInObjectCrcy Amount in Company Code Currency
ActualCostInObjectCrcy Amount in Company Code Currency
ActualRevenueInTransCrcy Amount in Company Code Currency
ActualCostInTransCrcy Amount in Company Code Currency
StrtToDteActlCostInCOCrcy Amount in Company Code Currency
StrtToDteActlRevnInCOCrcy Amount in Company Code Currency
ActlCostInProjCrcy Amount in Company Code Currency
ActlCostInPlnCrcy Amount in Company Code Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
TotalQuantity null
ActlEffortQty Valuation Quantity
Column Name Description
PostingDate Posting Date
MstrProjPerdStrtDte Period KPI Start Date
MstrProjPerdEndDte Period KPI End Date
MstrProjCutOffDate Cut-Off Date
DocumentDate Journal Entry Date
Column Name Description
ControllingObjectDebitType Controlling Object Debit Type Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
ControllingObject null
ControllingObjectExternalID null
ControllingObjectType Master Project: Related Business Object Type /CPD/PWS_WS_MP_REL_OBJ
StatisticalKeyFigure null
ExternalObjectIdentifier External Object Technical Key IAOM_OBJECT_KEY
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
PersonnelNumber Personnel Number PERNR
SalesOrderItem Sales Order Item POSNR
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
FinancialPlanID External ID for Financial Plan
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
MstrProjAnchorObjectInternalID External Object Technical Key IAOM_OBJECT_KEY
AccountingDocument Journal Entry BELNR
ClearingAccountingDocument Clearing Document Number BELNR
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == T006.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TGSB.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == T001.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TCURC.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TKA01.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • Client
  • CO Object Currency
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TCURC.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Plan Currency
  • Plan Currency
  • Client
  • P_MSTRPROJHIERACTLCOSTREV.FINANCIALPLANCURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TCURC.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == SKB1.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.COMPANYCODE == SKB1.BUKRS
  • P_MSTRPROJHIERACTLCOSTREV.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TCURC.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.GLOBALCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_MSTRPROJHIERACTLCOSTREV.MASTERPROJECTFISCALYEARVARIANT == T009.PERIV
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == T009.MANDT
Material Number
  • Client
  • Material Number
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == MARA.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.MATERIAL == MARA.MATNR
Origin Cost Center Activity Type
  • Client
  • ?
  • Origin Cost Center Activity Type
  • Controlling Area
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == CSLA.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.[column in domain "DATBI"] == CSLA.DATBI
  • P_MSTRPROJHIERACTLCOSTREV.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_MSTRPROJHIERACTLCOSTREV.CONTROLLINGAREA == CSLA.KOKRS
Plant
  • Client
  • Plant
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == T001W.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.PLANT == T001W.WERKS
Check for existence in table T006
  • Client
  • Unit for Statistical Key Figure
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == T006.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.STSTCKEYFIGQUANTITYUNIT == T006.MSEHI
Transaction Currency
  • Client
  • Transaction Currency
  • P_MSTRPROJHIERACTLCOSTREV.MANDT == TCURC.MANDT
  • P_MSTRPROJHIERACTLCOSTREV.TRANSACTIONCURRENCY == TCURC.WAERS