SAP ABAP Table AUVZ (Distribution Center)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WAUF (Package) Application development R/3 Purchasing, Allocation table

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AUVZ	Table Relationship Diagram
Short Description	Distribution Center

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	ABELN	☑	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
3	ABELP	☑	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
4	VZWRK	☑	VZWRK	WERKS	CHAR	4	0	Distribution center as plant	T001W
5	VZENT	☐	VZENT	KUNNR	CHAR	10	0	Distribution center (as customer)	KNA1
6	VZLFR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
7	PMNGV	☐	PMNGV	MENG13	QUAN	13	3	Planned GR qty Distribution Center
8	IMNGV	☐	IMNGV	MENG13	QUAN	13	3	Confirmed quantity, Distribution Center
9	MENGE_OPT	☐	MENGE_OPT	MENG13	QUAN	13	3	Optimized quantity
10	AUFME	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
11	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
14	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
15	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
16	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
17	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
18	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
19	BSTMG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
20	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
21	UMLMG	☐	BSTMG_RED	MENG13	QUAN	13	3	Reduced DC order quantity (in allocation table)
22	UMLME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
23	LFMNG	☐	EFMNG	MENG13	QUAN	13	3	GR qty assigned after alloc tbl adjustment made
24	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
25	EBLNU	☐	EBLNU	EBELN	CHAR	10	0	Purchase Order Generated for Vendor	*
26	EBLPU	☐	EBLPU	EBELP	NUMC	5	0	Generated purchase order item	*
27	.INCLUDE	☐				0	0	Structure for plant status
28	ABFST	☐	ABFST	ASTAB	CHAR	1	0	Status plant notification
29	ABAST	☐	ABAST	ABAST	CHAR	1	0	Details status, plant notification
30	BSTST	☐	BSTST	ASTAB	CHAR	1	0	Status: Vendor Purchase Order Generation
31	UMLST	☐	UMLST	ASTAB	CHAR	1	0	Status: warehouse order generation
32	LIEST	☐	LIEST	ASTAB	CHAR	1	0	Status: generate deliveries
33	ABVST	☐	ABVST	ASTAB	CHAR	1	0	Notification status (DC)
34	WEEST	☐	WEEST	ASTAB	CHAR	1	0	Entry status of GR in DC
35	KAGST	☐	KAGST	ASTAB	CHAR	1	0	Status of sales order generation
36	SPERR	☐	SPBTR	SPERR_A	CHAR	1	0	Blocking flag, plant	T629
37	BMERF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
38	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
39	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
40	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
41	WAFLU_VZ	☐	WAFLU_VZ	BARTV	CHAR	1	0	Processing Method / Goods Movement in Distribution Center
42	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
43	.INCLU--AP	☐				0	0	Append 600
44	SLS_REL	☐	SLS_REL	SLS_REL	CHAR	1	0	Single-Recipient Vendor Orders from Allocation Table

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AUVZ	ABELN	AUKO	ABELN	KEY	1	CN
2	AUVZ	ABELP	AUPO	ABELP	KEY	1	CN
3	AUVZ	AUFME	T006	MSEHI
4	AUVZ	BSTME	T006	MSEHI	REF	1	CN
5	AUVZ	BUKRS	T001	BUKRS
6	AUVZ	EKGRP	T024	EKGRP	REF	1	CN
7	AUVZ	EKORG	T024E	EKORG	REF	1	CN
8	AUVZ	LAND1	T005	LAND1
9	AUVZ	LGORT	T001L	LGORT
10	AUVZ	LIFNR	LFA1	LIFNR	KEY	1	CN
11	AUVZ	MANDT	T000	MANDT	KEY	1	N
12	AUVZ	SPART	TSPA	SPART	REF	1	CN
13	AUVZ	SPERR	T629	SPERR	REF	1	CN
14	AUVZ	UMLME	T006	MSEHI	REF	1	CN
15	AUVZ	VKORG	TVKO	VKORG	REF	1	CN
16	AUVZ	VRKME	T006	MSEHI	REF	1	CN
17	AUVZ	VTWEG	TVTW	VTWEG	REF	1	CN
18	AUVZ	VZENT	KNA1	KUNNR	REF	1	CN
19	AUVZ	VZLFR	LFA1	LIFNR	REF	1	CN
20	AUVZ	VZWRK	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in