C_MaterialBOM
Consumption view to consume & expose BOM
C_MaterialBOM is a Consumption CDS View that provides data about "Consumption view to consume & expose BOM" in SAP S/4HANA. It reads from 1 data source (I_MaterialBOM) and exposes 49 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, EngineeringChangeDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_MaterialBOM | I_MaterialBOM | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CMATERIALBOM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Consumption view to consume & expose BOM | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Search.searchable | true | view |
Fields (49)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillOfMaterialCategory | BillOfMaterialCategory | ||
| KEY | BillOfMaterial | BillOfMaterial | ||
| KEY | BillOfMaterialVariant | BillOfMaterialVariant | ||
| KEY | BillOfMaterialVersion | BillOfMaterialVersion | ||
| KEY | EngineeringChangeDocument | EngineeringChangeDocument | ||
| KEY | Material | Material | ||
| KEY | Plant | Plant | ||
| PlantName | _Plant | PlantName | ||
| BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | |||
| BillOfMaterialVariantUsageDesc | _BillOfMaterialVariantUsage | BillOfMaterialVariantUsageDesc | ||
| BillOfMaterialHeaderUUID | BillOfMaterialHeaderUUID | |||
| BillOfMaterialUUID | BillOfMaterialUUID | |||
| IsMultipleBOMAlt | IsMultipleBOMAlt | |||
| BOMHeaderInternalChangeCount | BOMHeaderInternalChangeCount | |||
| BOMPrioritizedVersion | BOMPrioritizedVersion | |||
| BOMExplosionApplication | BOMExplosionApplication | |||
| BOMUsagePriority | BOMUsagePriority | |||
| BillOfMaterialAuthsnGrp | BillOfMaterialAuthsnGrp | |||
| BOMVersionStatus | BOMVersionStatus | |||
| MaterialToLotSizeQuantity | MaterialToLotSizeQuantity | |||
| MatFromLotSizeQuantity | MatFromLotSizeQuantity | |||
| IsVersionBillOfMaterial | IsVersionBillOfMaterial | |||
| IsLatestBOMVersion | IsLatestBOMVersion | |||
| BOMTechnicalType | BOMTechnicalType | |||
| BOMGroup | BOMGroup | |||
| BOMHeaderText | BOMHeaderText | |||
| BOMAlternativeText | BOMAlternativeText | |||
| BillOfMaterialStatus | BillOfMaterialStatus | |||
| HeaderValidityEndDate | HeaderValidityEndDate | |||
| HeaderValidityStartDate | HeaderValidityStartDate | |||
| ChgToEngineeringChgDocument | ChgToEngineeringChgDocument | |||
| IsMarkedForDeletion | IsMarkedForDeletion | |||
| BOMIsArchivedForDeletion | BOMIsArchivedForDeletion | |||
| IsConfiguredMaterial | IsConfiguredMaterial | |||
| BOMIsConfigurable | BOMIsConfigurable | |||
| IsALE | IsALE | |||
| BOMHeaderBaseUnit | BOMHeaderBaseUnit | |||
| BOMHeaderQuantityInBaseUnit | BOMHeaderQuantityInBaseUnit | |||
| RecordCreationDate | RecordCreationDate | |||
| LastChangeDate | LastChangeDate | |||
| LastChangedByUser | LastChangedByUser | |||
| CreatedByUser | CreatedByUser | |||
| BOMIsToBeDeleted | BOMIsToBeDeleted | |||
| DocumentIsCreatedByCAD | DocumentIsCreatedByCAD | |||
| LaboratoryOrDesignOffice | LaboratoryOrDesignOffice | |||
| LastChangeDateTime | LastChangeDateTime | |||
| BOMAssetNtwkHndovrIsRelevant | BOMAssetNtwkHndovrIsRelevant | |||
| MaterialBOMObjectID | MaterialBOMObjectID | |||
| BOMPredecessorVersion | BOMPredecessorVersion |
@AbapCatalog.sqlViewName: 'CMATERIALBOM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption view to consume & expose BOM'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
define view C_MaterialBOM
as select from I_MaterialBOM
{
//I_MaterialBOM
@UI.hidden: true
key BillOfMaterialCategory,
@UI.hidden: true
key BillOfMaterial,
@UI.selectionField : {position:40}
@UI.lineItem: [{position:40,importance:#HIGH}]
key BillOfMaterialVariant,
@UI.hidden: true
key BillOfMaterialVersion,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ChangeMasterVH',
element: 'ChangeNumber' }
}]
@UI.selectionField : {position:50}
@UI.lineItem: [{position:50,importance:#HIGH}]
@Search.defaultSearchElement: true
key EngineeringChangeDocument,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'C_BOMMaterialVH',
element: 'Material' }
}]
@UI.selectionField : {position:10}
@UI.lineItem: [{position:10,importance:#HIGH}]
@Search.defaultSearchElement: true
key Material,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_PlantStdVH',
element: 'Plant' }
}]
@UI.selectionField : {position:20}
@UI.lineItem: [{position:20,importance:#HIGH}]
@ObjectModel.text.element: 'PlantName'
key Plant,
@UI.hidden: true
_Plant.PlantName,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BillOfMaterialUsage',
element: 'BillOfMaterialVariantUsage' }
}]
@UI.selectionField : {position:30}
@UI.lineItem: [{position:30,importance:#HIGH}]
@ObjectModel.text.element: [ 'BillOfMaterialVariantUsageDesc' ]
BillOfMaterialVariantUsage,
@UI.hidden: true
_BillOfMaterialVariantUsage.BillOfMaterialVariantUsageDesc,
@UI.hidden: true
BillOfMaterialHeaderUUID,
@UI.hidden: true
BillOfMaterialUUID,
@UI.hidden: true
IsMultipleBOMAlt,
BOMHeaderInternalChangeCount,
BOMPrioritizedVersion,
BOMExplosionApplication,
BOMUsagePriority,
BillOfMaterialAuthsnGrp,
@UI.hidden: true
BOMVersionStatus,
MaterialToLotSizeQuantity,
MatFromLotSizeQuantity,
@UI.hidden: true
IsVersionBillOfMaterial,
@UI.hidden: true
IsLatestBOMVersion,
BOMTechnicalType,
BOMGroup,
BOMHeaderText,
BOMAlternativeText,
BillOfMaterialStatus,
HeaderValidityEndDate,
@UI.selectionField : {position:60}
@UI.lineItem: [{position:60,importance:#HIGH}]
HeaderValidityStartDate,
ChgToEngineeringChgDocument,
IsMarkedForDeletion,
BOMIsArchivedForDeletion,
@UI.hidden: true
IsConfiguredMaterial,
@UI.hidden: true
BOMIsConfigurable,
IsALE,
BOMHeaderBaseUnit,
BOMHeaderQuantityInBaseUnit,
RecordCreationDate,
LastChangeDate,
LastChangedByUser,
CreatedByUser,
BOMIsToBeDeleted,
DocumentIsCreatedByCAD,
LaboratoryOrDesignOffice,
LastChangeDateTime,
BOMAssetNtwkHndovrIsRelevant,
MaterialBOMObjectID,
BOMPredecessorVersion
/* Associations */
//I_MaterialBOM
// _BillOfMaterialItem,
// _BillOfMaterialVariantUsage,
// _BOMChangeNumbers,
// _Material,
// _Plant,
// _Product,
// _UnitOfMeasure,
// _VersionStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIALUSAGE",
"I_MATERIALBOM",
"I_PLANT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA