I_BatchPlant

Batch in table MCHA with WERKS key | view: IBATCHPLANT | Extraction: Not supported | Component: Batch master
Tables used: MCHA
Column Name Description
Material FK Material Number
Plant FK Plant
Batch FK 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 on a Batch at a Plant Show values
MatlBatchIsInRstrcdUseStock Batch in Restricted-Use Stock Show values
Column Name Description Domain name
BatchBySupplier Supplier Batch Number LICHN
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
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Material Number
  • Client
  • I_BATCHPLANT.BATCH == MCH1.CHARG
  • I_BATCHPLANT.MATERIAL == MCH1.MATNR
  • I_BATCHPLANT.MANDT == MCH1.MANDT
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • I_BATCHPLANT.COUNTRYOFORIGIN == T005.LAND1
  • I_BATCHPLANT.MANDT == T005.MANDT
Material Group for Intrastat
  • Material Group for Intrastat
  • Client
  • I_BATCHPLANT.EXPORTANDIMPORTPRODUCTGROUP == TVFM.MTVER
  • I_BATCHPLANT.MANDT == TVFM.MANDT
Valuation type
  • ?
  • Material Number
  • Valuation Type
  • Client
  • I_BATCHPLANT.[column in domain "BWKEY"] == MBEW.BWKEY
  • I_BATCHPLANT.MATERIAL == MBEW.MATNR
  • I_BATCHPLANT.INVENTORYVALUATIONTYPE == MBEW.BWTAR
  • I_BATCHPLANT.MANDT == MBEW.MANDT
Material
  • Material Number
  • Client
  • I_BATCHPLANT.MATERIAL == MARA.MATNR
  • I_BATCHPLANT.MANDT == MARA.MANDT
Material/Plant
  • Plant
  • Material Number
  • Client
  • I_BATCHPLANT.PLANT == MARC.WERKS
  • I_BATCHPLANT.MATERIAL == MARC.MATNR
  • I_BATCHPLANT.MANDT == MARC.MANDT
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_BATCHPLANT.COUNTRYOFORIGIN == T005S.LAND1
  • I_BATCHPLANT.REGIONOFORIGIN == T005S.BLAND
  • I_BATCHPLANT.MANDT == T005S.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_BATCHPLANT.SUPPLIER == LFA1.LIFNR
  • I_BATCHPLANT.MANDT == LFA1.MANDT