AUFM is a standard SAP table in SAP ERP (or) S/4HANA which stores Goods movements for order data. There are total 46 fields in AUFM table.This blog post provides key technical details of SAP table AUFM, including its availability across SAP S/4HANA versions and the list of CDS views for AUFM table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Appl. Development R/3 Plant Maintenance Order Processing (IWO1) |
| Technical Component | Maintenance Orders (PM-WOC-MO) |
SAP AUFM Table Fields
The following is the list of fields that are available in SAP AUFM table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| MBLNR | Number of Material Document | MBLNR | BELNR | CHAR (10) | |
| MJAHR | Material Document Year | MJAHR | GJAHR | NUMC (4) | |
| ZEILE | Item in Material Document | MBLPO | MBLPO | NUMC (4) | |
| BLDAT | Document Date in Document | BLDAT | DATUM | DATS (8) | |
| BUDAT | Posting Date in the Document | BUDAT | DATUM | DATS (8) | |
| BWART | Movement type (inventory management) | BWART | BWART | T156 | CHAR (3) |
| MATNR | Material Number | MATNR | MATNR | MARA | CHAR (40) |
| WERKS | Plant | WERKS_D | WERKS | T001W | CHAR (4) |
| LGORT | Storage location | LGORT_D | LGORT | T001L | CHAR (4) |
| CHARG | Batch Number | CHARG_D | CHARG | MCH1 | CHAR (10) |
| SOBKZ | Special Stock Indicator | SOBKZ | SOBKZ | T148 | CHAR (1) |
| LIFNR | Vendor’s account number | ELIFN | LIFNR | LFA1 | CHAR (10) |
| KDAUF | Sales Order Number | KDAUF | VBELN | CHAR (10) | |
| KDPOS | Item number in Sales Order | KDPOS | NUM06 | NUMC (6) | |
| SHKZG | Debit/Credit Indicator | SHKZG | SHKZG | CHAR (1) | |
| DMBTR | Amount in Local Currency | DMBTR_CS | WERT7 | CURR (13) | |
| WAERS | Currency Key | WAERS | WAERS | TCURC | CUKY (5) |
| BWTAR | Valuation Type | BWTAR_D | BWTAR | T149D | CHAR (10) |
| MENGE | Quantity | MENGE_D | MENG13 | QUAN (13) | |
| MEINS | Base Unit of Measure | MEINS | MEINS | T006 | UNIT (3) |
| ERFMG | Quantity in unit of entry | ERFMG | MENG13 | QUAN (13) | |
| ERFME | Unit of entry | ERFME | MEINS | T006 | UNIT (3) |
| EBELN | Purchase order number | BSTNR | EBELN | EKKO | CHAR (10) |
| EBELP | Item Number of Purchasing Document | EBELP | EBELP | EKPO | NUMC (5) |
| ELIKZ | Delivery Completed Indicator | ELIKZ | XFELD | CHAR (1) | |
| WEMPF | Goods Recipient | WEMPF | WEMPF | CHAR (12) | |
| ABLAD | Unloading Point | ABLAD | TEXT25 | CHAR (25) | |
| AUFNR | Order Number | AUFNR | AUFNR | AUFK | CHAR (12) |
| RSNUM | Number of reservation/dependent requirements | RSNUM | RSNUM | RESB | NUMC (10) |
| RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | RSPOS | NUMC (4) | |
| RSART | Record type | RSART | RSART | CHAR (1) | |
| KZEAR | Final issue for this reservation | KZEAR | XFELD | CHAR (1) | |
| KZBEW | Movement Indicator | KZBEW | KZBEW | CHAR (1) | |
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | XFELD | CHAR (1) | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PS_POSNR | PRPS | NUMC (8) |
| NPLNR | Network Number for Account Assignment | NPLNR | AUFNR | AUFK | CHAR (12) |
| AUFPL | Routing number of operations in the order | CO_AUFPL | AUFPL | NUMC (10) | |
| APLZL | Internal counter | CIM_COUNT | CIM_COUNT | NUMC (8) | |
| SAKTO | G/L Account Number | SAKNR | SAKNR | SKA1 | CHAR (10) |
| KOKRS | Controlling Area | KOKRS | CACCD | TKA01 | CHAR (4) |
| /CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | MENG13 | QUAN (13) | |
| /CWM/MEINS | Parallel Unit of Measure | /CWM/MEINS | MEINS | * | UNIT (3) |
| /CWM/ERFMG | Quantity in Parallel Unit of Entry | /CWM/ERFMG | MENG13 | QUAN (13) | |
| /CWM/ERFME | PUoM Entry Unit of Measure | /CWM/ERFME | MEINS | * | UNIT (3) |
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | WTYSC_WTY_INDICATOR | CHAR (1) |
Availability
The SAP table AUFM is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AUFM table
The following is the list of AUFM CDS views, which can also be used instead of AUFM table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_MAINTORDERGOODSMOVEMENT | BASIC | Maintenance Order Goods Movement |
| P_HISTMATERIALMALFUNCMANAGE | CONSUMPTION | Historic Materials |
