SAP ABAP Table BBP_USR01 (Internet user data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP-ADM (Application Component) Enterprise/Business Partner Management
     ⤷ BBP_AT (Package) Administration Tools

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BBP_USR01	Table Relationship Diagram
Short Description	Internet user data

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	USERID	☑	BBPOBJID	BBPOBJID	CHAR	16	0	User ID in SAP Business-to-Business Procurement
3	USER_TYPE	☑	BBPOBJTYPE	BBPOBJTYPE	CHAR	10	0	User Type in SAP Business-to-Business Procurement	BBPUTYP
4	FIRSTNAME	☐	BBPNAMEFIR	TEXT40	CHAR	40	0	First name
5	LASTNAME	☐	BBPNAMELAS	TEXT40	CHAR	40	0	Last name
6	TITLE	☐	BBPTITLE1	TEXT30	CHAR	30	0	Formal title
7	FORMOFADDR	☐	BBPFORMADR	TEXT30	CHAR	30	0	Form of address
8	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
9	BUILDING_P	☐	BBPBLDNG	TEXT10	CHAR	10	0	Building (number or code)
10	ROOM_NO_P	☐	BBPROOMNO	TEXT10	CHAR	10	0	Room number
11	INHOUSE_ML	☐	BBPIHMAIL	TEXT10	CHAR	10	0	Internal mail
12	TEL1_NUMBR	☐	BBPTELNUM	TEXT30	CHAR	30	0	First telephone number
13	TEL1_EXT	☐	BBPTELEXT	CHAR10	CHAR	10	0	Extension number
14	TEL2_NUMBR	☐	BBPTELNUM2	TEXT30	CHAR	30	0	Second telephone number
15	TEL2_EXT	☐	BBPTELEXT	CHAR10	CHAR	10	0	Extension number
16	FAX_NUMBER	☐	BBPFAXNUM	TEXT30	CHAR	30	0	Fax number
17	E_MAIL	☐	BBPSMTPADR	AD_SMTPADR	CHAR	241	0	E-mail address
18	DATFM	☐	BBPDATFM	CHAR1	CHAR	1	0	Date format
19	DCPFM	☐	BBP_DCPFM	CHAR1	CHAR	1	0	Decimal notation
20	PHOTO	☐	BBPPHOTO	CHAR135	CHAR	135	0	URL of picture
21	APPROVE_IND	☐	BBPAPPROVE	CHANGEFLAG	CHAR	1	0	Approval indicator for creating a user
22	SECRETARY	☐	WWWOBJID	WWWOBJID	CHAR	16	0	User ID in Internet user master	*
23	PASSWORD	☐	BBP_PASSWD	TEXT8	CHAR	8	0	Proposed password for component user
24	ITS_DESTINATION	☐	IACHOST	IACVALUE	CHAR	132	0	Name of host
25	GROUP_NO	☐	BBPNODENO	BBPNODENO	CHAR	16	0	Current tree node number
26	ORG_UNIT	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
27	CHANGED_GROUP	☐	BBPGROUPNO	BBPNODENO	CHAR	16	0	Group number from PID tree
28	CHANGED_ORG	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
29	FORWARD_WI	☐	FLAG	FLAG	CHAR	1	0	General Flag
30	BBPPCINS	☐	BBPPCINS	BBPPCINS	CHAR	4	0	Procurement card company	*
31	PCNUM	☐	BBPPCNUM	BBPPCNUM	CHAR	25	0	Procurement card number	*
32	HOLDER_NAME	☐	BBPPCNAME	CHAR40	CHAR	40	0	Name of procurement cardholder
33	WFAGENT2	☐	PCWFOBJID2	CHAR12	CHAR	12	0	Second workflow agent ID for procurement card
34	PCDAT_FROM	☐	BBPPCDATF	DATUM	DATS	8	0	Procurement card valid from date
35	PCDAT_TO	☐	BBPPCDATE	DATUM	DATS	8	0	Procurement card expiration date
36	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
37	LOC_CURRCY	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
38	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
39	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
40	FLOOR_P	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
41	.INCLU--AP	☐				0	0	Customer modification via user exit
42	DUMMY_ITEM	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BBP_USR01	LANGU	T002	SPRAS
2	BBP_USR01	USER_TYPE	BBPUTYP	BBPUSERTYPE

History

Last changed by/on	SAP	20130604
SAP Release Created in