What is I_MaterialInclOrdAndNotifType in SAP S/4HANA?

I_MaterialInclOrdAndNotifType is a composite CDS view in SAP S/4HANA. Material incl. Order and Notif. Type It contains 95 fields.

Which tables does I_MaterialInclOrdAndNotifType read from?

I_MaterialInclOrdAndNotifType reads data from: P_MaterialPlantStorageLocation.

What VDM layer is I_MaterialInclOrdAndNotifType?

I_MaterialInclOrdAndNotifType is classified as a Composite view that combines data from multiple basic views.

I_MaterialInclOrdAndNotifType

DDL: I_MATERIALINCLORDANDNOTIFTYPE SQL: IMATORDNOTIF Type: view COMPOSITE

95 Fields 1 Data Sources 13 Associations

Material incl. Order and Notif. Type

I_MaterialInclOrdAndNotifType is a Composite CDS View that provides data about "Material incl. Order and Notif. Type" in SAP S/4HANA. It reads from 1 data source (P_MaterialPlantStorageLocation) and exposes 95 fields with key fields Material, Plant, StorageLocation, NotificationType, MaintenanceOrderType. It has 13 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_MaterialPlantStorageLocation	P_MaterialPlantStorageLocation	from

Associations (13)

Cardinality	Target	Alias	Condition
[0..1]	I_OrderType	_MaintenanceOrderType	`$projection.maintenanceordertype = _MaintenanceOrderType.OrderType`
[0..1]	I_PMNotificationType	_NotificationType	`$projection.notificationtype = _NotificationType.NotificationType`
[0..1]	I_MaterialUnrestrictedUseStock	_MaterialUnrestrictedUseStock	`$projection.Material = _MaterialUnrestrictedUseStock.Material and $projection.Plant = _MaterialUnrestrictedUseStock.Plant and $projection.StorageLocation = _MaterialUnrestrictedUseStock.StorageLocation`
[0..*]	I_MaintNotifTypesPerPlant	_MaintNotifTypesPerPlant	`$projection.Plant = _MaintNotifTypesPerPlant.Plant`
[0..*]	I_MaterialText	_Text	`$projection.Material = _Text.Material`
[0..1]	I_MaterialType	_MaterialType	`$projection.MaterialType = _MaterialType.MaterialType`
[0..1]	I_MaterialGroup	_MaterialGroup	`$projection.MaterialGroup = _MaterialGroup.MaterialGroup`
[0..1]	I_UnitOfMeasure	_BaseUnit	`$projection.MaterialBaseUnit = _BaseUnit.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_WeightUnit	`$projection.MaterialWeightUnit = _WeightUnit.UnitOfMeasure`
[0..1]	I_StorageLocation	_StorageLocation	`$projection.Plant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation`
[0..1]	I_ComponentItemCategory	_ComponentItemCategory	`$projection.MaterialType = _ComponentItemCategory.MaterialType and $projection.Plant = _ComponentItemCategory.Plant`
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[0..1]	I_UnrestrictedUseStkOnPlntLvl	_UnrestrictedUseStkOnPlntLvl	`$projection.Material = _UnrestrictedUseStkOnPlntLvl.Material and $projection.Plant = _UnrestrictedUseStkOnPlntLvl.Plant`

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	IMATORDNOTIF	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Material incl. Order and Notif. Type	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (95)

Key	Field	Source Table	Source Field	Description
KEY	Material		Material	Vehicle Model
KEY	Plant		Plant	Valuation Area
KEY	StorageLocation		StorageLocation	StorageLocation
KEY	NotificationType	_MaintNotifTypesPerPlant	NotificationType	Notifictn Type
KEY	MaintenanceOrderType
	ABCIndicator		ABCIndicator	ABC Indicator
	AvailabilityCheckType		AvailabilityCheckType	Avail. check
	Commodity		Commodity	Commodity Code
	ConsignmentControl		ConsignmentControl	Consign.Control
	ConsumptionQtyMultiplier		ConsumptionQtyMultiplier	Multiplier
	ConsumptionRefUsageEndDate		ConsumptionRefUsageEndDate	Date to
	ConsumptionReferencePlant		ConsumptionReferencePlant	Ref.plant:cons.
	ConsumptionReferenceProduct		ConsumptionReferenceProduct	Ref.matl: cons.
	ConsumptionTaxCtrlCode		ConsumptionTaxCtrlCode	Taxes F.Trade
	CountryOfOrigin		CountryOfOrigin	Country/Region of Origin
	CreationDate		CreationDate	Time Stamp
	DateOfLastPostedCntUnRstrcdStk		DateOfLastPostedCntUnRstrcdStk	Last Count Date
	DistrCntrDistributionProfile		DistrCntrDistributionProfile	Dist.prof.
	FiscalMonthCurrentPeriod		FiscalMonthCurrentPeriod	Current period
	FiscalYearCurrentInvtryPeriod		FiscalYearCurrentInvtryPeriod	Fiscal Year of Current Physical Inventory Indicator
	FiscalYearCurrentPeriod		FiscalYearCurrentPeriod	Year cur.period
	FiscalYearVariant		FiscalYearVariant	FY Variant
	FixedLotSizeQuantity		FixedLotSizeQuantity	Fixed lot size
	GoodIssueProcessingDays		GoodIssueProcessingDays	GI Proc.Time
	GoodsIssueUnit		GoodsIssueUnit	Unit of Issue
	GoodsReceiptBlockedStockQty		GoodsReceiptBlockedStockQty	Val. GR Blocked Stck
	GoodsReceiptDuration		GoodsReceiptDuration	GR proc. time
	HasConsignmentCtrl		HasConsignmentCtrl	Consign.Control
	HasInvtryBlockStockPrevPeriod		HasInvtryBlockStockPrevPeriod	Blocked stock
	HasPostToInspectionStock		HasPostToInspectionStock	Post to insp. stk
	InventoryBlockStockInd		InventoryBlockStockInd	Blocked stock
	InventoryCorrectionFactor		InventoryCorrectionFactor	Inven.cor.fact.
	InventoryStockPrevPeriod		InventoryStockPrevPeriod	Warehouse stock
	InvtryCurrentYearStockInd		InvtryCurrentYearStockInd	Warehouse stock
	InvtryQualInspCurrentYrStkInd		InvtryQualInspCurrentYrStkInd	QualInspStock
	InvtryRestStockPrevPeriodInd		InvtryRestStockPrevPeriodInd	Restricted use
	InvtryRestrictedUseStockInd		InvtryRestrictedUseStockInd	Restricted-use
	InvtryStockQltyInspPrevPeriod		InvtryStockQltyInspPrevPeriod	QualInspStock
	IsBatchManagementRequired		IsBatchManagementRequired	Batch Mgmt Rqt(Plnt)
	IsCoProduct		IsCoProduct	Co-product?
	IsInternalBatchManaged		IsInternalBatchManaged	Batches
	IsNegativeStockAllowed		IsNegativeStockAllowed	Neg. stocks
	IsPurgAcrossPurgGroup		IsPurgAcrossPurgGroup	Across Purch.Group
	MRPResponsible		MRPResponsible	MRP Controller
	MRPType		MRPType	MRP Type
	MaintenanceStatus		MaintenanceStatus	Maint. status
	MaintenanceStatusName		MaintenanceStatusName	Maint. status
	MaterialBaseUnit		MaterialBaseUnit	Valuation Unit
	MaterialGrossWeight		MaterialGrossWeight
	MaterialGroup		MaterialGroup	Product Group
	MaterialManufacturerNumber		MaterialManufacturerNumber
	MaterialManufacturerPartNumber		MaterialManufacturerPartNumber
	MaterialNetWeight		MaterialNetWeight
	MaterialType		MaterialType	Material Type
	MaterialWeightUnit		MaterialWeightUnit
	MaximumLotSizeQuantity		MaximumLotSizeQuantity	Max. Lot Size
	MinimumLotSizeQuantity		MinimumLotSizeQuantity	Min. Lot Size
	OverDelivToleranceLimit		OverDelivToleranceLimit	Overdely tol.
	PeriodType		PeriodType	PeriodIndicator
	PhysicalInventoryBlockInd		PhysicalInventoryBlockInd	Phys. Inv. Blk
	ProcurementType		ProcurementType	Procurement
	Product		Product	Product Sold
	ProductCFOPCategory		ProductCFOPCategory	Prod. category
	ProductIsConfigurable		ProductIsConfigurable	Configurable
	ProductUnitGroup		ProductUnitGroup	UoM Group
	ProductionInvtryManagedLoc		ProductionInvtryManagedLoc	Storage Location
	ProductionSchedulingProfile		ProductionSchedulingProfile	Production Scheduling Profile
	ProductionSupervisor		ProductionSupervisor	Prodn Supervisor
	ProfileCode		ProfileCode	Product Status
	ProfileValidityStartDate		ProfileValidityStartDate	Valid from
	ProfitCenter		ProfitCenter	Profit Center
	PurchasingGroup		PurchasingGroup	Purchasing Group
	RegionOfOrigin		RegionOfOrigin	Reg. of Origin
	SafetyStockQuantity		SafetyStockQuantity	Safety stock
	SerialNumberProfile		SerialNumberProfile	SerialNoProfile
	SourceOfSupplyCategory		SourceOfSupplyCategory	Supply source
	SpecialProcurementType		SpecialProcurementType	SpecProcurement
	StockDeterminationGroup		StockDeterminationGroup	Stock Determ. Group
	StockInTransferQuantity		StockInTransferQuantity	Stock in tfr
	StockInTransitQuantity		StockInTransitQuantity	Stk in Transit
	UnderDelivToleranceLimit		UnderDelivToleranceLimit	Underdely tol.
	WarehouseStorageBin		WarehouseStorageBin	Storage Bin
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	_NotificationType		_NotificationType
	_MaintenanceOrderType		_MaintenanceOrderType
	_Text		_Text
	_MaterialUnrestrictedUseStock		_MaterialUnrestrictedUseStock
	_BaseUnit		_BaseUnit
	_WeightUnit		_WeightUnit
	_MaterialGroup		_MaterialGroup
	_MaterialType		_MaterialType
	_StorageLocation		_StorageLocation
	_ComponentItemCategory		_ComponentItemCategory
	_Plant		_Plant
	_UnrestrictedUseStkOnPlntLvl		_UnrestrictedUseStkOnPlntLvl

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MaterialInclOrdAndNotifType.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMATORDNOTIF

CREATE VIEW I_MaterialInclOrdAndNotifType AS
SELECT
  Material,
  Plant,
  StorageLocation,
  _MaintNotifTypesPerPlant.NotificationType AS NotificationType,
  _MaintNotifTypesPerPlant._NotificationType.MaintenanceOrderType AS MaintenanceOrderType,
  ABCIndicator,
  AvailabilityCheckType,
  Commodity,
  ConsignmentControl,
  ConsumptionQtyMultiplier,
  ConsumptionRefUsageEndDate,
  ConsumptionReferencePlant,
  ConsumptionReferenceProduct,
  ConsumptionTaxCtrlCode,
  CountryOfOrigin,
  CreationDate,
  DateOfLastPostedCntUnRstrcdStk,
  DistrCntrDistributionProfile,
  FiscalMonthCurrentPeriod,
  FiscalYearCurrentInvtryPeriod,
  FiscalYearCurrentPeriod,
  FiscalYearVariant,
  FixedLotSizeQuantity,
  GoodIssueProcessingDays,
  GoodsIssueUnit,
  GoodsReceiptBlockedStockQty,
  GoodsReceiptDuration,
  HasConsignmentCtrl,
  HasInvtryBlockStockPrevPeriod,
  HasPostToInspectionStock,
  InventoryBlockStockInd,
  InventoryCorrectionFactor,
  InventoryStockPrevPeriod,
  InvtryCurrentYearStockInd,
  InvtryQualInspCurrentYrStkInd,
  InvtryRestStockPrevPeriodInd,
  InvtryRestrictedUseStockInd,
  InvtryStockQltyInspPrevPeriod,
  IsBatchManagementRequired,
  IsCoProduct,
  IsInternalBatchManaged,
  IsNegativeStockAllowed,
  IsPurgAcrossPurgGroup,
  MRPResponsible,
  MRPType,
  MaintenanceStatus,
  MaintenanceStatusName,
  MaterialBaseUnit,
  MaterialGrossWeight,
  MaterialGroup,
  MaterialManufacturerNumber,
  MaterialManufacturerPartNumber,
  MaterialNetWeight,
  MaterialType,
  MaterialWeightUnit,
  MaximumLotSizeQuantity,
  MinimumLotSizeQuantity,
  OverDelivToleranceLimit,
  PeriodType,
  PhysicalInventoryBlockInd,
  ProcurementType,
  Product,
  ProductCFOPCategory,
  ProductIsConfigurable,
  ProductUnitGroup,
  ProductionInvtryManagedLoc,
  ProductionSchedulingProfile,
  ProductionSupervisor,
  ProfileCode,
  ProfileValidityStartDate,
  ProfitCenter,
  PurchasingGroup,
  RegionOfOrigin,
  SafetyStockQuantity,
  SerialNumberProfile,
  SourceOfSupplyCategory,
  SpecialProcurementType,
  StockDeterminationGroup,
  StockInTransferQuantity,
  StockInTransitQuantity,
  UnderDelivToleranceLimit,
  WarehouseStorageBin,
  AuthorizationGroup
FROM P_MaterialPlantStorageLocation
LEFT OUTER JOIN I_OrderType AS _MaintenanceOrderType ON maintenanceordertype = _MaintenanceOrderType.OrderType  -- association [0..1]
LEFT OUTER JOIN I_PMNotificationType AS _NotificationType ON notificationtype = _NotificationType.NotificationType  -- association [0..1]
LEFT OUTER JOIN I_MaterialUnrestrictedUseStock AS _MaterialUnrestrictedUseStock ON Material = _MaterialUnrestrictedUseStock.Material AND Plant = _MaterialUnrestrictedUseStock.Plant AND StorageLocation = _MaterialUnrestrictedUseStock.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MaintNotifTypesPerPlant AS _MaintNotifTypesPerPlant ON Plant = _MaintNotifTypesPerPlant.Plant  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialType = _MaterialType.MaterialType  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON MaterialBaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON MaterialWeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ComponentItemCategory AS _ComponentItemCategory ON MaterialType = _ComponentItemCategory.MaterialType AND Plant = _ComponentItemCategory.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnrestrictedUseStkOnPlntLvl AS _UnrestrictedUseStkOnPlntLvl ON Material = _UnrestrictedUseStkOnPlntLvl.Material AND Plant = _UnrestrictedUseStkOnPlntLvl.Plant  -- association [0..1]
;

Depth:

I_MaterialInclOrdAndNotifType view

P_MaterialPlantStorageLocation view

I_AllMatlsInclStockOrdNotif view