1. Home
  2. Resources
  3. SAP Tables
  4. CHVW - Table CHVW for Batch Where-Used List

SAP Table CHVW

Table CHVW for Batch Where-Used List

CHVW (Table CHVW for Batch Where-Used List) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CHVW to other SAP tables.

CHVW table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
XZUGA No receipt XZUGA CHAR 1 0
X Yes
NULL No
WERKS Plant WERKS_D T001W CHAR 4 0
MATNR Material Number MATNR MARA CHAR 18 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
AUFPS Order Item Number CO_POSNR NUMC 4 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
ZEILE Item in Material Document MBLPO NUMC 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
XSTBW Reversal movement type XSTBW CHAR 1 0
X Yes
NULL No
KZBEW Movement Indicator KZBEW CHAR 1 0
NULL Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
L Goods movement for delivery note
K Goods movement for kanban requirement (WM - internal only)
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ZUSCH Batch status key DZUSCH CHAR 1 0
ZUSTD Batch in Restricted-Use Stock DZUSTD CHAR 1 0
X Yes
NULL No
VERAB Availability date VERAB DATS 8 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
UMWRK Receiving/Issuing Plant UMWRK T001W CHAR 4 0
UMMAT Receiving/Issuing Material UMMAT MARA CHAR 18 0
UMCHA Receiving/Issuing Batch UMCHA MCHA CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
LICHA Vendor Batch Number LICHN CHAR 15 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
VBELN Delivery VBELN_VL CHAR 10 0
POSNR Delivery Item POSNR_VL NUMC 6 0
DUMMY Dummy function in length 1 DUMMY CHAR 1 0

CHVW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CHVW AUFNR CHVW MANDT AUFK Order master data MANDT
CHVW AUFNR CHVW AUFNR AUFK Order master data AUFNR
CHVW BWART CHVW MANDT T156 Movement Type MANDT
CHVW BWART CHVW BWART T156 Movement Type BWART
CHVW CHARG CHVW CHARG MCHA Batches CHARG
CHVW CHARG CHVW MANDT MCHA Batches MANDT
CHVW CHARG CHVW MATNR MCHA Batches MATNR
CHVW CHARG CHVW WERKS MCHA Batches WERKS
CHVW EBELN CHVW MANDT EKKO Purchasing Document Header MANDT
CHVW EBELN CHVW EBELN EKKO Purchasing Document Header EBELN
CHVW EBELP CHVW MANDT EKPO Purchasing Document Item MANDT
CHVW EBELP CHVW EBELN EKPO Purchasing Document Item EBELN
CHVW EBELP CHVW EBELP EKPO Purchasing Document Item EBELP
CHVW KDAUF CHVW MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
CHVW KDAUF CHVW KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
CHVW KUNNR CHVW MANDT KNA1 General Data in Customer Master MANDT
CHVW KUNNR CHVW KUNNR KNA1 General Data in Customer Master KUNNR
CHVW LIFNR CHVW MANDT LFA1 Vendor Master (General Section) MANDT
CHVW LIFNR CHVW LIFNR LFA1 Vendor Master (General Section) LIFNR
CHVW MANDT CHVW MANDT T000 Clients MANDT
CHVW MATNR CHVW MATNR MARA General Material Data MATNR
CHVW MATNR CHVW MANDT MARA General Material Data MANDT
CHVW MEINS CHVW MANDT T006 Units of Measurement MANDT
CHVW MEINS CHVW MEINS T006 Units of Measurement MSEHI
CHVW SOBKZ CHVW MANDT T148 Special Stock Indicator MANDT
CHVW SOBKZ CHVW SOBKZ T148 Special Stock Indicator SOBKZ
CHVW UMCHA CHVW MANDT MCHA Batches MANDT
CHVW UMCHA CHVW UMMAT MCHA Batches MATNR
CHVW UMCHA CHVW UMWRK MCHA Batches WERKS
CHVW UMCHA CHVW UMCHA MCHA Batches CHARG
CHVW UMMAT CHVW MANDT MARA General Material Data MANDT
CHVW UMMAT CHVW UMMAT MARA General Material Data MATNR
CHVW UMWRK CHVW MANDT T001W Plants/Branches MANDT
CHVW UMWRK CHVW UMWRK T001W Plants/Branches WERKS
CHVW WERKS CHVW MANDT T001W Plants/Branches MANDT
CHVW WERKS CHVW WERKS T001W Plants/Branches WERKS