I_BOOVersionBOMAssignment

DDL: I_BOOVERSIONBOMASSIGNMENT SQL: IBOOVERSBOMASS Type: view BASIC

Bill of Operations Version BOM Assignment

I_BOOVersionBOMAssignment is a Basic CDS View that provides data about "Bill of Operations Version BOM Assignment" in SAP S/4HANA. It reads from 1 data source (plmb) and exposes 19 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, ProdnRtgVersBOMInternalID. It has 7 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
plmb plmb from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
[1..1] I_BillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant
[1..1] I_BillOfOperationsVersion _BillOfOperationsVersion $projection.BillOfOperationsType = _BillOfOperationsVersion.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsVersion.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsVersion.BillOfOperationsVariant and $projection.BillOfOperationsVersion = _BillOfOperationsVersion.BillOfOperationsVersion
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_Material _Material $projection.Material = _Material.Material
[1..1] I_MaterialBOM _BOMVersion $projection.BillOfMaterialVariantUsage = _BOMVersion.BillOfMaterialVariantUsage and $projection.BillOfMaterial = _BOMVersion.BillOfMaterial and $projection.BillOfMaterialVariant = _BOMVersion.BillOfMaterialVariant and $projection.BillOfMaterialCategory = _BOMVersion.BillOfMaterialCategory and $projection.BillOfMaterialVersion = _BOMVersion.BillOfMaterialVersion

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBOOVERSBOMASS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProdnRtgVersBOMInternalID view
EndUserText.label Bill of Operations Version BOM Assignment view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plnty
KEY BillOfOperationsGroup plnnr
KEY BillOfOperationsVariant plnal
KEY BillOfOperationsVersion versn
KEY ProdnRtgVersBOMInternalID zuonr
Material matnr
Plant werks
BillOfMaterialCategory stlty
BillOfMaterialVariantUsage stlan
BillOfMaterial stlnr
BillOfMaterialVariant stlal
BillOfMaterialVersion bom_versn
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperations _BillOfOperations
_BillOfOperationsVersion _BillOfOperationsVersion
_Material _Material
_Plant _Plant
_BOMVersion _BOMVersion 
@AbapCatalog.sqlViewName: 'IBOOVERSBOMASS'
@AbapCatalog.compiler.compareFilter:true 
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel.representativeKey: 'ProdnRtgVersBOMInternalID'
@EndUserText.label: 'Bill of Operations Version BOM Assignment'

define view I_BOOVersionBOMAssignment
  as select from plmb

  association [1..1] to I_BillOfOperationsType    as _BillOfOperationsType    on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  association [1..1] to I_BillOfOperationsGroup   as _BillOfOperationsGroup   on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                              and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
  association [1..1] to I_BillOfOperations        as _BillOfOperations        on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                              and $projection.BillOfOperationsGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                              and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant
  association [1..1] to I_BillOfOperationsVersion as _BillOfOperationsVersion on  $projection.BillOfOperationsType    = _BillOfOperationsVersion.BillOfOperationsType
                                                                              and $projection.BillOfOperationsGroup   = _BillOfOperationsVersion.BillOfOperationsGroup
                                                                              and $projection.BillOfOperationsVariant = _BillOfOperationsVersion.BillOfOperationsVariant
                                                                              and $projection.BillOfOperationsVersion = _BillOfOperationsVersion.BillOfOperationsVersion

  association [1..1] to I_Plant                   as _Plant                   on  $projection.Plant = _Plant.Plant
  association [1..1] to I_Material                as _Material                on  $projection.Material = _Material.Material

  association [1..1] to I_MaterialBOM             as _BOMVersion              on  $projection.BillOfMaterialVariantUsage = _BOMVersion.BillOfMaterialVariantUsage
                                                                              and $projection.BillOfMaterial             = _BOMVersion.BillOfMaterial
                                                                              and $projection.BillOfMaterialVariant      = _BOMVersion.BillOfMaterialVariant
                                                                              and $projection.BillOfMaterialCategory     = _BOMVersion.BillOfMaterialCategory
                                                                              and $projection.BillOfMaterialVersion      = _BOMVersion.BillOfMaterialVersion

{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plnty     as BillOfOperationsType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plnnr     as BillOfOperationsGroup,

      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key plnal     as BillOfOperationsVariant,

      @ObjectModel.foreignKey.association: '_BillOfOperationsVersion'
  key versn     as BillOfOperationsVersion,

  key zuonr     as ProdnRtgVersBOMInternalID,

      @ObjectModel.foreignKey.association: '_Material'
      matnr     as Material,
      @ObjectModel.foreignKey.association: '_Plant'
      werks     as Plant,

      stlty     as BillOfMaterialCategory,
      stlan     as BillOfMaterialVariantUsage,
      stlnr     as BillOfMaterial,
      stlal     as BillOfMaterialVariant,
      @ObjectModel.foreignKey.association: '_BOMVersion'
      bom_versn as BillOfMaterialVersion,

      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperations,
      _BillOfOperationsVersion,
      _Material,
      _Plant,
      _BOMVersion

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PLMB"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_BILLOFOPERATIONSVERSION",
"I_MATERIAL",
"I_MATERIALBOM",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More