SAP table AUFM (Goods movements for order)

SAP table AUFM has 4 primary key fields being MANDT,MBLNR,MJAHR,ZEILE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MBLNR Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
ZEILE Item in Material Document NUMC 4 0 MBLPO
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
KDAUF Sales Order Number CHAR 10 0 KDAUF
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
DMBTR Amount in Local Currency CURR 13 2 DMBTR_CS
WAERS Currency Key CUKY 5 0 TCURC WAERS
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
ERFMG Quantity in unit of entry QUAN 13 3 ERFMG
ERFME Unit of entry UNIT 3 0 T006 ERFME
EBELN Purchase order number CHAR 10 0 EKKO BSTNR
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
WEMPF Goods Recipient CHAR 12 0 WEMPF
ABLAD Unloading Point CHAR 25 0 ABLAD
AUFNR Order Number CHAR 12 0 AUFK AUFNR
RSNUM Number of reservation/dependent requirements NUMC 10 0 RESB RSNUM
RSPOS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
RSART Record type CHAR 1 0 RSART
KZEAR Final Issue for Reservation CHAR 1 0 KZEAR
KZBEW Movement Indicator CHAR 1 0 KZBEW
Goods movement w/o reference
B Goods movement for purchase order
F Goods movement for production order
K Goods movement for kanban requirement (WM - internal only)
L Goods movement for delivery note
O Subsequent adjustment of "material-provided" consumption
W Subsequent adjustment of proportion/product unit material
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 AUFK NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
SAKTO G/L Account Number CHAR 10 0 SKA1 SAKNR
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 * /CWM/MEINS
/CWM/ERFMG Quantity in Parallel Unit of Entry QUAN 13 3 /CWM/ERFMG
/CWM/ERFME PUoM Entry Unit of Measure UNIT 3 0 * /CWM/ERFME
WTY_IND Warranty indicator CHAR 1 0 WTYSC_WTY_INDICATOR
FALSE
X TRUE

AUFM foreign key relationships

Table Field Check Table Check Field
0 AUFM AUFNR AUFK Order master data AUFNR
1 AUFM BWART T156 Movement Type MANDT
1 AUFM BWART T156 Movement Type BWART
0 AUFM BWTAR T149D Global Valuation Types MANDT
0 AUFM BWTAR T149D Global Valuation Types BWTAR
1 AUFM CHARG MCH1 Batches (if Batch Management Cross-Plant) MANDT
0 AUFM EBELN EKKO Purchasing Document Header EBELN
1 AUFM EBELP EKPO Purchasing Document Item MANDT
1 AUFM EBELP EKPO Purchasing Document Item EBELN
0 AUFM ERFME T006 Units of Measurement MANDT
1 AUFM KOKRS TKA01 Controlling Areas MANDT
0 AUFM LGORT T001L Storage Locations MANDT
0 AUFM LGORT T001L Storage Locations WERKS
1 AUFM LIFNR LFA1 Supplier Master (General Section) MANDT
1 AUFM LIFNR LFA1 Supplier Master (General Section) LIFNR
0 AUFM MANDT T000 Clients MANDT
1 AUFM MATNR MARA General Material Data MANDT
1 AUFM MATNR MARA General Material Data MATNR
0 AUFM MEINS T006 Units of Measurement MANDT
0 AUFM MEINS T006 Units of Measurement MSEHI
1 AUFM NPLNR AUFK Order master data AUFNR
0 AUFM PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 AUFM PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 AUFM RSNUM RESB Reservation/dependent requirements MANDT
1 AUFM RSNUM RESB Reservation/dependent requirements RSNUM
1 AUFM RSNUM RESB Reservation/dependent requirements RSPOS
0 AUFM SAKTO SKA1 G/L Account Master (Chart of Accounts) MANDT
0 AUFM SAKTO SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 AUFM SAKTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 AUFM SOBKZ T148 Special Stock Indicator MANDT
1 AUFM SOBKZ T148 Special Stock Indicator SOBKZ
0 AUFM WAERS TCURC Currency Codes MANDT
0 AUFM WAERS TCURC Currency Codes WAERS
1 AUFM WERKS T001W Plants/Branches MANDT
1 AUFM WERKS T001W Plants/Branches WERKS