SAP ABAP Table CRMT_BUPA_IL_USER (Business Partner IL: User (ISA))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-DAT (Application Component) CRM Specific Business Partner Data
     ⤷ CRM_BUPA_BOL (Package) Interaction Layer for Business Partner (From 5.1)

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BUPA_IL_USER	Table Relationship Diagram
Short Description	Business Partner IL: User (ISA)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	PERSON_ID	☐	PERSONID	PERSONID	NUMC	8	0	Technical Person Number
2	USERNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
3	NAME	☐	EMNAM	TEXT40	CHAR	40	0	Formatted Name of Employee or Applicant
4	.INCLUDE	☐				0	0	HR Employee Number
5	EMPLOYEEID	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
6	.INCLUDE	☐				0	0	User: Logon Data Transfer Structure
7	GLTGV	☐	XUGLTGV	DATUM	DATS	8	0	User valid from
8	GLTGB	☐	XUGLTGB	DATUM	DATS	8	0	User valid to
9	USTYP	☐	XUUSTYP	XUUSTYP	CHAR	1	0	User Type
10	CLASS	☐	XUCLASS	XUCLASS	CHAR	12	0	User group in user master maintenance	USGRP
11	ACCNT	☐	XUACCNT	XUACCNT	CHAR	12	0	Account ID
12	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
13	LTIME	☐	XULTIME	UZEIT	TIMS	6	0	Last Logon Time
14	BCODE	☐	XUCODE	XUCODE	RAW	8	0	Password Hash Key
15	CODVN	☐	XUCODEVERS	XUCODEVERS	CHAR	1	0	Code Version of Password Hash Algorithm (Old Systems)
16	PASSCODE	☐	PWD_SHA1	SHA1_HASH	RAW	20	0	Password Hash Value (SHA1, 160 Bit)
17	CODVC	☐	XUCODEVER2	XUCODEVER2	CHAR	1	0	Code Version of Password Hash Algorithm (New Systems)
18	PWDSALTEDHASH	☐	PWD_HASH_STRING	PWD_HASH_STRING	CHAR	255	0	Password Hash Value (Various Algorithms and Codings)
19	CODVS	☐	XUCODEVER2	XUCODEVER2	CHAR	1	0	Code Version of Password Hash Algorithm (New Systems)
20	.INCLUDE	☐				0	0	User: Fixed Values Transfer Structure
21	STCOD	☐	XUSTCOD	TCODE	CHAR	20	0	Start menu (old, replaced by XUSTART)	*
22	SPLD	☐	RSPOPNAME	RSPOPNAME	CHAR	4	0	Spool: Output device	TSP03
23	SPLG	☐	XUSPLG	XUSPLG	CHAR	1	0	Print parameter 1
24	SPDB	☐	XUSPDB	XUSPDB	CHAR	1	0	Print parameter 2
25	SPDA	☐	XUSPDA	XUSPDA	CHAR	1	0	Print parameter 3
26	DATFM	☐	XUDATFM	XUDATFM	CHAR	1	0	Date format
27	DCPFM	☐	XUDCPFM	XUDCPFM	CHAR	1	0	Decimal Format
28	LANGU	☐	XULANGU	LANG	LANG	1	0	Logon Language
29	CATTKENNZ	☐	XUCATT	XUBUTTON	CHAR	1	0	CATT: Test Status
30	KOSTL	☐	XUKOSTL	CHAR8	CHAR	8	0	Cost center
31	START_MENU	☐	XUSTART	SYCHAR30	CHAR	30	0	Start menu
32	TIMEFM	☐	XUTIMEFM	XUTIMEFM	CHAR	1	0	Time Format (12-/24-Hour Specification)
33	.INCLUDE	☐				0	0	User: Address key (CAM) for user
34	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
35	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
36	HANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
37	HANDLE_COM	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
38	.INCLUDE	☐				0	0	User name
39	REF_USER	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
40	.INCLUDE	☐				0	0	User Name Alias
41	USERALIAS	☐	USALIAS	USALIAS	CHAR	40	0	Internet user alias
42	.INCLUDE	☐				0	0	License-Related User Classification
43	LIC_TYPE	☐	USERTYPEN	USERTYP	CHAR	2	0	ID for the User Types of the SAP System	*
44	SPEC_VERS	☐	VERSIONZU	VERSIONZU	CHAR	2	0	Assignment to special version	*
45	COUNTRY_SURCHARGE	☐	USMM_DEC3	USMM_DEC3	DEC	3	0	System Measurement: Country Surcharge (3 Characters)
46	SUBSTITUTE_FROM	☐	XVONDAT	DATUM	DATS	8	0	Substitute 'from date'
47	SUBSTITUTE_UNTIL	☐	XBISDAT	DATUM	DATS	8	0	Substitute 'to date'
48	SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
49	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
50	BNAME_CHARGEABLE	☐	XANAME	XUBNAME	CHAR	12	0	Chargeable User	*
51	LOCKED	☐	BU_USER_LOCK	CHAR1	CHAR	1	0	Business Partner: User Lock
52	PASSWORD	☐	BU_PASSWORD	XUBCODE	CHAR	40	0	New Password (Repeat)
53	PASSWORD_REPEAT	☐	BU_PASSW_REPEAT	XUBCODE	CHAR	40	0	New Password (Repeat)
54	PASSWORD_INACTIVE	☐	XUMARK	XUMARK	CHAR	1	0	Selection 'X' selected, ' ' unselected

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BUPA_IL_USER	CLASS	USGRP	USERGROUP
2	CRMT_BUPA_IL_USER	SPLD	TSP03	PADEST
3	CRMT_BUPA_IL_USER	TZONE	TTZZ	TZONE

History

Last changed by/on	SAP	20130604
SAP Release Created in	510