C_RAPerfOblgnToDocumentFlow

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_RAPerfOblgnToDocumentFlow.
-- 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.

CREATE VIEW C_RAPerfOblgnToDocumentFlow AS
SELECT
  PerfOblgn.PerformanceObligation AS PerformanceObligation,
  coalesce(PerfOblgn._Mapping.RASndgCompDocumentItem, '') AS RASndgCompDocumentItem,
  PerfOblgn.PerformanceObligationClass AS PerformanceObligationClass,
  PerfOblgn.RevenueAccountingContract AS RevenueAccountingContract,
  PerfOblgn.CompanyCode AS CompanyCode,
  PerfOblgn._CompanyCode.CompanyCodeName AS CompanyCodeName,
  PerfOblgn.AccountingPrinciple AS AccountingPrinciple,
  PerfOblgn._AccountingPrinciple._Text[1:Language=$session.system_language].AccountingPrincipleName AS AccountingPrincipleName,
  PerfOblgn.BusinessPartner AS BusinessPartner,
  PerfOblgn._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  PerfOblgn.Customer AS Customer,
  PerfOblgn._Customer.CustomerName AS CustomerName,
  PerfOblgn.SalesDocumentCurrency AS SalesDocumentCurrency,
  PerfOblgn.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  PerfOblgn.ControllingArea AS ControllingArea,
  PerfOblgn.PerfOblgnEventType AS PerfOblgnEventType,
  PerfOblgn.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerfOblgn.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  PerfOblgn.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  PerfOblgn.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  PerfOblgn.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  PerfOblgn._Mapping.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  cast('' as farr_vbtypl) AS SDDocumentCategory,
  PerfOblgn.RAFulfillmentIsValueBased AS RAFulfillmentIsValueBased,
  PerfOblgn.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  PerfOblgn._SalesOrganization._Text[1: Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  PerfOblgn.ProfitCenter AS ProfitCenter,
  PerfOblgn._CurrentProfitCenter._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  PerfOblgn.FunctionalArea AS FunctionalArea,
  PerfOblgn._FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  PerfOblgn.BusinessArea AS BusinessArea,
  PerfOblgn._BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  PerfOblgn.Segment AS Segment,
  PerfOblgn.CostCenter AS CostCenter,
  PerfOblgn._CurrentCostCenter._Text[1: Language = $session.system_language].CostCenterName AS CostCenterName,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  PerfOblgn.WBSElementExternalID AS WBSElementExternalID,
  PerfOblgn.PerfOblgnCreatedByUser AS PerfOblgnCreatedByUser,
  PerfOblgn.PerfOblgnLastChangedByUsr AS PerfOblgnLastChangedByUsr,
  PerfOblgn.PerfOblgnCreationDate AS PerfOblgnCreationDate,
  PerfOblgn.PerfOblgnLastChangeDate AS PerfOblgnLastChangeDate,
  PerfOblgn._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _RevnAccountingPosting.RAHasPostingDataReduction AS RAHasPostingDataReduction,
  PerfOblgn._RevenueAccountingContract AS _RevenueAccountingContract,
  PerfOblgn._AccountingPrinciple AS _AccountingPrinciple,
  PerfOblgn._CompanyCode AS _CompanyCode,
  PerfOblgn._SalesOrganization AS _SalesOrganization,
  PerfOblgn._BusinessPartner AS _BusinessPartner,
  PerfOblgn._Segment AS _Segment,
  PerfOblgn._FunctionalArea AS _FunctionalArea,
  PerfOblgn._WBSElement AS _WBSElement,
  PerfOblgn._CreatedByUser AS _CreatedByUser,
  PerfOblgn._ChangedByUser AS _ChangedByUser,
  PerfOblgn._BusinessArea AS _BusinessArea
FROM I_RAPerformanceObligation AS PerfOblgn
LEFT OUTER JOIN C_RAPerfOblgnDocumentFlow AS _DocFlow ON PerformanceObligation = _DocFlow.PerformanceObligation  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnStatusText AS _PerfOblgnStatusText ON RevnAcctgPerfOblgnStatus = _PerfOblgnStatusText.RevnAcctgPerfOblgnStatus  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnFlfmtTypeText AS _FulfillmentTypeName ON PerfOblgnFulfillmentType = _FulfillmentTypeName.PerfOblgnFulfillmentType  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnEventTypeText AS _EventTypeText ON PerfOblgnEventType = _EventTypeText.PerfOblgnEventType  -- association [1..*]
LEFT OUTER JOIN I_RAPostingAggregationType AS _RevnAccountingPosting ON RevenueAccountingContract = _RevnAccountingPosting.RevenueAccountingContract  -- association [0..1]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CostCenterHierarchyLeafNode ON CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101'  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _ProfitCenterHierLeafNode ON ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0106'  -- association [0..*]
;