P_StockMTM_NetQuantityData

DDL: P_STOCKMTM_NETQUANTITYDATA SQL: PSTKMTMADJDATA Type: view COMPOSITE
17 Fields 1 Data Sources

P_StockMTM_NetQuantityData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_StockMTM_Delta_Data) and exposes 17 fields with key fields mandt, PricingKey, Version, PricingDocumentItem, ConditionType.

Data Sources (1)

SourceAliasJoin Type
P_StockMTM_Delta_Data P_StockMTM_Delta_Data 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 PSTKMTMADJDATA 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 (17)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY PricingKey PricingKey Pricing Key
KEY Version Version XML Vers.
KEY PricingDocumentItem PricingDocumentItem Item
KEY ConditionType ConditionType Condition type
KEY SubConditionType SubConditionType
CompanyCode CompanyCode Receiver Company Code
Material Material Vehicle Model
PhysicalCommodity PhysicalCommodity
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
MTMDataSourceType MTMDataSourceType Type of Data Record
MTMConditionGroupCategory MTMConditionGroupCategory
MTMCalculationGroup MTMCalculationGroup
LoadDataCaptureObjectID LoadDataCaptureObjectID
AdjustedQuantity
AdjustedQuantityUnit CommodityUnit Order 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_StockMTM_NetQuantityData.
-- 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: PSTKMTMADJDATA
-- 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_StockMTM_NetQuantityData AS
SELECT
  mandt,
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  CompanyCode,
  Material,
  PhysicalCommodity,
  Plant,
  StorageLocation,
  MTMDataSourceType,
  MTMConditionGroupCategory,
  MTMCalculationGroup,
  LoadDataCaptureObjectID,
  sum( Commodityquantity ) AS AdjustedQuantity,
  CommodityUnit AS AdjustedQuantityUnit
FROM P_StockMTM_Delta_Data
;

Learn More