I_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 I_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: IRAPERFOBLGNRVXP

CREATE VIEW I_RAPerfOblgnToRevnExplItem AS
SELECT
  PerfOblgn.PerformanceObligation AS PerformanceObligation,
  coalesce(_Mapping.RASndgCompDocumentItem, '') AS RASndgCompDocumentItem,
  PerfOblgn.RevenueAccountingContract AS RevenueAccountingContract,
  _Mapping.RevnAcctgSenderComponent AS RevnAcctgSenderComponent,
  PerformanceObligationClass,
  RAPerfOblgnCategory,
  PerfOblgn.CompanyCode AS CompanyCode,
  PerfOblgn.AccountingPrinciple AS AccountingPrinciple,
  RAPerfOblgnDistinctType,
  RAPerformanceObligationType,
  PerfOblgnCreatedByUser,
  PerfOblgnCreationDate,
  PerfOblgnLastChangedByUsr,
  PerfOblgnLastChangeDate,
  BusinessPartner,
  Customer,
  RevnAcctgSalesOrganization,
  RevnAcctgPerfOblgnStatus,
  PerfOblgnFulfillmentType,
  PerfOblgnEventType,
  PerfOblgnIsFinallyInvoiced,
  RAFulfillmentIsValueBased,
  PerfOblgn.PerfOblgnHasManualSpreading AS PerfOblgnHasManualSpreading,
  OrderID,
  Segment,
  ProfitCenter,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  RAPerfOblgnFinalizationDate,
  _Mapping.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  SSPriceInSalesDocCrcy,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  RAUnivRevnRecgnIntegType,
  cast(_RevnAmt.ContractualPrcInSlsDocCrcy as farr_cds_contractual_price preserving type) AS ContractualPrcInSlsDocCrcy,
  cast(_RevnAmt.AllocatedPriceInSalesDocCrcy as farr_allocated_amt preserving type ) AS AllocatedPriceInSalesDocCrcy,
  cast(_RevnAmt.AllocatedPriceInSalesDocCrcy as farr_cds_pob_total_revn ) AS RAPerfOblgnTotRevnInSlsDocCrcy,
  cast(_RevnAmt.AllocatedPriceInSalesDocCrcy - _RevnAmt.ContractualPrcInSlsDocCrcy as farr_corr_amt) AS AllocEffctAmountInSalesDocCrcy,
  cast( coalesce(RARecognizedRevnInSlsDocCrcy, 0) + coalesce(RecgdCatchUpAmtInSlsDocCrcy, 0 ) as farr_recog_amt) AS UpToCurPeriodRecognizedRevenue,
  cast( _RevnAmt.AllocatedPriceInSalesDocCrcy - coalesce( RARecognizedRevnInSlsDocCrcy, 0 ) - coalesce( RecgdCatchUpAmtInSlsDocCrcy , 0 ) as farr_open_revenue) AS RATotalOpenRevnInSlsDocCrcy,
  cast( RARecognizedRevnInSlsDocCrcy as farr_cds_fulfillmt_revn ) AS RAFlfmtRecgdRevnInSlsDocCrcy,
  cast( RecgdCatchUpAmtInSlsDocCrcy as farr_cds_rev_catchup_amt ) AS RecgdCatchUpAmtInSlsDocCrcy,
  _RevnAmt.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast( '%' as farr_quantity_unit ) AS RatioUnit,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  _ChangedByUser.UserDescription AS LastChangedByUserDescription,
  FunctionalArea,
  BusinessArea,
  CostCenter,
  WBSElementExternalID,
  ControllingArea,
  PerfOblgn._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  PerfOblgn._ProfitCenter AS _ProfitCenter
FROM I_RAPerformanceObligation AS PerfOblgn
LEFT OUTER JOIN I_RevenueAccountingMapping AS _Mapping ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RAPerfOblgnIsFrozen AS _IsFrozen ON PerformanceObligation = _IsFrozen.PerformanceObligation  -- association [0..1]
;