BBP_USR01 SAP (Internet user data) Table details
Dictionary Type: Table
Description: Internet user data
Description: Internet user data
Table field list including key, data, relationships and ABAP select examples
BBP_USR01 is a standard SAP Table which is used to store Internet user data data and is available within R/3 SAP systems depending on the version and release level.
The BBP_USR01 table consists of various fields, each holding specific information or linking keys about Internet user data data available in SAP. These include USERID (User ID in SAP Business-to-Business Procurement), USER_TYPE (User Type in SAP Business-to-Business Procurement), FIRSTNAME (First name), LASTNAME (Last name).. 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)
SAP BBP_USR01 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 | Assigned to domain | MANDT | |||
USERID | User ID in SAP Business-to-Business Procurement | BBPOBJID | CHAR | 16 | BBPOBJID | ||||
USER_TYPE | User Type in SAP Business-to-Business Procurement | BBPOBJTYPE | CHAR | 10 | BBPUTYP | ALPHA | BBPOBJTYPE | UID | |
FIRSTNAME | First name | BBPNAMEFIR | CHAR | 40 | TEXT40 | ||||
LASTNAME | Last name | BBPNAMELAS | CHAR | 40 | TEXT40 | ||||
TITLE | Formal title | BBPTITLE1 | CHAR | 30 | TEXT30 | ||||
FORMOFADDR | Form of address | BBPFORMADR | CHAR | 30 | TEXT30 | ||||
LANGU | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
BUILDING_P | Building (number or code) | BBPBLDNG | CHAR | 10 | TEXT10 | ||||
ROOM_NO_P | Room number | BBPROOMNO | CHAR | 10 | TEXT10 | ||||
INHOUSE_ML | Internal mail | BBPIHMAIL | CHAR | 10 | TEXT10 | ||||
TEL1_NUMBR | First telephone number | BBPTELNUM | CHAR | 30 | TEXT30 | ||||
TEL1_EXT | Extension number | BBPTELEXT | CHAR | 10 | CHAR10 | ||||
TEL2_NUMBR | Second telephone number | BBPTELNUM2 | CHAR | 30 | TEXT30 | ||||
TEL2_EXT | Extension number | BBPTELEXT | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number | BBPFAXNUM | CHAR | 30 | TEXT30 | ||||
E_MAIL | E-mail address | BBPSMTPADR | CHAR | 241 | SXIDN | AD_SMTPADR | |||
DATFM | Date format | BBPDATFM | CHAR | 1 | CHAR1 | ||||
DCPFM | Decimal notation | BBP_DCPFM | CHAR | 1 | CHAR1 | ||||
PHOTO | URL of picture | BBPPHOTO | CHAR | 135 | CHAR135 | ||||
APPROVE_IND | Approval indicator for creating a user | BBPAPPROVE | CHAR | 1 | CHANGEFLAG | ||||
SECRETARY | User ID in Internet user master | WWWOBJID | CHAR | 16 | Assigned to domain | ALPHA | WWWOBJID | UID | |
PASSWORD | Proposed password for component user | BBP_PASSWD | CHAR | 8 | TEXT8 | ||||
ITS_DESTINATION | Name of host | IACHOST | CHAR | 132 | IACVALUE | ||||
GROUP_NO | Current tree node number | BBPNODENO | CHAR | 16 | BBPNODENO | ||||
ORG_UNIT | Object ID | OBJEKTID | NUMC | 8 | NUM08 | PON | |||
CHANGED_GROUP | Group number from PID tree | BBPGROUPNO | CHAR | 16 | BBPNODENO | ||||
CHANGED_ORG | User Name in User Master Record | XUBNAME | CHAR | 12 | Assigned to domain | XUBNAME | XUS | ||
FORWARD_WI | General Flag | FLAG | CHAR | 1 | FLAG | ||||
BBPPCINS | Procurement card company | BBPPCINS | CHAR | 4 | Assigned to domain | BBPPCINS | PCI | ||
PCNUM | Procurement card number | BBPPCNUM | CHAR | 25 | Assigned to domain | BBPPCNUM | PCC | BBP_PCMAS | |
HOLDER_NAME | Name of procurement cardholder | BBPPCNAME | CHAR | 40 | CHAR40 | ||||
WFAGENT2 | Second workflow agent ID for procurement card | PCWFOBJID2 | CHAR | 12 | CHAR12 | ||||
PCDAT_FROM | Procurement card valid from date | BBPPCDATF | DATS | 8 | DATUM | ||||
PCDAT_TO | Procurement card expiration date | BBPPCDATE | DATS | 8 | DATUM | ||||
COMP_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
LOC_CURRCY | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
GL_ACCOUNT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
COSTCENTER | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
FLOOR_P | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
.INCLU--AP | 0 | ||||||||
DUMMY_ITEM | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
Key field | Non-key field |
How do I retrieve data from SAP table BBP_USR01 using ABAP code
The following ABAP code Example will allow you to do a basic selection on BBP_USR01 to SELECT all data from the tableDATA: WA_BBP_USR01 TYPE BBP_USR01.
SELECT SINGLE *
FROM BBP_USR01
INTO CORRESPONDING FIELDS OF WA_BBP_USR01
WHERE...
How to access SAP table BBP_USR01
Within an ECC or HANA version of SAP you can also view further information about BBP_USR01 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