SAP AUBSI Worklist for PO (Follow-on Document Generation) Table
Overview
AUBSI is a standard SAP S/4HANA table that stores Worklist for PO (Follow-on Document Generation) data. There are total 44 fields in the AUBSI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AUBSI 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 AUBSI to other SAP tables and standard CDS views available based on AUBSI table in S/4HANA 2020.
Techincal Settings of AUBSI
Below are technical details of the table AUBSI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AUBSI Fields
The following table gives you an overview of the fields available in AUBSI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BEDAT | Purchase Order Date | BEDAT | DATS | 8 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| LIFNR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| BETRB | Customer no. of plant | FILNR | KNA1 | CHAR | 10 |
| ABELN | Allocation Table | ABELN | AUKO | CHAR | 10 |
| ABELP | Allocation Table Item | ABELP | AUPO | NUMC | 5 |
| ABELG | Store Group of an Allocation Table | ABELG | AUFG | NUMC | 5 |
| ABELF | Identifier of a Recipient of an Item of an Allocation Table | ABELF | AUFI | NUMC | 5 |
| LFNUM | Consecutive Number | LFNUM | CHAR | 5 | |
| VZENT | Distribution center (as customer) | VZENT | KNA1 | CHAR | 10 |
| FILNR | Customer no. of plant | FILNR | KNA1 | CHAR | 10 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| MENGE | Quantity | MENGE_D | QUAN | 13 | |
| AUFME | Allocation Unit | AUFME | T006 | UNIT | 3 |
| WETYP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| WEDAT | Delivery date | LFDAT | DATS | 8 | |
| WEVTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | |
| WEVDT | Delivery date | LFDAT | DATS | 8 | |
| BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| BSTME | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| EBLNU | Purchase Order Generated for Supplier | EBLNU | EKKO | CHAR | 10 |
| EBLPU | Generated purchase order item | EBLPU | EKPO | NUMC | 5 |
| BSART | Order Type in Allocation Table (for External Supplier) | BSART_LIEF | T161 | CHAR | 4 |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| VZWRK | Distribution Center | VZWRK | T001W | CHAR | 4 |
| FIWRK | Store | FIWRK | T001W | CHAR | 4 |
| BTWRK | Plant | BTWRK | T001W | CHAR | 4 |
| SPERR | Blocking flag, plant | SPBTR | T629 | CHAR | 1 |
| APSTP | Item category of allocation table | APSTP | T621 | CHAR | 4 |
| WEUZT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | |
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| AUREL | Relevant to Allocation Table | AUREL | CHAR | 1 | |
| RETPO | Returns Item | RETPO | CHAR | 1 | |
| BUKRS_BTWRK | Company Code | BUKRS | T001 | CHAR | 4 |
| LAND_BTWRK | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| SAPOS | Allocation table item of material on higher level | POSNR_SA | * | NUMC | 5 |
| RFKTN | Reference outline agreement | RFKTN | * | CHAR | 10 |
| RFKTP | Reference outline agreement item | RFKTP | * | NUMC | 5 |
| WRF_AT_DL_ID | Dateline ID (GUID) | WRF_AT_DL_ID | CHAR | 22 | |
| SLS_REL | Single-Recipient Supplier Orders from Allocation Table | SLS_REL | CHAR | 1 | |
| CONS_ORDER | Consignment Processing in Allocation Table (FBG) | WRF_AT_CONS_ORDER | 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 AUBSI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AUBSI | ABELF | : | AUFI |
| AUBSI | ABELG | : | AUFG |
| AUBSI | ABELN | 1: CN | AUKO |
| AUBSI | ABELP | 1: CN | AUPO |
| AUBSI | AKTNR | : | WAKH |
| AUBSI | APSTP | 1: CN | T621 |
| AUBSI | AUFME | : | T006 |
| AUBSI | BETRB | 1: CN | KNA1 |
| AUBSI | BSART | 1: CN | T161 |
| AUBSI | BSTME | 1: CN | T006 |
| AUBSI | BTWRK | 1: CN | T001W |
| AUBSI | BUKRS_BTWRK | : | T001 |
| AUBSI | EBLNU | 1: CN | EKKO |
| AUBSI | EBLPU | 1: CN | EKPO |
| AUBSI | EKGRP | 1: CN | T024 |
| AUBSI | EKORG | 1: CN | T024E |
| AUBSI | FILNR | 1: CN | KNA1 |
| AUBSI | FIWRK | 1: CN | T001W |
| AUBSI | LAND_BTWRK | : | T005 |
| AUBSI | LGORT | : | T001L |
| AUBSI | LIFNR | 1: CN | LFA1 |
| AUBSI | MANDT | 1: CN | T000 |
| AUBSI | MATNR | 1: CN | MARA |
| AUBSI | SPERR | 1: CN | T629 |
| AUBSI | VZENT | 1: CN | KNA1 |
| AUBSI | VZWRK | 1: CN | T001W |