Which tables does I_RoutingMaterialSearchModel use?

I_RoutingMaterialSearchModel reads from 1 data source(s): mapl.

I_RoutingMaterialSearchModel

Q: How many fields does I_RoutingMaterialSearchModel have?

I_RoutingMaterialSearchModel has 37 fields. Key fields: Material, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant.

DDL: I_ROUTINGMATERIALSEARCHMODEL Type: view_entity BASIC

Material assgmt. to BOO

I_RoutingMaterialSearchModel is a Basic CDS View that provides data about "Material assgmt. to BOO" in SAP S/4HANA. It reads from 1 data source (mapl) and exposes 37 fields with key fields Material, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. It has 14 associations to related views.

Data Sources (1)

Source	Alias	Join Type
mapl	mapl	from

Associations (14)

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_BOOMaterialAssignment	_BOOMaterialAssignment	`$projection.Plant = _BOOMaterialAssignment.Plant and $projection.Material = _BOOMaterialAssignment.Material and $projection.BillOfOperationsType = _BOOMaterialAssignment.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOMaterialAssignment.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOMaterialAssignment.BillOfOperationsVariant and $projection.BOOToMaterialInternalID = _BOOMaterialAssignment.BOOToMaterialInternalID`
[1..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[1..1]	I_Material	_Material	`$projection.Material = _Material.Material`
[0..1]	I_Supplier	_Supplier	`$projection.Supplier = _Supplier.Supplier`
[0..1]	I_Customer	_Customer	`$projection.Customer = _Customer.Customer`
[0..1]	I_SalesOrder	_SalesOrder	`$projection.SalesOrder = _SalesOrder.SalesOrder`
[0..1]	I_SalesOrderItem	_SalesOrderItem	`$projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem`
[0..1]	I_WBSElementByInternalKey	_WBSElement	`$projection.WBSElementInternalID = _WBSElement.WBSElementInternalID`
[0..1]	I_ChangeMaster	_ChangeMaster	`$projection.ChangeNumber = _ChangeMaster.ChangeNumber -- for ESH`
[1..1]	I_Product	_Product	`$projection.Material = _Product.Product`
[1..1]	I_ProductPlant	_ProductPlant	`$projection.Material = _ProductPlant.Product and $projection.Plant = _ProductPlant.Plant`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#BASIC	view
ObjectModel.representativeKey	BOOMatlInternalVersionCounter	view
Analytics.technicalName	IRTGMATSRCHMOD	view
EndUserText.label	Material assgmt. to BOO	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (37)

Key	Field	Source Table	Source Field
KEY	Material	mapl	matnr
KEY	Plant	mapl	werks
KEY	BillOfOperationsType	mapl	plnty
KEY	BillOfOperationsGroup	mapl	plnnr
KEY	BillOfOperationsVariant	mapl	plnal
KEY	BOOToMaterialInternalID	mapl	zkriz
KEY	BOOMatlInternalVersionCounter	mapl	zaehl
	ValidityStartDate	mapl	datuv
	ValidityEndDate	mapl	valid_to
	ChangeNumber	mapl	aennr
	CreationDate	mapl	andat
	CreatedByUser
	LastChangeDate	mapl	aedat
	LastChangedByUser
	IsDeleted	mapl	loekz
	IsImplicitlyDeleted	mapl	loekz_inherited
	Supplier	mapl	lifnr
	Customer	mapl	kunr
	SalesOrder	mapl	vbeln
	SalesOrderItem	mapl	posnr
	WBSElementInternalID
	BOOSearchText		suchfeld
	BillOfOperationsVersion	mapl	versn
	_Material		_Material
	_Plant		_Plant
	_BillOfOperationsType		_BillOfOperationsType
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_BillOfOperations		_BillOfOperations
	_BOOMaterialAssignment		_BOOMaterialAssignment
	_Supplier		_Supplier
	_Customer		_Customer
	_SalesOrder		_SalesOrder
	_SalesOrderItem		_SalesOrderItem
	_WBSElement		_WBSElement
	_ChangeMaster		_ChangeMaster
	_Product		_Product
	_ProductPlant		_ProductPlant

@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
//@Analytics.dataCategory: #DIMENSION

@ObjectModel.representativeKey: 'BOOMatlInternalVersionCounter'
@Analytics.technicalName: 'IRTGMATSRCHMOD'
@EndUserText.label: 'Material assgmt. to BOO'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
//@Metadata.allowExtensions:true

define view entity I_RoutingMaterialSearchModel

  as select from mapl

  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_BOOMaterialAssignment   as _BOOMaterialAssignment on  $projection.Plant                   = _BOOMaterialAssignment.Plant
                                                                            and $projection.Material                = _BOOMaterialAssignment.Material
                                                                            and $projection.BillOfOperationsType    = _BOOMaterialAssignment.BillOfOperationsType
                                                                            and $projection.BillOfOperationsGroup   = _BOOMaterialAssignment.BillOfOperationsGroup
                                                                            and $projection.BillOfOperationsVariant = _BOOMaterialAssignment.BillOfOperationsVariant
                                                                            and $projection.BOOToMaterialInternalID = _BOOMaterialAssignment.BOOToMaterialInternalID
  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 [0..1] to I_Supplier                as _Supplier              on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Customer                as _Customer              on  $projection.Customer = _Customer.Customer
  association [0..1] to I_SalesOrder              as _SalesOrder            on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [0..1] to I_SalesOrderItem          as _SalesOrderItem        on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder
                                                                            and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
  association [0..1] to I_WBSElementByInternalKey as _WBSElement            on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
  association [0..1] to I_ChangeMaster            as _ChangeMaster          on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber
    -- for ESH
  association [1..1] to I_Product                 as _Product               on $projection.Material = _Product.Product
  association [1..1] to I_ProductPlant            as _ProductPlant          on $projection.Material = _ProductPlant.Product 
                                                                            and $projection.Plant = _ProductPlant.Plant

{
      @ObjectModel.foreignKey.association: '_Material'
  key mapl.matnr                                                     as   Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key mapl.werks                                                     as   Plant,
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key mapl.plnty                                                     as   BillOfOperationsType,

      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key mapl.plnnr                                                     as   BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key mapl.plnal                                                     as   BillOfOperationsVariant,
      @ObjectModel.foreignKey.association: '_BOOMaterialAssignment'
  key mapl.zkriz                                                     as   BOOToMaterialInternalID,
  key mapl.zaehl                                                     as   BOOMatlInternalVersionCounter,

      @Semantics.businessDate.from: true
      mapl.datuv                                                     as   ValidityStartDate,
      @Semantics.businessDate.to: true
      mapl.valid_to                                                  as   ValidityEndDate,

      @ObjectModel.foreignKey.association: '_ChangeMaster'
      mapl.aennr                                                     as   ChangeNumber,
      @Semantics.systemDate.createdAt: true
      mapl.andat                                                     as   CreationDate,
      @Semantics.user.createdBy: true
      cast(mapl.annam as vdm_createdbyuserid preserving type)        as   CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      mapl.aedat                                                     as   LastChangeDate,
      @Semantics.user.lastChangedBy: true
      cast(mapl.aenam as vdm_lastchangedbyuserid preserving type)    as   LastChangedByUser,

      mapl.loekz                                                     as   IsDeleted,
      mapl.loekz_inherited                                           as   IsImplicitlyDeleted,

      @ObjectModel.foreignKey.association: '_Supplier'
      mapl.lifnr                                                     as   Supplier,
      @ObjectModel.foreignKey.association: '_Customer'
      mapl.kunr                                                      as   Customer,
      @ObjectModel.foreignKey.association: '_SalesOrder'
      mapl.vbeln                                                     as   SalesOrder,
      @ObjectModel.foreignKey.association: '_SalesOrderItem'
      mapl.posnr                                                     as   SalesOrderItem,
      @ObjectModel.foreignKey.association: '_WBSElement'
      cast(mapl.pspnr as pph_pspel preserving type)                  as   WBSElementInternalID,
      suchfeld                                                       as   BOOSearchText,
      //      MS_OBJECT Q_MS_OBJECT     global field name not available

      //      MS_OBJTYPE  Q_MS_OBJTYPE  global field name not available


      mapl.versn                                                     as   BillOfOperationsVersion,

      _Material,
      _Plant,
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperations,
      _BOOMaterialAssignment,
      _Supplier,
      _Customer,
      _SalesOrder,
      _SalesOrderItem,
      _WBSElement,
      _ChangeMaster,
      _Product,
      _ProductPlant
}

Depth:

I_RoutingMaterialSearchModel view_entity

mapl

I_JITOutbRtgRptgPt view