AUFM

Transparent Table Application Table
42 Fields 2 CDS Views

Goods movements for order

AUFM is an SAP database table in S/4HANA. Goods movements for order. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintOrderGoodsMovement view from BASIC Maintenance Order Goods Movement
I_OrderDocumentedGoodsMovement view from BASIC Documented Goods Movement of an Order

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY mblnr MBLNR Material Doc.
KEY mjahr MJAHR Mat. Doc. Year
KEY zeile MBLPO Mat. Doc.Item
bldat BLDAT Document Date
budat BUDAT Posting Date
bwart BWART Movement Type
matnr MATNR Material
werks WERKS_D Plant
lgort LGORT_D Location
charg CHARG_D Batch
sobkz SOBKZ Special Stock
lifnr ELIFN Supplier
kdauf KDAUF Sales Order
kdpos KDPOS Sales Ord. Item
shkzg SHKZG Debit/Credit
dmbtr DMBTR_CS Amount in LC
waers WAERS Currency
bwtar BWTAR_D Valuation Type
menge MENGE_D Quantity
meins MEINS Base Unit
erfmg ERFMG Quantity in UnE
erfme ERFME Unit of Entry
ebeln BSTNR Purchase order
ebelp EBELP Item
elikz ELIKZ Deliv. Compl.
wempf WEMPF Recipient
ablad ABLAD Unloading Point
aufnr AUFNR Order
rsnum RSNUM Reservation
rspos RSPOS Item no.
rsart RSART Record type
kzear KZEAR Final Issue
kzbew KZBEW Movement ind.
weunb WEUNB GR Non-Valuated
ps_psp_pnr PS_PSP_PNR WBS Element
nplnr NPLNR Network
aufpl CO_AUFPL Plan No.f.Oper.
aplzl CIM_COUNT Counter
sakto SAKNR G/L Account
kokrs KOKRS CO Area
wty_ind WTYSC_WTY_INDICATOR Warranty

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.

-- Goods movements for order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AUFM (
    MANDT,       -- Client [MANDT]
    MBLNR,       -- Material Doc. [MBLNR]
    MJAHR,       -- Mat. Doc. Year [MJAHR]
    ZEILE,       -- Mat. Doc.Item [MBLPO]
    BLDAT,       -- Document Date [BLDAT]
    BUDAT,       -- Posting Date [BUDAT]
    BWART,       -- Movement Type [BWART]
    MATNR,       -- Material [MATNR]
    WERKS,       -- Plant [WERKS_D]
    LGORT,       -- Location [LGORT_D]
    CHARG,       -- Batch [CHARG_D]
    SOBKZ,       -- Special Stock [SOBKZ]
    LIFNR,       -- Supplier [ELIFN]
    KDAUF,       -- Sales Order [KDAUF]
    KDPOS,       -- Sales Ord. Item [KDPOS]
    SHKZG,       -- Debit/Credit [SHKZG]
    DMBTR,       -- Amount in LC [DMBTR_CS]
    WAERS,       -- Currency [WAERS]
    BWTAR,       -- Valuation Type [BWTAR_D]
    MENGE,       -- Quantity [MENGE_D]
    MEINS,       -- Base Unit [MEINS]
    ERFMG,       -- Quantity in UnE [ERFMG]
    ERFME,       -- Unit of Entry [ERFME]
    EBELN,       -- Purchase order [BSTNR]
    EBELP,       -- Item [EBELP]
    ELIKZ,       -- Deliv. Compl. [ELIKZ]
    WEMPF,       -- Recipient [WEMPF]
    ABLAD,       -- Unloading Point [ABLAD]
    AUFNR,       -- Order [AUFNR]
    RSNUM,       -- Reservation [RSNUM]
    RSPOS,       -- Item no. [RSPOS]
    RSART,       -- Record type [RSART]
    KZEAR,       -- Final Issue [KZEAR]
    KZBEW,       -- Movement ind. [KZBEW]
    WEUNB,       -- GR Non-Valuated [WEUNB]
    PS_PSP_PNR,  -- WBS Element [PS_PSP_PNR]
    NPLNR,       -- Network [NPLNR]
    AUFPL,       -- Plan No.f.Oper. [CO_AUFPL]
    APLZL,       -- Counter [CIM_COUNT]
    SAKTO,       -- G/L Account [SAKNR]
    KOKRS,       -- CO Area [KOKRS]
    WTY_IND,     -- Warranty [WTYSC_WTY_INDICATOR]
    PRIMARY KEY (MANDT, MBLNR, MJAHR, ZEILE)
);

Learn More