Which tables does I_BOOVersionBOMAssignment use?

I_BOOVersionBOMAssignment reads from 1 data source(s): plmb.

I_BOOVersionBOMAssignment

Q: How many fields does I_BOOVersionBOMAssignment have?

I_BOOVersionBOMAssignment has 19 fields. Key fields: BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, ProdnRtgVersBOMInternalID.

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.

Data Sources (1)

Source	Alias	Join Type
plmb	plmb	from

Associations (7)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Field
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

}

Depth:

I_BOOVersionBOMAssignment view

plmb