P_MstrProjActualWipCost

Actual cost with work in progress | view: PMSTRPROJWIPCOST | 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/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
Column Name Description
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
StrtToDteActlCostInCOCrcy Amount in Company Code Currency
StrtToDteActlRevnInCOCrcy Amount in Company Code Currency
ActlCostInProjCrcy Amount in Company Code Currency
ActlCostInPlnCrcy Amount in Company Code Currency
UnbilledRevnInCtrlArCrcy Amount in Company Code Currency
UnbilledRevnInObjArCrcy Amount in Company Code Currency
UnbilledRevnInTrnsctnCrcy Amount in Company Code Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
TotalQuantity null
ActlEffortQty Valuation 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
MasterProjectUUID NodeID /BOBF/CONF_KEY
MasterProject Commercial Project ID /CPD/MP_ID
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
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
PersonnelNumber Personnel Number PERNR
SalesOrderItem Sales Order Item POSNR
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
FinancialPlanID External ID for Financial Plan
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
MstrProjAnchorObjectInternalID External Object Technical Key IAOM_OBJECT_KEY
AccountingDocument Journal Entry BELNR
ClearingAccountingDocument Clearing Document Number BELNR
StatisticalKeyFigure null
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MSTRPROJACTUALWIPCOST.MANDT == T006.MANDT
  • P_MSTRPROJACTUALWIPCOST.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • P_MSTRPROJACTUALWIPCOST.BUSINESSAREA == TGSB.GSBER
  • P_MSTRPROJACTUALWIPCOST.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • P_MSTRPROJACTUALWIPCOST.MANDT == T001.MANDT
  • P_MSTRPROJACTUALWIPCOST.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_MSTRPROJACTUALWIPCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALWIPCOST.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_MSTRPROJACTUALWIPCOST.MANDT == TKA01.MANDT
  • P_MSTRPROJACTUALWIPCOST.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • Client
  • CO Object Currency
  • P_MSTRPROJACTUALWIPCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALWIPCOST.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Plan Currency
  • Plan Currency
  • Client
  • P_MSTRPROJACTUALWIPCOST.FINANCIALPLANCURRENCY == TCURC.WAERS
  • P_MSTRPROJACTUALWIPCOST.MANDT == TCURC.MANDT
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_MSTRPROJACTUALWIPCOST.MANDT == SKB1.MANDT
  • P_MSTRPROJACTUALWIPCOST.GLACCOUNT == SKB1.SAKNR
  • P_MSTRPROJACTUALWIPCOST.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_MSTRPROJACTUALWIPCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALWIPCOST.GLOBALCURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_MSTRPROJACTUALWIPCOST.MASTERPROJECTFISCALYEARVARIANT == T009.PERIV
  • P_MSTRPROJACTUALWIPCOST.MANDT == T009.MANDT
Material Number
  • Material Number
  • Client
  • P_MSTRPROJACTUALWIPCOST.MATERIAL == MARA.MATNR
  • P_MSTRPROJACTUALWIPCOST.MANDT == MARA.MANDT
Origin Cost Center Activity Type
  • Client
  • Controlling Area
  • Origin Cost Center Activity Type
  • ?
  • P_MSTRPROJACTUALWIPCOST.MANDT == CSLA.MANDT
  • P_MSTRPROJACTUALWIPCOST.CONTROLLINGAREA == CSLA.KOKRS
  • P_MSTRPROJACTUALWIPCOST.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_MSTRPROJACTUALWIPCOST.[column in domain "DATBI"] == CSLA.DATBI
Plant
  • Client
  • Plant
  • P_MSTRPROJACTUALWIPCOST.MANDT == T001W.MANDT
  • P_MSTRPROJACTUALWIPCOST.PLANT == T001W.WERKS
Transaction Currency
  • Client
  • Transaction Currency
  • P_MSTRPROJACTUALWIPCOST.MANDT == TCURC.MANDT
  • P_MSTRPROJACTUALWIPCOST.TRANSACTIONCURRENCY == TCURC.WAERS