SAP Table AUFM
Goods movements for order
AUFM (Goods movements for order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AUFM to other SAP tables.
AUFM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | 0 | |||||||||||||||||
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | 0 | |||||||||||||||||
| ZEILE | Item in Material Document | MBLPO | NUMC | 4 | 0 | |||||||||||||||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||||||||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||||||||||||
| BWART | Movement Type (Inventory Management) | BWART | T156 | CHAR | 3 | 0 | ||||||||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||||||||||||
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 | 0 | ||||||||||||||||
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||||||||||||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||||||||||||
| KDAUF | Sales Order Number | KDAUF | VBUK | CHAR | 10 | 0 | ||||||||||||||||
| KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | 0 | |||||||||||||||||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| DMBTR | Amount in Local Currency | DMBTR | CURR | 13 | 2 | |||||||||||||||||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 0 | ||||||||||||||||
| MENGE | Quantity | MENGE_D | QUAN | 13 | 3 | |||||||||||||||||
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||||||||
| ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13 | 3 | |||||||||||||||||
| ERFME | Unit of Entry | ERFME | T006 | UNIT | 3 | 0 | ||||||||||||||||
| EBELN | Purchase Order Number | BSTNR | EKKO | CHAR | 10 | 0 | ||||||||||||||||
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 | 0 | ||||||||||||||||
| ELIKZ | "Delivery Completed" Indicator | ELIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | 0 | |||||||||||||||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||||||||
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||
| RSNUM | Number of Reservation/Dependent Requirement | RSNUM | RESB | NUMC | 10 | 0 | ||||||||||||||||
| RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | 0 | |||||||||||||||||
| RSART | Record type | RSART | CHAR | 1 | 0 | |||||||||||||||||
| KZEAR | Final Issue for This Reservation | KZEAR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| KZBEW | Movement Indicator | KZBEW | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 | 0 | ||||||||||||||||
| NPLNR | Network Number for Account Assignment | NPLNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | 0 | |||||||||||||||||
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||||
| SAKTO | G/L Account Number | SAKNR | SKA1 | CHAR | 10 | 0 | ||||||||||||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||||||
| /CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | QUAN | 13 | 3 | |||||||||||||||||
| /CWM/MEINS | Parallel Unit of Measure | /CWM/MEINS | UNIT | 3 | 0 | |||||||||||||||||
| /CWM/ERFMG | Quantity in Parallel Unit of Entry | /CWM/ERFMG | QUAN | 13 | 3 | |||||||||||||||||
| /CWM/ERFME | PUoM Entry Unit of Measure | /CWM/ERFME | UNIT | 3 | 0 | |||||||||||||||||
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
AUFM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| AUFM | AUFNR | AUFM | MANDT | AUFK | Order master data | MANDT |
| AUFM | AUFNR | AUFM | AUFNR | AUFK | Order master data | AUFNR |
| AUFM | BWART | AUFM | MANDT | T156 | Movement Type | MANDT |
| AUFM | BWART | AUFM | BWART | T156 | Movement Type | BWART |
| AUFM | BWTAR | AUFM | BWTAR | T149D | Global Valuation Types | BWTAR |
| AUFM | BWTAR | AUFM | MANDT | T149D | Global Valuation Types | MANDT |
| AUFM | CHARG | AUFM | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| AUFM | CHARG | AUFM | MATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
| AUFM | CHARG | AUFM | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
| AUFM | EBELN | AUFM | MANDT | EKKO | Purchasing Document Header | MANDT |
| AUFM | EBELN | AUFM | EBELN | EKKO | Purchasing Document Header | EBELN |
| AUFM | EBELP | AUFM | MANDT | EKPO | Purchasing Document Item | MANDT |
| AUFM | EBELP | AUFM | EBELN | EKPO | Purchasing Document Item | EBELN |
| AUFM | EBELP | AUFM | EBELP | EKPO | Purchasing Document Item | EBELP |
| AUFM | ERFME | AUFM | ERFME | T006 | Units of Measurement | MSEHI |
| AUFM | ERFME | AUFM | MANDT | T006 | Units of Measurement | MANDT |
| AUFM | KDAUF | AUFM | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| AUFM | KDAUF | AUFM | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| AUFM | KOKRS | AUFM | MANDT | TKA01 | Controlling Areas | MANDT |
| AUFM | KOKRS | AUFM | KOKRS | TKA01 | Controlling Areas | KOKRS |
| AUFM | LGORT | AUFM | WERKS | T001L | Storage Locations | WERKS |
| AUFM | LGORT | AUFM | LGORT | T001L | Storage Locations | LGORT |
| AUFM | LGORT | AUFM | MANDT | T001L | Storage Locations | MANDT |
| AUFM | LIFNR | AUFM | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| AUFM | LIFNR | AUFM | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| AUFM | MANDT | AUFM | MANDT | T000 | Clients | MANDT |
| AUFM | MATNR | AUFM | MANDT | MARA | General Material Data | MANDT |
| AUFM | MATNR | AUFM | MATNR | MARA | General Material Data | MATNR |
| AUFM | MEINS | AUFM | MANDT | T006 | Units of Measurement | MANDT |
| AUFM | MEINS | AUFM | MEINS | T006 | Units of Measurement | MSEHI |
| AUFM | NPLNR | AUFM | MANDT | AUFK | Order master data | MANDT |
| AUFM | NPLNR | AUFM | NPLNR | AUFK | Order master data | AUFNR |
| AUFM | PS_PSP_PNR | AUFM | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| AUFM | PS_PSP_PNR | AUFM | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| AUFM | RSNUM | AUFM | MANDT | RESB | Reservation/dependent requirements | MANDT |
| AUFM | RSNUM | AUFM | RSNUM | RESB | Reservation/dependent requirements | RSNUM |
| AUFM | RSNUM | AUFM | RSPOS | RESB | Reservation/dependent requirements | RSPOS |
| AUFM | RSNUM | AUFM | RSART | RESB | Reservation/dependent requirements | RSART |
| AUFM | SAKTO | AUFM | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| AUFM | SAKTO | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| AUFM | SAKTO | AUFM | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| AUFM | SOBKZ | AUFM | MANDT | T148 | Special Stock Indicator | MANDT |
| AUFM | SOBKZ | AUFM | SOBKZ | T148 | Special Stock Indicator | SOBKZ |
| AUFM | WAERS | AUFM | MANDT | TCURC | Currency Codes | MANDT |
| AUFM | WAERS | AUFM | WAERS | TCURC | Currency Codes | WAERS |
| AUFM | WERKS | AUFM | MANDT | T001W | Plants/Branches | MANDT |
| AUFM | WERKS | AUFM | WERKS | T001W | Plants/Branches | WERKS |
