AUBSI SAP (Worklist for PO (Follow-on Document Generation)) Table details
Dictionary Type: Table
Description: Worklist for PO (Follow-on Document Generation)
Description: Worklist for PO (Follow-on Document Generation)
Table field list including key, data, relationships and ABAP select examples
AUBSI is a standard SAP Table which is used to store Worklist for PO (Follow-on Document Generation) data and is available within R/3 SAP systems depending on the version and release level.
The AUBSI table consists of various fields, each holding specific information or linking keys about Worklist for PO (Follow-on Document Generation) data available in SAP. These include BEDAT (Purchase Order Date), EKORG (Purchasing Organization), EKGRP (Purchasing Group), LIFNR (Vendor Account Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP AUBSI table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BEDAT | Purchase Order Date | BEDAT | DATS | 8 | DATUM | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
BETRB | Customer no. of plant | FILNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
ABELP | Item number of allocation table | ABELP | NUMC | 5 | AUPO | ABELP | |||
ABELG | Sub-item no. of plant group (alloc tbl) | ABELG | NUMC | 5 | AUFG | ABELG | |||
ABELF | Sub.item no. of plant (alloc. tbl) | ABELF | NUMC | 5 | AUFI | ABELF | |||
LFNUM | Consecutive Number | LFNUM | CHAR | 5 | CHAR5 | ||||
VZENT | Distribution center (as customer) | VZENT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
FILNR | Customer no. of plant | FILNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
AUFME | Allocation Unit | AUFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
WETYP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
WEDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
WEVTP | Date type (day, week, month, interval) | PRGRS | CHAR | 1 | PRGRS | ||||
WEVDT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
BSTME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
EBLNU | Purchase Order Generated for Vendor | EBLNU | CHAR | 10 | EKKO | ALPHA | EBELN | BES | |
EBLPU | Generated purchase order item | EBLPU | NUMC | 5 | EKPO | EBELP | POS | ||
BSART | Order type in allocation table (for external vendor) | BSART_LIEF | CHAR | 4 | T161 | BSART | BSA | WAUF_T161 | |
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
VZWRK | Distribution center as plant | VZWRK | CHAR | 4 | T001W | WERKS | VZW | ||
FIWRK | Store as plant | FIWRK | CHAR | 4 | T001W | WERKS | WRK | ||
BTWRK | Plant | BTWRK | CHAR | 4 | T001W | WERKS | WRK | ||
SPERR | Blocking flag, plant | SPBTR | CHAR | 1 | T629 | SPERR_A | |||
APSTP | Item category of allocation table | APSTP | CHAR | 4 | T621 | APSTP | |||
WEUZT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | UZEIT | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
AUREL | Relevant to Allocation Table | AUREL | CHAR | 1 | AUREL | ||||
RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
BUKRS_BTWRK | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
LAND_BTWRK | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
SAPOS | Number of alloc tbl item of material on higher level | POSNR_SA | NUMC | 5 | Assigned to domain | ABELP | |||
RFKTN | Reference outline agreement | RFKTN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | ||
RFKTP | Reference outline agreement item | RFKTP | NUMC | 5 | Assigned to domain | EBELP | |||
WRF_AT_DL_ID | Dateline ID (GUID) | WRF_AT_DL_ID | CHAR | 22 | SYSUUID_22 | ||||
.INCLU--AP | 0 | ||||||||
SLS_REL | Single-Recipient Vendor Orders from Allocation Table | SLS_REL | CHAR | 1 | SLS_REL | ||||
.INCLU--AP | 0 | ||||||||
CONS_ORDER | Consignment Processing in Allocation Table (FBG) | WRF_AT_CONS_ORDER | CHAR | 1 | WRF_AT_CONS_ORDER |
Key field | Non-key field |
How do I retrieve data from SAP table AUBSI using ABAP code
The following ABAP code Example will allow you to do a basic selection on AUBSI to SELECT all data from the tableDATA: WA_AUBSI TYPE AUBSI.
SELECT SINGLE *
FROM AUBSI
INTO CORRESPONDING FIELDS OF WA_AUBSI
WHERE...
How to access SAP table AUBSI
Within an ECC or HANA version of SAP you can also view further information about AUBSI and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects