C_EvtBsdRevnRecgnProjWIPItm

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_EvtBsdRevnRecgnProjWIPItm.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_Ledger : fins_ledger, P_ExchangeRateDate : vdm_v_exchange_rate_date

CREATE VIEW C_EvtBsdRevnRecgnProjWIPItm AS
SELECT
  lookupEntity: 'I_Ledger' AS lookupEntityI_Ledger,
  resultElement: 'Ledger' AS resultElementLedger,
  binding: [ { targetElement: 'IsLeadingLedger', type: #CONSTANT, value: 'X' AS ValidityEndDatekeyLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  BillingWBSElementInternalID,
  WBSElementInternalID,
  Project,
  ProjectDescription,
  _EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  Customer,
  ServicesRenderedDate,
  PostingDate,
  ResponsiblePerson,
  ResponsiblePersonName,
  BillingWBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS BillingWBSElementDescription,
  _WorkPackageBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WorkPackageBasicData.WBSDescription AS WBSDescription,
  WorkItem,
  PersonWorkAgreement,
  _PersonWorkAgreement_1.PersonFullName AS PersonFullName,
  GLAccount,
  Material,
  ResultAnalysisInternalID,
  TimeSheetOvertimeCategory,
  ReferenceDocumentType,
  DocumentItemText,
  BillableControl,
  cast(ServicesRenderedYearPeriod as fins_trr_rendered_year_period ) AS ServicesRenderedYearPeriod,
  cast(FiscalYearPeriod as fins_fyearperiod) AS FiscalYearPeriod,
  PartnerCostCenter,
  _PersonServicCostLevel.ServiceCostLevel AS ServiceCostLevel,
  PrjBlgElmEntryLongText,
  DocumentCurrency,
  JournalCurrency AS Currency,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  QuantityUnit,
  TotalWIPAmountInPC,
  WIPQuantity,
  BillableRevenueAmtInDocCrcy,
  BillableQuantity,
  BillgReqdRevenueAmtInDocCrcy,
  BillingRequestedQuantity,
  WrittenOffRevenueAmtInDocCrcy,
  WrittenOffQuantity,
  NonBillableRevenueAmtInDocCrcy AS NonBillableAmtInCtrlgAreaCrcy,
  NonBillableQuantity,
  MnlContrAccrBalShtAmtInPC,
  RequestedDownPaytAmtInDocCrcy,
  ReceivedDownPaytAmtInDocCrcy,
  WipNetting AS WIPNettingDownPaytAmtInPC,
  CappedNetAmount,
  BilledRevenueAmtInDocCrcy,
  BilledQuantity,
  EvtBsdRevnRecgnProjWIPItm.ControllingArea AS ControllingArea,
  ResponsibleCostCenter,
  RespCostCenterControllingArea,
  EvtBsdRevnRecgnProjWIPItm.ProfitCenter AS ProfitCenter,
  ValidityEndDate
FROM P_EvtBsdRevnRecgnProjWIPItm
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON Project = _EngagementProject.EngagementProject  -- association [1..1]
LEFT OUTER JOIN I_EngagementProjectStageText AS _EngagementProjectStageText ON engagementprojectstage = _EngagementProjectStageText.EngagementProjectStage  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON BillingWBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WorkPackageBasicData ON WBSElementInternalID = _WorkPackageBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonWorkAgreement = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgrmtSrvcCostLevel AS _PersonServicCostLevel ON _PersonServicCostLevel.PersonWorkAgreement = PersonWorkAgreement AND _PersonServicCostLevel.StartDate <= ServicesRenderedDate AND _PersonServicCostLevel.EndDate >= ServicesRenderedDate  -- association [0..*]
LEFT OUTER JOIN I_ServiceCostLevelText AS _ServiceCostLevelText ON _ServiceCostLevelText.ServiceCostLevel = servicecostlevel  -- association [0..*]
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON WorkItem = _WorkItemText.WorkItem  -- association [0..*]
LEFT OUTER JOIN I_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON Customer = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ResultAnalysisVersionText AS _ResultAnalysisVersionText ON ResultAnalysisInternalID = _ResultAnalysisVersionText.ResultAnalysisInternalID  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _GLAccountName ON CompanyCode = _GLAccountName.CompanyCode AND GLAccount = _GLAccountName.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_ReferenceDocumentTypeText AS _ReferenceDocumentTypeText ON ReferenceDocumentType = _ReferenceDocumentTypeText.ReferenceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON Customer = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN E_ProfitCenter AS _Extension ON ControllingArea = _Extension.ControllingArea AND ProfitCenter = _Extension.ProfitCenter AND ValidityEndDate = _Extension.ValidityEndDate  -- association [1..1]
;