I_UnitizedMaterial

DDL: I_UNITIZEDMATERIAL SQL: IUNITIZEDMATL Type: view COMPOSITE Package: MPE_CM_PE

Unitized Materials for Parameter Effectivity

I_UnitizedMaterial is a Composite CDS View that provides data about "Unitized Materials for Parameter Effectivity" in SAP S/4HANA. It reads from 2 data sources (I_Material, I_UnitizedMaterialType) and exposes 19 fields with key field Material. Part of development package MPE_CM_PE.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
I_Material Material from
I_UnitizedMaterialType UnitizedMatlType inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IUNITIZEDMATL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Unitized Materials for Parameter Effectivity view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Material Material
MaterialType I_Material MaterialType
MaterialGroup MaterialGroup
MaterialBaseUnit MaterialBaseUnit
MaterialGrossWeight MaterialGrossWeight
MaterialNetWeight MaterialNetWeight
MaterialWeightUnit MaterialWeightUnit
MaterialManufacturerNumber MaterialManufacturerNumber
MaterialManufacturerPartNumber MaterialManufacturerPartNumber
AuthorizationGroup AuthorizationGroup
IsBatchManagementRequired IsBatchManagementRequired
EffectivityType EffectivityType
ComplexAssemblyType ComplexAssemblyType
_BaseUnit _BaseUnit
_MaterialGroup _MaterialGroup
_MaterialPlant _MaterialPlant
_MaterialType _MaterialType
_Text _Text
_WeightUnit _WeightUnit 
@AbapCatalog.sqlViewName: 'IUNITIZEDMATL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Unitized Materials for Parameter Effectivity'
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #MASTER}
@Search.searchable: true
define view I_UnitizedMaterial
    as select from I_Material as Material
    inner join I_UnitizedMaterialType as UnitizedMatlType on Material.MaterialType = UnitizedMatlType.MaterialType
{
      
      //Material

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @ObjectModel.text.association: '_Text'
  key Material,
      Material.MaterialType,
      MaterialGroup,
      MaterialBaseUnit,
      MaterialGrossWeight,
      MaterialNetWeight,
      MaterialWeightUnit,
      MaterialManufacturerNumber,
      MaterialManufacturerPartNumber,
      AuthorizationGroup,
      IsBatchManagementRequired,
      
      //UnitizedMatlType

      EffectivityType,
      ComplexAssemblyType,
      
      /* Associations */
      _BaseUnit,
      _MaterialGroup,
      _MaterialPlant,
      _MaterialType,
      _Text,
      _WeightUnit

}

Learn More