AUKO
Allocation Table Document Header
AUKO is an SAP database table in S/4HANA. Allocation Table Document Header. It contains 27 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AllocationTable | view | from | BASIC | Allocation Table |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | abeln | abeln | Alloc. Table | |||
| aufar | aufar | Alloc. tbl type | ||||
| bezch | bezei40 | Description | ||||
| ekorg | ekorg | Purchasing Org. | ||||
| ekgrp | ekgrp | Purch. Group | ||||
| astak | astak | Activity status | ||||
| pstak | pstak | Maint. Status | ||||
| sperr | spkpf | Blocked | ||||
| erdat | erdat | Created On | ||||
| aedat | aedat | Changed On | ||||
| ernam | ernam | Created By | ||||
| aenam | aenam | Changed By | ||||
| lepos | lepos | Last item | ||||
| pincr | pincr | Item Interval | ||||
| afdat | afidt | Conf.req.date | ||||
| afdtp | prgrs | Date type | ||||
| fbdat | fbidt | Purchase order | ||||
| fbdtp | prgrs | Date type | ||||
| fldat | flidt | Delivery | ||||
| fldtp | prgrs | Date type | ||||
| fudat | fuidt | Stock transfer | ||||
| fudtp | prgrs | Date type | ||||
| vksdt | vkidt | Sell from | ||||
| vkstp | prgrs | Date type | ||||
| rfcdest | rfcdest | Destination | ||||
| ervon | ervon | Application |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Allocation Table Document Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUKO (
MANDT, -- Client [mandt]
ABELN, -- Alloc. Table [abeln]
AUFAR, -- Alloc. tbl type [aufar]
BEZCH, -- Description [bezei40]
EKORG, -- Purchasing Org. [ekorg]
EKGRP, -- Purch. Group [ekgrp]
ASTAK, -- Activity status [astak]
PSTAK, -- Maint. Status [pstak]
SPERR, -- Blocked [spkpf]
ERDAT, -- Created On [erdat]
AEDAT, -- Changed On [aedat]
ERNAM, -- Created By [ernam]
AENAM, -- Changed By [aenam]
LEPOS, -- Last item [lepos]
PINCR, -- Item Interval [pincr]
AFDAT, -- Conf.req.date [afidt]
AFDTP, -- Date type [prgrs]
FBDAT, -- Purchase order [fbidt]
FBDTP, -- Date type [prgrs]
FLDAT, -- Delivery [flidt]
FLDTP, -- Date type [prgrs]
FUDAT, -- Stock transfer [fuidt]
FUDTP, -- Date type [prgrs]
VKSDT, -- Sell from [vkidt]
VKSTP, -- Date type [prgrs]
RFCDEST, -- Destination [rfcdest]
ERVON, -- Application [ervon]
PRIMARY KEY (MANDT, ABELN)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA