Sunday, May 19, 2024

SAP Table AUKO – Allocation Table Document Header

AUKO is a standard SAP table in SAP ERP (or) S/4HANA which stores Allocation Table Document Header data. There are total 27 fields in AUKO table.This blog post provides key technical details of SAP table AUKO, including its availability across SAP S/4HANA versions and the list of CDS views for AUKO table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Application development R/3 Purchasing, Allocation table (WAUF)
Technical Component Allocation (LO-RFM-PUR-AL)

SAP AUKO Table Fields

The following is the list of fields that are available in SAP AUKO table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT T000 CLNT (3)
ABELN Allocation Table ABELN ABELN CHAR (10)
AUFAR Allocation Table Type AUFAR AUFAR T620 CHAR (4)
BEZCH Description BEZEI40 TEXT40 CHAR (40)
EKORG Purchasing organization EKORG EKORG T024E CHAR (4)
EKGRP Purchasing Group EKGRP EKGRP T024 CHAR (3)
ASTAK Activity status allocation tbl (header) ASTAK ASTAK CHAR (1)
PSTAK Maintenance Status of an Allocation Table PSTAK PSTAK CHAR (1)
SPERR Blocking flag: allocation table SPKPF SPERR_A T629 CHAR (1)
ERDAT Date on which the record was created ERDAT DATUM DATS (8)
AEDAT Date of Last Change AEDAT DATUM DATS (8)
ERNAM Name of Person who Created the Object ERNAM USNAM CHAR (12)
AENAM Name of person who changed object AENAM USNAM CHAR (12)
LEPOS Last item number LEPOS ABELP * NUMC (5)
PINCR Item Number Interval PINCR PINCR NUMC (5)
AFDAT Confirmation request date AFIDT DATUM DATS (8)
AFDTP Date type (day, week, month, interval) PRGRS PRGRS CHAR (1)
FBDAT Release date of PO generation FBIDT DATUM DATS (8)
FBDTP Date type (day, week, month, interval) PRGRS PRGRS CHAR (1)
FLDAT Release date for generation of delivery note FLIDT DATUM DATS (8)
FLDTP Date type (day, week, month, interval) PRGRS PRGRS CHAR (1)
FUDAT Release date for generation of stock transfer FUIDT DATUM DATS (8)
FUDTP Date type (day, week, month, interval) PRGRS PRGRS CHAR (1)
VKSDT Date of start of sales at plant VKIDT DATUM DATS (8)
VKSTP Date type (day, week, month, interval) PRGRS PRGRS CHAR (1)
RFCDEST Logical destination (specified in function call) RFCDEST RFCDEST * CHAR (32)
ERVON Application creating allocation table ERVON ERVON CHAR (1)

Availability

The SAP table AUKO is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for AUKO table

The following is the list of AUKO CDS views, which can also be used instead of AUKO table based on your business requirements.

CDS View CDS View Type Description
I_ALLOCATIONTABLE BASIC Allocation Table
I_ALLOCATIONTABLESTDVH COMPOSITE Value Help for Allocation Table
C_ALLOCATIONTABLEITEMOBJPG CONSUMPTION Allocation Table Item Object Page
C_ALLOCATIONTABLEOBJPG CONSUMPTION Allocation Table Object Page
C_ALLOCTBLOBJPGRECEIVINGSTORE CONSUMPTION Allocation Table Object Page – Receiving Stores
C_PRODUCTOBJPGALLOCATIONTABLE CONSUMPTION Product Object Page – Allocation Table
C_RTLPROMNITMOBJPGALLOCTBLITM CONSUMPTION Retail Promotion Item Object Page – Allocation Table Item
C_RTLPROMNOBJPGALLOCATIONTABLE CONSUMPTION Retail Promotion Object Page – Allocation Tables
C_SITEOBJPGALLOCATIONTABLE CONSUMPTION Site Object Page – Allocation Table