P_BatchPlant

Batch on Plant Level without split valuation | view: PBATCHPLANT | Extraction: Not supported | Component: Batch master
Tables used: MCHAMARCTCUCH
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
BatchIdentifyingPlant Plant WERKS
Master Data Relations Join Conditions
Batch Number
  • Client
  • Material Number
  • Batch Number
  • P_BATCHPLANT.MANDT == MCH1.MANDT
  • P_BATCHPLANT.MATERIAL == MCH1.MATNR
  • P_BATCHPLANT.BATCH == MCH1.CHARG
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • P_BATCHPLANT.COUNTRYOFORIGIN == T005.LAND1
  • P_BATCHPLANT.MANDT == T005.MANDT
Material Group for Intrastat
  • Material Group for Intrastat
  • Client
  • P_BATCHPLANT.EXPORTANDIMPORTPRODUCTGROUP == TVFM.MTVER
  • P_BATCHPLANT.MANDT == TVFM.MANDT
Valuation type
  • ?
  • Client
  • Material Number
  • Valuation Type
  • P_BATCHPLANT.[column in domain "BWKEY"] == MBEW.BWKEY
  • P_BATCHPLANT.MANDT == MBEW.MANDT
  • P_BATCHPLANT.MATERIAL == MBEW.MATNR
  • P_BATCHPLANT.INVENTORYVALUATIONTYPE == MBEW.BWTAR
Material
  • Client
  • Material Number
  • P_BATCHPLANT.MANDT == MARA.MANDT
  • P_BATCHPLANT.MATERIAL == MARA.MATNR
Material/Plant
  • Plant
  • Client
  • Material Number
  • P_BATCHPLANT.PLANT == MARC.WERKS
  • P_BATCHPLANT.MANDT == MARC.MANDT
  • P_BATCHPLANT.MATERIAL == MARC.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
  • P_BATCHPLANT.COUNTRYOFORIGIN == T005S.LAND1
  • P_BATCHPLANT.REGIONOFORIGIN == T005S.BLAND
  • P_BATCHPLANT.MANDT == T005S.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • P_BATCHPLANT.SUPPLIER == LFA1.LIFNR
  • P_BATCHPLANT.MANDT == LFA1.MANDT