P_PROJECTWIPDETAIL1

WIP Detail view for projects | view: PPROJ_DLI_WIP1 | Extraction: Not supported | Component: Cost Object Controlling
Tables used: PRTE, AD01DLI, AD01DLISF, AD01WIP_DTL, T001, TKA02, TKA01, /SHCM/HRP5092, PROJ, T000, USR21, PRPS
Column Name Description
Column Name Description
BillableAmountInTransacCrcy Billable Cost (Transaction Currency)
BillableAmountInCtrlgObjCrcy Billable Cost (Company Code Currency)
NonBillableAmountInTransacCrcy Not Billable Cost (Transaction Currency)
NonBllbleAmtInCtrlgObjCurrency Not Billable Cost (Company Code Currency)
TransacCrcyInvoicedAmount Billed Cost (Transaction Currency)
ObjectCrcyInvoicedAmount Billed Cost (Company Code Currency)
TransacCrcyWIPAmount Unbilled Cost (Transaction Currency)
ObjectCrcyWIPAmount Unbilled Cost (Company Code Currency)
TotTransacCrcyInvoiceSimlnAmt Billable Revenue (Sales Order Currency)
TotObjectCrcyInvoiceSimlnAmt Billable Revenue (Company Code Currency)
Column Name Description
BillableQuantity Billable Quantity
NonBillableQuantity Not Billable Quantity
InvoicedQuantity Billed Quantity
WIPQuantity Unbilled Quantity
Column Name Description
ServicesRenderedDate Date on which services are rendered
CreationDate Date on which the record was created
Column Name Description
Column Name Description Domain name
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
PersonnelNumber Personnel Number PERNR
ManualInvoiceItem Manual Item CHAR1
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
CostAnalysisResource Resource CO_RESSOURCE
CalendarMonth Work Period (Internal Representation) PRS_WORK_PERIOD
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
ResultAnalysisVersion Results Analysis Version VERSN_ABGR
PostingPeriod Fiscal Year Period FIS_JAHRPER_CONV
ControllingDocument Document Number CO_BELNR
ControllingDocumentItem Six-Character Posting Item for Ledger DOCLN6
WBSDescription WBS Element Name TEXT40
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
ControllingObjectClass Object Class
ProjectManagerName Project Manager Name TEXT80
EmployeeFullName Employee Name TEXT80
Master Data Relations Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • P_PROJECTWIPDETAIL1.ACCOUNTINGINDICATORCODE == TBMOT.BEMOT
  • P_PROJECTWIPDETAIL1.MANDT == TBMOT.MANDT
Business area
  • Client
  • Business Area
  • P_PROJECTWIPDETAIL1.MANDT == TGSB.MANDT
  • P_PROJECTWIPDETAIL1.BUSINESSAREA == TGSB.GSBER
Business Process
  • Client
  • ?
  • ?
  • Business Process
  • P_PROJECTWIPDETAIL1.MANDT == CBPR.MANDT
  • P_PROJECTWIPDETAIL1.[column in domain "DATBI"] == CBPR.DATBI
  • P_PROJECTWIPDETAIL1.[column in domain "KOKRS"] == CBPR.KOKRS
  • P_PROJECTWIPDETAIL1.BUSINESSPROCESS == CBPR.PRZNR
Company code
  • Client
  • Company Code
  • P_PROJECTWIPDETAIL1.MANDT == T001.MANDT
  • P_PROJECTWIPDETAIL1.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • P_PROJECTWIPDETAIL1.MANDT == TKA01.MANDT
  • P_PROJECTWIPDETAIL1.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • ?
  • P_PROJECTWIPDETAIL1.MANDT == CSKS.MANDT
  • P_PROJECTWIPDETAIL1.COSTCENTER == CSKS.KOSTL
  • P_PROJECTWIPDETAIL1.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PROJECTWIPDETAIL1.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Client
  • ?
  • ?
  • Activity Type
  • P_PROJECTWIPDETAIL1.MANDT == CSLA.MANDT
  • P_PROJECTWIPDETAIL1.[column in domain "DATBI"] == CSLA.DATBI
  • P_PROJECTWIPDETAIL1.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_PROJECTWIPDETAIL1.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Element
  • Client
  • ?
  • Cost Element
  • P_PROJECTWIPDETAIL1.MANDT == CSKA.MANDT
  • P_PROJECTWIPDETAIL1.[column in domain "KTOPL"] == CSKA.KTOPL
  • P_PROJECTWIPDETAIL1.COSTELEMENT == CSKA.KSTAR
Functional Area
  • Client
  • Functional Area
  • P_PROJECTWIPDETAIL1.MANDT == TFKB.MANDT
  • P_PROJECTWIPDETAIL1.FUNCTIONALAREA == TFKB.FKBER
Material Number
  • Client
  • Material Number
  • P_PROJECTWIPDETAIL1.MANDT == MARA.MANDT
  • P_PROJECTWIPDETAIL1.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • P_PROJECTWIPDETAIL1.MANDT == T001W.MANDT
  • P_PROJECTWIPDETAIL1.PLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • ?
  • Profit Center
  • P_PROJECTWIPDETAIL1.MANDT == CEPC.MANDT
  • P_PROJECTWIPDETAIL1.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PROJECTWIPDETAIL1.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJECTWIPDETAIL1.PROFITCENTER == CEPC.PRCTR
Project manager (personnel number)
  • Client
  • Project Manager
  • P_PROJECTWIPDETAIL1.MANDT == TCJ04.MANDT
  • P_PROJECTWIPDETAIL1.PROJECTMANAGER == TCJ04.VERNR
Results analysis key
  • Client
  • Recognition Key for event-based revenue recognition
  • P_PROJECTWIPDETAIL1.MANDT == TKKAA.MANDT
  • P_PROJECTWIPDETAIL1.RESULTANALYSISINTERNALID == TKKAA.ABGSL