SAP ABAP Table CHVW_ALL (All Fields in the Tables CHVW and CHVW_PRE)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-BF (Application Component) Basic Functions
⤷
VB (Package) Application Development R/3 Batches
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | CHVW_ALL |
|
| Short Description | All Fields in the Tables CHVW and CHVW_PRE |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
0 | 0 | Table CHVW for Batch Where-Used List | |||||
| 2 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | |
XZUGA | XFELD | CHAR | 1 | 0 | No receipt | ||
| 4 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 5 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 6 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
| 7 | |
AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
| 8 | |
CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
| 9 | |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
| 10 | |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
| 11 | |
KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | VBUK | |
| 12 | |
KDPOS | NUM06 | NUMC | 6 | 0 | Item number in Sales Order | ||
| 13 | |
MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
| 14 | |
MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
| 15 | |
MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
| 16 | |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
| 17 | |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 18 | |
BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | T156 | |
| 19 | |
XSTBW | XFELD | CHAR | 1 | 0 | Reversal transaction type | ||
| 20 | |
KZBEW | KZBEW | CHAR | 1 | 0 | Movement Indicator | ||
| 21 | |
SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
| 22 | |
MENGE_D | MENG13 | QUAN | 13 | 3 | Quantity | ||
| 23 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 24 | |
DZUSCH | ZUSCH | CHAR | 1 | 0 | Batch status key | ||
| 25 | |
DZUSTD | XFELD | CHAR | 1 | 0 | Batch in Restricted-Use Stock | ||
| 26 | |
VERAB | DATUM | DATS | 8 | 0 | Availability date | ||
| 27 | |
VFDAT | DATUM | DATS | 8 | 0 | Shelf Life Expiration or Best-Before Date | ||
| 28 | |
UMWRK | WERKS | CHAR | 4 | 0 | Receiving plant/issuing plant | T001W | |
| 29 | |
UMMAT | MATNR | CHAR | 18 | 0 | Receiving/issuing material | MARA | |
| 30 | |
UMCHA | CHARG | CHAR | 10 | 0 | Receiving/issuing batch | MCHA | |
| 31 | |
LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
| 32 | |
LICHN | LICHN | CHAR | 15 | 0 | Vendor Batch Number | ||
| 33 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
| 34 | |
PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | * | |
| 35 | |
AUFTYP | AUFTYP | NUMC | 2 | 0 | Order category | ||
| 36 | |
VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
| 37 | |
POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
| 38 | |
0 | 0 | Dummy Structure for Adding a CustomInclude with Dummy | |||||
| 39 | |
DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
| 40 | |
0 | 0 | ||||||
| 41 | |
RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
| 42 | |
RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
| 43 | |
RSART | RSART | CHAR | 1 | 0 | Record type | ||
| 44 | |
LFBNR | BELNR | CHAR | 10 | 0 | Document number of a reference document | ||
| 45 | |
LFPOS | MBLPO | NUMC | 4 | 0 | Item of a reference document |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CHVW_ALL | AUFNR | |
|
KEY | 1 | CN |
| 2 | CHVW_ALL | BWART | |
|
REF | 1 | CN |
| 3 | CHVW_ALL | CHARG | |
|
KEY | 1 | CN |
| 4 | CHVW_ALL | EBELN | |
|
KEY | 1 | CN |
| 5 | CHVW_ALL | EBELP | |
|
KEY | 1 | CN |
| 6 | CHVW_ALL | KDAUF | |
|
KEY | 1 | CN |
| 7 | CHVW_ALL | KUNNR | |
|
REF | 1 | CN |
| 8 | CHVW_ALL | LIFNR | |
|
REF | 1 | CN |
| 9 | CHVW_ALL | MANDT | |
|
KEY | 1 | CN |
| 10 | CHVW_ALL | MATNR | |
|
KEY | 1 | CN |
| 11 | CHVW_ALL | MEINS | |
|
REF | 1 | CN |
| 12 | CHVW_ALL | SOBKZ | |
|
REF | 1 | CN |
| 13 | CHVW_ALL | UMCHA | |
|
REF | 1 | CN |
| 14 | CHVW_ALL | UMMAT | |
|
REF | 1 | CN |
| 15 | CHVW_ALL | UMWRK | |
|
REF | 1 | CN |
| 16 | CHVW_ALL | WERKS | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 500 |