SAP ABAP Table AUKEY (Key fields, allocation table document access)

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	INTTAB	Structure
Structure	AUKEY	Table Relationship Diagram
Short Description	Key fields, allocation table document access

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
3	ABELN_BIS	☐	ABELN_BIS	ABELN	CHAR	10	0	Document no. of alloc. tbl	AUKO
4	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
5	EKORG_BIS	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
6	EKOTX	☐	EKOTX	TEXT20	CHAR	20	0	Description of purchasing organization
7	EKOTX_BIS	☐	EKOTX	TEXT20	CHAR	20	0	Description of purchasing organization
8	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
9	EKGRP_BIS	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
10	EKNAM	☐	EKNAM	TEXT18	CHAR	18	0	Description of purchasing group
11	EKNAM_BIS	☐	EKNAM	TEXT18	CHAR	18	0	Description of purchasing group
12	ERDAT	☐	ERDAT_V	DATUM	DATS	8	0	Creation date from which selection is to be made
13	ERDAT_BIS	☐	ERDAT_B	DATUM	DATS	8	0	Creation date up to which selection is to be made
14	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
15	LIFNR_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
16	LIFNR_BIS	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
17	LIFNR_BIS_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
18	EBELN_BIS	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
19	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
20	FGEND_BIS	☐	FGENB	DATUM	DATS	8	0	Latest generation date of follow-on documents
21	FGEND	☐	FGENB	DATUM	DATS	8	0	Latest generation date of follow-on documents
22	BEDAT_BIS	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
23	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
24	FLDAT_BIS	☐	FLDAT	CHAR10	CHAR	10	0	Release date for generation of deliveries
25	FLDAT	☐	FLDAT	CHAR10	CHAR	10	0	Release date for generation of deliveries
26	FUDAT_BIS	☐	FUDAT	CHAR10	CHAR	10	0	Date for generation of stock transprt orders
27	FUDAT	☐	FUDAT	CHAR10	CHAR	10	0	Date for generation of stock transprt orders
28	AFDAT_BIS	☐	AFDAT	CHAR10	CHAR	10	0	Confirmation Request Date
29	AFDAT	☐	AFDAT	CHAR10	CHAR	10	0	Confirmation Request Date
30	NBSTN_NUR	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
31	UBSTN_NUR	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
32	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
33	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
34	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
35	VSTEL_VON	☐	VSTLV	VSTEL	CHAR	4	0	Shipping point From	TVST
36	VTEXT_VON	☐	BEZEI30	TEXT30	CHAR	30	0	Description
37	VSTEL_BIS	☐	VSTLB	VSTEL	CHAR	4	0	Shipping point To	TVST
38	VTEXT_BIS	☐	BEZEI30	TEXT30	CHAR	30	0	Description
39	LEDAT_VON	☐	LEDAT	DATUM	DATS	8	0	Delivery Creation Date
40	LEDAT_BIS	☐	LEDAT_BIS	DATUM	DATS	8	0	Delivery creation date until...
41	LPRIO_VON	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
42	LPRIO_BIS	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
43	ROUTE_VON	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
44	ROUTE_VON_BEZEI	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
45	ROUTE_BIS	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
46	ROUTE_BIS_BEZEI	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
47	SPDNR_VON	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
48	SPDNR_BIS	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
49	WADAT_VON	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
50	WADAT_BIS	☐	WADAT_BIS	DATUM	DATS	8	0	Goods issue date
51	FILNR	☐	FILNR	KUNNR	CHAR	10	0	Customer no. of plant	KNA1
52	FILNR_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
53	FILNR_BIS	☐	FILNR	KUNNR	CHAR	10	0	Customer no. of plant	KNA1
54	FILNR_BIS_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
55	VZENT	☐	VZENT	KUNNR	CHAR	10	0	Distribution center (as customer)	KNA1
56	VZENT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
57	VZENT_BIS	☐	VZENT	KUNNR	CHAR	10	0	Distribution center (as customer)	KNA1
58	VZENT_BIS_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
59	FILWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
60	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
61	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
62	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
63	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
64	MG_CLASS	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
65	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
66	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
67	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
68	NUR_STRECKE	☐	NUR_STRECKE	CHAR1_X	CHAR	1	0	Only generate third party orders (direct delivery)
69	NUR_VZ_LIEF_BEST	☐	NUR_VZ_LIEF_BEST	CHAR1_X	CHAR	1	0	Only generate vendor purchase orders for DCs

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AUKEY	ABELN	AUKO	ABELN	REF	1	CN
2	AUKEY	ABELN_BIS	AUKO	ABELN
3	AUKEY	AKTNR	WAKH	AKTNR
4	AUKEY	EBELN	EKKO	EBELN
5	AUKEY	EBELN_BIS	EKKO	EBELN
6	AUKEY	EKGRP	T024	EKGRP	REF	1	CN
7	AUKEY	EKGRP_BIS	T024	EKGRP	REF	1	CN
8	AUKEY	EKORG	T024E	EKORG	REF	1	CN
9	AUKEY	EKORG_BIS	T024E	EKORG	REF	1	CN
10	AUKEY	FILNR	KNA1	KUNNR
11	AUKEY	FILNR_BIS	KNA1	KUNNR
12	AUKEY	FILWE	KNA1	KUNNR
13	AUKEY	KUNNR	KNA1	KUNNR
14	AUKEY	LFART	TVLK	LFART
15	AUKEY	LIFNR	LFA1	LIFNR
16	AUKEY	LIFNR_BIS	LFA1	LIFNR	REF	1	CN
17	AUKEY	LPRIO_BIS	TPRIO	LPRIO
18	AUKEY	LPRIO_VON	TPRIO	LPRIO
19	AUKEY	MANDT	T000	MANDT	REF	1	CN
20	AUKEY	ROUTE_BIS	TVRO	ROUTE
21	AUKEY	ROUTE_VON	TVRO	ROUTE
22	AUKEY	SPART	TSPA	SPART
23	AUKEY	SPDNR_BIS	LFA1	LIFNR
24	AUKEY	SPDNR_VON	LFA1	LIFNR
25	AUKEY	VKORG	TVKO	VKORG
26	AUKEY	VSTEL_BIS	TVST	VSTEL
27	AUKEY	VSTEL_VON	TVST	VSTEL
28	AUKEY	VTWEG	TVTW	VTWEG
29	AUKEY	VZENT	KNA1	KUNNR
30	AUKEY	VZENT_BIS	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in