P_MstrProjActualsInProjCrcy

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
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
ActlCostInProjCrcy Amount in Company Code Currency
ActualRevenueInProjCrcy Amount in Company Code Currency
StrtToDteActlCostInCOCrcy Amount in Company Code Currency
StrtToDteActlRevnInCOCrcy Amount in Company Code Currency
StrtToDteActlCostInProjCrcy Amount in Company Code Currency
StrtToDteActlRevnInProjCrcy 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
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
AccoutAssgmntObj null
WBSElementObject Object number J_OBJNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
PersonnelNumber Personnel Number PERNR
SalesOrderItem Sales Order Item POSNR
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
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_MSTRPROJACTUALSINPROJCRCY.MANDT == T006.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == TGSB.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == T001.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_MSTRPROJACTUALSINPROJCRCY.CONTROLLINGAREA == TKA01.KOKRS
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == SKB1.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.GLACCOUNT == SKB1.SAKNR
  • P_MSTRPROJACTUALSINPROJCRCY.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.GLOBALCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == MARA.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == T001W.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.PLANT == T001W.WERKS
Transaction Currency
  • Client
  • Transaction Currency
  • P_MSTRPROJACTUALSINPROJCRCY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALSINPROJCRCY.TRANSACTIONCURRENCY == TCURC.WAERS