I_BatchHistory

History of Batch Usage | view: IBATCHISTORY | TRAN | Extraction: Not supported | Component: Batch master
Tables used: CHVW
Column Name Description
IsGoodsIssueDocument Is Goods Receipt Show values
Plant FK Plant
Material FK Material Number
Batch FK Batch Number
ManufacturingOrder FK Manufacturing Order ID
ManufacturingOrderItem Manufacturing Order Item ID
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem FK Purchase Document Item
SalesOrder Sales Order Number
SalesOrderItem Sales Order Item
MaterialDocumentYear Material Document Year
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
QuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
IsGoodsIssueDocument Is Goods Receipt Show values
IsReversalMovementType Reversal movement type Show values
GoodsMovementRefDocType Movement Indicator Show values
Column Name Description Domain name
BatchBySupplier Supplier Batch Number LICHN
DeliveryDocument Delivery VBELN
DeliveryDocumentItem Delivery Item POSNR
Master Data Relations Join Conditions
Batch Number
  • Client
  • Plant
  • Batch Number
  • Material Number
  • I_BATCHHISTORY.MANDT == MCHA.MANDT
  • I_BATCHHISTORY.PLANT == MCHA.WERKS
  • I_BATCHHISTORY.BATCH == MCHA.CHARG
  • I_BATCHHISTORY.MATERIAL == MCHA.MATNR
Customer Number
  • Client
  • Customer Number
  • I_BATCHHISTORY.MANDT == KNA1.MANDT
  • I_BATCHHISTORY.CUSTOMER == KNA1.KUNNR
Receiving/Issuing Material
  • Client
  • Receiving/Issuing Material
  • I_BATCHHISTORY.MANDT == MARA.MANDT
  • I_BATCHHISTORY.ISSGORRCVGMATERIAL == MARA.MATNR
Manufacturing Order ID
  • Client
  • Manufacturing Order ID
  • I_BATCHHISTORY.MANDT == AUFK.MANDT
  • I_BATCHHISTORY.MANUFACTURINGORDER == AUFK.AUFNR
MatNo.
  • Client
  • Material Number
  • I_BATCHHISTORY.MANDT == MARA.MANDT
  • I_BATCHHISTORY.MATERIAL == MARA.MATNR
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_BATCHHISTORY.MANDT == T006.MANDT
  • I_BATCHHISTORY.MATERIALBASEUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_BATCHHISTORY.MANDT == T001W.MANDT
  • I_BATCHHISTORY.PLANT == T001W.WERKS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_BATCHHISTORY.MANDT == LFA1.MANDT
  • I_BATCHHISTORY.SUPPLIER == LFA1.LIFNR