P_WIPDETAILBASIC1

Detail WIP from DIP data | view: PDLIWIP_BAS1 | Extraction: Not supported | Component: Cost Object Controlling
Tables used: AD01DLIAD01DLISFAD01WIP_DTL
Column Name Description
Column Name Description
TransacCrcyForInvoiceAmount null
ObjectCrcyForInvoiceAmount null
CtrlgAreaCrcyForInvoiceAmount null
TransacCrcyForRjcnAmount null
ObjectCrcyForRjcnAmount null
CtrlgAreaCrcyForRjcnAmount null
TransacCrcyInvoicedAmount null
ObjectCrcyInvoicedAmount null
CtrlgAreaCrcyInvoicedAmount null
TransacCrcyRejectedAmount null
ObjectCrcyRejectedAmount null
CtrlgAreaCrcyRejectedAmount null
TransacCrcyWIPAmount null
ObjectCrcyWIPAmount null
CtrlgAreaCrcyWIPAmount null
TotTransacCrcyInvoiceSimlnAmt null
TotObjectCrcyInvoiceSimlnAmt null
TotCtrlgAreaCrcyInvcSimlnAmt null
TransacCrcyInvoiceSimlnAmt Amount referenced for invoicing
ObjectCrcyInvoiceSimlnAmt Amount referenced for invoicing
CtrlgAreaCrcyInvoiceSimlnAmt Amount referenced for invoicing
Column Name Description
ForInvoiceQuantity null
ForRjcnQuantity null
InvoicedQuantity null
RejectedQuantity null
WIPQuantity null
Column Name Description
Column Name Description
ManualInvoiceItem Checkbox Show values
BillingDocumentCategory Billing Plan Usage Category Show values
BillingPlanItemUsage Billing Plan Item Usage Show values
Column Name Description Domain name
PostingPeriod Fiscal Year Period FIS_JAHRPER_CONV
PersonnelNumber Personnel Number PERNR
ProfitCenter Profit Center PRCTR
ControllingDocument Document Number CO_BELNR
ControllingDocumentItem Six-Character Posting Item for Ledger DOCLN6
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
ResultAnalysisVersion null
RevenueCostElement Cost Element KSTAR
SoldMaterial Material Number MATNR
Master Data Relations Join Conditions
Accounting Indicator
  • Client
  • Accounting Indicator
  • P_WIPDETAILBASIC1.MANDT == TBMOT.MANDT
  • P_WIPDETAILBASIC1.ACCOUNTINGINDICATORCODE == TBMOT.BEMOT
Business Process
  • Client
  • Business Process
  • ?
  • ?
  • P_WIPDETAILBASIC1.MANDT == CBPR.MANDT
  • P_WIPDETAILBASIC1.BUSINESSPROCESS == CBPR.PRZNR
  • P_WIPDETAILBASIC1.[column in domain "DATBI"] == CBPR.DATBI
  • P_WIPDETAILBASIC1.[column in domain "KOKRS"] == CBPR.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • ?
  • P_WIPDETAILBASIC1.MANDT == CSKS.MANDT
  • P_WIPDETAILBASIC1.COSTCENTER == CSKS.KOSTL
  • P_WIPDETAILBASIC1.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_WIPDETAILBASIC1.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Activity Type
  • Client
  • ?
  • ?
  • P_WIPDETAILBASIC1.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_WIPDETAILBASIC1.MANDT == CSLA.MANDT
  • P_WIPDETAILBASIC1.[column in domain "DATBI"] == CSLA.DATBI
  • P_WIPDETAILBASIC1.[column in domain "KOKRS"] == CSLA.KOKRS
Cost Element
  • Client
  • Cost Element
  • ?
  • P_WIPDETAILBASIC1.MANDT == CSKA.MANDT
  • P_WIPDETAILBASIC1.COSTELEMENT == CSKA.KSTAR
  • P_WIPDETAILBASIC1.[column in domain "KTOPL"] == CSKA.KTOPL
Material Number
  • Client
  • Material Number
  • P_WIPDETAILBASIC1.MANDT == MARA.MANDT
  • P_WIPDETAILBASIC1.MATERIAL == MARA.MATNR
Currency Key
  • Client
  • Currency code for WIP revenue
  • Currency Key
  • P_WIPDETAILBASIC1.MANDT == TCURC.MANDT
  • P_WIPDETAILBASIC1.TRANSACCURRENCYINVOICESIMLN == TCURC.WAERS
  • P_WIPDETAILBASIC1.SALESDOCUMENTITEMCURRENCY == TCURC.WAERS
Transaction Currency
  • Client
  • Transaction Currency
  • P_WIPDETAILBASIC1.MANDT == TCURC.MANDT
  • P_WIPDETAILBASIC1.TRANSACTIONCURRENCY == TCURC.WAERS
Unit of Measure
  • Client
  • Unit of Measure
  • P_WIPDETAILBASIC1.MANDT == T006.MANDT
  • P_WIPDETAILBASIC1.UNITOFMEASURE == T006.MSEHI