C_CntrlPurContrItmCndnAmountTP

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_CntrlPurContrItmCndnAmountTP.
-- 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: CCCTRICNDNAMTTP

CREATE VIEW C_CntrlPurContrItmCndnAmountTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionSequentialNumber,
  ConditionType,
  _ConditionText.ConditionText AS ConditionText,
  ConditionTextID,
  ConditionCalculationType,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionRateRatioUnit,
  ConditionRateRatio,
  ConditionCurrency,
  ConditionRateAmount,
  ConditionRateValueIsAmount,
  ConditionRateValueIsRatio,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  cast ('' as text60) AS ConditionUnitConversionText,
  ConditionLowerLimit,
  ConditionUpperLimit,
  ConditionAlternativeCurrency,
  ConditionExclusion,
  ConditionIsDeleted,
  AdditionalValueDays,
  FixedValueDate,
  PaymentTerms,
  CndnMaxNumberOfSalesOrders,
  MinimumConditionBasisValue,
  MaximumConditionBasisValue,
  MaximumConditionAmount,
  ConditionReleaseStatus,
  ConditionChangeReason,
  _PurgCndnChangeReasonText.ConditionChangeReasonText AS ConditionChangeReasonText,
  CmmdtyPricingEngineIsEnabled,
  cast( '' as boolean preserving type ) AS PrcgCndnCmmdtyDataIsDisabled,
  cast( '' as boolean preserving type ) AS StdPrcgCndnDataIsDisabled,
  cast( ' ' as boolean preserving type) AS CmmdtyPrcgConditionIsActivated,
  cast( ' ' as cmm_cmdty_code_dsbd preserving type) AS PurgDocCmmdtyCodeIsDisabled,
  cast( ' ' as cmm_cmdty_is_dsbd preserving type) AS CommodityIsDisabled,
  ConditionValidityStartDate,
  ProcmtHubPlantUniqueID,
  _CntrlPurContrItmCndnValdtyTP.ProcmtHubPlant AS ProcmtHubPlant,
  _CntrlPurContrItmCndnValdtyTP.ProcmtHubPlantName AS ProcmtHubPlantName,
  _CntrlPurContrItmCndnValdtyTP.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _CntrlPurContrItmCndnValdtyTP.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
  PricingScaleType,
  PricingScaleBasis,
  _PricingScaleBasisText.PricingScaleBasisName AS PricingScaleBasisName,
  PricingScaleCheckingRule,
  _PrcgScaleCheckingRuleText.PricingScaleCheckingRuleName AS PricingScaleCheckingRuleName,
  PricingScaleLine,
  ConditionHasScales,
  _CentralPurchaseContractTP.IsExtPurgScenario AS IsExtPurgScenario
FROM I_CntrlPurContrItmCndnAmountTP
LEFT OUTER JOIN C_CntrlPurContrItmCndnValdtyTP AS _CntrlPurContrItmCndnValdtyTP ON CentralPurchaseContract = _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrItmCndnValdtyTP.CentralPurchaseContractItem AND ConditionRecord = _CntrlPurContrItmCndnValdtyTP.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrItmCndnValdtyTP.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrItmCndnScalesTP AS _CntrlPurContrItmCndnScalesTP ON _CntrlPurContrItmCndnScalesTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItmCndnScalesTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItmCndnScalesTP.ConditionRecord = ConditionRecord AND _CntrlPurContrItmCndnScalesTP.ConditionValidityEndDate = ConditionValidityEndDate AND _CntrlPurContrItmCndnScalesTP.ConditionSequentialNumber = ConditionSequentialNumber  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrCmmdtyFormulaTP AS _CntrlPurContrCmmdtyFormulaTP ON CentralPurchaseContract = _CntrlPurContrCmmdtyFormulaTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrCmmdtyFormulaTP.CentralPurchaseContractItem AND ConditionRecord = _CntrlPurContrCmmdtyFormulaTP.ConditionRecord AND ConditionValidityEndDate = _CntrlPurContrCmmdtyFormulaTP.ConditionValidityEndDate AND ConditionSequentialNumber = _CntrlPurContrCmmdtyFormulaTP.ConditionSequentialNumber  -- association [0..1]
LEFT OUTER JOIN I_PurConditionText AS _ConditionText ON ConditionType = _ConditionText.ConditionType AND _ConditionText.ConditionApplication = 'M' AND _ConditionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PricingScaleBasisText AS _PricingScaleBasisText ON _PricingScaleBasisText.PricingScaleBasis = PricingScaleBasis AND _PricingScaleBasisText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PrcgScaleCheckingRuleText AS _PrcgScaleCheckingRuleText ON _PrcgScaleCheckingRuleText.PricingScaleCheckingRule = PricingScaleCheckingRule AND _PrcgScaleCheckingRuleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgCndnChangeReasonText AS _PurgCndnChangeReasonText ON ConditionChangeReason = _PurgCndnChangeReasonText.ConditionChangeReason AND _PurgCndnChangeReasonText.Language = $session.system_language  -- association [0..1]
;