C_CntrlPurConHierCmmdtyTermTP

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_CntrlPurConHierCmmdtyTermTP.
-- 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: CCCNTRHTERMTP

CREATE VIEW C_CntrlPurConHierCmmdtyTermTP AS
SELECT
  ConditionRecord,
  ConditionSequentialNumber,
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  ConditionValidityEndDate,
  PricingConditionTerm,
  _CommodityPricingTermText[1:Language=$session.system_language].PricingConditionTermText AS PricingConditionTermText,
  DocItemCommodityPricingUUID,
  ConditionType,
  PricingConditionFormulaKey,
  PrcgConditionFormulaInputUUID,
  OriginSystem,
  PrcgCndnFmlaCommodityQuantity,
  PrcgCndnFmlaCmmdtyQuantityUnit,
  PrcgCndnFmlaEvaluationDateTime,
  PricingConditionTermGroup,
  PricingConditionTermKey,
  _CmmdtyPrcgTermCalcTypeText[1:Language=$session.system_language].PricingConditionRoutineText AS PrcgCndnTrmCalculationTypeText,
  PrcgCndnTermCalculationType,
  PricingConditionTermFixedRate,
  PrcgConditionTermFixedRateCrcy,
  PrcgConditionTermFixedRateQty,
  PrcgCndnTermFixedRateQtyUnit,
  PricingConditionTermRule,
  _CmmdtyPricingTermRuleText[1:Language=$session.system_language].PricingConditionRuleText AS PricingConditionTermRuleText,
  PrcgCndnTermCalculationRule,
  _CmmdtyPrcgCalcRuleText[1:Language=$session.system_language].PricingConditionRuleText AS PrcgCndnCalculationRuleText,
  PrcgCndnTermQuotationRule,
  _CmmdtyPrcgQuotationRuleText[1:Language=$session.system_language].PricingConditionRuleText AS PrcgConditionQuotationRuleText,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  TimeToMaturity,
  QuotationPriceType,
  PricingConditionTermRate,
  PrcgConditionTermRateCrcy,
  PrcgConditionTermRateQty,
  PrcgConditionTermRateQtyUnit,
  PrcgConditionTermQuotationRate,
  PrcgCndnTrmQtanRateCurrency,
  PrcgCndnTrmQtanRateQuantity,
  PrcgCndnTrmQtanRateQtyUnit,
  PrcgCndnTrmQtanPerdStrtDteTime,
  PrcgCndnTrmQtanPerdEndDateTime,
  PrcgCndnTrmQtanPerdRefDate,
  PrcgCndnTrmQtanPerdBaseDteTime,
  CndnTrmExchRatePerdStrtDteTime,
  CndnTrmExchRatePerdEndDateTime,
  PrcgCndnTrmExchRatePerdRefDate,
  CndnTrmExchRatePerdBaseDteTime,
  PrcgConditionTermSurchargeRate,
  PrcgCndnTrmSurchargeRteCrcy,
  PrcgCndnTrmSurchargeRteQty,
  PrcgCndnTrmSurchargeRteQtyUnit,
  PricingConditionSourceCurrency,
  PricingConditionTargetCurrency,
  PrcgConditionFixedExchangeRate,
  cast( '' as boolean preserving type ) AS PrcgCndnCnvrsnIsExchRateAvg,
  PricingConditionConversionRule,
  CndnCnvrsnRuleValdtyStrtDteTme,
  PrcgConditionConversionPlace,
  cast( '' as boolean preserving type ) AS PrcgCndnTrmFixRateIsDisabled,
  cast( '' as boolean preserving type ) AS PrcgCndnQuotationIsDisabled,
  cast( '' as cmm_cctr_term_page_title ) AS PricingConditionTermTitle,
  cast( '' as boolean preserving type ) AS PrcgCndnSurchargeIsDisabled,
  cast( '' as boolean preserving type ) AS PrcgCndnExchangeRateIsDisabled,
  cast( '' as boolean preserving type) AS PrcgCndnQtanExchRateIsDisabled,
  cast( '' as boolean preserving type) AS PrcgCndnExchRateAvgIsDisabled
FROM I_CntrlPurContrCmmdtyTermTP AS CntrlPurContrCmmdtyTermTP
LEFT OUTER JOIN C_CntrlPurContrHierHdrTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurConHierCmmdtyFmlaTP AS _CntrlPurContrCmmdtyFormulaTP ON ConditionRecord = _CntrlPurContrCmmdtyFormulaTP.ConditionRecord AND ConditionSequentialNumber = _CntrlPurContrCmmdtyFormulaTP.ConditionSequentialNumber AND CentralPurchaseContract = _CntrlPurContrCmmdtyFormulaTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrCmmdtyFormulaTP.CentralPurchaseContractItem AND ConditionValidityEndDate = _CntrlPurContrCmmdtyFormulaTP.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrHierCmmdtyQtnTP AS _CntrlPurContrCmmdtyTrmQtnTP ON ConditionRecord = _CntrlPurContrCmmdtyTrmQtnTP.ConditionRecord AND ConditionSequentialNumber = _CntrlPurContrCmmdtyTrmQtnTP.ConditionSequentialNumber AND CentralPurchaseContract = _CntrlPurContrCmmdtyTrmQtnTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrCmmdtyTrmQtnTP.CentralPurchaseContractItem AND ConditionValidityEndDate = _CntrlPurContrCmmdtyTrmQtnTP.ConditionValidityEndDate AND PricingConditionTerm = _CntrlPurContrCmmdtyTrmQtnTP.PricingConditionTerm  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrHierExchRateTP AS _CntrlPurConCmmdtyExchRateTP ON ConditionRecord = _CntrlPurConCmmdtyExchRateTP.ConditionRecord AND ConditionSequentialNumber = _CntrlPurConCmmdtyExchRateTP.ConditionSequentialNumber AND CentralPurchaseContract = _CntrlPurConCmmdtyExchRateTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurConCmmdtyExchRateTP.CentralPurchaseContractItem AND ConditionValidityEndDate = _CntrlPurConCmmdtyExchRateTP.ConditionValidityEndDate AND PricingConditionTerm = _CntrlPurConCmmdtyExchRateTP.PricingConditionTerm  -- association [0..*]
;