SAP Table CHVW_PRE

Preliminary Batch Where-used List According to Order/PO

CHVW_PRE (Preliminary Batch Where-used List According to Order/PO) 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_PRE to other SAP tables.

CHVW_PRE 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
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
VBELN Delivery VBELN_VL CHAR 10 0
POSNR Delivery Item POSNR_VL NUMC 6 0
GENKEY Generic Enhancement Key (Type + Generic Part) DOCUBATCH_GENKEY CHAR 21 0
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
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 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
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0

CHVW_PRE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CHVW_PRE AUFNR CHVW_PRE MANDT AUFK Order master data MANDT
CHVW_PRE AUFNR CHVW_PRE AUFNR AUFK Order master data AUFNR
CHVW_PRE CHARG CHVW_PRE MANDT MCHA Batches MANDT
CHVW_PRE CHARG CHVW_PRE MATNR MCHA Batches MATNR
CHVW_PRE CHARG CHVW_PRE WERKS MCHA Batches WERKS
CHVW_PRE CHARG CHVW_PRE CHARG MCHA Batches CHARG
CHVW_PRE EBELN CHVW_PRE EBELN EKKO Purchasing Document Header EBELN
CHVW_PRE EBELN CHVW_PRE MANDT EKKO Purchasing Document Header MANDT
CHVW_PRE EBELP CHVW_PRE MANDT EKPO Purchasing Document Item MANDT
CHVW_PRE EBELP CHVW_PRE EBELN EKPO Purchasing Document Item EBELN
CHVW_PRE EBELP CHVW_PRE EBELP EKPO Purchasing Document Item EBELP
CHVW_PRE MANDT CHVW_PRE MANDT T000 Clients MANDT
CHVW_PRE MATNR CHVW_PRE MATNR MARA General Material Data MATNR
CHVW_PRE MATNR CHVW_PRE MANDT MARA General Material Data MANDT
CHVW_PRE WERKS CHVW_PRE MANDT T001W Plants/Branches MANDT
CHVW_PRE WERKS CHVW_PRE WERKS T001W Plants/Branches WERKS