I_AllMatlsInclStockOrdNotif

DDL: I_ALLMATLSINCLSTOCKORDNOTIF SQL: IMATSTOCKORDNTF Type: view COMPOSITE
95 Fields 1 Data Sources

All Materials including Stock, Order and Notification

I_AllMatlsInclStockOrdNotif is a Composite CDS View that provides data about "All Materials including Stock, Order and Notification" in SAP S/4HANA. It reads from 1 data source (I_MaterialInclOrdAndNotifType) and exposes 95 fields with key fields Material, Plant, StorageLocation, NotificationType, MaintenanceOrderType.

Data Sources (1)

SourceAliasJoin Type
I_MaterialInclOrdAndNotifType I_MaterialInclOrdAndNotifType from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IMATSTOCKORDNTF view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label All Materials including Stock, Order and Notification view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation StorageLocation
KEY NotificationType NotificationType Notifictn Type
KEY MaintenanceOrderType MaintenanceOrderType Order Type
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
MatlWrhsStkQtyInMatlBaseUnit _MaterialUnrestrictedUseStock MatlWrhsStkQtyInMatlBaseUnit Quantity
MatlWrhsStkQtyOnPlantLvl _UnrestrictedUseStkOnPlntLvl MatlWrhsStkQtyInMatlBaseUnit Quantity
AuthorizationGroup AuthorizationGroup AuthorizGroup
_NotificationType _NotificationType
_MaintenanceOrderType _MaintenanceOrderType
_Text _Text
_BaseUnit _BaseUnit
_WeightUnit _WeightUnit
_MaterialGroup _MaterialGroup
_MaterialType _MaterialType
_StorageLocation _StorageLocation
_ComponentItemCategory _ComponentItemCategory
_Plant _Plant

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_AllMatlsInclStockOrdNotif.
-- 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: IMATSTOCKORDNTF

CREATE VIEW I_AllMatlsInclStockOrdNotif AS
SELECT
  Material,
  Plant,
  StorageLocation,
  NotificationType,
  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,
  _MaterialUnrestrictedUseStock.MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyInMatlBaseUnit,
  _UnrestrictedUseStkOnPlntLvl.MatlWrhsStkQtyInMatlBaseUnit AS MatlWrhsStkQtyOnPlantLvl,
  AuthorizationGroup
FROM I_MaterialInclOrdAndNotifType
;

Learn More