I_MaterialTimeDependentStock

DDL: I_MATERIALTIMEDEPENDENTSTOCK Type: view_entity COMPOSITE
22 Fields 2 Data Sources 9 Associations

List of Time Dependent Stock Materials

I_MaterialTimeDependentStock is a Composite CDS View that provides data about "List of Time Dependent Stock Materials" in SAP S/4HANA. It reads from 2 data sources (I_MRPMaterial, I_SDMAreaOfResponsibility) and exposes 22 fields with key fields Material, MRPPlant, MRPArea. It has 9 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MRPMaterial Material from
I_SDMAreaOfResponsibility SDMAreaOfResponsibility inner

Associations (9)

CardinalityTargetAliasCondition
[0..1] P_ProductPlantBasic MaterialPlant MaterialPlant.Product = Material.Material and MaterialPlant.Plant = Material.MRPPlant
[0..1] mdma _MaterialMRPArea $projection.MRPArea = _MaterialMRPArea.berid and $projection.Material = _MaterialMRPArea.matnr
[0..1] I_MRPArea _MRPArea $projection.MRPArea = _MRPArea.MRPArea
[0..1] I_MRPType _MRPType $projection.MRPType = _MRPType.MRPType
[0..1] I_ProductPlantAdvPlanEnhanced _ProductPlantAdvPlanEnhanced $projection.Material = _ProductPlantAdvPlanEnhanced.Product and $projection.MRPPlant = _ProductPlantAdvPlanEnhanced.Plant
[0..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = Material.BaseUnit
[0..1] I_SafetyStockMethodVH _SafetyStockMethod $projection.SafetyStockMethod = _SafetyStockMethod.SafetyStockMethod
[0..1] I_AdvncdPlngSftyStkMethTxt _AdvncdPlngSftyStkMeth $projection.advncdplngsftystkmeth = _AdvncdPlngSftyStkMeth.AdvncdPlngSftyStkMeth and _AdvncdPlngSftyStkMeth.Language = $session.system_language
[0..1] I_AdvncdPlngTgtStkLvlMethTxt _AdvncdPlngTgtStkLvlMeth $projection.advncdplngtgtstklvlmeth = _AdvncdPlngTgtStkLvlMeth.AdvncdPlngTgtStkLvlMeth and _AdvncdPlngTgtStkLvlMeth.Language = $session.system_language

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label List of Time Dependent Stock Materials view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Material I_MRPMaterial Material Vehicle Model
KEY MRPPlant I_MRPMaterial MRPPlant Plant
KEY MRPArea I_MRPMaterial MRPArea MRP Area
MaterialName I_MRPMaterial MaterialName Material Description
PlantName I_MRPMaterial PlantName Plant Name
MRPType I_MRPMaterial MRPType MRP Type
MRPTypeName I_MRPMaterial MRPTypeName
MRPAreaText I_MRPMaterial MRPAreaText
MRPProcedure _MRPType MRPProcedure
MRPController I_MRPMaterial MRPController MRP Controller
UnitOfMeasureISOCode _UnitOfMeasure UnitOfMeasureISOCode
UnitOfMeasure _UnitOfMeasure UnitOfMeasure Unit Protected Qty
UnitOfMeasureNumberOfDecimals _UnitOfMeasure UnitOfMeasureNumberOfDecimals
UnitOfMeasureDspNmbrOfDcmls _UnitOfMeasure UnitOfMeasureDspNmbrOfDcmls
AdvancedPlanningIsSupported MaterialPlant IsAdvancedPlanningUsed Advanced Planning
AdvncdPlngSftyStkMeth _ProductPlantAdvPlanEnhanced AdvncdPlngSftyStkMeth Safety Stock Method
AdvncdPlngTgtStkLvlMeth _ProductPlantAdvPlanEnhanced AdvncdPlngTgtStkLvlMeth Targ.Stk Lvl Md
_AdvncdPlngSftyStkMeth _AdvncdPlngSftyStkMeth
_AdvncdPlngTgtStkLvlMeth _AdvncdPlngTgtStkLvlMeth
_SafetyStockMethod _SafetyStockMethod
_ISOCode _UnitOfMeasure _ISOCode
_MRPProcedure _MRPType _MRPProcedure

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 I_MaterialTimeDependentStock.
-- 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 I_MaterialTimeDependentStock AS
SELECT
  Material.Material AS Material,
  Material.MRPPlant AS MRPPlant,
  Material.MRPArea AS MRPArea,
  Material.MaterialName AS MaterialName,
  Material.PlantName AS PlantName,
  Material.MRPType AS MRPType,
  Material.MRPTypeName AS MRPTypeName,
  Material.MRPAreaText AS MRPAreaText,
  _MRPType.MRPProcedure AS MRPProcedure,
  Material.MRPController AS MRPController,
  _UnitOfMeasure.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  _UnitOfMeasure.UnitOfMeasure AS UnitOfMeasure,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  MaterialPlant.IsAdvancedPlanningUsed AS AdvancedPlanningIsSupported,
  _ProductPlantAdvPlanEnhanced.AdvncdPlngSftyStkMeth AS AdvncdPlngSftyStkMeth,
  _ProductPlantAdvPlanEnhanced.AdvncdPlngTgtStkLvlMeth AS AdvncdPlngTgtStkLvlMeth,
  _UnitOfMeasure._ISOCode AS _ISOCode,
  _MRPType._MRPProcedure AS _MRPProcedure
FROM I_MRPMaterial AS Material
INNER JOIN I_SDMAreaOfResponsibility AS SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProductPlantBasic AS MaterialPlant ON MaterialPlant.Product = Material.Material AND MaterialPlant.Plant = Material.MRPPlant  -- association [0..1]
LEFT OUTER JOIN mdma AS _MaterialMRPArea ON MRPArea = _MaterialMRPArea.berid AND Material = _MaterialMRPArea.matnr  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_MRPType AS _MRPType ON MRPType = _MRPType.MRPType  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantAdvPlanEnhanced AS _ProductPlantAdvPlanEnhanced ON Material = _ProductPlantAdvPlanEnhanced.Product AND MRPPlant = _ProductPlantAdvPlanEnhanced.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = Material.BaseUnit  -- association [0..1]
LEFT OUTER JOIN I_SafetyStockMethodVH AS _SafetyStockMethod ON SafetyStockMethod = _SafetyStockMethod.SafetyStockMethod  -- association [0..1]
LEFT OUTER JOIN I_AdvncdPlngSftyStkMethTxt AS _AdvncdPlngSftyStkMeth ON advncdplngsftystkmeth = _AdvncdPlngSftyStkMeth.AdvncdPlngSftyStkMeth AND _AdvncdPlngSftyStkMeth.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AdvncdPlngTgtStkLvlMethTxt AS _AdvncdPlngTgtStkLvlMeth ON advncdplngtgtstklvlmeth = _AdvncdPlngTgtStkLvlMeth.AdvncdPlngTgtStkLvlMeth AND _AdvncdPlngTgtStkLvlMeth.Language = $session.system_language  -- association [0..1]
;

Learn More