P_MstrProjActlCostQty

Actuals for Master Project | view: PMSTRPROJACTL | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Tables used: VBAP, IAOM_EXT_OBJ_INF, IAOM_EXT_OBJ_INF, /CPD/D_MP_TEAM, /CPD/D_MP_TEAM_R, /CPD/D_MP_TEAM_M, AFKO, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_ITEM, /CPD/D_PFP_PH, /CPD/D_MP_MEMBER, AFKO, AFPO, AFVC, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, PRTE, ACDOCA, BSEG, /CPD/D_MP_HDR, /CPD/D_PFP_PH, /CPD/D_PFP_ANCH, /CPD/D_PFP_PV, COSR, AD01DLI, AD01DLISF, AD01WIP_DTL, BUT0ID, BUT000, USR21, T001, TKA02, TKA01, /SHCM/HRP5092, AUFK, PROJ, TKA01, /S4PPM/HIERARCHY, /S4PPM/TASK, /CPD/PWSC_MPTYP, IAOM_ASSIGNMENTS, /CPD/AVR_RES_EXP, /CPD/PWSC_WSROLE, /CPD/PWSC_ROLPID, AUFK, PROJ, PROJ, CNLDST_SHORTTX, TVKO, T000, TKA03, USR21, PRPS, ADRP, BUT000, BUT0ID, TB039A, TB003, BUT100, T001, T014, /CPD/PWSC_MPTYP, /CPD/FC_VER_TYPE, /CPD/PFP_SKF_EXC, TVTA, FINSC_LEDGER_REP, /CPD/AC_ACC_SUPR, /CPD/AC_PRF_ACC, BPU_ROLECAT_WHL, BPU_ROLECAT_WHL, FINSC_FISC_DATE
Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
Column Name Description
AccountingDocumentStatus null
ActlCostInPlnCrcy Amount in Company Code Currency
ActlCostInProjCrcy Amount in Company Code Currency
ActlRevnInProjCrcy Amount in Company Code Currency
ActualRevenueInPlnCrcy Amount in Company Code 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
StrtToDteActlCostInCOCrcy Amount in Company Code Currency
StrtToDteActlRevnInCOCrcy Amount in Company Code Currency
UnbilledRevnInCtrlArCrcy Amount in Company Code Currency
UnbilledRevnInObjArCrcy Amount in Company Code Currency
UnbilledRevnInTrnsctnCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
WIPQuantity 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
MasterProjectType Commercial Project Type /CPD/PWS_WS_MP_TYPE
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
StatisticalKeyFigure null
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
FiscalPeriod Fiscal Period POPER
AccountingDocument Journal Entry BELNR
ClearingAccountingDocument Clearing Document Number BELNR
FinancialPlanID External ID for Financial Plan
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
MstrProjAnchorObjectInternalID External Object Technical Key IAOM_OBJECT_KEY
YearMonth null
MstrProjKeyFigElmnt Key Figure Element /CPD/AVR_ELEM
MstrProjResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
MstrProjRsceID Resource ID /CPD/PFP_RESOURCE_ID
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_MSTRPROJACTLCOSTQTY.BASEUNIT == T006.MSEHI
  • P_MSTRPROJACTLCOSTQTY.MANDT == T006.MANDT
Business Area
  • Client
  • Business Area
  • P_MSTRPROJACTLCOSTQTY.MANDT == TGSB.MANDT
  • P_MSTRPROJACTLCOSTQTY.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_MSTRPROJACTLCOSTQTY.MANDT == T001.MANDT
  • P_MSTRPROJACTLCOSTQTY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_MSTRPROJACTLCOSTQTY.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_MSTRPROJACTLCOSTQTY.CONTROLLINGAREA == TKA01.KOKRS
  • P_MSTRPROJACTLCOSTQTY.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • P_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTLCOSTQTY.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Plan Currency
  • Client
  • Plan Currency
  • P_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTLCOSTQTY.FINANCIALPLANCURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_MSTRPROJACTLCOSTQTY.GLACCOUNT == SKB1.SAKNR
  • P_MSTRPROJACTLCOSTQTY.MANDT == SKB1.MANDT
  • P_MSTRPROJACTLCOSTQTY.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • P_MSTRPROJACTLCOSTQTY.GLOBALCURRENCY == TCURC.WAERS
  • P_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_MSTRPROJACTLCOSTQTY.MASTERPROJECTFISCALYEARVARIANT == T009.PERIV
  • P_MSTRPROJACTLCOSTQTY.MANDT == T009.MANDT
Material Number
  • Material Number
  • Client
  • P_MSTRPROJACTLCOSTQTY.MATERIAL == MARA.MATNR
  • P_MSTRPROJACTLCOSTQTY.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • P_MSTRPROJACTLCOSTQTY.MANDT == T001W.MANDT
  • P_MSTRPROJACTLCOSTQTY.PLANT == T001W.WERKS
Transaction Currency
  • Client
  • Transaction Currency
  • P_MSTRPROJACTLCOSTQTY.MANDT == TCURC.MANDT
  • P_MSTRPROJACTLCOSTQTY.TRANSACTIONCURRENCY == TCURC.WAERS