C_RAPerfOblgnToRevnExplItem

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_RAPerfOblgnToRevnExplItem.
-- 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: CRAPERFOBLGNRVXP

CREATE VIEW C_RAPerfOblgnToRevnExplItem AS
SELECT
  PerformanceObligation,
  RASndgCompDocumentItem,
  RevenueAccountingContract,
  RevnAcctgSenderComponent,
  PerformanceObligationClass,
  CompanyCode,
  AccountingPrinciple,
  RAPerfOblgnDistinctType,
  RAPerformanceObligationType,
  PerfOblgnCreatedByUser,
  PerfOblgnCreationDate,
  PerfOblgnLastChangedByUsr,
  PerfOblgnLastChangeDate,
  BusinessPartner,
  RAPerfOblgnCategory,
  PerfOblgn._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  Customer,
  PerfOblgn._Customer.CustomerName AS CustomerName,
  RevnAcctgSalesOrganization,
  PerfOblgn._SalesOrganization._Text[1:Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  RevnAcctgPerfOblgnStatus,
  RAPerfOblgnStatusCriticality,
  PerfOblgnFulfillmentType,
  PerfOblgnEventType,
  PerfOblgnIsFinallyInvoiced,
  RAFulfillmentIsValueBased,
  RAFulfilledAmountIsHidden,
  PerfOblgnHasManualSpreading,
  OrderID,
  Segment,
  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,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  RAPerfOblgnFinalizationDate,
  RevnAcctgOperationalDocument,
  SSPriceInSalesDocCrcy,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  ContractualPrcInSlsDocCrcy,
  AllocatedPriceInSalesDocCrcy,
  AllocEffctAmountInSalesDocCrcy,
  RAPerfOblgnTotRevnInSlsDocCrcy,
  UpToCurPeriodRecognizedRevenue,
  RATotalOpenRevnInSlsDocCrcy,
  RAFlfmtRecgdRevnInSlsDocCrcy,
  RecgdCatchUpAmtInSlsDocCrcy,
  SalesDocumentCurrency,
  RatioUnit,
  RAPerfOblgnIsFrozen,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  CostCenter,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  WBSElementExternalID,
  ProfitabilitySegment,
  ControllingArea,
  IsBusinessPurposeCompleted,
  RAUnivRevnRecgnIntegType,
  _RAUnivRevnRecgnIntegTypeText[1:Language=$session.system_language].RAUnivRevnRecgnIntegTypeName AS RAUnivRevnRecgnIntegTypeName
FROM I_RAPerfOblgnToRevnExplItem AS PerfOblgn
LEFT OUTER JOIN C_RARevnExplanationItem AS _Item ON PerformanceObligation = _Item.RAHigherLevelPerfOblgn AND RevenueAccountingContract = _Item.RevenueAccountingContract  -- 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_RAPerfOblgnStatusText AS _PerfOblgnStatusText ON RevnAcctgPerfOblgnStatus = _PerfOblgnStatusText.RevnAcctgPerfOblgnStatus  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnDistinctTypeText AS _DistinctTypeText ON RAPerfOblgnDistinctType = _DistinctTypeText.RAPerfOblgnDistinctType  -- association [1..*]
LEFT OUTER JOIN I_RAUnivRevnRecgnIntegTypeText AS _RAUnivRevnRecgnIntegTypeText ON RAUnivRevnRecgnIntegType = _RAUnivRevnRecgnIntegTypeText.RAUnivRevnRecgnIntegType  -- association [1..*]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea AND _FunctionalAreaText.Language = $session.system_language  -- association [1..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..*]
LEFT OUTER JOIN E_RAPerformanceObligation AS _E_RAPerformanceObligation ON PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation  -- association [1..1]
;