I_MaterialPlant

DDL: I_MATERIALPLANT Type: view BASIC
12 Fields 1 Data Sources 5 Associations

Material Plant

I_MaterialPlant is a Basic CDS View (Dimension) that provides data about "Material Plant" in SAP S/4HANA. It reads from 1 data source (marc) and exposes 12 fields with key fields Material, Plant. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
marc marc from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_MRPController _MRPController $projection.Plant = _MRPController.Plant and $projection.MRPController = _MRPController.MRPController
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] I_Matlabcclassification _MaterialABCClassification $projection.MaterialABCClassification = _MaterialABCClassification.MaterialABCClassification
[0..*] I_Matlabcclassificationtext _MaterialABCClassificationDesc $projection.MaterialABCClassification = _MaterialABCClassificationDesc.MaterialABCClassification

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMATERIALPLANT view
AbapCatalog.preserveKey true view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
EndUserText.label Material Plant view
ObjectModel.representativeKey Plant view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.privilegedAssociations _MRPController view
Metadata.allowExtensions true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Material marc matnr Vehicle Model
KEY Plant marc werks Receiving Plant
MRPController dispo MRP Controller
MaterialSafetyStockQty eisbe Safety Stock
DfltStorLocForExtProcmt lgfsb Storage Location
RptvMfgIsAllwd sauft Repetitive Mfg
MaterialABCClassification maabc ABC Indicator
_MaterialABCClassification _MaterialABCClassification
_MRPController _MRPController
_MaterialText _MaterialText
_MaterialABCClassificationDesc _MaterialABCClassificationDesc
_Material _Material

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_MaterialPlant.
-- 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_MaterialPlant AS
SELECT
  marc.matnr AS Material,
  marc.werks AS Plant,
  dispo AS MRPController,
  eisbe AS MaterialSafetyStockQty,
  lgfsb AS DfltStorLocForExtProcmt,
  sauft AS RptvMfgIsAllwd,
  maabc AS MaterialABCClassification
FROM marc
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Matlabcclassification AS _MaterialABCClassification ON MaterialABCClassification = _MaterialABCClassification.MaterialABCClassification  -- association [0..1]
LEFT OUTER JOIN I_Matlabcclassificationtext AS _MaterialABCClassificationDesc ON MaterialABCClassification = _MaterialABCClassificationDesc.MaterialABCClassification  -- association [0..*]
;

Learn More