I_RAChangeTypeItemChangeHist

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_RAChangeTypeItemChangeHist.
-- 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: IRACHGTYPCHGHIS

CREATE VIEW I_RAChangeTypeItemChangeHist AS
SELECT
  PerformanceObligation,
  RevnAcctgContrChangeEffctvDate,
  RACurrentContrChangeEffctvDate,
  cast ('' as fieldname) AS ChangeDocDatabaseTableField,
  cast('' as scrtext_l) AS DatabaseTableFieldText,
  RevenueAccountingContract,
  OriglRevenueAccountingContract,
  _PerformanceObligation.CompanyCode AS CompanyCode,
  cast('' as changedocnewfieldvalue) AS ChangeDocNewFieldValue,
  cast('' as changedocpreviousfieldvalue) AS ChangeDocPreviousFieldValue,
  RAChangeTypeChangeDateTime,
  PerformanceObligationClass,
  RAPerfOblgnDistinctType,
  _DistinctTypeText.RAPerfOblgnDistinctTypeName AS RAPerfOblgnDistinctTypeName,
  RAHigherLevelPerfOblgn,
  SSPriceInSalesDocCrcy,
  SSPriceTolerancePercent,
  SSPriceToleranceAmount,
  ContractualPrcInSlsDocCrcy,
  OplContractualPrcInSlsDocCrcy,
  SalesDocumentCurrency,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  PerfOblgnFulfillmentType,
  PerfObligationDeferralMethod,
  _NewDeferralMethodTxt.PerfOblgnDeferralMethodText AS PerfOblgnDeferralMethodText,
  PerfOblgnContractualQuantity,
  PerfOblgnContractualQtyUnit,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  RAPerfOblgnIsResidual,
  PerfOblgnIsExclFromPriceAlloc,
  RAContractIsManuallyAllocated,
  PerfOblgnIsFinallyInvoiced,
  PerfOblgnIsSoftDeleted,
  RAPerfOblgnFinalizationDate
FROM P_RAChangeTypeItemChangeHist
LEFT OUTER JOIN I_RAPerformanceObligation AS _PerformanceObligation ON PerformanceObligation = _PerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnDeferralMethodTxt AS _NewDeferralMethodTxt ON PerfObligationDeferralMethod = _NewDeferralMethodTxt.PerfObligationDeferralMethod AND _NewDeferralMethodTxt.Language = $session.system_language  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnDistinctTypeText AS _DistinctTypeText ON RAPerfOblgnDistinctType = _DistinctTypeText.RAPerfOblgnDistinctType AND _DistinctTypeText.Language = $session.system_language  -- association [0..1]
;