C_Projectwipdetail

WIP Detail View for projects | view: CPROJ_DLI_WIP | Extraction: Not supported | Component: Cost Object Controlling
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
BillableAmountInTransacCrcy Billable Cost (Transaction Currency)
NonBillableAmountInTransacCrcy Not Billable Cost (Transaction Currency)
TransacCrcyInvoicedAmount Billed Cost (Transaction Currency)
TransacCrcyWIPAmount Unbilled Cost (Transaction Currency)
💲 Local Currency (ControllingObjectCurrency):
BillableAmountInCtrlgObjCrcy Billable Cost (Company Code Currency)
NonBllbleAmtInCtrlgObjCurrency Not Billable Cost (Company Code Currency)
ObjectCrcyInvoicedAmount Billed Cost (Company Code Currency)
ObjectCrcyWIPAmount Unbilled Cost (Company Code Currency)
TotObjectCrcyInvoiceSimlnAmt Billable Revenue (Company Code Currency)
💲 Currency Key of Sales Document (TransacCurrencyInvoiceSimln):
TotTransacCrcyInvoiceSimlnAmt Billable Revenue (Sales Order Currency)
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
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
PostingPeriod To Fiscal Year Period
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
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
ProjectManagerName Project Manager Name TEXT80
ControllingObjectClass Object Class
EmployeeFullName Employee Name TEXT80
Master Data Relations Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • C_PROJECTWIPDETAIL.ACCOUNTINGINDICATORCODE == TBMOT.BEMOT
  • C_PROJECTWIPDETAIL.MANDT == TBMOT.MANDT
Business area
  • Business Area
  • Client
  • C_PROJECTWIPDETAIL.BUSINESSAREA == TGSB.GSBER
  • C_PROJECTWIPDETAIL.MANDT == TGSB.MANDT
Company code
  • Client
  • Company Code
  • C_PROJECTWIPDETAIL.MANDT == T001.MANDT
  • C_PROJECTWIPDETAIL.COMPANYCODE == T001.BUKRS
Controlling area
  • Controlling Area
  • Client
  • C_PROJECTWIPDETAIL.CONTROLLINGAREA == TKA01.KOKRS
  • C_PROJECTWIPDETAIL.MANDT == TKA01.MANDT
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • C_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PROJECTWIPDETAIL.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJECTWIPDETAIL.COSTCENTER == CSKS.KOSTL
  • C_PROJECTWIPDETAIL.MANDT == CSKS.MANDT
Activity Type
  • Activity Type
  • ?
  • ?
  • Client
  • C_PROJECTWIPDETAIL.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_PROJECTWIPDETAIL.[column in domain "DATBI"] == CSLA.DATBI
  • C_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_PROJECTWIPDETAIL.MANDT == CSLA.MANDT
Cost Element
  • Cost Element
  • ?
  • Client
  • C_PROJECTWIPDETAIL.COSTELEMENT == CSKA.KSTAR
  • C_PROJECTWIPDETAIL.[column in domain "KTOPL"] == CSKA.KTOPL
  • C_PROJECTWIPDETAIL.MANDT == CSKA.MANDT
Functional Area
  • Functional Area
  • Client
  • C_PROJECTWIPDETAIL.FUNCTIONALAREA == TFKB.FKBER
  • C_PROJECTWIPDETAIL.MANDT == TFKB.MANDT
Material Number
  • Material Number
  • Client
  • C_PROJECTWIPDETAIL.MATERIAL == MARA.MATNR
  • C_PROJECTWIPDETAIL.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • C_PROJECTWIPDETAIL.PLANT == T001W.WERKS
  • C_PROJECTWIPDETAIL.MANDT == T001W.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROJECTWIPDETAIL.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTWIPDETAIL.MANDT == CEPC.MANDT
  • C_PROJECTWIPDETAIL.PROFITCENTER == CEPC.PRCTR
Project manager (personnel number)
  • Project Manager
  • Client
  • C_PROJECTWIPDETAIL.PROJECTMANAGER == TCJ04.VERNR
  • C_PROJECTWIPDETAIL.MANDT == TCJ04.MANDT
Results analysis key
  • Recognition Key for event-based revenue recognition
  • Client
  • C_PROJECTWIPDETAIL.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • C_PROJECTWIPDETAIL.MANDT == TKKAA.MANDT