SAP table AUKO (Allocation Table Document Header)

SAP table AUKO has 2 primary key fields being MANDT,ABELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
ABELN Allocation Table CHAR 10 0 ABELN
AUFAR Allocation Table Type CHAR 4 0 T620 AUFAR
BEZCH Description CHAR 40 0 BEZEI40
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
ASTAK Activity status allocation tbl (header) CHAR 1 0 ASTAK
1 Not active
2 Partially active
3 Active
4 Done
PSTAK Maintenance Status of an Allocation Table CHAR 1 0 PSTAK
1 New
2 Released
3 In Process
4 Incomplete
SPERR Blocking flag: allocation table CHAR 1 0 T629 SPKPF
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
LEPOS Last item number NUMC 5 0 * LEPOS
PINCR Item Number Interval NUMC 5 0 PINCR
AFDAT Confirmation request date DATS 8 0 AFIDT
AFDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
FBDAT Release date of PO generation DATS 8 0 FBIDT
FBDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
FLDAT Release date for generation of delivery note DATS 8 0 FLIDT
FLDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
FUDAT Release date for generation of stock transfer DATS 8 0 FUIDT
FUDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
VKSDT Date of start of sales at plant DATS 8 0 VKIDT
VKSTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
1 Day
2 Week
3 Month
4 Posting period
5 Planning calendar period
RFCDEST Logical destination (specified in function call) CHAR 32 0 * RFCDEST
ERVON Application creating allocation table CHAR 1 0 ERVON
Allocation table was created online
A Allocation table was generated in a promotion
B Allocation table was generated in perishables planning
C Allocation table was generated in MAP
D Alloc. Table was Generated From Prepack Planning Tool
E Alloc.Tble Generated from Oper.Assortmt Planning and Control
F Allocation Table Generated from Demand Management System
G Allocation Table was Generated from CAR
Z Allocation table was generated from individual program

AUKO foreign key relationships

Table Field Check Table Check Field
0 AUKO AUFAR T620 Allocation Table Document Types MANDT
1 AUKO EKGRP T024 Purchasing Groups EKGRP
0 AUKO EKORG T024E Purchasing Organizations EKORG
1 AUKO MANDT T000 Clients MANDT
0 AUKO SPERR T629 Allocation Table Rejection Reasons MANDT
0 AUKO SPERR T629 Allocation Table Rejection Reasons SPERR