P_Projectwiprevdetlbasic

Project WIP with revenue from DIP | view: PPROJ_DLIWPRV_BS | Extraction: Not supported | Component: Cost Object Controlling
Column Name Description
Column Name Description
TransacCrcyForInvoiceAmount Billable Cost (Transaction Currency)
ObjectCrcyForInvoiceAmount Billable Cost (Company Code Currency)
CtrlgAreaCrcyForInvoiceAmount Amount for invoicing in controlling area currency
TransacCrcyForRjcnAmount Not Billable Cost (Transaction Currency)
ObjectCrcyForRjcnAmount Not Billable Cost (Company Code Currency)
CtrlgAreaCrcyForRjcnAmount Amount not to be invoiced in controlling area currency
TransacCrcyInvoicedAmount Already billed costs (transaction currency)
ObjectCrcyInvoicedAmount Already billed costs (company code currency)
CtrlgAreaCrcyInvoicedAmount Already billed costs (CO Area currency)
TransacCrcyRejectedAmount Already rejected costs (transaction currency)
ObjectCrcyRejectedAmount Already rejected costs (Company Code currency)
CtrlgAreaCrcyRejectedAmount Already rejected costs (CO Area currency)
TransacCrcyWIPAmount Not yet billed costs (WIP costs) (transaction currency)
ObjectCrcyWIPAmount Not yet billed costs (WIP costs) (Company Code currency)
CtrlgAreaCrcyWIPAmount Not yet billed costs (WIP costs) (CO Area currency)
TotTransacCrcyInvoiceSimlnAmt Revenue to be billed (revenue currency)
TotObjectCrcyInvoiceSimlnAmt Billable Revenue (Company Code Currency)
TotCtrlgAreaCrcyInvcSimlnAmt Revenue to be billed (CO Area currency)
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
ForInvoiceQuantity Billable Quantity
ForRjcnQuantity Not Billable Quantity
InvoicedQuantity Already billed quantity
RejectedQuantity Already rejected quantity
WIPQuantity Not yet billed quantity (WIP quantity)
Column Name Description
DocumentDate Document Date
Column Name Description
ControllingObjectClass Object class (language-independent) Show values
Column Name Description Domain name
PostingPeriod Fiscal Year Period FIS_JAHRPER_CONV
PersonnelNumber Personnel Number PERNR
ManualInvoiceItem Manual Item CHAR1
RevenueCostElement Cost element for revenues KSTAR
SoldMaterial Product for invoicing MATNR
WBSElementInternalID WBS Element PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSDescription PS: Short description (1st text line) TEXT40
ProjectInternalID Project (internal) PS_PSPNR
Project Project definition PS_PSPID
ProjectDescription PS: Short description (1st text line) TEXT40
ResultAnalysisInternalID Results Analysis Key ABGR_SCHL
ProfitLossAccountUnbilledRev G/L Account for Profit and Loss Statement SAKNR
BlanceSheetAccountUnbilledRev G/L Account for Balance Sheet SAKNR
Master Data Relations Join Conditions
Business area
  • Business area for WBS element
  • Client
  • P_PROJECTWIPREVDETLBASIC.BUSINESSAREA == TGSB.GSBER
  • P_PROJECTWIPREVDETLBASIC.MANDT == TGSB.MANDT
Business Process
  • ?
  • ?
  • Client
  • Business Process
  • P_PROJECTWIPREVDETLBASIC.[column in domain "DATBI"] == CBPR.DATBI
  • P_PROJECTWIPREVDETLBASIC.[column in domain "KOKRS"] == CBPR.KOKRS
  • P_PROJECTWIPREVDETLBASIC.MANDT == CBPR.MANDT
  • P_PROJECTWIPREVDETLBASIC.BUSINESSPROCESS == CBPR.PRZNR
Company code
  • Company code for WBS element
  • Client
  • P_PROJECTWIPREVDETLBASIC.COMPANYCODE == T001.BUKRS
  • P_PROJECTWIPREVDETLBASIC.MANDT == T001.MANDT
Controlling area
  • Controlling area for WBS element
  • Client
  • P_PROJECTWIPREVDETLBASIC.CONTROLLINGAREA == TKA01.KOKRS
  • P_PROJECTWIPREVDETLBASIC.MANDT == TKA01.MANDT
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • P_PROJECTWIPREVDETLBASIC.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_PROJECTWIPREVDETLBASIC.[column in domain "DATBI"] == CSKS.DATBI
  • P_PROJECTWIPREVDETLBASIC.COSTCENTER == CSKS.KOSTL
  • P_PROJECTWIPREVDETLBASIC.MANDT == CSKS.MANDT
Activity Type
  • ?
  • ?
  • Activity Type
  • Client
  • P_PROJECTWIPREVDETLBASIC.[column in domain "DATBI"] == CSLA.DATBI
  • P_PROJECTWIPREVDETLBASIC.[column in domain "KOKRS"] == CSLA.KOKRS
  • P_PROJECTWIPREVDETLBASIC.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_PROJECTWIPREVDETLBASIC.MANDT == CSLA.MANDT
Cost Element
  • ?
  • Cost Element
  • Client
  • P_PROJECTWIPREVDETLBASIC.[column in domain "KTOPL"] == CSKA.KTOPL
  • P_PROJECTWIPREVDETLBASIC.COSTELEMENT == CSKA.KSTAR
  • P_PROJECTWIPREVDETLBASIC.MANDT == CSKA.MANDT
Functional Area
  • Functional Area
  • Client
  • P_PROJECTWIPREVDETLBASIC.FUNCTIONALAREA == TFKB.FKBER
  • P_PROJECTWIPREVDETLBASIC.MANDT == TFKB.MANDT
Material Number
  • Client
  • Material Number
  • P_PROJECTWIPREVDETLBASIC.MANDT == MARA.MANDT
  • P_PROJECTWIPREVDETLBASIC.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • P_PROJECTWIPREVDETLBASIC.PLANT == T001W.WERKS
  • P_PROJECTWIPREVDETLBASIC.MANDT == T001W.MANDT
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • P_PROJECTWIPREVDETLBASIC.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_PROJECTWIPREVDETLBASIC.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJECTWIPREVDETLBASIC.PROFITCENTER == CEPC.PRCTR
  • P_PROJECTWIPREVDETLBASIC.MANDT == CEPC.MANDT
Results Analysis Version
  • ?
  • Results Analysis Version
  • Client
  • P_PROJECTWIPREVDETLBASIC.[column in domain "KOKRS"] == TKKAP.KOKRS
  • P_PROJECTWIPREVDETLBASIC.RESULTANALYSISVERSION == TKKAP.VERSA
  • P_PROJECTWIPREVDETLBASIC.MANDT == TKKAP.MANDT
Currency Key
  • Client
  • Currency code for WIP revenue
  • Currency Key
  • P_PROJECTWIPREVDETLBASIC.MANDT == TCURC.MANDT
  • P_PROJECTWIPREVDETLBASIC.TRANSACCURRENCYINVOICESIMLN == TCURC.WAERS
  • P_PROJECTWIPREVDETLBASIC.SALESDOCUMENTITEMCURRENCY == TCURC.WAERS
Transaction Currency
  • Transaction Currency
  • Client
  • P_PROJECTWIPREVDETLBASIC.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_PROJECTWIPREVDETLBASIC.MANDT == TCURC.MANDT
Unit of Measure
  • Unit of Measure
  • Client
  • P_PROJECTWIPREVDETLBASIC.UNITOFMEASURE == T006.MSEHI
  • P_PROJECTWIPREVDETLBASIC.MANDT == T006.MANDT