AUFM SAP (Goods movements for order) Table details

Dictionary Type: Table
Description: Goods movements for order




ABAP Code to SELECT data from AUFM
Related tables to AUFM
Access table AUFM




Table field list including key, data, relationships and ABAP select examples

AUFM is a standard SAP Table which is used to store Goods movements for order data and is available within R/3 SAP systems depending on the version and release level.

The AUFM table consists of various fields, each holding specific information or linking keys about Goods movements for order data available in SAP. These include MBLNR (Number of Material Document), MJAHR (Material Document Year), ZEILE (Item in Material Document), BLDAT (Document Date in Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AUFM table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MBLPOPOS
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
KDAUFSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3T006CUNITMEINS
EBELNPurchase Order Number BSTNRCHAR10EKKOALPHAEBELNBES
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
WEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
ABLADUnloading Point ABLADCHAR25TEXT25
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10RESBRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
RSARTRecord type RSARTCHAR1RSART
KZEARFinal Issue for This Reservation KZEARCHAR1XFELD
KZBEWMovement Indicator KZBEWCHAR1KZBEW
WEUNBGoods Receipt, Non-Valuated WEUNBCHAR1XFELD
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12AUFKALPHAAUFNRNET
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
SAKTOG/L Account Number SAKNRCHAR10SKA1ALPHASAKNRSAKC_SAKNR
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
.INCLU--AP 0
WTY_INDWarranty indicator WTYSC_WTY_INDICATORCHAR1WTYSC_WTY_INDICATOR

Key field Non-key field



How do I retrieve data from SAP table AUFM using ABAP code

The following ABAP code Example will allow you to do a basic selection on AUFM to SELECT all data from the table
DATA: WA_AUFM TYPE AUFM.

SELECT SINGLE *
FROM AUFM
INTO CORRESPONDING FIELDS OF WA_AUFM
WHERE...

How to access SAP table AUFM

Within an ECC or HANA version of SAP you can also view further information about AUFM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!