SAP ABAP Table CHVW (Table CHVW for Batch Where-Used List)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MB (Package) Application development R/3 inventory management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CHVW	Table Relationship Diagram
Short Description	Table CHVW for Batch Where-Used List

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	XZUGA	☑	XZUGA	XFELD	CHAR	1	0	No receipt
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
6	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
7	AUFPS	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
8	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
9	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
10	KDAUF	☑	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
11	KDPOS	☑	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
12	MBLNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
13	MJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
14	ZEILE	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
15	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
17	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
18	XSTBW	☐	XSTBW	XFELD	CHAR	1	0	Reversal transaction type
19	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
20	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
21	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
22	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
23	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
24	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
25	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
26	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
27	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
28	UMMAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	MARA
29	UMCHA	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch	MCHA
30	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
31	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
32	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
33	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
34	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
35	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
36	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
37	.INCLUDE	☐				0	0	Dummy Structure for Adding a CustomInclude with Dummy
38	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
39	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CHVW	AUFNR	AUFK	AUFNR	KEY	1	CN
2	CHVW	BWART	T156	BWART	REF	1	CN
3	CHVW	CHARG	MCHA	CHARG	KEY	C	CN
4	CHVW	EBELN	EKKO	EBELN	KEY	1	CN
5	CHVW	EBELP	EKPO	EBELP	KEY	1	CN
6	CHVW	KDAUF	VBUK	VBELN	KEY	1	CN
7	CHVW	KUNNR	KNA1	KUNNR	REF	1	CN
8	CHVW	LIFNR	LFA1	LIFNR	REF	1	CN
9	CHVW	MANDT	T000	MANDT	KEY	1	CN
10	CHVW	MATNR	MARA	MATNR	KEY	1	CN
11	CHVW	MEINS	T006	MSEHI	REF	1	CN
12	CHVW	SOBKZ	T148	SOBKZ	REF	1	CN
13	CHVW	UMCHA	MCHA	CHARG	KEY	C	CN
14	CHVW	UMMAT	MARA	MATNR	REF	1	CN
15	CHVW	UMWRK	T001W	WERKS	REF	1	CN
16	CHVW	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in