AUKAI is a standard SAP table in SAP ERP (or) S/4HANA which stores Worklist for Sales Orders (FBG) data. There are total 28 fields in AUKAI table.This blog post provides key technical details of SAP table AUKAI, including its availability across SAP S/4HANA versions and the list of CDS views for AUKAI 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 AUKAI Table Fields
The following is the list of fields that are available in SAP AUKAI table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | * | CLNT (3) |
| ABELN | Allocation Table | ABELN | ABELN | * | CHAR (10) |
| ABELP | Allocation Table Item | ABELP | ABELP | * | NUMC (5) |
| ABELG | Store Group of an Allocation Table | ABELG | ABELG | * | NUMC (5) |
| ABELF | Identifier of a Recipient of an Item of an Allocation Table | ABELF | ABELF | * | NUMC (5) |
| LFNUM | Consecutive Number | LFNUM | CHAR5 | CHAR (5) | |
| MATNR | Material Number | MATNR | MATNR | * | CHAR (40) |
| MATKL | Material Group | MATKL | MATKL | * | CHAR (9) |
| MENGE | Quantity | MENGE_D | MENG13 | QUAN (13) | |
| VRKME | Sales unit | VRKME | MEINS | * | UNIT (3) |
| WEDAT | Delivery date | LFDAT | DATUM | DATS (8) | |
| WETYP | Date type (day, week, month, interval) | PRGRS | PRGRS | CHAR (1) | |
| WEZEIT | Delivery Date Time-Spot | LZEIT | UZEIT | TIMS (6) | |
| VZWRK | Distribution Center | VZWRK | WERKS | * | CHAR (4) |
| VZENT | Distribution center (as customer) | VZENT | KUNNR | * | CHAR (10) |
| KUNDE | Customer no. of plant | FILNR | KUNNR | * | CHAR (10) |
| KDWRK | Store | FIWRK | WERKS | * | CHAR (4) |
| SPBEDAT | Order date/ latest date for generating follow-on documents | SPBEDAT | DATUM | DATS (8) | |
| VKORG | Sales Organization | VKORG | VKORG | * | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | VTWEG | * | CHAR (2) |
| SPART | Division | SPART | SPART | * | CHAR (2) |
| SPERR | Blocking flag, plant | SPBTR | SPERR_A | * | CHAR (1) |
| APSTP | Item category of allocation table | APSTP | APSTP | * | CHAR (4) |
| KAART | Sales Document Type | AUART | AUART | * | CHAR (4) |
| AKTNR | Promotion | WAKTION | WAKTION | * | CHAR (10) |
| AUREL | Relevant to Allocation Table | AUREL | AUREL | CHAR (1) | |
| SAPOS | Allocation table item of material on higher level | POSNR_SA | ABELP | * | NUMC (5) |
| RETPO | Returns Item | RETPO | XFELD | CHAR (1) |
Availability
The SAP table AUKAI 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 AUKAI table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
