C_EvtBsdRevnRecgnProjWIPItm

Project WIP Details (2) | view: CEBRRPROJWIPITM | Extraction: Not supported | Component: Event-Based Revenue Recognition
Tables used: FPLA, VBAP, PRTE, ACDOCA, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, BUT000, T001, TKA02, FINSC_LEDGER, CEPC, PROJ, PROJ, PRPS, PROJ, FINSC_ACTVE_APPL
Column Name Description
Ledger Ledger in General Ledger Accounting
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
LedgerGLLineItem Six-Character Posting Item for Ledger
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TotalWIPAmountInCoCodeCrcy null
💲 Document Currency (DocumentCurrency):
TotalWIPAmountInPC null
BillableRevenueAmtInDocCrcy null
BillgReqdRevenueAmtInDocCrcy null
WrittenOffRevenueAmtInDocCrcy null
BilledRevenueAmtInDocCrcy null
💲 Document Currency (Currency):
MnlContrAccrBalShtAmtInPC Amount in CO Object Currency
RequestedDownPaytAmtInDocCrcy Amount in CO Object Currency
ReceivedDownPaytAmtInDocCrcy Amount in CO Object Currency
CappedNetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of measure (QuantityUnit):
ToBeBilledQuantity Project Billing Element Entry: To be Billed Quantity
Column Name Description
ServicesRenderedDate Date on which services are rendered
PostingDate Posting Date
ValidityEndDate Valid To Date
Column Name Description
Column Name Description Domain name
BillingWBSElementInternalID WBS Element PS_S4_PSPNR
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
ResponsiblePersonName Name of responsible person (Project manager) PS_VERNA
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WorkItem Work Item ID
PersonWorkAgreement Personnel Number
Material Material Number
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
DocumentItemText Item Text TEXT50
ServicesRenderedYearPeriod Fiscal Year + Fiscal Period
FiscalYearPeriod Fiscal Year + Fiscal Period
ServiceCostLevel Service Cost Level
Master Data Relations Join Conditions
Billable Control
  • Client
  • Billable Control
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == TBMOT.MANDT
  • C_EVTBSDREVNRECGNPROJWIPITM.BILLABLECONTROL == TBMOT.BEMOT
Currency Key
  • Client
  • Currency Key
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == TCURC.MANDT
  • C_EVTBSDREVNRECGNPROJWIPITM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling area
  • Controlling Area
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.CONTROLLINGAREA == TKA01.KOKRS
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == TKA01.MANDT
Customer Number
  • Customer Number
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.CUSTOMER == KNA1.KUNNR
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • ?
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.GLACCOUNT == SKB1.SAKNR
  • C_EVTBSDREVNRECGNPROJWIPITM.[column in domain "BUKRS"] == SKB1.BUKRS
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == SKB1.MANDT
Partner Cost Center
  • Client
  • ?
  • ?
  • Partner Cost Center
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == CSKS.MANDT
  • C_EVTBSDREVNRECGNPROJWIPITM.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_EVTBSDREVNRECGNPROJWIPITM.[column in domain "DATBI"] == CSKS.DATBI
  • C_EVTBSDREVNRECGNPROJWIPITM.PARTNERCOSTCENTER == CSKS.KOSTL
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_EVTBSDREVNRECGNPROJWIPITM.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_EVTBSDREVNRECGNPROJWIPITM.[column in domain "DATBI"] == CEPC.DATBI
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == CEPC.MANDT
  • C_EVTBSDREVNRECGNPROJWIPITM.PROFITCENTER == CEPC.PRCTR
Reference Document Type C_EVTBSDREVNRECGNPROJWIPITM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Controlling area of responsible cost center
  • Responsible Cost Center Controlling Area
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.RESPCOSTCENTERCONTROLLINGAREA == TKA01.KOKRS
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == TKA01.MANDT
Responsible cost center
  • Responsible Cost Center Controlling Area
  • Responsible Cost Center
  • ?
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.RESPCOSTCENTERCONTROLLINGAREA == CSKS.KOKRS
  • C_EVTBSDREVNRECGNPROJWIPITM.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • C_EVTBSDREVNRECGNPROJWIPITM.[column in domain "DATBI"] == CSKS.DATBI
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == CSKS.MANDT
Project manager (personnel number)
  • Responsible Person Number (Project Manager)
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.RESPONSIBLEPERSON == TCJ04.VERNR
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == TCJ04.MANDT
Results analysis key
  • Results Analysis Key
  • Client
  • C_EVTBSDREVNRECGNPROJWIPITM.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • C_EVTBSDREVNRECGNPROJWIPITM.MANDT == TKKAA.MANDT