I_ChgImpactMBOMRoutingLink

Q: Which tables does I_ChgImpactMBOMRoutingLink use?

I_ChgImpactMBOMRoutingLink reads from 2 data source(s): I_BillOfOperationsVersion, I_BOOVersionBOMAssignment.

Q: How many fields does I_ChgImpactMBOMRoutingLink have?

I_ChgImpactMBOMRoutingLink has 19 fields. Key fields: BillOfOperationsGroup, BillOfOperationsType, BillOfOperationsVariant, BillOfOperationsVersion, MfgBillOfMaterialHeaderUUID.

DDL: I_CHGIMPACTMBOMROUTINGLINK SQL: ICHIMPMBOMROULNK Type: view COMPOSITE

Manufacturing BOMs Linked with Routing

I_ChgImpactMBOMRoutingLink is a Composite CDS View that provides data about "Manufacturing BOMs Linked with Routing" in SAP S/4HANA. It reads from 2 data sources (I_BillOfOperationsVersion, I_BOOVersionBOMAssignment) and exposes 19 fields with key fields BillOfOperationsGroup, BillOfOperationsType, BillOfOperationsVariant, BillOfOperationsVersion, MfgBillOfMaterialHeaderUUID. It has 2 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_BillOfOperationsVersion	BOOVersion	inner
I_BOOVersionBOMAssignment	MfgBOMRoutingLink	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_MaterialBOM	_MaterialBOM	`MfgBOMRoutingLink.BillOfMaterial = _MaterialBOM.BillOfMaterial and MfgBOMRoutingLink.BillOfMaterialVariant = _MaterialBOM.BillOfMaterialVariant and MfgBOMRoutingLink.BillOfMaterialVariantUsage = _MaterialBOM.BillOfMaterialVariantUsage and MfgBOMRoutingLink.BillOfMaterialVersion = _MaterialBOM.BillOfMaterialVersion`
[0..1]	I_BOOVersionStatusText	_BOOVersionStatusText	`$projection.billofoperationsversionstatus = _BOOVersionStatusText.BillOfOperationsVersionStatus and _BOOVersionStatusText.Language = $session.system_language`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	ICHIMPMBOMROULNK	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	Manufacturing BOMs Linked with Routing	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (19)

Key	Field	Source Table	Source Field
KEY	BillOfOperationsGroup	I_BOOVersionBOMAssignment	BillOfOperationsGroup
KEY	BillOfOperationsType	I_BOOVersionBOMAssignment	BillOfOperationsType
KEY	BillOfOperationsVariant	I_BOOVersionBOMAssignment	BillOfOperationsVariant
KEY	BillOfOperationsVersion	I_BOOVersionBOMAssignment	BillOfOperationsVersion
KEY	MfgBillOfMaterialHeaderUUID	_MaterialBOM	BillOfMaterialHeaderUUID
KEY	BillOfMaterial	I_BOOVersionBOMAssignment	BillOfMaterial
KEY	BillOfMaterialVariant	I_BOOVersionBOMAssignment	BillOfMaterialVariant
KEY	BillOfMaterialVersion	I_BOOVersionBOMAssignment	BillOfMaterialVersion
KEY	ProdnRtgVersBOMInternalID	I_BOOVersionBOMAssignment	ProdnRtgVersBOMInternalID
KEY	BillOfMaterialVariantUsage	I_BOOVersionBOMAssignment	BillOfMaterialVariantUsage
KEY	BillOfMaterialCategory	I_BOOVersionBOMAssignment	BillOfMaterialCategory
	Material	I_BOOVersionBOMAssignment	Material
	Plant	I_BOOVersionBOMAssignment	Plant
	BillOfOperationsVersionStatus
	BillOfOperationsSubtype
	UserID
	_MaterialBOM		_MaterialBOM
	_BillOfOperations	I_BOOVersionBOMAssignment	_BillOfOperations
	_BOOVersionStatusText		_BOOVersionStatusText

@AbapCatalog.sqlViewName:'ICHIMPMBOMROULNK'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Manufacturing BOMs Linked with Routing'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
define view I_ChgImpactMBOMRoutingLink

  as select from I_BOOVersionBOMAssignment as MfgBOMRoutingLink
  inner join   I_BillOfOperationsVersion as BOOVersion on  BOOVersion.BillOfOperationsGroup   = MfgBOMRoutingLink.BillOfOperationsGroup
                                                         and BOOVersion.BillOfOperationsType    = MfgBOMRoutingLink.BillOfOperationsType
                                                         and BOOVersion.BillOfOperationsVariant = MfgBOMRoutingLink.BillOfOperationsVariant
                                                         and BOOVersion.BillOfOperationsVersion = MfgBOMRoutingLink.BillOfOperationsVersion
  
  association [0..*] to I_MaterialBOM          as _MaterialBOM          on  MfgBOMRoutingLink.BillOfMaterial             = _MaterialBOM.BillOfMaterial
                                                                        and MfgBOMRoutingLink.BillOfMaterialVariant      = _MaterialBOM.BillOfMaterialVariant
                                                                        and MfgBOMRoutingLink.BillOfMaterialVariantUsage = _MaterialBOM.BillOfMaterialVariantUsage
                                                                        and MfgBOMRoutingLink.BillOfMaterialVersion      = _MaterialBOM.BillOfMaterialVersion
  association [0..1] to I_BOOVersionStatusText as _BOOVersionStatusText on  $projection.billofoperationsversionstatus = _BOOVersionStatusText.BillOfOperationsVersionStatus
                                                                        and _BOOVersionStatusText.Language            = $session.system_language
{

  key    MfgBOMRoutingLink.BillOfOperationsGroup,
  key    MfgBOMRoutingLink.BillOfOperationsType,
  key    MfgBOMRoutingLink.BillOfOperationsVariant,
  key    MfgBOMRoutingLink.BillOfOperationsVersion,
  key    _MaterialBOM.BillOfMaterialHeaderUUID as MfgBillOfMaterialHeaderUUID,
  key    MfgBOMRoutingLink.BillOfMaterial,
  key    MfgBOMRoutingLink.BillOfMaterialVariant,
  key    MfgBOMRoutingLink.BillOfMaterialVersion,
  key    MfgBOMRoutingLink.ProdnRtgVersBOMInternalID,
  key    MfgBOMRoutingLink.BillOfMaterialVariantUsage,
  key    MfgBOMRoutingLink.BillOfMaterialCategory,
         MfgBOMRoutingLink.Material,
         MfgBOMRoutingLink.Plant,
         @ObjectModel.text.association:'_BOOVersionStatusText'
         MfgBOMRoutingLink._BillOfOperationsVersion.BillOfOperationsVersionStatus,
         MfgBOMRoutingLink._BillOfOperations.BillOfOperationsSubtype,
         _BillOfOperationsVersion._CreatedByUser.UserID,

         //_BillOfOperations._BillOfOperationsChangeState.ValidityStartDate,

         //_BillOfOperations._BillOfOperationsChangeState.ValidityEndDate,


         _MaterialBOM,
         MfgBOMRoutingLink._BillOfOperations,
         _BOOVersionStatusText
         //  _Plant,

         //  _Material



//Changes done with respect to order specific routing - to filter out Order specific routings - 1909

//If there is an Order ID associated with the routing - filter it out

//This view will give only master routings

}
where
  BOOVersion.OrderID = ''

Depth:

I_ChgImpactMBOMRoutingLink view

I_BOOVersionBOMAssignment view
I_BillOfOperationsVersion view