I_PrepaymentMaterial

DDL: I_PREPAYMENTMATERIAL SQL: IPPMGMATERIAL Type: view BASIC

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.

1 data source(s) 19 fields

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 (15)

NameValueLevelField
AbapCatalog.sqlViewName IPPMGMATERIAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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
MaterialType mara mtart
MaterialGroup mara matkl
MaterialBaseUnit mara meins
MaterialGrossWeight mara brgew
MaterialNetWeight mara ntgew
MaterialWeightUnit mara gewei
Commodity mara commodity
MaterialManufacturerNumber mara mfrnr
MaterialManufacturerPartNumber mara mfrpn
AuthorizationGroup mara begru
IsBatchManagementRequired mara xchpf
_Text _Text
_MaterialType _MaterialType
_MaterialGroup _MaterialGroup
_BaseUnit _BaseUnit
_WeightUnit _WeightUnit
_MaterialPlant _MaterialPlant
_Commodity _Commodity 
@AbapCatalog.sqlViewName                    : 'IPPMGMATERIAL'
@AbapCatalog.compiler.compareFilter         : true
@AbapCatalog.preserveKey                    : true
@AccessControl.authorizationCheck           : #CHECK
@EndUserText.label                          : 'Material Data'
@Analytics                                  : { dataCategory: #DIMENSION }
@VDM.viewType                               : #BASIC
@ObjectModel.representativeKey              : 'Material'
@ObjectModel.usageType.serviceQuality       : #A
@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.dataClass            : #MASTER
@ClientHandling.algorithm                   : #SESSION_VARIABLE
@Metadata.allowExtensions                   : true
@Metadata.ignorePropagatedAnnotations       : true
@Analytics.internalName                     : #LOCAL

define view I_PrepaymentMaterial as select from mara 
  association [0..*] to I_MaterialText  as _Text          on $projection.Material           = _Text.Material
  association [0..1] to I_MaterialType  as _MaterialType  on $projection.MaterialType       = _MaterialType.MaterialType
  association [0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup      = _MaterialGroup.MaterialGroup
  association [0..1] to I_UnitOfMeasure as _BaseUnit      on $projection.MaterialBaseUnit   = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure as _WeightUnit    on $projection.MaterialWeightUnit = _WeightUnit.UnitOfMeasure
  association [0..*] to I_MaterialPlant as _MaterialPlant on $projection.Material           = _MaterialPlant.Material
  association [0..1] to I_Cmmdty        as _Commodity     on $projection.Commodity          = _Commodity.Commodity
{
  key mara.matnr                                                        as Material,

      mara.mtart                                                        as MaterialType,

      mara.matkl                                                        as MaterialGroup,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      mara.meins                                                        as MaterialBaseUnit,

      @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'
      @Analytics.hidden: true
      mara.brgew                                                        as MaterialGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'
      @Analytics.hidden: true
      mara.ntgew                                                        as MaterialNetWeight,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_WeightUnit'
      mara.gewei                                                        as MaterialWeightUnit,

      @ObjectModel.foreignKey.association: '_Commodity'
      mara.commodity                                                    as Commodity,
      
      mara.mfrnr                                                        as MaterialManufacturerNumber,
      
      mara.mfrpn                                                        as MaterialManufacturerPartNumber,
      
      mara.begru                                                        as AuthorizationGroup,
      
      mara.xchpf                                                        as IsBatchManagementRequired,
      
//    Associations

      _Text,     
      _MaterialType, 
      _MaterialGroup,
      _BaseUnit,
      _WeightUnit,
      _MaterialPlant,
      _Commodity
}

Learn More