C_MaterialBOM

DDL: C_MATERIALBOM SQL: CMATERIALBOM Type: view CONSUMPTION

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)

SourceAliasJoin Type
I_MaterialBOM I_MaterialBOM from

Annotations (11)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/