SAP ABAP Table CRMT_ISA_UA_IUSER_DATA (User Management: Internet User Data)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISA (Application Component) Internet Sales
     ⤷ CRM_ISALES (Package) CRM Internet Sales
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_ISA_UA_IUSER_DATA   Table Relationship Diagram
Short Description User Management: Internet User Data    
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 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
2 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
3 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
4 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
5 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
6 NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
7 NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
8 NAME3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
9 NAME4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
10 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key *
11 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
12 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
13 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
14 TITLELETTER BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
15 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
16 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
17 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
18 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
19 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
20 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
21 NAMCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
22 SEX BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
23 BIRTHPLACE BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
24 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
25 DEATHDATE BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
26 MARITALSTATUS BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
27 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
28 EMPLOYER BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
29 OCCUPATION BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group *
30 NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
31 NATIONALITYISO INTCA INTCA CHAR 2   0   Country ISO code  
32 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
33 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
34 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
35 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
36 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
37 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
38 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
39 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
40 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
41 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
42 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
43 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
44 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
45 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
46 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
47 PO_CTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
48 STREET AD_STREET TEXT60 CHAR 60   0   Street  
49 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
50 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
51 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
52 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
53 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
54 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
55 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
56 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
57 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
58 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
59 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
60 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
61 COUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
62 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
63 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
64 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
65 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
66 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
67 LANGU SPRAS SPRAS LANG 1   0   Language Key *
68 LANGUISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
69 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
70 TELEPHONE AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
71 TEL_EXTENSION AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
72 TEL_NO AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
73 FAX AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
74 FAX_EXTENSION AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
75 FAX_NO AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
76 E_MAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
77 .INCLUDE       0   0   Internet Sales: Descriptions  
78 LANGU_TEXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
79 TITLE_TEXT AD_TITLETX TEXT30 CHAR 30   0   Title text  
80 ACA_TITLE_TEXT AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
81 REGION_TEXT CRMT_DESCRIPTION_20 TEXT20 CHAR 20   0   Description (20 Characters)  
82 COUNTRY_TEXT LANDX TEXT15 CHAR 15   0   Country Name  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_ISA_UA_IUSER_DATA MARITALSTATUS TB027 MARST 1 CN
2 CRMT_ISA_UA_IUSER_DATA NAMCOUNTRY T005 LAND1 REF C CN
3 CRMT_ISA_UA_IUSER_DATA NAMEFORMAT T005N NAMEFORMAT REF C CN
4 CRMT_ISA_UA_IUSER_DATA POBOX_CTRY T005 LAND1 REF C CN
5 CRMT_ISA_UA_IUSER_DATA PO_BOX_REG T005S BLAND C CN
6 CRMT_ISA_UA_IUSER_DATA PREFIX1 TSAD4 PREFIX_KEY    
7 CRMT_ISA_UA_IUSER_DATA PREFIX2 TSAD4 PREFIX_KEY    
8 CRMT_ISA_UA_IUSER_DATA REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
9 CRMT_ISA_UA_IUSER_DATA REGION T005S BLAND REF C CN
10 CRMT_ISA_UA_IUSER_DATA STR_ABBR ADRSTRTYPE STRTYPEAB REF C CN
11 CRMT_ISA_UA_IUSER_DATA TIME_ZONE TTZZ TZONE REF C CN
12 CRMT_ISA_UA_IUSER_DATA TITLE_ACA1 TSAD2 TITLE_KEY    
13 CRMT_ISA_UA_IUSER_DATA TITLE_ACA2 TSAD2 TITLE_KEY    
14 CRMT_ISA_UA_IUSER_DATA TITLE_SPPL TSAD5 TITLE_KEY    
History
Last changed by/on SAP  20140117 
SAP Release Created in 310