I_RARevnExplanationItem

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_RARevnExplanationItem.
-- 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 I_RARevnExplanationItem AS
SELECT
  RevnExplItemWithRevnQty.RAHigherLevelPerfOblgn AS RAHigherLevelPerfOblgn,
  RevnExplItemWithRevnQty.RecnclnKeyGroupId AS RevnAcctgReconciliationKey,
  RevnExplItemWithRevnQty.RARevenueAdjustReason AS RARevenueAdjustReason,
  RevnExplItemWithRevnQty.RevenueAccountingContract AS RevenueAccountingContract,
  RevnExplItemWithRevnQty.FiscalYearPeriod AS FiscalYearPeriod,
  PerfOblgn.CompanyCode AS CompanyCode,
  RevnExplItemWithRevnQty.RAHigherLevelPerfOblgn AS PerformanceObligation,
  PerfOblgn.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  PerfOblgn.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerfOblgn.PerfOblgnEventType AS PerfOblgnEventType,
  PerfOblgn.RAFulfillmentIsValueBased AS RAFulfillmentIsValueBased,
  PerfOblgn.PerfOblgnStartDateType AS PerfOblgnStartDateType,
  RevnExplItemCumltvValue.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast(ChgTypeItemKeyGroup.AllocatedPriceInSalesDocCrcy as farr_allocated_amt preserving type) AS CumltvEffectiveAmtInSlsDocCrcy,
  ChgTypeItemKeyGroup.PerfOblgnFaceAmtInSlsDocCrcy AS PerfOblgnFaceAmtInSlsDocCrcy,
  ChgTypeItemKeyGroup.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  cast(RevnExplItemWithRevnQty.DeltaRecognizedAmtInSlsDocCrcy as farr_cds_recog_amt preserving type) AS DeltaRecognizedAmtInSlsDocCrcy,
  cast(RevnExplItemWithRevnQty.DeltaRecognizedAmtInSlsDocCrcy as farr_cds_rev_catchup_amt preserving type) AS RecgdCatchUpAmtInSlsDocCrcy,
  PerfOblgn.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  ChgTypeItemKeyGroup.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  cast(RevnExplItemWithRevnQty.DeltaPerfOblgnFulfilledQty as farr_cds_delta_fulfilled_qty) AS DeltaPerfOblgnFulfilledQty,
  cast(RevnExplItemWithRevnQty.DeltaPerfOblgnFulfilledAmount as farr_cds_fulfilled_value preserving type) AS FulfilledAmountInSlsDocCrcy,
  cast('%' as farr_quantity_unit) AS RatioUnit,
  ChgTypeItemKeyGroup.PerformanceObligationClass AS PerformanceObligationClass,
  ChgTypeItemKeyGroup.RABusinessChangeReason AS RABusinessChangeReason,
  ChgTypeItemKeyGroup.RAPerfOblgnChangeType AS RAPerfOblgnChangeType,
  ChgTypeItemKeyGroup.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  ChgTypeItemKeyGroup.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  ChgTypeItemKeyGroup.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  ChgTypeItemKeyGroup.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  'X' AS RARevenueCatchUpIsHidden,
  'X' AS RAChangedFieldIsHidden,
  'X' AS RAFulfillmentDetailIsHidden,
  cast('00000000' as farr_effective_date) AS RevnAcctgContrChangeEffctvDate,
  cast('00000000' as farr_cds_prior_effective_date) AS RAPrevContrChangeEffctvDate,
  '' AS RAContractIsSoftDeleted,
  cast(RevnAdjustReasonText.RARevenueAdjustReasonName as farr_cds_rev_adj_reason_text) AS RARevenueAdjustReasonName
FROM P_RARevnExplItemWithRevnQty AS RevnExplItemWithRevnQty
LEFT OUTER JOIN I_RARevenueAdjustReasonText AS RevnAdjustReasonText ON RARevenueAdjustReason = RevnAdjustReasonText.RARevenueAdjustReason  -- association [1..*]
-- UNION ALL with additional select branch(es): P_RARevnExplMigrationItem
;