P_ContractMtM

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_ContractMtM.
-- 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: PCONTRMTM
-- Parameters: P_Language : spras, P_MTMDataSelectionType : cmm_vlogp_consumptiontype

CREATE VIEW P_ContractMtM AS
SELECT
  ContrMtM.PricingKey AS PricingKey,
  ContrMtM.Version AS Version,
  ContrMtM.PricingDocumentItem AS PricingDocumentItem,
  ContrMtM.ConditionType AS ConditionType,
  ContrMtM.SubConditionType AS SubConditionType,
  ContrMtM.VersStockRecordUUID AS VersStockRecordUUID,
  ContrMtM.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  ContrMtM.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
  ContrMtM.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
  ContrMtM.CompanyCodeName AS CompanyCodeName,
  ContrMtM.ProfitCenter AS ProfitCenter,
  ContrMtM.PlantName AS PlantName,
  ContrMtM.CommodityName AS CommodityName,
  ContrMtM.MaterialName AS MaterialName,
  ContrMtM.OriginReferenceDocument AS OriginReferenceDocument,
  ContrMtM.SourceDocument AS SourceDocument,
  ContrMtM.SourceDocumentItem AS SourceDocumentItem,
  ContrMtM.SourceDocumentBusObjTypeName AS SourceDocumentBusObjTypeName,
  ContrMtM.ValidityStartDate AS ValidityStartDate,
  ContrMtM.IncotermsClassificationName AS IncotermsClassificationName,
  ContrMtM.IncotermsTransferLocation AS IncotermsTransferLocation,
  ContrMtM.StatisticsCurrency AS StatisticsCurrency,
  ContrMtM.MTMConditionGroupCategoryName AS MTMConditionGroupCategoryName,
  ContrMtM.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  ContrMtM.MaturityKeyDate AS MaturityKeyDate,
  ContrMtM.BasisIDName AS BasisIDName,
  ContrMtM.DerivativeContrSpecName AS DerivativeContrSpecName,
  ContrMtM.MarketIdentifierCodeName AS MarketIdentifierCodeName,
  ContrMtM.PricingStatusName AS PricingStatusName,
  ContrMtM.MTMAdjustmentTypeName AS MTMAdjustmentTypeName,
  ContrMtM.ConditionTermRateFixation AS ConditionTermRateFixation,
  ContrMtM.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  ContrMtM.CommodityQuantity AS CommodityQuantity,
  ContrMtM.ConditionTermRate AS ConditionTermRate,
  ContrMtM.MarketToDocExchRate AS MarketToDocExchRate,
  ContrMtM.DocToStatisticalExchRate AS DocToStatisticalExchRate,
  ContrMtM.ConditionTermValueInStstcCrcy AS ConditionTermValueInStstcCrcy,
  ContrMtM.ConditionTermValueInDocCrcy AS ConditionTermValueInDocCrcy,
  ContrMtM.CompanyCode AS CompanyCode,
  ContrMtM.Commodity AS Commodity,
  ContrMtM.Material AS Material,
  ContrMtM.Plant AS Plant,
  ContrMtM.Creditor AS Creditor,
  ContrMtM.SoldToParty AS SoldToParty,
  ContrMtM.OriginRefDocBusObjTypeName AS OriginRefDocBusObjTypeName,
  ContrMtM.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  ContrMtM.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  ContrMtM.ReferenceDocument AS ReferenceDocument,
  ContrMtM.ReferenceDocBusObjTypeName AS ReferenceDocBusObjTypeName,
  ContrMtM.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  ContrMtM.ReferenceDocumentItem AS ReferenceDocumentItem,
  ContrMtM.DeliveryYear AS DeliveryYear,
  ContrMtM.DeliveryDate AS DeliveryDate,
  ContrMtM.DeliveryMonth AS DeliveryMonth,
  ContrMtM.ExpectedPaymentDate AS ExpectedPaymentDate,
  ContrMtM.ExchRateEvaluationDate AS ExchRateEvaluationDate,
  ContrMtM.DocToStstcCrcyExchRateEvalDate AS DocToStstcCrcyExchRateEvalDate,
  ContrMtM.DocumentCurrency AS DocumentCurrency,
  ContrMtM.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  ContrMtM.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  ContrMtM.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  ContrMtM.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  ContrMtM.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  ContrMtM.ExchRateMaturityDate AS ExchRateMaturityDate,
  ContrMtM.BsMktRefDrvtvContrMaturityCode AS BsMktRefDrvtvContrMaturityCode,
  ContrMtM.BasisMarketRefRate AS BasisMarketRefRate,
  ContrMtM.BasisMarketRefAdjustmentSpread AS BasisMarketRefAdjustmentSpread,
  ContrMtM.MarketToDocFrozenExchRate AS MarketToDocFrozenExchRate,
  ContrMtM.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  ContrMtM.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  ContrMtM.OldestQuotationDate AS OldestQuotationDate,
  ContrMtM.SystemMessageText AS SystemMessageText,
  ContrMtM.HasError AS HasError,
  ContrMtM.MTMDataSourceType AS MTMDataSourceType,
  ContrMtM.PhysicalCommodity AS PhysicalCommodity,
  ContrMtM.SalesOrganization AS SalesOrganization,
  ContrMtM.DistributionChannel AS DistributionChannel,
  ContrMtM.Division AS Division,
  ContrMtM.StorageLocation AS StorageLocation,
  ContrMtM.Batch AS Batch,
  ContrMtM.GoodsMovementType AS GoodsMovementType,
  ContrMtM.IncotermsClassification AS IncotermsClassification,
  ContrMtM.BusinessArea AS BusinessArea,
  ContrMtM.PurchasingOrganization AS PurchasingOrganization,
  ContrMtM.MaterialGroup AS MaterialGroup,
  ContrMtM.BasisID AS BasisID,
  ContrMtM.SystemMessageNumber AS SystemMessageNumber,
  ContrMtM.MTMCalculationGroup AS MTMCalculationGroup,
  ContrMtM.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  ContrMtM.MTMConditionGroup AS MTMConditionGroup,
  ContrMtM.MTMAdjustmentType AS MTMAdjustmentType,
  ContrMtM.PricingStatus AS PricingStatus,
  ContrMtM.BasisMarketRefRateCurrency AS BasisMarketRefRateCurrency,
  ContrMtM.BasisMarketRefKeyDate AS BasisMarketRefKeyDate,
  ContrMtM.ConditionTermFactor AS ConditionTermFactor,
  ContrMtM.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  ContrMtM.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  ContrMtM.DerivativeContrSpecification AS DerivativeContrSpecification,
  ContrMtM.MarketIdentifierCode AS MarketIdentifierCode,
  ContrMtM.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  ContrMtM.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  ContrMtM.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  ContrMtM.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  ContrMtM.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  ContrMtM.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  CmmdtyUnitConv.CmmdtyPriceExpsrVolumeUnit AS CmmdtyQtytermVolUnit,
  _vlogp.ConditionApplication AS ConditionApplication,
  _vlogp.PricingProcedure AS PricingProcedure
FROM P_ContrMtmValueCube
LEFT OUTER JOIN I_ContrPrcAttribLogSync AS LogSync ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyUnitCnvrsn AS CmmdtyUnitConv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PhysCmmdtyUnit AS PCommUom ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMaterialUnitCnvrsnFactor AS PConvFactorPCU ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS PConvFactorPCUT006 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMaterialUnitCnvrsnFactor AS BasePhyCommUoM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS BasePhyCommUoMT006 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMaterialUnitCnvrsnFactor AS BaseUoM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS BaseUoMT006 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMaterialUnitCnvrsnFactor AS MassUoM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS MassUoMT006 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMMaterialUnitCnvrsnFactor AS VolumeUoM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasure AS VolumeUoMT006 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ContrVersionedLogPrcDoc AS _vlogp ON ContrMtM.PricingKey = _vlogp.PricingKey AND ContrMtM.Version = _vlogp.Version AND ContrMtM.PricingDocumentItem = _vlogp.PricingDocumentItem AND ContrMtM.ConditionType = _vlogp.ConditionType AND ContrMtM.SubConditionType = _vlogp.SubConditionType  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityMassUnit ON CmmdtyPriceExpsrMassUnit = _CommodityMassUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityVolumeUnit ON CmmdtyPriceExpsrVolumeUnit = _CommodityVolumeUnit.UnitOfMeasure  -- association [0..1]
;