P_StkMTM_ElevFinalNetQtyData

DDL: P_STKMTM_ELEVFINALNETQTYDATA SQL: PSTKMELEFINAJDQ Type: view COMPOSITE
28 Fields 1 Data Sources

P_StkMTM_ElevFinalNetQtyData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_StkMTM_ElevationNetQtyData) and exposes 28 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

Data Sources (1)

SourceAliasJoin Type
P_StkMTM_ElevationNetQtyData P_StkMTM_ElevationNetQtyData from

Parameters (5)

NameTypeDefault
P_EvaluationDate cmm_eval_keydate
P_ExchRateEvaluationDate cmm_eval_keydate
P_EndOfDaySnapshotFromDate cmm_eval_keydate
P_EndOfDaySnapshotToDate cmm_eval_keydate
P_MTMDataSelectionType cmm_vlogp_consumptiontype

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSTKMELEFINAJDQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PricingKey NetQty PricingKey Pricing Key
KEY Version NetQty Version XML Vers.
KEY PricingDocumentItem NetQty PricingDocumentItem Item
KEY ConditionType NetQty ConditionType Condition type
KEY SubConditionType NetQty SubConditionType
KEY VersStockRecordUUID NetQty VersStockRecordUUID
CompanyCode NetQty CompanyCode Receiver Company Code
Material NetQty Material Vehicle Model
PhysicalCommodity NetQty PhysicalCommodity
Plant NetQty Plant Valuation Area
StorageLocation NetQty StorageLocation StorageLocation
MTMDataSourceType NetQty MTMDataSourceType Type of Data Record
SourceDocument NetQty SourceDocument Document
SourceDocumentItem NetQty SourceDocumentItem
ReferenceDocument NetQty ReferenceDocument Reference Document
ReferenceDocumentItem NetQty ReferenceDocumentItem Reference item
LoadDataCaptureObjectID NetQty LoadDataCaptureObjectID
QuantityRepositoryUUID NetQty QuantityRepositoryUUID
QuantityRepositoryVersion NetQty QuantityRepositoryVersion
AdjustedQuantityendendasAdjustedQuantity
Commodityquantityendascommodityquantity
CommodityUnit NetQty CommodityUnit Order Unit
NetPriceExpsrQuantity NetQty NetPriceExpsrQuantity
DiscPremQtyScheduleType NetQty DiscPremQtyScheduleType
NetDryErrorCode NetQty NetDryErrorCode
DiscPremVolSchedEvalIsRqd NetQty DiscPremVolSchedEvalIsRqd
StorageGrossQtyInCmmdtyUnit NetQty StorageGrossQtyInCmmdtyUnit
MaterialBaseUnit NetQty MaterialBaseUnit Valuation Unit

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_StkMTM_ElevFinalNetQtyData.
-- 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: PSTKMELEFINAJDQ
-- Parameters: P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_eval_keydate, P_EndOfDaySnapshotToDate : cmm_eval_keydate, P_MTMDataSelectionType : cmm_vlogp_consumptiontype

CREATE VIEW P_StkMTM_ElevFinalNetQtyData AS
SELECT
  NetQty.PricingKey AS PricingKey,
  NetQty.Version AS Version,
  NetQty.PricingDocumentItem AS PricingDocumentItem,
  NetQty.ConditionType AS ConditionType,
  NetQty.SubConditionType AS SubConditionType,
  NetQty.VersStockRecordUUID AS VersStockRecordUUID,
  NetQty.CompanyCode AS CompanyCode,
  NetQty.Material AS Material,
  NetQty.PhysicalCommodity AS PhysicalCommodity,
  NetQty.Plant AS Plant,
  NetQty.StorageLocation AS StorageLocation,
  NetQty.MTMDataSourceType AS MTMDataSourceType,
  NetQty.SourceDocument AS SourceDocument,
  NetQty.SourceDocumentItem AS SourceDocumentItem,
  NetQty.ReferenceDocument AS ReferenceDocument,
  NetQty.ReferenceDocumentItem AS ReferenceDocumentItem,
  NetQty.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  NetQty.QuantityRepositoryUUID AS QuantityRepositoryUUID,
  NetQty.QuantityRepositoryVersion AS QuantityRepositoryVersion,
  case AS AdjustedQuantityendendasAdjustedQuantity,
  case when NetQty.DiscPremVolSchedEvalIsRqd = ' ' then NetQty.StorageGrossQtyInCmmdtyUnit when NetQty.DiscPremVolSchedEvalIsRqd = 'X' AS Commodityquantityendascommodityquantity,
  NetQty.CommodityUnit AS CommodityUnit,
  NetQty.NetPriceExpsrQuantity AS NetPriceExpsrQuantity,
  NetQty.DiscPremQtyScheduleType AS DiscPremQtyScheduleType,
  NetQty.NetDryErrorCode AS NetDryErrorCode,
  NetQty.DiscPremVolSchedEvalIsRqd AS DiscPremVolSchedEvalIsRqd,
  NetQty.StorageGrossQtyInCmmdtyUnit AS StorageGrossQtyInCmmdtyUnit,
  NetQty.MaterialBaseUnit AS MaterialBaseUnit
FROM P_StkMTM_ElevationNetQtyData
;

Learn More