I_MAST
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/