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 |
Possible values
|
||||||||||||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||||||||||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||
MENGE | Quantity | MENGE_D | QUAN | 13 | 3 | |||||||||||||||||||||||||||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||||||||||||||||||||||||||||
AUTYP | Order category | AUFTYP | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||
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 |