C_RAPriceAllocationDetails

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_RAPriceAllocationDetails.
-- 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_RAPriceAllocationDetails AS
SELECT
  PerformanceObligation,
  RevenueAccountingContract,
  RevnAcctgContrChangeEffctvDate,
  RevnAcctgReconciliationKey,
  PerformanceObligationClass,
  CompanyCode,
  RAFulfillmentIsValueBased,
  RAPerfOblgnFinalizationDate,
  RAPerfOblgnCategory,
  _Category.RAPerfOblgnCategoryName AS RAPerfOblgnCategoryName,
  RootPerformanceObligationInBOM,
  FiscalYearPeriod,
  RAPerfOblgnChangeType,
  RABusinessChangeReason,
  RAPerfOblgnDistinctType,
  ContractualPrcInSlsDocCrcy,
  AllocatedPriceInSalesDocCrcy,
  SSPriceInSalesDocCrcy,
  SSPriceTolerancePercent,
  RatioUnit,
  SSPriceToleranceAmount,
  SalesDocumentCurrency,
  RAPerfOblgnIsResidual,
  PerfOblgnIsExclFromPriceAlloc,
  RAContractIsManuallyAllocated,
  PerfOblgnEffectiveQuantity,
  RAPrevContrChangeEffctvDate,
  PrevRecognizedAmtInSlsDocCrcy,
  PerfOblgnPreviousFulfilledQty,
  PerfOblgnEffectiveQuantityUnit,
  PreviousSSPriceInSalesDocCrcy,
  PrevSSPriceTolAmtInSlsDocCrcy,
  PrevSSPriceTolerancePercent,
  PrevPerfOblgnEffectiveQuantity,
  PrevContractualPrcInSlsDocCrcy,
  PrevAllocatedPriceInSlsDocCrcy,
  RemainingSSPriceInSalesDocCrcy,
  RmngSSPriceTolAmtInSlsDocCrcy,
  RATotalInterestAmtInSlsDocCrcy,
  ToBeAllocatedAmtInSlsDocCrcy,
  AllocRsltAmtInSlsDocCrcy,
  RAAllocAmtDistrDetailIsHidden
FROM I_RAPriceAllocationDetails
LEFT OUTER JOIN C_RAChangeTypeItemChangeHist AS _ChgTypeItmChgHist ON PerformanceObligation = _ChgTypeItmChgHist.RAHigherLevelPerfOblgn AND RevenueAccountingContract = _ChgTypeItmChgHist.RevenueAccountingContract AND RevnAcctgContrChangeEffctvDate = _ChgTypeItmChgHist.RACurrentContrChangeEffctvDate  -- association [1..*]
LEFT OUTER JOIN C_RAAllocatedAmtDistrDetail AS _DistrDetail ON PerformanceObligation = _DistrDetail.RAHigherLevelPerfOblgn AND RevenueAccountingContract = _DistrDetail.RevenueAccountingContract AND RevnAcctgContrChangeEffctvDate = _DistrDetail.RevnAcctgContrChangeEffctvDate AND RAPerfOblgnDistinctType = 'C'  -- association [1..*]
LEFT OUTER JOIN I_RevnAcctgChangeTypeText AS _ChangeTypeText ON RAPerfOblgnChangeType = _ChangeTypeText.RAPerfOblgnChangeType  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnDistinctTypeText AS _DistinctTypeText ON RAPerfOblgnDistinctType = _DistinctTypeText.RAPerfOblgnDistinctType  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnCategoryText AS _Category ON RAPerfOblgnCategory = _Category.RAPerfOblgnCategory AND _Category.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN E_RAPerfOblgnChangeTypeItem AS _E_RAPerfOblgnChangeTypeItem ON RevenueAccountingContract = _E_RAPerfOblgnChangeTypeItem.RevenueAccountingContract AND PerformanceObligation = _E_RAPerfOblgnChangeTypeItem.PerformanceObligation AND RevnAcctgContrChangeEffctvDate = _E_RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate  -- association [1..1]
;