I_PricingConditionRecord

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_PricingConditionRecord.
-- 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_PricingConditionRecord AS
SELECT
  header.ConditionRecord AS ConditionRecord,
  item.ConditionSequentialNumber AS ConditionSequentialNumber,
  header.ConditionTable AS ConditionTable,
  header.ConditionApplication AS ConditionApplication,
  item.ConditionType AS ConditionType,
  header.ConditionValidityEndDate AS ConditionValidityEndDate,
  header.ConditionValidityStartDate AS ConditionValidityStartDate,
  header.CreatedByUser AS CreatedByUser,
  header.CreationDate AS CreationDate,
  item.ConditionTextID AS ConditionTextID,
  item.PricingScaleType AS PricingScaleType,
  item.PricingScaleBasis AS PricingScaleBasis,
  item.ConditionScaleQuantity AS ConditionScaleQuantity,
  item.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  item.ConditionScaleAmount AS ConditionScaleAmount,
  item.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  item.ConditionCalculationType AS ConditionCalculationType,
  item.ConditionRateValue AS ConditionRateValue,
  item.ConditionRateValueUnit AS ConditionRateValueUnit,
  item.ConditionRateRatio AS ConditionRateRatio,
  item.ConditionRateRatioUnit AS ConditionRateRatioUnit,
  item.ConditionRateAmount AS ConditionRateAmount,
  item.ConditionCurrency AS ConditionCurrency,
  item.ConditionQuantity AS ConditionQuantity,
  item.ConditionQuantityUnit AS ConditionQuantityUnit,
  item.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  item.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  item.BaseUnit AS BaseUnit,
  item.ConditionLowerLimit AS ConditionLowerLimit,
  item.ConditionLowerLimitAmount AS ConditionLowerLimitAmount,
  item.ConditionLowerLimitRatio AS ConditionLowerLimitRatio,
  item.ConditionUpperLimit AS ConditionUpperLimit,
  item.ConditionUpperLimitAmount AS ConditionUpperLimitAmount,
  item.ConditionUpperLimitRatio AS ConditionUpperLimitRatio,
  item.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  item.ConditionExclusion AS ConditionExclusion,
  item.ConditionIsDeleted AS ConditionIsDeleted,
  item.AdditionalValueDays AS AdditionalValueDays,
  item.FixedValueDate AS FixedValueDate,
  item.PaymentTerms AS PaymentTerms,
  item.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  item.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  item.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  item.MaximumConditionAmount AS MaximumConditionAmount,
  item.IncrementalScale AS IncrementalScale,
  item.PricingScaleLine AS PricingScaleLine,
  item.ConditionReleaseStatus AS ConditionReleaseStatus,
  item.ConditionChangeReason AS ConditionChangeReason,
  item.CmmdtyPrcgConditionFormulaUUID AS CmmdtyPrcgConditionFormulaUUID
FROM P_PrcgCndnRecordHeader AS header
INNER JOIN P_PrcgCndnRecordItem AS item ON /* join condition not captured in parsed metadata */
;