AUFI

Transparent Table Application Table
66 Fields 1 CDS Views

Allocation Table, Document Sub-item, Stores

AUFI is an SAP database table in S/4HANA. Allocation Table, Document Sub-item, Stores. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocationTableItemRecipient view from BASIC Allocation Table Item Recipient

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY abeln ABELN Alloc. Table
KEY abelp ABELP Item
KEY abelg ABELG Store Group
KEY abelf ABELF Store
filnr KUNNR Customer
fiwrk FIWRK Store
ekorg EKORG Purchasing Org.
ekgrp EKGRP Purch. Group
erdat ERDAT Created On
aedat AEDAT Changed On
ernam ERNAM Created By
aenam AENAM Changed By
lfnru LFNRU Supplier
pmngu PMNGU Plan Qty
imngu IMNGU Confirmed Qty
mmngu MMNGU MinimumQuantity
wmnge WMNGE Requested qty
aufme AUFME Unit of Measure
liefw LIEFW Deliv.phase
eblnu EBLNU Supplier Order
eblpu EBLPU Item
ubstn UBSTN Warehouse order
ubstp UBSTP Item
vblnu VBLNU Delivery number
vblpu VBLPU Item
bedat BEDAT PO Date
bedtp PRGRS Date type
vkdat VKIDT Sell from
vktyp PRGRS Date type
lewed LEWED Latest GR Date
vzent VZENT Distr. center
vzwrk VZWRK Distr. Center
vzlfr LIFNR_WK Sppl. No. Plnt
aavit AAVIT Notif. Category
plifz PLIFZ Pl. Deliv. Time
webaz WEBAZ GR proc. time
abfdt AFIDT Conf.req.date
abftp PRGRS Date type
pstab PSTAB Status
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
bstmg BSTMG PO Quantity
bstme BSTME Order Unit
umlmg BSTMG PO Quantity
umlme BSTME Order Unit
lfmng EFMNG GR qty assigned
vrkme VRKME Sales Unit
sperr SPBTR Blocked
vquot VQUOT Quotas
wmerf CHAR1 Single-Character Flag
bmerf CHAR1 Single-Character Flag
bewza UPOBZ Plant Eval.Fi
labst LABST Unrestricted
hmngu HMNGU Max. Quantity
bukrs BUKRS Company Code
land1 LAND1 Country/Reg.
elikz ELIKZ Deliv. Compl.
lgort LGORT_D Location
abfst ABFST Notif.
abast ABAST Notification
blgtp BLGTP Doc. Cat.
expected_sales UPOBZ Plant Eval.Fi
open_orders BSTMG PO Quantity
trend_factor TREND_ALL Trend Factor

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 Sub-item, Stores
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUFI (
    MANDT,           -- Client [MANDT]
    ABELN,           -- Alloc. Table [ABELN]
    ABELP,           -- Item [ABELP]
    ABELG,           -- Store Group [ABELG]
    ABELF,           -- Store [ABELF]
    FILNR,           -- Customer [KUNNR]
    FIWRK,           -- Store [FIWRK]
    EKORG,           -- Purchasing Org. [EKORG]
    EKGRP,           -- Purch. Group [EKGRP]
    ERDAT,           -- Created On [ERDAT]
    AEDAT,           -- Changed On [AEDAT]
    ERNAM,           -- Created By [ERNAM]
    AENAM,           -- Changed By [AENAM]
    LFNRU,           -- Supplier [LFNRU]
    PMNGU,           -- Plan Qty [PMNGU]
    IMNGU,           -- Confirmed Qty [IMNGU]
    MMNGU,           -- MinimumQuantity [MMNGU]
    WMNGE,           -- Requested qty [WMNGE]
    AUFME,           -- Unit of Measure [AUFME]
    LIEFW,           -- Deliv.phase [LIEFW]
    EBLNU,           -- Supplier Order [EBLNU]
    EBLPU,           -- Item [EBLPU]
    UBSTN,           -- Warehouse order [UBSTN]
    UBSTP,           -- Item [UBSTP]
    VBLNU,           -- Delivery number [VBLNU]
    VBLPU,           -- Item [VBLPU]
    BEDAT,           -- PO Date [BEDAT]
    BEDTP,           -- Date type [PRGRS]
    VKDAT,           -- Sell from [VKIDT]
    VKTYP,           -- Date type [PRGRS]
    LEWED,           -- Latest GR Date [LEWED]
    VZENT,           -- Distr. center [VZENT]
    VZWRK,           -- Distr. Center [VZWRK]
    VZLFR,           -- Sppl. No. Plnt [LIFNR_WK]
    AAVIT,           -- Notif. Category [AAVIT]
    PLIFZ,           -- Pl. Deliv. Time [PLIFZ]
    WEBAZ,           -- GR proc. time [WEBAZ]
    ABFDT,           -- Conf.req.date [AFIDT]
    ABFTP,           -- Date type [PRGRS]
    PSTAB,           -- Status [PSTAB]
    VKORG,           -- Sales Org. [VKORG]
    VTWEG,           -- Distr. Channel [VTWEG]
    SPART,           -- Division [SPART]
    BSTMG,           -- PO Quantity [BSTMG]
    BSTME,           -- Order Unit [BSTME]
    UMLMG,           -- PO Quantity [BSTMG]
    UMLME,           -- Order Unit [BSTME]
    LFMNG,           -- GR qty assigned [EFMNG]
    VRKME,           -- Sales Unit [VRKME]
    SPERR,           -- Blocked [SPBTR]
    VQUOT,           -- Quotas [VQUOT]
    WMERF,           -- Single-Character Flag [CHAR1]
    BMERF,           -- Single-Character Flag [CHAR1]
    BEWZA,           -- Plant Eval.Fi [UPOBZ]
    LABST,           -- Unrestricted [LABST]
    HMNGU,           -- Max. Quantity [HMNGU]
    BUKRS,           -- Company Code [BUKRS]
    LAND1,           -- Country/Reg. [LAND1]
    ELIKZ,           -- Deliv. Compl. [ELIKZ]
    LGORT,           -- Location [LGORT_D]
    ABFST,           -- Notif. [ABFST]
    ABAST,           -- Notification [ABAST]
    BLGTP,           -- Doc. Cat. [BLGTP]
    EXPECTED_SALES,  -- Plant Eval.Fi [UPOBZ]
    OPEN_ORDERS,     -- PO Quantity [BSTMG]
    TREND_FACTOR,    -- Trend Factor [TREND_ALL]
    PRIMARY KEY (MANDT, ABELN, ABELP, ABELG, ABELF)
);

Learn More