SAP AUBF Document Flow SAP Retail (Allocation Table, Promotions...) Table
Overview
AUBF is a standard SAP S/4HANA table that stores Document Flow SAP Retail (Allocation Table, Promotions...) data. There are total 23 fields in the AUBF table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUBF belongs to Allocation (LO-RFM-PUR-AL) module and is located in the package Application development R/3 Purchasing, Allocation table (WAUF).
In addition, following links provide an overview of foreign key relationships, if any, that link AUBF to other SAP tables and standard CDS views available based on AUBF table in S/4HANA 2020.
Techincal Settings of AUBF
Below are technical details of the table AUBF
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUBF Fields
The following table gives you an overview of the fields available in AUBF
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| NBELT | Document category in document flow | RTBELTYP | CHAR | 1 | |
| NBELN | Doc. no. in document flow | RTBELNR | CHAR | 10 | |
| NPOSN | Item no. of document in document flow | RTPOSNR | CHAR | 5 | |
| VBELT | Document category in document flow | RTBELTYP | CHAR | 1 | |
| VBELN | Doc. no. in document flow | RTBELNR | CHAR | 10 | |
| VPOSN | Item no. of document in document flow | RTPOSNR | CHAR | 5 | |
| STUFE | Level of the document flow record | RTSTUFE | NUMC | 2 | |
| MATNR | Material Number | MATNR | CHAR | 40 | |
| FILNR | Customer Number | KUNNR | CHAR | 10 | |
| FILGR | Base plant group | FIGRP | CHAR | 18 | |
| WERKS | Plant | WERKS_D | CHAR | 4 | |
| AUFAR | Allocation Table Type | AUFAR | CHAR | 4 | |
| PLMIN | Quantity is calculated positively, negatively or not at all | PLMIN | CHAR | 1 | |
| MENGE | Quantity field, 15 characters | MENG15 | QUAN | 15 | |
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | |
| EKWRT | 9(17)-character value field with 2 decimal places | WERTV9 | CURR | 17 | |
| VKWRT | 9(17)-character value field with 2 decimal places | WERTV9 | CURR | 17 | |
| WAERS | Currency Key | WAERS | CUKY | 5 | |
| ERNAM | Name of person who changed object | AENAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 |
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 AUBF
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUBF | MANDT | : | T000 |