SAP ABAP Table ACHVW (Archiving Structure 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	INTTAB	Structure
Structure	ACHVW	Table Relationship Diagram
Short Description	Archiving Structure for Batch Where-Used List

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	.INCLUDE	☐				0	0	Table CHVW for Batch Where-Used List
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	XZUGA	☐	XZUGA	XFELD	CHAR	1	0	No receipt
4	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
7	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
8	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
9	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
10	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
11	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
12	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
13	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
14	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
15	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
16	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
17	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
18	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
19	XSTBW	☐	XSTBW	XFELD	CHAR	1	0	Reversal transaction type
20	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
21	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
22	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
23	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
24	ZUSCH	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
25	ZUSTD	☐	DZUSTD	XFELD	CHAR	1	0	Batch in Restricted-Use Stock
26	VERAB	☐	VERAB	DATUM	DATS	8	0	Availability date
27	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
28	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
29	UMMAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	MARA
30	UMCHA	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch	MCHA
31	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
32	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number	*
33	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
34	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
35	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
36	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
37	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
38	.INCLUDE	☐				0	0	Dummy Structure for Adding a CustomInclude with Dummy
39	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
40	.INCLUDE	☐				0	0
41	KZ	☐	CKZ	KZNEB	CHAR	1	0	Top-down or bottom-up for batch where-used file reorg.
42	ZAEHL	☐	CZAEHL	CSTUFE	CHAR	10	0	Number of records for batch where-used file reorganization
43	ZUABKZ	☐	CZUABKZ	XFELD	CHAR	1	0	Batch where-used file reorganization: receipt or issue
44	XSORTFELD	☐	XSORTFELD	TEXT25	CHAR	25	0	X sort field for batch where-used file reorganization
45	LEVEL	☐	CLEVEL	BELPOS	NUMC	14	0	Level for batch where-used file reorganization
46	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
47	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in