I_MaterialInclOrdAndNotifType

Material incl. Order and Notif. Type | view: IMATORDNOTIF | Extraction: Not supported | Component: Plant Maintenance
Tables used: MATDOC_EXTRACT, MATDOC_EXTRACT, MARA, MARA, NRIV, TQ80, MARA, /SAPSLL/CLSNR, /SAPSLL/MARITC, /SAPSLL/NOSCA, MARC, T001W, MARD, EAM_PLANT, TPAER, /SAPSLL/TUNOS
Column Name Description
Material Material Number
Plant Plant
StorageLocation Storage location
NotificationType FK Notification Type
MaintenanceOrderType FK Order Type
Column Name Description
Column Name Description
FixedLotSizeQuantity Fixed lot size
GoodsReceiptBlockedStockQty null
MaximumLotSizeQuantity Maximum Lot Size
MinimumLotSizeQuantity Minimum Lot Size
SafetyStockQuantity Safety Stock
StockInTransferQuantity null
StockInTransitQuantity null
📏 Weight Unit (MaterialWeightUnit):
MaterialGrossWeight Gross weight
MaterialNetWeight Net weight
Column Name Description
ConsumptionRefUsageEndDate To date of the material to be copied for consumption
CreationDate Created On
DateOfLastPostedCntUnRstrcdStk Date of Last Posted Count
ProfileValidityStartDate Date from Which the Plant-Specific Material Status Is Valid
Column Name Description
HasPostToInspectionStock Has Post to Inspection Stock Show values
IsBatchManagementRequired Batch Management Requirement Indicator for Plant Show values
IsCoProduct Indicator: Material can be co-product Show values
IsInternalBatchManaged Batch management indicator (internal) Show values
IsNegativeStockAllowed Negative stocks allowed in plant Show values
IsPurgAcrossPurgGroup Purchasing Across Purchasing Group Show values
PeriodType Period Indicator Show values
PhysicalInventoryBlockInd Physical Inventory Blocking Indicator Show values
ProcurementType Procurement Type Show values
ProductCFOPCategory Material CFOP category Show values
Column Name Description Domain name
ABCIndicator ABC Indicator MAABC
AvailabilityCheckType Checking Group for Availability Check MTVFP
Commodity Commodity Code STAWN
ConsignmentControl Consignment Control WRF_CONS_PROCG
ConsumptionQtyMultiplier Multiplier for reference material for consumption DEC2_2
ConsumptionReferencePlant Reference plant for consumption WERKS
ConsumptionReferenceProduct Reference material for consumption MATNR
ConsumptionTaxCtrlCode Control code for consumption taxes in foreign trade STEUC
CountryOfOrigin Country/Region of Origin of Material (Non-Preferential Ori.) LAND1
DistrCntrDistributionProfile Distribution profile of material in plant MPPRF
FiscalMonthCurrentPeriod null
FiscalYearCurrentInvtryPeriod Fiscal year of current physical inventory indicator GJAHR
FiscalYearCurrentPeriod null
FiscalYearVariant Fiscal Year Variant PERIV
GoodIssueProcessingDays Goods Issue Processing Time in Days DEC3
GoodsReceiptDuration Goods receipt processing time in days DEC3
HasConsignmentCtrl Consignment Control WRF_CONS_PROCG
HasInvtryBlockStockPrevPeriod Phys. inventory indicator for blocked stock in prev. period INVKZ
InventoryBlockStockInd Physical inventory indicator for blocked stock INVKZ
InventoryCorrectionFactor Inventory Correction Factor FLTP
InventoryStockPrevPeriod Physical inventory indicator for stock in previous year INVKZ
InvtryCurrentYearStockInd Physical inventory indicator for whse stock in current year INVKZ
InvtryQualInspCurrentYrStkInd Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
InvtryRestStockPrevPeriodInd Physical inventory ind. for restricted-use stock, prev.pd INVKZ
InvtryRestrictedUseStockInd Physical inventory indicator for restricted-use stock INVKZ
InvtryStockQltyInspPrevPeriod Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
MRPResponsible MRP Controller DISPO
MRPType MRP Type DISMM
MaintenanceStatus Maintenance status PSTAT
MaintenanceStatusName Maintenance status PSTAT
MaterialManufacturerPartNumber Manufacturer Part Number CHAR40
OverDelivToleranceLimit Overdelivery tolerance limit DEC2_1
Product Material Number MATNR
ProductIsConfigurable Configurable Product MATNR
ProductUnitGroup Unit of Measure Group MEGRU
ProductionInvtryManagedLoc Issue Storage Location LGORT
ProductionSchedulingProfile Production Scheduling Profile CO_PRODPRF
ProductionSupervisor Production Supervisor FEVOR
ProfileCode Plant-Specific Material Status MMSTA
ProfitCenter Profit Center PRCTR
PurchasingGroup Purchasing Group EKGRP
RegionOfOrigin Region of Origin of Material (Non-Preferential Origin) REGIO
SerialNumberProfile Serial Number Profile SERAIL
SourceOfSupplyCategory Source of Supply BQSCL
SpecialProcurementType Special procurement type SOBSL
StockDeterminationGroup Stock determination group BF_GROUP
UnderDelivToleranceLimit Underdelivery tolerance limit DEC2_1
WarehouseStorageBin Storage Bin CHAR10
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Order Type
  • Client
  • Order Type
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == T003O.CLIENT
  • I_MATERIALINCLORDANDNOTIFTYPE.MAINTENANCEORDERTYPE == T003O.AUART
Unit of Measure
  • Client
  • Base Unit of Measure
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == T006.MANDT
  • I_MATERIALINCLORDANDNOTIFTYPE.MATERIALBASEUNIT == T006.MSEHI
Material Group
  • Client
  • Material Group
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == T023.MANDT
  • I_MATERIALINCLORDANDNOTIFTYPE.MATERIALGROUP == T023.MATKL
Manufacturer Number
  • Client
  • Manufacturer number
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == LFA1.MANDT
  • I_MATERIALINCLORDANDNOTIFTYPE.MATERIALMANUFACTURERNUMBER == LFA1.LIFNR
Material type
  • Material type
  • Client
  • I_MATERIALINCLORDANDNOTIFTYPE.MATERIALTYPE == T134.MTART
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == T134.MANDT
Unit of Weight
  • Weight Unit
  • Client
  • I_MATERIALINCLORDANDNOTIFTYPE.MATERIALWEIGHTUNIT == T006.MSEHI
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == T006.MANDT
Notification Type
  • Notification Type
  • Client
  • I_MATERIALINCLORDANDNOTIFTYPE.NOTIFICATIONTYPE == TQ80.QMART
  • I_MATERIALINCLORDANDNOTIFTYPE.MANDT == TQ80.MANDT