AUBF is a standard SAP table in SAP ERP (or) S/4HANA which stores Document Flow SAP Retail (Allocation Table, Promotions…) data. There are total 23 fields in AUBF table.This blog post provides key technical details of SAP table AUBF, including its availability across SAP S/4HANA versions and the list of CDS views for AUBF table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Application development R/3 Purchasing, Allocation table (WAUF) |
| Technical Component | Allocation (LO-RFM-PUR-AL) |
SAP AUBF Table Fields
The following is the list of fields that are available in SAP AUBF 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) |
| NBELT | Document category in document flow | RTBELTYP | RTBELTYP | CHAR (1) | |
| NBELN | Doc. no. in document flow | RTBELNR | RTBELNR | CHAR (10) | |
| NPOSN | Item no. of document in document flow | RTPOSNR | R3POSNR | CHAR (5) | |
| VBELT | Document category in document flow | RTBELTYP | RTBELTYP | CHAR (1) | |
| VBELN | Doc. no. in document flow | RTBELNR | RTBELNR | CHAR (10) | |
| VPOSN | Item no. of document in document flow | RTPOSNR | R3POSNR | CHAR (5) | |
| STUFE | Level of the document flow record | RTSTUFE | NUM2 | NUMC (2) | |
| MATNR | Material Number | MATNR | MATNR | CHAR (40) | |
| FILNR | Customer Number | KUNNR | KUNNR | CHAR (10) | |
| FILGR | Base plant group | FIGRP | KLASSE | CHAR (18) | |
| WERKS | Plant | WERKS_D | WERKS | CHAR (4) | |
| AUFAR | Allocation Table Type | AUFAR | AUFAR | CHAR (4) | |
| PLMIN | Quantity is calculated positively, negatively or not at all | PLMIN | PLMIN | CHAR (1) | |
| MENGE | Quantity field, 15 characters | MENG15 | MENG15 | QUAN (15) | |
| MEINS | Base Unit of Measure | MEINS | MEINS | UNIT (3) | |
| EKWRT | 9(17)-character value field with 2 decimal places | WERTV9 | WERTV9 | CURR (17) | |
| VKWRT | 9(17)-character value field with 2 decimal places | WERTV9 | WERTV9 | CURR (17) | |
| WAERS | Currency Key | WAERS | WAERS | CUKY (5) | |
| ERNAM | Name of person who changed object | AENAM | USNAM | CHAR (12) | |
| ERDAT | Date on which the record was created | ERDAT | DATUM | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | USNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATUM | DATS (8) |
Availability
The SAP table AUBF 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 AUBF table
There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.
