P_MstrProjActualRevCost

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
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
TotalQuantity null
ActlEffortQty Valuation Quantity
Column Name Description
PostingDate Posting Date
Column Name Description
ControllingObjectDebitType Controlling Object Debit Type 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
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
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MSTRPROJACTUALREVCOST.MANDT == T006.MANDT
  • P_MSTRPROJACTUALREVCOST.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_MSTRPROJACTUALREVCOST.BUSINESSAREA == TGSB.GSBER
  • P_MSTRPROJACTUALREVCOST.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • P_MSTRPROJACTUALREVCOST.MANDT == T001.MANDT
  • P_MSTRPROJACTUALREVCOST.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MSTRPROJACTUALREVCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALREVCOST.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_MSTRPROJACTUALREVCOST.CONTROLLINGAREA == TKA01.KOKRS
  • P_MSTRPROJACTUALREVCOST.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • P_MSTRPROJACTUALREVCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALREVCOST.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_MSTRPROJACTUALREVCOST.GLACCOUNT == SKB1.SAKNR
  • P_MSTRPROJACTUALREVCOST.MANDT == SKB1.MANDT
  • P_MSTRPROJACTUALREVCOST.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_MSTRPROJACTUALREVCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALREVCOST.GLOBALCURRENCY == TCURC.WAERS
Transaction Currency
  • Transaction Currency
  • Client
  • P_MSTRPROJACTUALREVCOST.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_MSTRPROJACTUALREVCOST.MANDT == TCURC.MANDT