SAP Table

AUKO Allocation Table Document Header

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

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

/ Fields

AUKO columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyABELN 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
PSTAK Maintenance Status of an Allocation Table CHAR 1 0 PSTAK
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
FBDAT Release date of PO generation DATS 8 0 FBIDT
FBDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
FLDAT Release date for generation of delivery note DATS 8 0 FLIDT
FLDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
FUDAT Release date for generation of stock transfer DATS 8 0 FUIDT
FUDTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
VKSDT Date of start of sales at plant DATS 8 0 VKIDT
VKSTP Date type (day, week, month, interval) CHAR 1 0 PRGRS
RFCDEST Logical destination (specified in function call) CHAR 32 0 * RFCDEST
ERVON Application creating allocation table CHAR 1 0 ERVON
/ Relationships

AUKO foreign keys.

Table Field Check Table Description Check Field
AUKO AUFAR T620 Allocation Table Document Types MANDT
AUKO EKGRP T024 Purchasing Groups EKGRP
AUKO EKORG T024E Purchasing Organizations EKORG
AUKO MANDT T000 Clients MANDT
AUKO SPERR T629 Allocation Table Rejection Reasons MANDT
AUKO SPERR T629 Allocation Table Rejection Reasons SPERR
Back to SAP tables