P_MstrProjActuals

Master Project Actuals | view: PMPACTUALS | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
ActualRevenue Amount in Company Code Currency
ActualCost Amount in Company Code Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
TotalQuantity null
ActlEffortQty Valuation Quantity
Column Name Description
StartDate Commercial Project: Start Date
EndDate Commercial Project: End Date
PostingDate Posting Date
Column Name Description
WorkType Type of Work Show values
Industry Industry Show values
FinancialRisk Financial Risk Show values
TechnicalRisk Technical Risk Show values
OverallRisk Overall Project Risk Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
Country Country/Region LAND1
Region Region (State, Province, County) REGIO
ProjectRisk Commercial Project Risk CHAR1
MasterProjectItemUUID NodeID /BOBF/CONF_KEY
MasterProjectItem Item Key (Master Project) /CPD/MP_ITM_OKEY
Project Project FIS_PROJECT
WBSElement WBS Element FIS_WBS
PersonnelNumber Personnel Number PERNR
SalesOrderItem Sales Order Item POSNR
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
AccountingDocument Journal Entry BELNR
ClearingAccountingDocument Clearing Document Number BELNR
AccountingDocumentStatus null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_MSTRPROJACTUALS.BASEUNIT == T006.MSEHI
  • P_MSTRPROJACTUALS.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • P_MSTRPROJACTUALS.BUSINESSAREA == TGSB.GSBER
  • P_MSTRPROJACTUALS.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • P_MSTRPROJACTUALS.COMPANYCODE == T001.BUKRS
  • P_MSTRPROJACTUALS.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_MSTRPROJACTUALS.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MSTRPROJACTUALS.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_MSTRPROJACTUALS.CONTROLLINGAREA == TKA01.KOKRS
  • P_MSTRPROJACTUALS.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • P_MSTRPROJACTUALS.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALS.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • P_MSTRPROJACTUALS.COMPANYCODE == SKB1.BUKRS
  • P_MSTRPROJACTUALS.GLACCOUNT == SKB1.SAKNR
  • P_MSTRPROJACTUALS.MANDT == SKB1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_MSTRPROJACTUALS.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_MSTRPROJACTUALS.MANDT == TCURC.MANDT