I_Projectwipdetail

WIP Detail view for projects | view: IPROJ_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)
RejectedAmtInTransCrcy Rejected 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)
RejectedAmountInObjectCurrency Rejected Cost (Company Code Currency)
ObjectCrcyWIPAmount Unbilled Cost (Company Code Currency)
TotObjectCrcyInvoiceSimlnAmt Billable Revenue (Company Code Currency)
ObjectCrcyInvoiceSimlnAmt Revenue to be billed (Company Code currency)
💲 Controlling area currency (ControllingAreaCurrency):
BillableAmountInCtrlgAreaCrcy Amount for invoicing in controlling area currency
NonBillableAmtInCtrlgAreaCrcy Amount not to be invoiced in controlling area currency
CtrlgAreaCrcyInvoicedAmount Already billed costs (CO Area currency)
RejectedAmountInCtrlgAreaCrcy Already rejected costs (CO Area currency)
CtrlgAreaCrcyWIPAmount Not yet billed costs (WIP costs) (CO Area currency)
TotCtrlgAreaCrcyInvcSimlnAmt Revenue to be billed (CO Area currency)
CtrlgAreaCrcyInvoiceSimlnAmt Revenue to be billed (CO Area currency)
💲 Currency Key of Sales Document (TransacCurrencyInvoiceSimln):
TotTransacCrcyInvoiceSimlnAmt Billable Revenue (Sales Order Currency)
TransacCrcyInvoiceSimlnAmt Revenue to be billed (revenue currency)
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
BillableQuantity Billable Quantity
NonBillableQuantity Not Billable Quantity
InvoicedQuantity Billed Quantity
RejectedQuantity Rejected 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
BillingDocumentCategory Billing Plan Usage Category Show values
BillingPlanItemUsage Billing Plan Item Usage Show values
Column Name Description Domain name
WBSElementInternalID WBS Element PS_S4_PSPNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
PersonnelNumber Personnel Number PERNR
ManualInvoiceItem Manual Item CHAR1
RevenueCostElement Cost element for revenues KSTAR
SoldMaterial Product for invoicing MATNR
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_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
ProjectInternalID Project (internal) PS_S4_PROJ_PSPNR
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
  • I_PROJECTWIPDETAIL.ACCOUNTINGINDICATORCODE == TBMOT.BEMOT
  • I_PROJECTWIPDETAIL.MANDT == TBMOT.MANDT
Business area
  • Business Area
  • Client
  • I_PROJECTWIPDETAIL.BUSINESSAREA == TGSB.GSBER
  • I_PROJECTWIPDETAIL.MANDT == TGSB.MANDT
Business Process
  • ?
  • ?
  • Client
  • Business Process
  • I_PROJECTWIPDETAIL.[column in domain "DATBI"] == CBPR.DATBI
  • I_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CBPR.KOKRS
  • I_PROJECTWIPDETAIL.MANDT == CBPR.MANDT
  • I_PROJECTWIPDETAIL.BUSINESSPROCESS == CBPR.PRZNR
Company code
  • Client
  • Company Code
  • I_PROJECTWIPDETAIL.MANDT == T001.MANDT
  • I_PROJECTWIPDETAIL.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_PROJECTWIPDETAIL.MANDT == TKA01.MANDT
  • I_PROJECTWIPDETAIL.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • I_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PROJECTWIPDETAIL.[column in domain "DATBI"] == CSKS.DATBI
  • I_PROJECTWIPDETAIL.COSTCENTER == CSKS.KOSTL
  • I_PROJECTWIPDETAIL.MANDT == CSKS.MANDT
Activity Type
  • ?
  • ?
  • Activity Type
  • Client
  • I_PROJECTWIPDETAIL.[column in domain "DATBI"] == CSLA.DATBI
  • I_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CSLA.KOKRS
  • I_PROJECTWIPDETAIL.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_PROJECTWIPDETAIL.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Cost Element
  • Client
  • I_PROJECTWIPDETAIL.[column in domain "KTOPL"] == CSKA.KTOPL
  • I_PROJECTWIPDETAIL.COSTELEMENT == CSKA.KSTAR
  • I_PROJECTWIPDETAIL.MANDT == CSKA.MANDT
Functional Area
  • Functional Area
  • Client
  • I_PROJECTWIPDETAIL.FUNCTIONALAREA == TFKB.FKBER
  • I_PROJECTWIPDETAIL.MANDT == TFKB.MANDT
Material Number
  • Material Number
  • Client
  • I_PROJECTWIPDETAIL.MATERIAL == MARA.MATNR
  • I_PROJECTWIPDETAIL.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • I_PROJECTWIPDETAIL.MANDT == T001W.MANDT
  • I_PROJECTWIPDETAIL.PLANT == T001W.WERKS
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • I_PROJECTWIPDETAIL.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_PROJECTWIPDETAIL.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROJECTWIPDETAIL.PROFITCENTER == CEPC.PRCTR
  • I_PROJECTWIPDETAIL.MANDT == CEPC.MANDT
Project manager (personnel number)
  • Project Manager
  • Client
  • I_PROJECTWIPDETAIL.PROJECTMANAGER == TCJ04.VERNR
  • I_PROJECTWIPDETAIL.MANDT == TCJ04.MANDT
Results analysis key
  • Recognition Key for event-based revenue recognition
  • Client
  • I_PROJECTWIPDETAIL.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_PROJECTWIPDETAIL.MANDT == TKKAA.MANDT