P_Cpe_T_Rate_Stock_Deltaqty

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 P_Cpe_T_Rate_Stock_Deltaqty.
-- 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: PCPETRATESTOD
-- Parameters: P_consumption_type : cmm_vlogp_consumptiontype, P_valuation_date0 : cmm_eval_keydate, P_valuation_date1 : cmm_eval_keydate, P_FX_valuation_date : cmm_eval_keydate, P_snapshot_date0 : cmm_dend_cutdate, P_snapshot_date1 : cmm_dend_cutdate

CREATE VIEW P_Cpe_T_Rate_Stock_Deltaqty AS
SELECT
  termrate.PricingKey AS PricingKey,
  termrate.Version AS Version,
  termrate.ConditionType AS ConditionType,
  termrate.SubConditionType AS SubConditionType,
  stockdelta.VersStockRecordUUID AS VersStockRecordUUID,
  termrate.valuationDate AS valuationDate,
  termrate.FXvaluationDate AS FXvaluationDate,
  termrate.FXvaluationDateDocToStstc AS FXvaluationDateDocToStstc,
  termrate.Scenario AS Scenario,
  termrate.SnapshotDate0 AS SnapshotDate0,
  termrate.SnapshotDate1 AS SnapshotDate1,
  termrate.DataSelectionType AS DataSelectionType,
  termrate.MTMDataSourceType AS MTMDataSourceType,
  termrate.ValidityStartDate AS ValidityStartDate,
  termrate.ValidityStartDateTime AS ValidityStartDateTime,
  termrate.ValidityEndDate AS ValidityEndDate,
  termrate.ValidityEndDateTime AS ValidityEndDateTime,
  termrate.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  termrate.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  termrate.EndOfDayTimestampFrom AS EndOfDayTimestampFrom,
  termrate.EndOfDayTimestampTo AS EndOfDayTimestampTo,
  termrate.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  termrate.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  termrate.MaximumVersion AS MaximumVersion,
  termrate.PreviousVersion AS PreviousVersion,
  termrate.PreviousSubConditionType AS PreviousSubConditionType,
  termrate.SalesOrganization AS SalesOrganization,
  termrate.DistributionChannel AS DistributionChannel,
  termrate.Division AS Division,
  termrate.Creditor AS Creditor,
  termrate.SoldToParty AS SoldToParty,
  termrate.Material AS Material,
  termrate.PhysicalCommodity AS PhysicalCommodity,
  termrate.Plant AS Plant,
  termrate.StorageLocation AS StorageLocation,
  termrate.Batch AS Batch,
  termrate.IncotermsTransferLocation AS IncotermsTransferLocation,
  termrate.ConditionApplication AS ConditionApplication,
  case when (stockdelta.PricingKey is not null or stockdelta.PricingKey != ' ') AS SourceDocumentendasSourceDocument,
  termrate.OriginReferenceDocument AS OriginReferenceDocument,
  termrate.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  termrate.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  termrate.ReferenceDocument AS ReferenceDocument,
  termrate.ReferenceDocumentItem AS ReferenceDocumentItem,
  termrate.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  termrate.DeliveryDate AS DeliveryDate,
  termrate.ExpectedPaymentDate AS ExpectedPaymentDate,
  termrate.StatisticsCurrency AS StatisticsCurrency,
  termrate.DocumentCurrency AS DocumentCurrency,
  termrate.ProfitCenter AS ProfitCenter,
  termrate.BusinessArea AS BusinessArea,
  termrate.PurchasingOrganization AS PurchasingOrganization,
  termrate.MaterialGroup AS MaterialGroup,
  termrate.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  termrate.ConditionTermRateConv AS ConditionTermRateConv,
  termrate.OldConditionTermrate AS OldConditionTermrate,
  termrate.MarketToDocExchrate AS MarketToDocExchrate,
  termrate.MarketToDocFrozenExchrate AS MarketToDocFrozenExchrate,
  termrate.MarketToDocExchrateDate AS MarketToDocExchrateDate,
  termrate.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  termrate.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  termrate.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  termrate.OldConditionTermValue AS OldConditionTermValue,
  termrate.ConditionTermValue AS ConditionTermValue,
  termrate.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  termrate.ConditionTermName AS ConditionTermName,
  termrate.ConditionTermStatus AS ConditionTermStatus,
  termrate.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  termrate.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
  termrate.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  termrate.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  termrate.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  termrate.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  termrate.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  termrate.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  termrate.FixedExchRateDate AS FixedExchRateDate,
  termrate.ExchRateMaturityDate AS ExchRateMaturityDate,
  termrate.BsMktRefDrvtvContrMaturityCode AS BsMktRefDrvtvContrMaturityCode,
  termrate.BasisMarketRefRate AS BasisMarketRefRate,
  termrate.BasisMarketRefRateCurrency AS BasisMarketRefRateCurrency,
  termrate.BasisMarketRefKeyDate AS BasisMarketRefKeyDate,
  termrate.BasisMarketRefAdjustmentSpread AS BasisMarketRefAdjustmentSpread,
  termrate.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  termrate.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  termrate.BasisID AS BasisID,
  termrate.BasisType AS BasisType,
  termrate.QuotationCurrency AS QuotationCurrency,
  termrate.QuotationQuantityUnit AS QuotationQuantityUnit,
  termrate.QuotationGroup AS QuotationGroup,
  termrate.DerivativeContrSpecification AS DerivativeContrSpecification,
  termrate.MarketIdentifierCode AS MarketIdentifierCode,
  termrate.MaturityKeyDate AS MaturityKeyDate,
  termrate.CommodityContractMaturityCode AS CommodityContractMaturityCode,
  termrate.QuotationPriceType AS QuotationPriceType,
  termrate.OldestQuotationDate AS OldestQuotationDate,
  case when (stockdelta.PricingKey is null or stockdelta.PricingKey = ' ') then termrate.CommodityQuantityInTermUnit else AS dec173endasCommodityQuantityInTermUnit,
  termrate.CommodityUnit AS CommodityUnit,
  case when (stockdelta.PricingKey is not null or stockdelta.PricingKey != ' ') then case AS MaterialBaseUnitendendasMaterialBaseUnit,
  case when (stockdelta.PricingKey is null or stockdelta.PricingKey = ' ') then termrate.QuantitySign else stockdelta.QuantitySign * termrate.QuantitySign end as ValueSign AS QuantitySignendasValueSign,
  termrate.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  termrate.MTMConditionGroup AS MTMConditionGroup,
  termrate.MTMCalculationGroup AS MTMCalculationGroup,
  termrate.MTMAdjustmentType AS MTMAdjustmentType,
  termrate.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  termrate.PricingStatus AS PricingStatus,
  termrate.ConditionTermRateFixation AS ConditionTermRateFixation,
  termrate.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  termrate.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  termrate.SystemMessageNumber AS SystemMessageNumber,
  termrate.PrevVersionCommodityQuantity AS PrevVersionCommodityQuantity,
  termrate.PreviousVersionQuantitySign AS PreviousVersionQuantitySign,
  termrate.PrevVersCndnTermRateCurrency AS PrevVersCndnTermRateCurrency,
  termrate.PrevVersionConditionTermValue AS PrevVersionConditionTermValue
FROM P_Cpe_T_Rate_Doccur
LEFT OUTER JOIN I_Vlogpkonvd AS stockdelta ON /* join condition not captured in parsed metadata */
;