Deprecated
This CDS view is deprecated in S/4HANA. Use C_CMMDTYSTOCKENDOFDAYQRY instead. View all deprecated CDS views →

C_CmmdtyMtmStkEodQry

DDL: C_CMMDTYMTMSTKEODQRY SQL: CCOMTMSEODQRY Type: view CONSUMPTION
63 Fields 1 Data Sources

MtM End-of-Day Values Query for Stock

C_CmmdtyMtmStkEodQry is a Consumption CDS View that provides data about "MtM End-of-Day Values Query for Stock" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyMtmValueCube) and exposes 63 fields with key field PricingKey.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyMtmValueCube I_CmmdtyMtmValueCube from

Parameters (2)

NameTypeDefault
P_EndOfDaySnapshotDate cmm_dend_cutdate
P_Language spras

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCOMTMSEODQRY view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey PricingKey view
VDM.viewType #CONSUMPTION view
Analytics.query true view
EndUserText.label MtM End-of-Day Values Query for Stock view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_CMMDTYSTOCKENDOFDAYQRY view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY PricingKey PricingKey Pricing Key
CompanyCodeName
ProfitCenter ProfitCenter Profit Center
PlantName _Plant PlantName Plant Name
StorageLocationName _StorageLocation StorageLocationName Storage Loc. Name
CommodityName
ProductName
MTMDataSourceTypeName
MTMConditionGroupCategoryName
MTMCalculationGroupName
SourceDocument SourceDocument Document
CommodityQuantity CommodityQuantity Commodity Quantity
ConditionTermRate ConditionTermRate
MarketToDocExchRate MarketToDocExchRate
DocToStatisticalExchRate DocToStatisticalExchRate
ConditionTermValueInStstcCrcy ConditionTermValueInStstcCrcy
ConditionTermValueInDocCrcy ConditionTermValueInDocCrcy
QuotationPeriodReferenceDate QuotationPeriodReferenceDate
keyfieldsConditionType
SubConditionType SubConditionType
BusinessDocumentCompanyCode
PhysicalCommodity PhysicalCommodity
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
GoodsMovementType GoodsMovementType Movement Type
GoodsMovementTypeName
IncotermsClassificationName
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
SourceDocumentItem SourceDocumentItem
OriginReferenceDocument OriginReferenceDocument Root Document
OriginRefDocBusObjTypeName
OriginReferenceDocBusObjType OriginReferenceDocBusObjType Root (BOR) Obj. Type
OriginReferenceDocumentItem OriginReferenceDocumentItem Root Document Item
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocBusObjTypeName
ReferenceDocBusObjType ReferenceDocBusObjType Pred(BOR) Object Typ
ReferenceDocumentItem ReferenceDocumentItem Reference item
DeliveryYear DeliveryYear
DeliveryDate DeliveryDate Delivery Date
DeliveryMonth DeliveryMonth
ExpectedPaymentDate ExpectedPaymentDate
ExchRateEvaluationDate ExchRateEvaluationDate
StatisticsCurrency StatisticsCurrency
DocumentCurrency DocumentCurrency Document Currency
IsIntercompanyTransfer IsIntercompanyTransfer
ConditionTermRateQuantity ConditionTermRateQuantity
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit
ConditionTermFactor ConditionTermFactor
DerivativeContrSpecName
MarketIdentifierCodeName
BasisIDName
ConditionTermRateFixation ConditionTermRateFixation
PricingStatusName
MarketPriceCurrency MarketPriceCurrency Market Price Crcy
OldestQuotationDate OldestQuotationDate
MiscellanousfieldsBatch
CommodityUnit CommodityUnit Order Unit
MTMAdjustmentTypeName
SystemMessageText
HasError HasError TRUE
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming
CmmdtyForwardIndexTimingText CmmdtyForwardIndexTimingText Short Description

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_CmmdtyMtmStkEodQry.
-- 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: CCOMTMSEODQRY
-- Parameters: P_EndOfDaySnapshotDate : cmm_dend_cutdate, P_Language : spras

CREATE VIEW C_CmmdtyMtmStkEodQry AS
SELECT
  PricingKey,
  ProfitCenter,
  _Plant.PlantName AS PlantName,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _PhysicalCmmdty._Text[1:Language = :P_Language].CommodityName AS CommodityName,
  _Material._Text[1:Language = :P_Language].ProductName AS ProductName,
  _MTMDataSourceType._MtmDataSourceTypT[1:Language = :P_Language].MTMDataSourceTypeName AS MTMDataSourceTypeName,
  _MTMCalculationGroup._MtmCalculationGroupT[1:Language = :P_Language].MTMCalculationGroupName AS MTMCalculationGroupName,
  SourceDocument,
  CommodityQuantity,
  ConditionTermRate,
  MarketToDocExchRate,
  DocToStatisticalExchRate,
  ConditionTermValueInStstcCrcy,
  ConditionTermValueInDocCrcy,
  QuotationPeriodReferenceDate,
  SubConditionType,
  PhysicalCommodity,
  Material,
  MaterialGroup,
  Plant,
  GoodsMovementType,
  IncotermsTransferLocation,
  SourceDocumentItem,
  OriginReferenceDocument,
  _OriginReferenceDocBusObjType._Text[1:Language = :P_Language].BusinessObjectTypeName AS OriginRefDocBusObjTypeName,
  OriginReferenceDocBusObjType,
  OriginReferenceDocumentItem,
  ReferenceDocument,
  _ReferenceDocBusObjType._Text[1:Language = :P_Language].BusinessObjectTypeName AS ReferenceDocBusObjTypeName,
  ReferenceDocBusObjType,
  ReferenceDocumentItem,
  DeliveryYear,
  DeliveryDate,
  DeliveryMonth,
  ExpectedPaymentDate,
  ExchRateEvaluationDate,
  StatisticsCurrency,
  DocumentCurrency,
  IsIntercompanyTransfer,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermFactor,
  _MarketIdentCode._Text[1:Language = :P_Language].MarketIdentifierCodeName AS MarketIdentifierCodeName,
  _BasisID._Text[1:Language = :P_Language].BasisIDName AS BasisIDName,
  ConditionTermRateFixation,
  _PricingStatus._Text[1:Language = :P_Language].PricingStatusName AS PricingStatusName,
  MarketPriceCurrency,
  OldestQuotationDate,
  CommodityUnit,
  _MTMAdjustmentType._MtmAdjustmentTypeT[1:Language = :P_Language].MTMAdjustmentTypeName AS MTMAdjustmentTypeName,
  _CmmdtyMtmMessage[1:Language = :P_Language].SystemMessageText AS SystemMessageText,
  HasError,
  CmmdtyForwardIndexTiming,
  CmmdtyForwardIndexTimingText
FROM I_CmmdtyMtmValueCube
;

Learn More