I_UnitizedMaterialVersBOM

DDL: I_UNITIZEDMATERIALVERSBOM SQL: IUNTZDMATVERSBOM Type: view COMPOSITE

Unitized Versioned Material BOM

I_UnitizedMaterialVersBOM is a Composite CDS View that provides data about "Unitized Versioned Material BOM" in SAP S/4HANA. It reads from 2 data sources (I_MaterialBOM, I_UnitizedMaterial) and exposes 10 fields with key fields BillOfMaterialVariantUsage, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialCategory, BillOfMaterialVersion.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_MaterialBOM MaterialBOM from
I_UnitizedMaterial UnitizedMaterial inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUNTZDMATVERSBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Unitized Versioned Material BOM view
VDM.viewType #COMPOSITE view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage
KEY BillOfMaterial I_MaterialBOM BillOfMaterial
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID
Material I_MaterialBOM Material
MaterialType I_UnitizedMaterial MaterialType
EffectivityType I_UnitizedMaterial EffectivityType
Plant I_MaterialBOM Plant 
@AbapCatalog.sqlViewName: 'IUNTZDMATVERSBOM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Unitized Versioned Material BOM'
@VDM.viewType: #COMPOSITE
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
define view I_UnitizedMaterialVersBOM as select from I_MaterialBOM as MaterialBOM

inner join I_UnitizedMaterial as UnitizedMaterial on MaterialBOM.Material = UnitizedMaterial.Material

{
  key MaterialBOM.BillOfMaterialVariantUsage,                                                                                                                                      
  key MaterialBOM.BillOfMaterial,                                                                                                                                               
  key MaterialBOM.BillOfMaterialVariant,                                                                                                                                         
  key MaterialBOM.BillOfMaterialCategory,                                                                                                                                        
  key MaterialBOM.BillOfMaterialVersion,                                                                                                               
      MaterialBOM.BillOfMaterialHeaderUUID,
      MaterialBOM.Material,
      UnitizedMaterial.MaterialType,
      UnitizedMaterial.EffectivityType,
      MaterialBOM.Plant   
} where MaterialBOM.BillOfMaterialCategory = 'M' and MaterialBOM.IsVersionBillOfMaterial = 'X'

Learn More