I_EngBOM

DDL: I_ENGBOM SQL: IENGBOM Type: view BASIC

Engineering Bill of Materials

I_EngBOM is a Basic CDS View that provides data about "Engineering Bill of Materials" in SAP S/4HANA. It reads from 2 data sources (I_EngBOMUsage, I_MaterialBOM) and exposes 42 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, Material.

2 data source(s) 42 fields

Data Sources (2)

SourceAliasJoin Type
I_EngBOMUsage _EngBomUsage inner
I_MaterialBOM MaterialBOM from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENGBOM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #INHERITED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Engineering Bill of Materials view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory
KEY BillOfMaterial I_MaterialBOM BillOfMaterial
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant
KEY BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion
KEY Material I_MaterialBOM Material
KEY Plant I_MaterialBOM Plant
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage
BillOfMaterialUUID I_MaterialBOM BillOfMaterialUUID
IsMultipleBOMAlt I_MaterialBOM IsMultipleBOMAlt
BOMHeaderInternalChangeCount I_MaterialBOM BOMHeaderInternalChangeCount
BOMPrioritizedVersion I_MaterialBOM BOMPrioritizedVersion
BOMExplosionApplication I_MaterialBOM BOMExplosionApplication
BOMUsagePriority I_MaterialBOM BOMUsagePriority
BillOfMaterialAuthsnGrp I_MaterialBOM BillOfMaterialAuthsnGrp
BOMVersionStatus I_MaterialBOM BOMVersionStatus
IsVersionBillOfMaterial I_MaterialBOM IsVersionBillOfMaterial
IsLatestBOMVersion I_MaterialBOM IsLatestBOMVersion
IsConfiguredMaterial I_MaterialBOM IsConfiguredMaterial
BOMTechnicalType I_MaterialBOM BOMTechnicalType
BOMGroup I_MaterialBOM BOMGroup
BOMHeaderText I_MaterialBOM BOMHeaderText
BOMAlternativeText I_MaterialBOM BOMAlternativeText
BillOfMaterialStatus I_MaterialBOM BillOfMaterialStatus
HeaderValidityStartDate I_MaterialBOM HeaderValidityStartDate
HeaderValidityEndDate I_MaterialBOM HeaderValidityEndDate
EngineeringChangeDocument I_MaterialBOM EngineeringChangeDocument
ChgToEngineeringChgDocument I_MaterialBOM ChgToEngineeringChgDocument
IsMarkedForDeletion I_MaterialBOM IsMarkedForDeletion
IsALE I_MaterialBOM IsALE
BOMHeaderBaseUnit I_MaterialBOM BOMHeaderBaseUnit
BOMHeaderQuantityInBaseUnit I_MaterialBOM BOMHeaderQuantityInBaseUnit
RecordCreationDate I_MaterialBOM RecordCreationDate
LastChangeDate I_MaterialBOM LastChangeDate
CreatedByUser I_MaterialBOM CreatedByUser
LastChangedByUser I_MaterialBOM LastChangedByUser
BOMIsToBeDeleted I_MaterialBOM BOMIsToBeDeleted
DocumentIsCreatedByCAD I_MaterialBOM DocumentIsCreatedByCAD
LaboratoryOrDesignOffice I_MaterialBOM LaboratoryOrDesignOffice
_BillOfMaterialItem I_MaterialBOM _BillOfMaterialItem
_BillOfMaterialVariantUsage I_MaterialBOM _BillOfMaterialVariantUsage
_UnitOfMeasure I_MaterialBOM _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'IENGBOM'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.type : #INHERITED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Engineering Bill of Materials'
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #BASIC

define view I_EngBOM
  as select from I_MaterialBOM as MaterialBOM
    inner join   I_EngBOMUsage as _EngBomUsage on MaterialBOM.BillOfMaterialVariantUsage = _EngBomUsage.BillOfMaterialVariantUsage

{

  key     MaterialBOM.BillOfMaterialCategory,
  key     MaterialBOM.BillOfMaterial,
  key     MaterialBOM.BillOfMaterialVariant,
  key     MaterialBOM.BillOfMaterialVersion,
  key     MaterialBOM.Material,
  key     MaterialBOM.Plant,
          MaterialBOM.BillOfMaterialHeaderUUID,
          MaterialBOM.BillOfMaterialVariantUsage,
          MaterialBOM.BillOfMaterialUUID,
          MaterialBOM.IsMultipleBOMAlt,
          MaterialBOM.BOMHeaderInternalChangeCount,
          MaterialBOM.BOMPrioritizedVersion,
          MaterialBOM.BOMExplosionApplication,
          MaterialBOM.BOMUsagePriority,
          MaterialBOM.BillOfMaterialAuthsnGrp,
          MaterialBOM.BOMVersionStatus,
          MaterialBOM.IsVersionBillOfMaterial,
          MaterialBOM.IsLatestBOMVersion,
          MaterialBOM.IsConfiguredMaterial,
          MaterialBOM.BOMTechnicalType,
          MaterialBOM.BOMGroup,
          MaterialBOM.BOMHeaderText,
          MaterialBOM.BOMAlternativeText,
          MaterialBOM.BillOfMaterialStatus,
          MaterialBOM.HeaderValidityStartDate,
          MaterialBOM.HeaderValidityEndDate,
          MaterialBOM.EngineeringChangeDocument,
          MaterialBOM.ChgToEngineeringChgDocument,
          MaterialBOM.IsMarkedForDeletion,
          MaterialBOM.IsALE,
          MaterialBOM.BOMHeaderBaseUnit,
          MaterialBOM.BOMHeaderQuantityInBaseUnit,
          MaterialBOM.RecordCreationDate,
          MaterialBOM.LastChangeDate,
          MaterialBOM.CreatedByUser,
          MaterialBOM.LastChangedByUser,
          MaterialBOM.BOMIsToBeDeleted,
          MaterialBOM.DocumentIsCreatedByCAD,
          MaterialBOM.LaboratoryOrDesignOffice,


          /* Associations */
          MaterialBOM._BillOfMaterialItem,
          MaterialBOM._BillOfMaterialVariantUsage,

          MaterialBOM._UnitOfMeasure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGBOMUSAGE",
"I_MATERIALBOM"
],
"ASSOCIATED":
[
"I_BILLOFMATERIALITEM",
"I_BILLOFMATERIALUSAGE",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MATERIALBOM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More