P_Wiprevdetailbasic

WIP revenue details from DIP data | view: PDLIWIPRVBS | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: AD01DLI, AD01WIP_REV, /SHCM/HRP5092, USR21
Column Name Description
Column Name Description
TransacCrcyInvoiceSimlnAmt Revenue to be billed (revenue currency)
ObjectCrcyInvoiceSimlnAmt Revenue to be billed (Company Code currency)
CtrlgAreaCrcyInvoiceSimlnAmt Revenue to be billed (CO Area currency)
Column Name Description
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
EmployeeFullName Full Name TEXT80
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
RevenueCostElement Cost Element KSTAR
SoldMaterial Material Number MATNR
ResultAnalysisControllingObj Object number J_OBJNR
ResultAnalysisInternalID Results Analysis Key ABGR_SCHL
Master Data Relations Join Conditions
Accounting Indicator
  • Client
  • Accounting Indicator
  • P_WIPREVDETAILBASIC.MANDT == TBMOT.MANDT
  • P_WIPREVDETAILBASIC.ACCOUNTINGINDICATORCODE == TBMOT.BEMOT
Business Process
  • ?
  • ?
  • Client
  • Business Process
  • P_WIPREVDETAILBASIC.[column in domain "DATBI"] == CBPR.DATBI
  • P_WIPREVDETAILBASIC.[column in domain "KOKRS"] == CBPR.KOKRS
  • P_WIPREVDETAILBASIC.MANDT == CBPR.MANDT
  • P_WIPREVDETAILBASIC.BUSINESSPROCESS == CBPR.PRZNR
Cost Center
  • ?
  • ?
  • Client
  • Cost Center
  • P_WIPREVDETAILBASIC.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_WIPREVDETAILBASIC.[column in domain "DATBI"] == CSKS.DATBI
  • P_WIPREVDETAILBASIC.MANDT == CSKS.MANDT
  • P_WIPREVDETAILBASIC.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • ?
  • Client
  • Activity Type
  • P_WIPREVDETAILBASIC.[column in domain "DATBI"] == CSLA.DATBI
  • P_WIPREVDETAILBASIC.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_WIPREVDETAILBASIC.MANDT == CSLA.MANDT
  • P_WIPREVDETAILBASIC.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Element
  • ?
  • Client
  • Cost Element
  • P_WIPREVDETAILBASIC.[column in domain "KTOPL"] == CSKA.KTOPL
  • P_WIPREVDETAILBASIC.MANDT == CSKA.MANDT
  • P_WIPREVDETAILBASIC.COSTELEMENT == CSKA.KSTAR
Material Number
  • Client
  • Material Number
  • P_WIPREVDETAILBASIC.MANDT == MARA.MANDT
  • P_WIPREVDETAILBASIC.MATERIAL == MARA.MATNR
Results Analysis Version
  • ?
  • Client
  • Results Analysis Version
  • P_WIPREVDETAILBASIC.[column in domain "KOKRS"] == TKKAP.KOKRS
  • P_WIPREVDETAILBASIC.MANDT == TKKAP.MANDT
  • P_WIPREVDETAILBASIC.RESULTANALYSISVERSION == TKKAP.VERSA
Transaction Currency
  • Client
  • Transaction Currency
  • P_WIPREVDETAILBASIC.MANDT == TCURC.MANDT
  • P_WIPREVDETAILBASIC.TRANSACTIONCURRENCY == TCURC.WAERS
Unit of Measure
  • Client
  • Unit of Measure
  • P_WIPREVDETAILBASIC.MANDT == T006.MANDT
  • P_WIPREVDETAILBASIC.UNITOFMEASURE == T006.MSEHI