SAP ABAP Table AUBSI (Worklist for PO (Follow-on Document Generation))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WAUF (Package) Application development R/3 Purchasing, Allocation table

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AUBSI	Table Relationship Diagram
Short Description	Worklist for PO (Follow-on Document Generation)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BEDAT	☑	BEDAT	DATUM	DATS	8	0	Purchase Order Date
3	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
4	EKGRP	☑	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
5	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
6	BETRB	☑	FILNR	KUNNR	CHAR	10	0	Customer no. of plant	KNA1
7	ABELN	☑	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
8	ABELP	☑	ABELP	ABELP	NUMC	5	0	Item number of allocation table	AUPO
9	ABELG	☑	ABELG	ABELG	NUMC	5	0	Sub-item no. of plant group (alloc tbl)	AUFG
10	ABELF	☑	ABELF	ABELF	NUMC	5	0	Sub.item no. of plant (alloc. tbl)	AUFI
11	LFNUM	☑	LFNUM	CHAR5	CHAR	5	0	Consecutive number
12	VZENT	☐	VZENT	KUNNR	CHAR	10	0	Distribution center (as customer)	KNA1
13	FILNR	☐	FILNR	KUNNR	CHAR	10	0	Customer no. of plant	KNA1
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
15	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
16	AUFME	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
17	WETYP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
18	WEDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
19	WEVTP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
20	WEVDT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
21	BSTMG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
22	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
23	EBLNU	☐	EBLNU	EBELN	CHAR	10	0	Purchase Order Generated for Vendor	EKKO
24	EBLPU	☐	EBLPU	EBELP	NUMC	5	0	Generated purchase order item	EKPO
25	BSART	☐	BSART_LIEF	BSART	CHAR	4	0	Order type in allocation table (for external vendor)	T161
26	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
27	VZWRK	☐	VZWRK	WERKS	CHAR	4	0	Distribution center as plant	T001W
28	FIWRK	☐	FIWRK	WERKS	CHAR	4	0	Store as plant	T001W
29	BTWRK	☐	BTWRK	WERKS	CHAR	4	0	Plant	T001W
30	SPERR	☐	SPBTR	SPERR_A	CHAR	1	0	Blocking flag, plant	T629
31	APSTP	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	T621
32	WEUZT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
33	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
34	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
35	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
36	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
37	BUKRS_BTWRK	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	LAND_BTWRK	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
39	SAPOS	☐	POSNR_SA	ABELP	NUMC	5	0	Number of alloc tbl item of material on higher level	*
40	RFKTN	☐	RFKTN	EBELN	CHAR	10	0	Reference outline agreement	*
41	RFKTP	☐	RFKTP	EBELP	NUMC	5	0	Reference outline agreement item	*
42	WRF_AT_DL_ID	☐	WRF_AT_DL_ID	SYSUUID_22	CHAR	22	0	Dateline ID (GUID)
43	.INCLU--AP	☐				0	0	Append 600
44	SLS_REL	☐	SLS_REL	SLS_REL	CHAR	1	0	Single-Recipient Vendor Orders from Allocation Table
45	.INCLU--AP	☐				0	0	SeasPr: Enhancement of Allocation Table by Consignment Proc.
46	CONS_ORDER	☐	WRF_AT_CONS_ORDER	WRF_AT_CONS_ORDER	CHAR	1	0	Consignment Processing in Allocation Table (FBG)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AUBSI	ABELF	AUFI	ABELF
2	AUBSI	ABELG	AUFG	ABELG
3	AUBSI	ABELN	AUKO	ABELN	KEY	1	CN
4	AUBSI	ABELP	AUPO	ABELP	KEY	1	CN
5	AUBSI	AKTNR	WAKH	AKTNR
6	AUBSI	APSTP	T621	APSTP	REF	1	CN
7	AUBSI	AUFME	T006	MSEHI
8	AUBSI	BETRB	KNA1	KUNNR	KEY	1	CN
9	AUBSI	BSART	T161	BSART	KEY	1	CN
10	AUBSI	BSTME	T006	MSEHI	REF	1	CN
11	AUBSI	BTWRK	T001W	WERKS	REF	1	CN
12	AUBSI	BUKRS_BTWRK	T001	BUKRS
13	AUBSI	EBLNU	EKKO	EBELN	REF	1	CN
14	AUBSI	EBLPU	EKPO	EBELP	REF	1	CN
15	AUBSI	EKGRP	T024	EKGRP	KEY	1	CN
16	AUBSI	EKORG	T024E	EKORG	KEY	1	CN
17	AUBSI	FILNR	KNA1	KUNNR	KEY	1	CN
18	AUBSI	FIWRK	T001W	WERKS	REF	1	CN
19	AUBSI	LAND_BTWRK	T005	LAND1
20	AUBSI	LGORT	T001L	LGORT
21	AUBSI	LIFNR	LFA1	LIFNR	KEY	1	CN
22	AUBSI	MANDT	T000	MANDT	KEY	1	CN
23	AUBSI	MATNR	MARA	MATNR	REF	1	CN
24	AUBSI	SPERR	T629	SPERR	REF	1	CN
25	AUBSI	VZENT	KNA1	KUNNR	KEY	1	CN
26	AUBSI	VZWRK	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in