1. Home
  2. Resources
  3. SAP Tables
  4. CHVW_ALL - All Fields in the Tables CHVW and CHVW_PRE

SAP Table CHVW_ALL

All Fields in the Tables CHVW and CHVW_PRE

CHVW_ALL (All Fields in the Tables CHVW and CHVW_PRE) 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_ALL to other SAP tables.

CHVW_ALL 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
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RSART Record type RSART CHAR 1 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0

CHVW_ALL foreign key relationships

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