AUVZ

Transparent Table Application Table
33 Fields 1 CDS Views

Distribution Center

AUVZ is an SAP database table in S/4HANA. Distribution Center. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AllocTableItemSuplgDistrCtr view from BASIC Alloc. Table Item Supplying Distr. Ctr.

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY abeln abeln Alloc. Table
KEY abelp abelp Item
KEY vzwrk vzwrk Distr. Center
vzent vzent Distr. center
vzlfr lifnr_wk Sppl. No. Plnt
pmngv pmngv Plan Quantity
imngv imngv Confirmed Qty
menge_opt menge_opt Optimized qty
aufme aufme Unit of Measure
lifnr elifn Supplier
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
spart spart Division
plifz plifz Pl. Deliv. Time
webaz webaz GR proc. time
ekorg ekorg Purchasing Org.
ekgrp ekgrp Purch. Group
bstmg bstmg PO Quantity
bstme bstme Order Unit
umlmg bstmg_red Red. order qty
umlme bstme Order Unit
lfmng efmng GR qty assigned
vrkme vrkme Sales Unit
eblnu eblnu Supplier Order
eblpu eblpu Item
sperr spbtr Blocked
bmerf char1 Single-Character Flag
elikz elikz Deliv. Compl.
bukrs bukrs Company Code
land1 land1 Country/Reg.
waflu_vz waflu_vz Method
lgort lgort_d Location

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.

-- Distribution Center
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUVZ (
    MANDT,      -- Client [mandt]
    ABELN,      -- Alloc. Table [abeln]
    ABELP,      -- Item [abelp]
    VZWRK,      -- Distr. Center [vzwrk]
    VZENT,      -- Distr. center [vzent]
    VZLFR,      -- Sppl. No. Plnt [lifnr_wk]
    PMNGV,      -- Plan Quantity [pmngv]
    IMNGV,      -- Confirmed Qty [imngv]
    MENGE_OPT,  -- Optimized qty [menge_opt]
    AUFME,      -- Unit of Measure [aufme]
    LIFNR,      -- Supplier [elifn]
    VKORG,      -- Sales Org. [vkorg]
    VTWEG,      -- Distr. Channel [vtweg]
    SPART,      -- Division [spart]
    PLIFZ,      -- Pl. Deliv. Time [plifz]
    WEBAZ,      -- GR proc. time [webaz]
    EKORG,      -- Purchasing Org. [ekorg]
    EKGRP,      -- Purch. Group [ekgrp]
    BSTMG,      -- PO Quantity [bstmg]
    BSTME,      -- Order Unit [bstme]
    UMLMG,      -- Red. order qty [bstmg_red]
    UMLME,      -- Order Unit [bstme]
    LFMNG,      -- GR qty assigned [efmng]
    VRKME,      -- Sales Unit [vrkme]
    EBLNU,      -- Supplier Order [eblnu]
    EBLPU,      -- Item [eblpu]
    SPERR,      -- Blocked [spbtr]
    BMERF,      -- Single-Character Flag [char1]
    ELIKZ,      -- Deliv. Compl. [elikz]
    BUKRS,      -- Company Code [bukrs]
    LAND1,      -- Country/Reg. [land1]
    WAFLU_VZ,   -- Method [waflu_vz]
    LGORT,      -- Location [lgort_d]
    PRIMARY KEY (MANDT, ABELN, ABELP, VZWRK)
);

Learn More