I_PRAPricingFormulaTerms2

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_PRAPricingFormulaTerms2.
-- 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_PRAPricingFormulaTerms2 AS
SELECT
  formula_term_uuid AS PRAPricingFormulaTermUUID,
  formula_uuid AS PRAPricingFormulaUUID,
  fortrmtyp AS FormulaTermType,
  kopos AS PricingFormulaTermItemNumber,
  oiu_quotgrp AS PricingQuotationGroup,
  quosrc AS PricingQuotationSource,
  quotyp AS PricingQuotationType,
  quotno AS PricingQuotationNumber,
  mult1 AS PricingFormulaCalcFctrOneVal,
  mult2 AS PricingFormulaCalcFctrTwoVal,
  trmexit AS PricingTermCalcRule,
  surcharge AS PricingFormulaSurchargeAmt,
  surcurr AS PricingFormulaCurrency,
  surprun AS PricingSurchargeVolInQty,
  suruom AS PricingSurchargeVolUnit,
  perbef AS PeriodsBeforeRefDteInVal,
  peraft AS PeriodsAfterRefDteInVal,
  datfrm AS FormulaFixedPeriodStartDte,
  datto AS FormulaFixedPeriodEndDte,
  local_last_changed_at AS PRALoclLastChgdAtDateTime
FROM oiu_fanda_termsb
LEFT OUTER JOIN I_PRAPricingFormulaHeader AS _PRAPricingFormulaHeader ON PRAPricingFormulaUUID = _PRAPricingFormulaHeader.PRAPricingFormulaUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON PricingSurchargeVolUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON PricingFormulaCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PRAQuotationSource AS _PRAQuotationSource ON PricingQuotationSource = _PRAQuotationSource.PricingQuotationSource  -- association [1..1]
LEFT OUTER JOIN I_PRAQuotationType AS _PRAQuotationType ON PricingQuotationType = _PRAQuotationType.PricingQuotationType  -- association [1..1]
LEFT OUTER JOIN I_PRAQuotation AS _PRAQuotation ON PricingQuotationSource = _PRAQuotation.PricingQuotationSource AND PricingQuotationType = _PRAQuotation.PricingQuotationType AND PricingQuotationNumber = _PRAQuotation.PricingQuotationNumber  -- association [1..1]
LEFT OUTER JOIN I_PRAFormulaTermItemRule AS _PRAFormulaTermItemRule ON PricingTermCalcRule = _PRAFormulaTermItemRule.PricingTermCalcRule  -- association [1..1]
;