R_MatlStkDetCsgnmtStorLoc

DDL: R_MATLSTKDETCSGNMTSTORLOC Type: view_entity COMPOSITE Package: ODATA_MM_IM_STOCKOUTPUT
11 Fields 1 Data Sources 2 Associations

MatlStk Details Csgmnt StorageLocation

R_MatlStkDetCsgnmtStorLoc is a Composite CDS View that provides data about "MatlStk Details Csgmnt StorageLocation" in SAP S/4HANA. It reads from 1 data source (I_MatlStkDetCsgnmtQuantity) and exposes 11 fields with key fields MaterialStockReportUUID, Product, StorageLocation. It has 2 associations to related views. Part of development package ODATA_MM_IM_STOCKOUTPUT.

Data Sources (1)

SourceAliasJoin Type
I_MatlStkDetCsgnmtQuantity I_MatlStkDetCsgnmtQuantity from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_MatlStkDetCsgnmtDocItem _GoodsMvtLvl $projection.MaterialStockReportUUID = _GoodsMvtLvl.MaterialStockReportUUID and $projection.MaterialBaseUnit = _GoodsMvtLvl.MaterialBaseUnit and $projection.Product = _GoodsMvtLvl.Product and $projection.StorageLocation = _GoodsMvtLvl.StorageLocation
[0..1] I_Material _Material $projection.Product = _Material.Material

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MatlStk Details Csgmnt StorageLocation view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.private false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MaterialStockReportUUID MaterialStockReportUUID
KEY Product Product Product Sold
KEY StorageLocation StorageLocation StorageLocation
ProductName
MatlStockReportAnalysisDate _Report MatlStockReportAnalysisDate
MatlStockReportAnalysisTime _Report MatlStockReportAnalysisTime
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MatlStkIncrQtyInMatlBaseUnit MatlStkIncrQtyInMatlBaseUnit
MatlStkDecrQtyInMatlBaseUnit MatlStkDecrQtyInMatlBaseUnit
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Quantity
_GoodsMvtLvl _GoodsMvtLvl

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 R_MatlStkDetCsgnmtStorLoc.
-- 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.

CREATE VIEW R_MatlStkDetCsgnmtStorLoc AS
SELECT
  MaterialStockReportUUID,
  Product,
  StorageLocation,
  _Material._Text[1: Language=$session.system_language].MaterialName AS ProductName,
  _Report.MatlStockReportAnalysisDate AS MatlStockReportAnalysisDate,
  _Report.MatlStockReportAnalysisTime AS MatlStockReportAnalysisTime,
  MaterialBaseUnit,
  MatlStkIncrQtyInMatlBaseUnit,
  MatlStkDecrQtyInMatlBaseUnit,
  MatlWrhsStkQtyInMatlBaseUnit
FROM I_MatlStkDetCsgnmtQuantity
LEFT OUTER JOIN R_MatlStkDetCsgnmtDocItem AS _GoodsMvtLvl ON MaterialStockReportUUID = _GoodsMvtLvl.MaterialStockReportUUID AND MaterialBaseUnit = _GoodsMvtLvl.MaterialBaseUnit AND Product = _GoodsMvtLvl.Product AND StorageLocation = _GoodsMvtLvl.StorageLocation  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Product = _Material.Material  -- association [0..1]
;

Learn More