I_Batch

Batch information | view: IBATCH | ATTR | Extraction: Not supported | Component: Batch master
Tables used: MCH1MCHAMARCTCUCH
Column Name Description
Plant Plant
Material FK Material Number
Batch Batch Number
Column Name Description
Column Name Description
Column Name Description
MatlBatchAvailabilityDate Availability date
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
ManufactureDate Date of Manufacture
NextInspectionDate Next Inspection Date
LastGoodsReceiptDate Date of last goods receipt
FreeDefinedDate1 Date for Free Use 1
FreeDefinedDate2 Date for Free Use 2
FreeDefinedDate3 Date for Free Use 3
FreeDefinedDate4 Date for Free Use 4
FreeDefinedDate5 Date for Free Use 5
FreeDefinedDate6 Date for Free Use 6
Column Name Description
BatchIsMarkedForDeletion Deletion Flag for All Data in a Batch Show values
MatlBatchIsInRstrcdUseStock Batch in Restricted-Use Stock Show values
DefinitionOfBatchLevel Indicator: definition of batch management level Show values
IsSubordinateBatch Subordinate Batch Show values
Column Name Description Domain name
BatchBySupplier Supplier Batch Number LICHN
BatchIdentifyingPlant Plant WERKS
CreationDateTime Created On Timestamp TZNTSTMPL
LastChangeDateTime Last Change Timestamp TZNTSTMPL
ClfnObjectInternalID Internal object no.: Batch classification CUOBJ
BatchExtWhseMgmtInternalId Batch ID
StockSegment Stock Segment SGT_SRCA
InventoryValuationType Valuation Type BWTAR
Master Data Relations Join Conditions
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • I_BATCH.COUNTRYOFORIGIN == T005.LAND1
  • I_BATCH.MANDT == T005.MANDT
Material Group for Intrastat
  • Client
  • Material Group for Intrastat
  • I_BATCH.MANDT == TVFM.MANDT
  • I_BATCH.EXPORTANDIMPORTPRODUCTGROUP == TVFM.MTVER
Material Number
  • Client
  • Material Number
  • I_BATCH.MANDT == MARA.MANDT
  • I_BATCH.MATERIAL == MARA.MATNR
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Region of Origin of Material (Non-Preferential Origin)
  • Client
  • I_BATCH.COUNTRYOFORIGIN == T005S.LAND1
  • I_BATCH.REGIONOFORIGIN == T005S.BLAND
  • I_BATCH.MANDT == T005S.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_BATCH.SUPPLIER == LFA1.LIFNR
  • I_BATCH.MANDT == LFA1.MANDT