BBP_USR01 SAP (Internet user data) Table details

Dictionary Type: Table
Description: Internet user data




ABAP Code to SELECT data from BBP_USR01
Related tables to BBP_USR01
Access table BBP_USR01




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
USERIDUser ID in SAP Business-to-Business Procurement BBPOBJIDCHAR16BBPOBJID
USER_TYPEUser Type in SAP Business-to-Business Procurement BBPOBJTYPECHAR10BBPUTYPALPHABBPOBJTYPEUID
FIRSTNAMEFirst name BBPNAMEFIRCHAR40TEXT40
LASTNAMELast name BBPNAMELASCHAR40TEXT40
TITLEFormal title BBPTITLE1CHAR30TEXT30
FORMOFADDRForm of address BBPFORMADRCHAR30TEXT30
LANGULanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
BUILDING_PBuilding (number or code) BBPBLDNGCHAR10TEXT10
ROOM_NO_PRoom number BBPROOMNOCHAR10TEXT10
INHOUSE_MLInternal mail BBPIHMAILCHAR10TEXT10
TEL1_NUMBRFirst telephone number BBPTELNUMCHAR30TEXT30
TEL1_EXTExtension number BBPTELEXTCHAR10CHAR10
TEL2_NUMBRSecond telephone number BBPTELNUM2CHAR30TEXT30
TEL2_EXTExtension number BBPTELEXTCHAR10CHAR10
FAX_NUMBERFax number BBPFAXNUMCHAR30TEXT30
E_MAILE-mail address BBPSMTPADRCHAR241SXIDNAD_SMTPADR
DATFMDate format BBPDATFMCHAR1CHAR1
DCPFMDecimal notation BBP_DCPFMCHAR1CHAR1
PHOTOURL of picture BBPPHOTOCHAR135CHAR135
APPROVE_INDApproval indicator for creating a user BBPAPPROVECHAR1CHANGEFLAG
SECRETARYUser ID in Internet user master WWWOBJIDCHAR16Assigned to domainALPHAWWWOBJIDUID
PASSWORDProposed password for component user BBP_PASSWDCHAR8TEXT8
ITS_DESTINATIONName of host IACHOSTCHAR132IACVALUE
GROUP_NOCurrent tree node number BBPNODENOCHAR16BBPNODENO
ORG_UNITObject ID OBJEKTIDNUMC8NUM08PON
CHANGED_GROUPGroup number from PID tree BBPGROUPNOCHAR16BBPNODENO
CHANGED_ORGUser Name in User Master Record XUBNAMECHAR12Assigned to domainXUBNAMEXUS
FORWARD_WIGeneral Flag FLAGCHAR1FLAG
BBPPCINSProcurement card company BBPPCINSCHAR4Assigned to domainBBPPCINSPCI
PCNUMProcurement card number BBPPCNUMCHAR25Assigned to domainBBPPCNUMPCCBBP_PCMAS
HOLDER_NAMEName of procurement cardholder BBPPCNAMECHAR40CHAR40
WFAGENT2Second workflow agent ID for procurement card PCWFOBJID2CHAR12CHAR12
PCDAT_FROMProcurement card valid from date BBPPCDATFDATS8DATUM
PCDAT_TOProcurement card expiration date BBPPCDATEDATS8DATUM
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
LOC_CURRCYLocal Currency HWAERCUKY5Assigned to domainWAERS
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
COSTCENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
FLOOR_PFloor in building AD_FLOORCHAR10TEXT10
.INCLU--AP 0
DUMMY_ITEMDummy function in length 1 DUMMYCHAR1DUMMY

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 table
DATA: 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 as

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!