I_MaterialBOMLink

DDL: I_MATERIALBOMLINK SQL: IMATTOBOMLINK Type: view BASIC

Material Link for Bill of Material

I_MaterialBOMLink is a Basic CDS View (Fact) that provides data about "Material Link for Bill of Material" in SAP S/4HANA. It reads from 1 data source (mast) and exposes 12 fields with key fields BillOfMaterial, BillOfMaterialVariant, Material, Plant, BillOfMaterialVariantUsage.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
mast mast from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IMATTOBOMLINK view
AbapCatalog.preserveKey true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Link for Bill of Material view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial stlnr
KEY BillOfMaterialVariant stlal
KEY Material matnr
KEY Plant werks
KEY BillOfMaterialVariantUsage stlan
BillOfMaterialCategory
MatFromLotSizeQuantity losvn
MaterialToLotSizeQuantity losbs
IsConfiguredMaterial cslty
MaterialBOMObjectID material_bom_key
CreatedByUser annam
LastChangedByUser aenam 
@AbapCatalog.sqlViewName: 'IMATTOBOMLINK'
@AbapCatalog.preserveKey:true
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@Analytics.dataCategory: #FACT
@Analytics.dataExtraction: {
        enabled: true,
        delta.changeDataCapture.automatic: true
}
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #MASTER}
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material Link for Bill of Material'
@Metadata.ignorePropagatedAnnotations: true
define view I_MaterialBOMLink 
  as select from mast
 {

  
  key stlnr                                    as BillOfMaterial,
  key stlal                                    as BillOfMaterialVariant,
  @Consumption.valueHelpDefinition: [
         { entity:  { name:    'C_BOMMaterialVH',
                     element: 'Material' }
        }]
  key matnr                                    as Material,
  key werks                                    as Plant,
  key stlan                                    as BillOfMaterialVariantUsage,
      cast ('M' as stlty preserving type)      as BillOfMaterialCategory,
      losvn                                    as MatFromLotSizeQuantity,
      losbs                                    as MaterialToLotSizeQuantity,
      cslty                                    as IsConfiguredMaterial,
      material_bom_key                         as MaterialBOMObjectID,
      annam                                    as CreatedByUser,  
      aenam                                    as LastChangedByUser 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More