I_MstrProjActlCostQty

Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
Column Name Description
AccountingDocumentStatus null
ActualCostAmount Amount in Company Code Currency
ActualRevenueAmount Amount in Company Code Currency
ActlCostInCoCodeCrcy Amount in Company Code Currency
ActlRevnInCoCodeCrcy Amount in Company Code Currency
ActualCostInObjectCrcy Amount in Company Code Currency
ActualRevenueInObjectCrcy Amount in Company Code Currency
ActualCostInTransCrcy Amount in Company Code Currency
ActualRevenueInTransCrcy Amount in Company Code Currency
ActlCostInProjCrcy Amount in Company Code Currency
ActlRevnInProjCrcy Amount in Company Code Currency
ActlCostInPlnCrcy Amount in Company Code Currency
ActualRevenueInPlnCrcy Amount in Company Code Currency
PerdActlCostInCOCrcy Amount in Company Code Currency
PerdActlRevnInCOCrcy Amount in Company Code Currency
PerdActlCostInCCCrcy Amount in Company Code Currency
PerdActlRevnInCCCrcy Amount in Company Code Currency
PerdActlCostInObjCrcy Amount in Company Code Currency
PerdActlRevnInObjCrcy Amount in Company Code Currency
PerdActlCostInTransCrcy Amount in Company Code Currency
PerdActlRevnInTransCrcy Amount in Company Code Currency
PerdActlCostInProjCrcy Amount in Company Code Currency
PerdActlRevnProjCrcy Amount in Company Code Currency
PerdActlCostInPlnCrcy Amount in Company Code Currency
PerdActlRevnInPlnCrcy Amount in Company Code Currency
StrtToDteActlCostInCOCrcy Amount in Company Code Currency
StrtToDteActlRevnInCOCrcy Amount in Company Code Currency
StrtToDteActlCostInCCCrcy Amount in Company Code Currency
StrtToDteActlRevnInCCCrcy Amount in Company Code Currency
StrtToDteActlCostInObjCrcy Amount in Company Code Currency
StrtToDteActlRevnInObjCrcy Amount in Company Code Currency
StrtToDteActlCostInTC Amount in Company Code Currency
StrtToDteActlRevnInTC Amount in Company Code Currency
StrtToDteActlCostInPlnCrcy Amount in Company Code Currency
StrtToDteActlRevnInPlnCrcy Amount in Company Code Currency
StrtToDteActlCostInProjCrcy Amount in Company Code Currency
StrtToDteActlRevnInProjCrcy Amount in Company Code Currency
UnbilledRevnInCtrlArCrcy Amount in Company Code Currency
UnbilledRevnInObjAreaCrcy Amount in Company Code Currency
UnbilledRevnInTransCrcy Amount in Company Code Currency
Column Name Description
Quantity null
PerdActualQuantity null
StrtToDteActualQuantity null
WIPQuantity Quantity
Column Name Description
MstrProjPerdStrtDte Period KPI Start Date
MstrProjPerdEndDte Period KPI End Date
MstrProjCutOffDate Cut-Off Date
PostingDate Posting 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
MasterProjectType Commercial Project Type /CPD/PWS_WS_MP_TYPE
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
MstrProjAnchorObjectInternalID External Object Technical Key IAOM_OBJECT_KEY
AccountingDocument Journal Entry BELNR
ClearingAccountingDocument Clearing Document Number BELNR
ControllingObject null
ControllingObjectExternalID null
ControllingObjectType Master Project: Related Business Object Type /CPD/PWS_WS_MP_REL_OBJ
StatisticalKeyFigure null
PersonnelNumber null
SalesOrderItem Sales Order Item POSNR
FinancialPlanID External ID for Financial Plan
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
MstrProjKeyFigElmnt Key Figure Element /CPD/AVR_ELEM
MstrProjResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
MstrProjRsceID Resource ID /CPD/PFP_RESOURCE_ID
YearMonth null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MSTRPROJACTLCOSTQTY.MANDT == T006.MANDT
  • I_MSTRPROJACTLCOSTQTY.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • I_MSTRPROJACTLCOSTQTY.BUSINESSAREA == TGSB.GSBER
  • I_MSTRPROJACTLCOSTQTY.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_MSTRPROJACTLCOSTQTY.COMPANYCODE == T001.BUKRS
  • I_MSTRPROJACTLCOSTQTY.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_MSTRPROJACTLCOSTQTY.COMPANYCODECURRENCY == TCURC.WAERS
  • I_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_MSTRPROJACTLCOSTQTY.CONTROLLINGAREA == TKA01.KOKRS
  • I_MSTRPROJACTLCOSTQTY.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • I_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
  • I_MSTRPROJACTLCOSTQTY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Plan Currency
  • Plan Currency
  • Client
  • I_MSTRPROJACTLCOSTQTY.FINANCIALPLANCURRENCY == TCURC.WAERS
  • I_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_MSTRPROJACTLCOSTQTY.GLACCOUNT == SKB1.SAKNR
  • I_MSTRPROJACTLCOSTQTY.COMPANYCODE == SKB1.BUKRS
  • I_MSTRPROJACTLCOSTQTY.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
  • I_MSTRPROJACTLCOSTQTY.GLOBALCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_MSTRPROJACTLCOSTQTY.MASTERPROJECTFISCALYEARVARIANT == T009.PERIV
  • I_MSTRPROJACTLCOSTQTY.MANDT == T009.MANDT
Material Number
  • Material Number
  • Client
  • I_MSTRPROJACTLCOSTQTY.MATERIAL == MARA.MATNR
  • I_MSTRPROJACTLCOSTQTY.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • I_MSTRPROJACTLCOSTQTY.PLANT == T001W.WERKS
  • I_MSTRPROJACTLCOSTQTY.MANDT == T001W.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • I_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
  • I_MSTRPROJACTLCOSTQTY.TRANSACTIONCURRENCY == TCURC.WAERS