ESH_S_BATCH_PLANT

Search view -BATCH_PLANT | view: ESH_U_BATCH_PLNT | Extraction: Not supported | Component: Enterprise Search for Master Batch Records
Tables used: MARAMCHAT005T005TT001WMARAMAKT
Column Name Description
BATCH FK Batch Number
MATERIAL FK Material Number
PLANT FK Plant
Column Name Description
Column Name Description
Column Name Description
MANUFACTUREDATE Date of Manufacture
SHELFLIFEEXPIRATIONDATE Shelf Life Expiration or Best-Before Date
Column Name Description
MATLBATCHISINRSTRCDUSESTOCK Batch in Restricted-Use Stock Show values
Column Name Description Domain name
AUTHORIZATIONGROUP Authorization Group BEGRU
BATCHBYSUPPLIER Supplier Batch Number LICHN
BATCHRESTRICTIONSTATUSTEXT Short Text for Fixed Values
COUNTRYNAME Country/Region Name
PLANTNAME Plant Name TEXT30
PRODUCTNAME Product Description
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Client
  • Batch Number
  • ESH_S_BATCH_PLANT.MATERIAL == MCH1.MATNR
  • ESH_S_BATCH_PLANT.MANDT == MCH1.MANDT
  • ESH_S_BATCH_PLANT.BATCH == MCH1.CHARG
Material
  • Material Number
  • Client
  • ESH_S_BATCH_PLANT.MATERIAL == MARA.MATNR
  • ESH_S_BATCH_PLANT.MANDT == MARA.MANDT
Material/Plant
  • Material Number
  • Client
  • Plant
  • ESH_S_BATCH_PLANT.MATERIAL == MARC.MATNR
  • ESH_S_BATCH_PLANT.MANDT == MARC.MANDT
  • ESH_S_BATCH_PLANT.PLANT == MARC.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • ESH_S_BATCH_PLANT.SUPPLIER == LFA1.LIFNR
  • ESH_S_BATCH_PLANT.MANDT == LFA1.MANDT