IBUSINESSUSER_D - I_BUSINESSUSERTP I_BUSINESSUSERTP

I_BUSINESSUSERTP I_BUSINESSUSERTP information is stored in SAP table IBUSINESSUSER_D.
It is part of development package FS4_BPU_ODATA in software component CA-GTF-BUM. This development package consists of objects that can be grouped under "Cross Applications Foundation Business Partner OData".

Fields for table IBUSINESSUSER_D

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUSINESSPARTNERUUID	Business Partner GUID	X	BU_PARTNER_GUID	RAW	16
BUSINESSPARTNER	Business Partner Number		BU_PARTNER	CHAR	20
BUSINESSPARTNERROLECATEGORY	BP Role Category		BU_PARTNERROLECAT	CHAR	12
BUSINESSPARTNERROLE	BP Role		BU_PARTNERROLE	CHAR	12
PERSONNUMBER	Person Number		AD_PERSNUM	CHAR	20
PERSONEXTERNALID	Identification Number		BU_ID_NUMBER	CHAR	120
FORMOFADDRESS	Form-of-Address Key		AD_TITLE	CHAR	8
FIRSTNAME	First name of business partner (person)		BU_NAMEP_F	CHAR	80
LASTNAME	Last name of business partner (person)		BU_NAMEP_L	CHAR	80
VALIDITYSTARTDATE	Validity Start of a BP Role		BU_ROLE_VALID_FROM	DEC	8
VALIDITYENDDATE	Validity End of a BP Role		BU_ROLE_VALID_TO	DEC	8
ISMARKEDFORARCHIVING	Central Archiving Flag		BU_XDELE	CHAR	2
USERID	User ID		VDM_USERID	CHAR	24
USERNAME	Internet user alias		USALIAS	CHAR	80
USERDESCRIPTION	User Description		VDM_USERDESCRIPTION	CHAR	160
BUSINESSPARTNERCOMPANYBUR025	Business Partner Number		BU_PARTNER	CHAR	20
BUSINESSPARTNERCOMPANYBUR028	Business Partner Number		BU_PARTNER	CHAR	20
EMAILADDRESS	E-Mail Address		AD_SMTPADR	CHAR	482
CORRESPONDENCELANGUAGE	Business Partner: Correspondence Language		BU_LANGU_CORR	LANG	2
DESTINATIONLOCATIONCOUNTRY	Country/Region for Telephone/Fax Number		AD_COMCTRY	CHAR	6
PHONENUMBER	Telephone no.: dialling code+number		AD_TLNMBR	CHAR	60
PHONENUMBEREXTENSION	Telephone no.: Extension		AD_TLXTNS	CHAR	20
MBLPHONEDESTINATIONLOCCOUNTRY	Country/Region for Telephone/Fax Number		AD_COMCTRY	CHAR	6
MOBILEPHONENUMBER	Telephone no.: dialling code+number		AD_TLNMBR	CHAR	60
FAXNUMBERCOUNTRY	Country/Region for Telephone/Fax Number		AD_COMCTRY	CHAR	6
FAXAREACODESUBSCRIBERNUMBER	Fax number: dialling code+number		AD_FXNMBR	CHAR	60
FAXEXTENSIONNUMBER	Fax no.: Extension		AD_FXXTNS	CHAR	20
BUILDING	Building (number or code)		AD_BLDNG_P	CHAR	20
ROOMNUMBER	Room or Apartment Number		AD_ROOMNUM	CHAR	20
DEPARTMENT	Department		AD_DPRTMNT	CHAR	80
FUNCTIONALTITLENAME	Function		AD_FNCTN	CHAR	80
ADDITIONALLASTNAME	Other Last Name of a Person		BU_NAMEPL2	CHAR	80
LASTNAMEPREFIX	Name Prefix (Key)		AD_PREFIX	CHAR	8
LASTNAMESECONDPREFIX	2nd name prefix (key)		AD_PREFIX2	CHAR	8
BIRTHNAME	Name at birth of business partner		BU_BIRTHNM	CHAR	80
NICKNAME	Nickname of Business Partner (Person)		BU_NICKNAM	CHAR	80
MIDDLENAME	Middle name or second forename of a person		BU_NAMEMID	CHAR	80
ACADEMICTITLE	Academic Title: Key		AD_TITLE1	CHAR	8
ACADEMICSECONDTITLE	Second academic title (key)		AD_TITLE2	CHAR	8
NAMESUPPLEMENT	Name supplement, e.g. noble title (key)		AD_TITLES	CHAR	8
INITIALS	"Middle Initial" or personal initials		AD_INITS	CHAR	20
PERSONFULLNAME	Full Name of Person		AD_NAMTEXT	CHAR	160
AUTHORIZATIONGROUP	Authorization Group		BU_AUGRP	CHAR	8
CREATIONDATETIME				CHAR	28
CREATEDBYUSER	User who created the object		BU_CRUSR	CHAR	24
LASTCHANGEDATETIME				CHAR	28
LASTCHANGEDBYUSER	Last user to change object		BU_CHUSR	CHAR	24
ISBUSINESSPURPOSECOMPLETED	Business Purpose Completed Flag		BU_XPCPT	CHAR	2
ACTIVEUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2
.INCLU--AP				IBUSINESSUSER_D_EXT	0
.INCLUDE				FS4BPU_S_EXTENSION_INTERNAL	0
COSTREVENUERATECODE	Cost Rate/Revenue Rate for Project Costing		DPR_TV_RATE	CHAR	30	*