P_ProjBillingElementEntrFlw00

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 P_ProjBillingElementEntrFlw00.
-- 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.
-- SQL view name: PPPRJBLGELMFLW00

CREATE VIEW P_ProjBillingElementEntrFlw00 AS
SELECT
  _ProjBillingElemEntrFlw.ProjBillgElmntEntrItmFlowUUID AS ProjBillgElmntEntrItmFlowUUID,
  _ProjBillingElemEntrFlw.BillingDocument AS BillingDocument,
  _ProjBillingElemEntrFlw.BillingDocumentItem AS BillingDocumentItem,
  _GLAccountLineItemRawData.SalesDocument AS SalesDocument,
  _GLAccountLineItemRawData.SalesDocumentItem AS SalesDocumentItem,
  _ProjBillingElemEntrFlw.ProjectBillingRequest AS ProjectBillingRequest,
  _ProjBillingElemEntrFlw.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  _ProjBillingElemEntrFlw.SDDocumentCategory AS SDDocumentCategory,
  _ProjBillingElemEntrFlw.TransactionCurrency AS TransactionCurrency,
  _ProjBillingElemEntrFlw.QuantityUnit AS QuantityUnit,
  _ProjBillingElemEntrFlw.BillgReqdAmtInTransacCrcy AS BillgReqdAmtInTransacCrcy,
  _ProjBillingElemEntrFlw.BillgReqdAmtInGlobalCrcy AS BillgReqdAmtInGlobalCrcy,
  _ProjBillingElemEntrFlw.WrittenOffQuantity AS WrittenOffQuantity,
  _ProjBillingElemEntrFlw.WrittenOffAmtInTransacCrcy AS WrittenOffAmtInTransacCrcy,
  _ProjBillingElemEntrFlw.WrittenOffAmtInGlobalCrcy AS WrittenOffAmtInGlobalCrcy,
  _ProjBillingElemEntrFlw.PostponedQuantity AS PostponedQuantity,
  _ProjBillingElemEntrFlw.PostponedAmountInTransacCrcy AS PostponedAmountInTransacCrcy,
  _ProjBillingElemEntrFlw.PostponedAmountInGlobalCrcy AS PostponedAmountInGlobalCrcy,
  _ProjBillingElemEntrFlw.GlobalCurrency AS GlobalCurrency,
  _ProjBillingElemEntrFlw.NetPriceAmountInDocCrcy AS NetPriceAmountInDocCrcy,
  _ProjBillingElemEntrFlw.DocumentCurrency AS DocumentCurrency,
  _ProjBillingElemEntrFlw.BillgReqdRevenueAmtInDocCrcy AS NetAmount,
  _ProjBillingElemEntrFlw.BillingDocumentType AS BillingDocumentType,
  _ProjBillingElemEntrFlw.ProjBillgElmntEntrSrvcExpnCode AS ProjBillgElmntEntrSrvcExpnCode,
  _PrjBlgElmEntrJrnlEntrLink.Ledger AS Ledger,
  _PrjBlgElmEntrJrnlEntrLink.FiscalYear AS FiscalYear,
  _PrjBlgElmEntrJrnlEntrLink.AccountingDocument AS AccountingDocument,
  _PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem AS LedgerGLLineItem,
  _PrjBlgElmEntrJrnlEntrLink.CompanyCode AS CompanyCode,
  _PrjBlgElmEntrBillgPlnLink.BillingPlan AS BillingPlan,
  _PrjBlgElmEntrBillgPlnLink.BillingPlanItem AS BillingPlanItem,
  _GLAccountLineItemRawData.ControllingObject AS ControllingObject,
  _GLAccountLineItemRawData.OriginCostCtrActivityType AS CostCtrActivityType,
  _GLAccountLineItemRawData.DocumentItemText AS DocumentItemText,
  _GLAccountLineItemRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _GLAccountLineItemRawData.SourceLedger AS SourceLedger,
  _GLAccountLineItemRawData.ServicesRenderedDate AS ServicesRenderedDate,
  _GLAccountLineItemRawData.PostingDate AS PostingDate,
  _GLAccountLineItemRawData.DocumentDate AS DocumentDate,
  _GLAccountLineItemRawData.PartnerCompanyCode AS PartnerCompanyCode,
  _GLAccountLineItemRawData.PersonnelNumber AS Personnel,
  _GLAccountLineItemRawData.WorkItem AS WorkItem,
  _GLAccountLineItemRawData.GLAccount AS CostElement,
  _GLAccountLineItemRawData.ReferenceDocument AS ReferenceDocument,
  _GLAccountLineItemRawData.ReferenceDocumentItem AS ReferenceDocumentItem,
  _GLAccountLineItemRawData.WorkPackage AS WorkPackage,
  _WBSElement.WBSElementExternalID AS WBSElement,
  _WBSElement._Project.Project AS Project,
  _WBSElement._Project.ProjectDescription AS ProjectDescription,
  _WBSElement.WBSDescription AS WBSDescription,
  _WBSElement.WBSElementObject AS WBSElementObject
FROM I_ProjectBillingElementEntrFlw AS _ProjBillingElemEntrFlw
LEFT OUTER JOIN I_PrjBlgElmEntrJrnlEntrLink AS _PrjBlgElmEntrJrnlEntrLink ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PrjBlgElmEntrBillgPlnLink AS _PrjBlgElmEntrBillgPlnLink ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProjectBillingElementEntry AS ProjectBillingElementEntry ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProjectBillingElement AS _ProjectBillingElement ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountLineItemRawData AS _GLAccountLineItemRawData ON _PrjBlgElmEntrJrnlEntrLink.AccountingDocument = _GLAccountLineItemRawData.AccountingDocument AND _PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem = _GLAccountLineItemRawData.LedgerGLLineItem AND _PrjBlgElmEntrJrnlEntrLink.FiscalYear = _GLAccountLineItemRawData.FiscalYear AND _PrjBlgElmEntrJrnlEntrLink.CompanyCode = _GLAccountLineItemRawData.CompanyCode AND _PrjBlgElmEntrJrnlEntrLink.Ledger = _GLAccountLineItemRawData.SourceLedger  -- association [1..1]
LEFT OUTER JOIN I_WorkForcePersonMappings AS _WorkForcePersonMappings ON Personnel = _WorkForcePersonMappings.WorkforceAssignment  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON _ProjectBillingElement.BillingWBSElementInternalID = _SalesOrderItem.WBSElementInternalID AND _SalesOrderItem.WBSElementInternalID <> '00000000'  -- association [1..1]
LEFT OUTER JOIN I_SDBillingPlanItem AS _SlsDocItemBillingPlanDueDate ON _PrjBlgElmEntrBillgPlnLink.BillingPlan = _SlsDocItemBillingPlanDueDate.BillingPlan AND _PrjBlgElmEntrBillgPlnLink.BillingPlanItem = _SlsDocItemBillingPlanDueDate.BillingPlanItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _PrjBlgElmEntrJrnlEntrLink.CompanyCode = _JournalEntry.CompanyCode AND FiscalYear = _JournalEntry.FiscalYear AND _PrjBlgElmEntrJrnlEntrLink.AccountingDocument = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentRequestItem AS _BillingDocumentReqItem ON BillingDocument = _BillingDocumentReqItem.BillingDocumentRequest AND BillingDocumentItem = _BillingDocumentReqItem.BillingDocumentRequestItem  -- association [1..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON timesheetovertimecategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory AND _TimeSheetOvertimeCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON ControllingArea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND _CostCenterActivityTypeText.ValidityEndDate >= $session.system_date AND _CostCenterActivityTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;