CHVW

Table CHVW for Batch Where-Used List | #transactional | Component: Inventory Management
Column Name Description
MANDT FK Client
XZUGA No receipt Show values
WERKS FK Plant
MATNR FK Material Number
CHARG FK Batch Number
AUFNR FK Order Number
AUFPS Order item number
EBELN FK Purchasing Document Number
EBELP FK Item Number of Purchasing Document
KDAUF Sales Order Number
KDPOS Item number in Sales Order
MBLNR Number of Material Document
MJAHR Material Document Year
ZEILE Item in Material Document
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
📏 Parallel Unit of Measure (/CWM/MEINS):
/CWM/MENGE Quantity in Parallel Unit of Measure
Column Name Description
BUDAT Posting Date in the Document
VERAB Availability date
VFDAT Shelf Life Expiration or Best-Before Date
Column Name Description
XZUGA No receipt Show values
SHKZG Debit/Credit Indicator Show values
XSTBW Reversal movement type Show values
KZBEW Movement Indicator Show values
ZUSTD Batch in Restricted-Use Stock Show values
AUTYP Order category Show values
Column Name Description Domain name
ZUSCH Batch status key ZUSCH
LICHA Supplier Batch Number LICHN
PSTYP Item category in purchasing document PSTYP
VBELN Delivery VBELN
POSNR Delivery Item POSNR
DUMMY Dummy function in length 1 DUMMY
MILL_OC_AUFNR_O Number of Combined Order AUFNR
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • CHVW.AUFNR == AUFK.AUFNR
  • CHVW.MANDT == AUFK.MANDT
Movement type (inventory management)
  • CHVW.MANDT == T156.MANDT
  • CHVW.BWART == T156.BWART
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • CHVW.MANDT == MCHA.MANDT
  • CHVW.MATNR == MCHA.MATNR
  • CHVW.CHARG == MCHA.CHARG
  • CHVW.WERKS == MCHA.WERKS
Customer Number
  • CHVW.MANDT == KNA1.MANDT
  • CHVW.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • CHVW.MANDT == LFA1.MANDT
  • CHVW.LIFNR == LFA1.LIFNR
Client CHVW.MANDT == T000.MANDT
MatNo.
  • Material Number
  • Client
  • CHVW.MATNR == MARA.MATNR
  • CHVW.MANDT == MARA.MANDT
Base Unit of Measure
  • CHVW.MANDT == T006.MANDT
  • CHVW.MEINS == T006.MSEHI
Special Stock Indicator
  • CHVW.MANDT == T148.MANDT
  • CHVW.SOBKZ == T148.SOBKZ
Receiving/Issuing Batch
  • Receiving/Issuing Material
  • Receiving/Issuing Batch
  • Receiving plant/issuing plant
  • CHVW.MANDT == MCHA.MANDT
  • CHVW.UMMAT == MCHA.MATNR
  • CHVW.UMCHA == MCHA.CHARG
  • CHVW.UMWRK == MCHA.WERKS
Receiving/Issuing Material
  • Receiving/Issuing Material
  • Client
  • CHVW.UMMAT == MARA.MATNR
  • CHVW.MANDT == MARA.MANDT
Receiving plant/issuing plant
  • CHVW.MANDT == T001W.MANDT
  • CHVW.UMWRK == T001W.WERKS
Plant
  • CHVW.MANDT == T001W.MANDT
  • CHVW.WERKS == T001W.WERKS