SAP BBPS_UM_UI_TBLSELECT Structire fpr Table Control: BBPUSERMAINT Access Table data and field list

BBPS_UM_UI_TBLSELECT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structire fpr Table Control: BBPUSERMAINT Access" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_BBPS_UM_UI_TBLSELECT TYPE BBPS_UM_UI_TBLSELECT.

The BBPS_UM_UI_TBLSELECT table consists of various fields, each holding specific information or linking keys about Structire fpr Table Control: BBPUSERMAINT Access data available in SAP. These include FIRSTNAME (First name of business partner (person)), LASTNAME (Last name of business partner (person)), USER_ID (User Name in User Master Record), PERSON_ID (Technical Person 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. .

BBPS_UM_UI_TBLSELECT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP BBPS_UM_UI_TBLSELECT structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the BBPS_UM_UI_TBLSELECT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MARKED	General Flag	FLAG	CHAR	1			FLAG
FIRSTNAME	First name of business partner (person)	BU_NAMEP_F	CHAR	40			BU_NAME
LASTNAME	Last name of business partner (person)	BU_NAMEP_L	CHAR	40			BU_NAME
USER_ID	User Name in User Master Record	XUBNAME	CHAR	12	Assigned to domain		XUBNAME	XUS
PERSON_ID	Technical Person Number	PERSONID	NUMC	8			PERSONID
EMPLOYEE_ID	Business Partner Number	BU_PARTNER	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
EMPLOYEE_GUID	Globally Unique Identifier	GUID	RAW	16
E_MAIL	E-Mail Address	AD_SMTPADR	CHAR	241		SXIDN	AD_SMTPADR
DEPARTMENT_ID	Object ID	HROBJID	NUMC	8	Assigned to domain		HROBJID	PON
DEPARTMENT_STERM	Object Abbreviation	SHORT_D	CHAR	12			TEXT12
DEPARTMENT_NAME	Object Name	STEXT	CHAR	40			TEXT40
POSITION_ID	Object ID	HROBJID	NUMC	8	Assigned to domain		HROBJID	PON
POSITION_STERM	Object Abbreviation	SHORT_D	CHAR	12			TEXT12
POSITION_NAME	Object Name	STEXT	CHAR	40			TEXT40
LOCK_STATE	Status of User Lock	BAPIUSLOCK	CHAR	1			BAPIUSLOCK

Key field

Non-key field

< BBPS_UM_UI_PERSON_ALL - All Data Belonging to a Natural Person BBPS_UM_UI_USER_ACCOUNT - User Mainten. in SRM: BBPUSERMAINT / BBPAT05 - User Data >

How do I retrieve data from SAP structure BBPS_UM_UI_TBLSELECT using ABAP code?

As BBPS_UM_UI_TBLSELECT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on BBPS_UM_UI_TBLSELECT as there is no data to select.

How to access SAP table BBPS_UM_UI_TBLSELECT

Within an ECC or HANA version of SAP you can also view further information about BBPS_UM_UI_TBLSELECT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).