SAP AUFM Goods movements for order Table
Overview
AUFM is a standard SAP S/4HANA table that stores Goods movements for order data. There are total 46 fields in the AUFM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUFM belongs to Maintenance Orders (PM-WOC-MO) module and is located in the package Appl. Development R/3 Plant Maintenance Order Processing (IWO1).
In addition, following links provide an overview of foreign key relationships, if any, that link AUFM to other SAP tables and standard CDS views available based on AUFM table in S/4HANA 2020.
Techincal Settings of AUFM
Below are technical details of the table AUFM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUFM Fields
The following table gives you an overview of the fields available in AUFM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | |
| ZEILE | Item in Material Document | MBLPO | NUMC | 4 | |
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| BWART | Movement type (inventory management) | BWART | T156 | CHAR | 3 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 |
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 |
| LIFNR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| KDAUF | Sales Order Number | KDAUF | CHAR | 10 | |
| KDPOS | Item number in Sales Order | KDPOS | NUMC | 6 | |
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | |
| DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 13 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| MENGE | Quantity | MENGE_D | QUAN | 13 | |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| ERFMG | Quantity in unit of entry | ERFMG | QUAN | 13 | |
| ERFME | Unit of entry | ERFME | T006 | UNIT | 3 |
| EBELN | Purchase order number | BSTNR | EKKO | CHAR | 10 |
| EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| WEMPF | Goods Recipient | WEMPF | CHAR | 12 | |
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| RSNUM | Number of reservation/dependent requirements | RSNUM | RESB | NUMC | 10 |
| RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4 | |
| RSART | Record type | RSART | CHAR | 1 | |
| KZEAR | Final issue for this reservation | KZEAR | CHAR | 1 | |
| KZBEW | Movement Indicator | KZBEW | CHAR | 1 | |
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| NPLNR | Network Number for Account Assignment | NPLNR | AUFK | CHAR | 12 |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | |
| SAKTO | G/L Account Number | SAKNR | SKA1 | CHAR | 10 |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| /CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | QUAN | 13 | |
| /CWM/MEINS | Parallel Unit of Measure | /CWM/MEINS | * | UNIT | 3 |
| /CWM/ERFMG | Quantity in Parallel Unit of Entry | /CWM/ERFMG | QUAN | 13 | |
| /CWM/ERFME | PUoM Entry Unit of Measure | /CWM/ERFME | * | UNIT | 3 |
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AUFM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUFM | AUFNR | C: CN | AUFK |
| AUFM | BWART | 1: CN | T156 |
| AUFM | BWTAR | C: CN | T149D |
| AUFM | CHARG | C: CN | MCH1 |
| AUFM | EBELN | C: CN | EKKO |
| AUFM | EBELP | C: CN | EKPO |
| AUFM | ERFME | 1: N | T006 |
| AUFM | KOKRS | C: CN | TKA01 |
| AUFM | LGORT | C: CN | T001L |
| AUFM | LIFNR | C: CN | LFA1 |
| AUFM | MANDT | 1: CN | T000 |
| AUFM | MATNR | C: CN | MARA |
| AUFM | MEINS | C: CN | T006 |
| AUFM | NPLNR | 1: CN | AUFK |
| AUFM | PS_PSP_PNR | C: CN | PRPS |
| AUFM | RSNUM | C: CN | RESB |
| AUFM | SAKTO | C: CN | SKA1 |
| AUFM | SOBKZ | C: CN | T148 |
| AUFM | WAERS | 1: CN | TCURC |
| AUFM | WERKS | 1: CN | T001W |