I_PrepaymentMaterial

DDL: I_PREPAYMENTMATERIAL SQL: IPPMGMATERIAL Type: view BASIC
19 Fields 1 Data Sources 7 Associations

Material Data

I_PrepaymentMaterial is a Basic CDS View (Dimension) that provides data about "Material Data" in SAP S/4HANA. It reads from 1 data source (mara) and exposes 19 fields with key field Material. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mara mara from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _Text $projection.Material = _Text.Material
[0..1] I_MaterialType _MaterialType $projection.MaterialType = _MaterialType.MaterialType
[0..1] I_MaterialGroup _MaterialGroup $projection.MaterialGroup = _MaterialGroup.MaterialGroup
[0..1] I_UnitOfMeasure _BaseUnit $projection.MaterialBaseUnit = _BaseUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _WeightUnit $projection.MaterialWeightUnit = _WeightUnit.UnitOfMeasure
[0..*] I_MaterialPlant _MaterialPlant $projection.Material = _MaterialPlant.Material
[0..1] I_Cmmdty _Commodity $projection.Commodity = _Commodity.Commodity

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGMATERIAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Material Data view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
ObjectModel.representativeKey Material view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Material mara matnr Vehicle Model
MaterialType mara mtart Product Type
MaterialGroup mara matkl Product Sold Group
MaterialBaseUnit mara meins Valuation Unit
MaterialGrossWeight mara brgew Weight
MaterialNetWeight mara ntgew Net Weight
MaterialWeightUnit mara gewei Weight Unit
Commodity mara commodity Commodity Code
MaterialManufacturerNumber mara mfrnr Manufacturer
MaterialManufacturerPartNumber mara mfrpn Mfr Part Number
AuthorizationGroup mara begru AuthorizGroup
IsBatchManagementRequired mara xchpf Batch Mgmt Rqt(Plnt)
_Text _Text
_MaterialType _MaterialType
_MaterialGroup _MaterialGroup
_BaseUnit _BaseUnit
_WeightUnit _WeightUnit
_MaterialPlant _MaterialPlant
_Commodity _Commodity

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_PrepaymentMaterial.
-- 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: IPPMGMATERIAL

CREATE VIEW I_PrepaymentMaterial AS
SELECT
  mara.matnr AS Material,
  mara.mtart AS MaterialType,
  mara.matkl AS MaterialGroup,
  mara.meins AS MaterialBaseUnit,
  mara.brgew AS MaterialGrossWeight,
  mara.ntgew AS MaterialNetWeight,
  mara.gewei AS MaterialWeightUnit,
  mara.commodity AS Commodity,
  mara.mfrnr AS MaterialManufacturerNumber,
  mara.mfrpn AS MaterialManufacturerPartNumber,
  mara.begru AS AuthorizationGroup,
  mara.xchpf AS IsBatchManagementRequired
FROM mara
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialType = _MaterialType.MaterialType  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON MaterialBaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON MaterialWeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Material = _MaterialPlant.Material  -- association [0..*]
LEFT OUTER JOIN I_Cmmdty AS _Commodity ON Commodity = _Commodity.Commodity  -- association [0..1]
;

Learn More