I_PRAPricingFormulaHeader

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_PRAPricingFormulaHeader.
-- 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_PRAPricingFormulaHeader AS
SELECT
  formula_uuid AS PRAPricingFormulaUUID,
  formula_id AS PricingFormulaNumber,
  fordesc AS PricingFormulaDescription,
  eff_from_date AS EffectiveValidityStartDate,
  eff_to_date AS EffectiveValidityEndDate,
  foravb AS FormulaTermRule,
  oiu_dnty AS DensityType,
  oiu_dmgrv AS EstimatedStandardDensityVal,
  oiu_clgrv AS FormulaCeilingGravityVal,
  oiu_flgrv AS FormulaFloorGravityVal,
  oiu_floor AS FormulaFlooringRateInAmt,
  oiu_curf AS FormulaFlooringRateCurrency,
  oiu_perf AS FormulaFloorCndnPrcgUnitQty,
  oiu_uomf AS FlooringRateVolUnit,
  oiu_ceil AS FormulaCeilingRateInAmt,
  oiu_curc AS FormulaCeilingRateCurrency,
  oiu_perc AS FormulaCeilingCndnPrcgUnitQty,
  oiu_uomc AS CeilingRateVolUnit,
  oiu_crtmstmp AS PRACreationDateTime,
  oiu_cruser AS CreatedByUser,
  oiu_chtmstmp AS PRAChangeDateTime,
  oiu_chuser AS LastChangedByUser,
  local_last_changed_at AS PRALoclLastChgdAtDateTime
FROM oiu_fanda_header
LEFT OUTER JOIN I_Currency AS _Currency ON FormulaFlooringRateCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CeilingCurrency ON FormulaCeilingRateCurrency = _CeilingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _FloorUnitOfMeasure ON FlooringRateVolUnit = _FloorUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CeilingUnitOfMeasure ON CeilingRateVolUnit = _CeilingUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PRAFormulaTermRule AS _PRAFormulaTermRule ON FormulaTermRule = _PRAFormulaTermRule.FormulaTermRule  -- association [0..1]
LEFT OUTER JOIN I_DensityType AS _DensityType ON DensityType = _DensityType.DensityType  -- association [0..1]
;