I_MAST

CDS View

Material to BOM Link

I_MAST is a CDS View in S/4HANA. Material to BOM Link. It contains 5 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_BillOfMaterialPlant view from CONSUMPTION BOM different plants
C_BillOfMaterialUsage view from CONSUMPTION BOM different usages
C_BOMAltAndUsage view from CONSUMPTION Consumption view to fetch alternatives of a BOM
I_BOMAssembly view inner COMPOSITE Material to BOM Link
I_ConstructionTypeBoM view left_outer BASIC Bill of Material of a Construction Type
I_EquipmentConstructionMatBom view inner BASIC BoM of Equipment Const. Type
I_FlocConstMaterialBom view inner BASIC BoM of Functional Location Const. Type
I_FlocConstTypeBoM view left_outer BASIC Construction Material BOM - FLOC
I_MultiLevelBOM view from COMPOSITE Multi Level BOM determination
P_PmBillOfMaterialUnion view union COMPOSITE
P_ProjMatBOMAssembly view from BASIC
P_Valid_Bomitems view left_outer BASIC Get Valid BOM items for BOM header
P_VALID_COMPONENTS view left_outer BASIC Get Valid BOM items for BOM header
P_Valid_VersionBomitems view left_outer BASIC
SHSM_MAST view from CDS view for CS_MAST

Fields (5)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterialCategory BillOfMaterialCategory 2
KEY BillOfMaterialVariant BillOfMaterialVariant 5
BillOfMaterial BillOfMaterial 4
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 3
Material Material 2
@AbapCatalog.sqlViewName: 'IMAST'
@AbapCatalog.preserveKey:true
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #MASTER}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material to BOM Link'


define view I_Mast
  as select from mast
{
  key cast( stlnr as char8 preserving type)    as BillOfMaterial,
  key stlal                                    as BillOfMaterialVariant,
  key cast ('M' as stlty preserving type)      as BillOfMaterialCategory,
      matnr                                    as Material,
      werks                                    as Plant,
      stlan                                    as BillOfMaterialVariantUsage,
      losvn                                    as MatFromLotSizeQuantity,
      losbs                                    as MaterialToLotSizeQuantity,
      cslty                                    as IsConfiguredMaterial
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/