SAP table USUSERALL (Users with All Data for List Output)

Field Description Data Type Length Decimals Checktable Data Element
BNAME User Name in User Master Record CHAR 12 0 XUBNAME
GLTGV User valid from DATS 8 0 XUGLTGV
GLTGB User valid to DATS 8 0 XUGLTGB
USTYP User Type CHAR 1 0 XUUSTYP
A Dialog
B System
C Communications Data
L Reference (Logon not possible)
S Service
CLASS User group in user master maintenance CHAR 12 0 XUCLASS
ACCNT Account ID CHAR 12 0 XUACCNT
TZONE Time Zone CHAR 6 0 TZNZONE
STCOD Start menu (old, replaced by XUSTART) CHAR 20 0 XUSTCOD
SPLD Spool: Output device CHAR 4 0 RSPOPNAME
CATTKENNZ CATT: Test Status CHAR 1 0 XUCATT
LIC_TYPE ID for the User Types of the SAP System CHAR 2 0 USERTYPEN
KOSTL Cost center CHAR 8 0 XUKOSTL
ANAME Creator of the User Master Record CHAR 12 0 XUANAME
UFLAG CHAR 70 0
REFUSER Reference user CHAR 12 0 US_REFUS
USERALIAS Internet user alias CHAR 40 0 USALIAS
PERSNUMBER Person Number CHAR 10 0 AD_PERSNUM
ADDRNUMBER Address Number CHAR 10 0 * AD_ADDRNUM
ADDRHANDLE Handle for Creating Addresses/Persons (Bus. Addr. Services) CHAR 140 0 AD_HANDLE
NATION Version ID for International Addresses CHAR 1 0 * AD_NATION
DATE Date referred to DATS 8 0 AD_DATE
PERSHANDLE Handle for Creating Addresses/Persons (Bus. Addr. Services) CHAR 140 0 AD_HANDLE
DATE_FROM Valid-from date - in current Release only 00010101 possible DATS 8 0 AD_DATE_FR
DATE_TO Valid-to date in current Release only 99991231 possible DATS 8 0 AD_DATE_TO
SO_KEY SAP-Office key CHAR 10 0 AD_SO_KEY
DEPARTMENT Department CHAR 40 0 AD_DPRTMNT
FUNCTION Function CHAR 40 0 AD_FNCTN
BUILDING_C Building (number or code) CHAR 10 0 AD_BLDNG_P
FLOOR_C Floor in building CHAR 10 0 AD_FLOOR
ROOMNUM_C Room or Apartment Number CHAR 10 0 AD_ROOMNUM
ID_CODE Short name for correspondence CHAR 10 0 AD_ID_CODE
IH_MAIL Internal Mail Postal Code CHAR 10 0 AD_IH_MAIL
SORT1_C (Not Supported) Search Term CHAR 20 0 AD_SORTOLD
SORT2_C (Not Supported) Search Term CHAR 20 0 AD_SORTOLD
SORT_PHN_C (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
TITLE_P Form-of-Address Key CHAR 4 0 TSAD3 AD_TITLE
NAME_FIRST First name CHAR 40 0 AD_NAMEFIR
NAME_LAST Last name CHAR 40 0 AD_NAMELAS
NAME2_P Name of person at birth CHAR 40 0 AD_NAME2_P
NAMEMIDDLE Middle name or second forename of a person CHAR 40 0 AD_NAMEMID
NAME_LAST2 Other Last Name of a Person CHAR 40 0 AD_NAMLAS2
NAME_TEXT Full Name of Person CHAR 80 0 AD_NAMTEXT
CONVERTED Status of Field 'Full Name' NAME_TEXT CHAR 1 0 AD_NAMCONV
Generated from the parts of the name
M Defined manually
X Converted from the previous release
TITLE_ACA1 Academic Title: Key CHAR 4 0 AD_TITLE1
TITLE_ACA2 Second academic title (key) CHAR 4 0 * AD_TITLE2
PREFIX1 Name Prefix (Key) CHAR 4 0 * AD_PREFIX
PREFIX2 2nd name prefix (key) CHAR 4 0 * AD_PREFIX2
TITLE_SPPL Name supplement, e.g. noble title (key) CHAR 4 0 * AD_TITLES
NICKNAME Nickname or name used CHAR 40 0 AD_NICKNAM
INITIALS "Middle Initial" or personal initials CHAR 10 0 AD_INITS
NAMEFORMAT Name format CHAR 2 0 T005N AD_FORMAT
NAMCOUNTRY Country/Region for Name Format Rule CHAR 3 0 T005 AD_NAMCTRY
PROFESSION Profession CHAR 40 0 AD_PROFESS
SEX Gender key CHAR 1 0 TSAD15 AD_SEX
LANGU_P Language Key LANG 1 0 T002 SPRAS
SORT1_P Search Term 1 CHAR 20 0 AD_SORT1UL
SORT2_P Search Term 2 CHAR 20 0 AD_SORT2UL
SORT_PHN_P (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
PERSORIGIN Personal data source (key) CHAR 4 0 TSAD6 AD_ORIGINP
LANGU_CR_P Address record creation original language LANG 1 0 T002 AD_LANGUCR
DEFLT_COMM Communication Method (Key) (Business Address Services) CHAR 3 0 TSAC AD_COMM
ADDR_COMP (not used) CHAR 10 0 ADRC AD_ADDRCOM
AD_COMP_HD First company address: internal ID if DB no. not yet issued CHAR 140 0 AD_COMP_HD
XPCPT Business Purpose Completed Flag CHAR 1 0 AD_XPCPT
False
X True
TITLE Form-of-Address Key CHAR 4 0 TSAD3 AD_TITLE
NAME1 Name 1 CHAR 40 0 AD_NAME1
NAME2 Name 2 CHAR 40 0 AD_NAME2
NAME3 Name 3 CHAR 40 0 AD_NAME3
NAME4 Name 4 CHAR 40 0 AD_NAME4
NAME_TXT Converted name field (with form of address) CHAR 50 0 AD_NAMETXT
NAME_CO c/o name CHAR 40 0 AD_NAME_CO
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
CITY_CODE City code for city/street file CHAR 12 0 ADRCITY AD_CITYNUM
CITYP_CODE District code for City and Street file CHAR 8 0 ADRCITYPRT AD_CITYPNM
HOME_CITY City (different from postal city) CHAR 40 0 AD_CITY3
CITYH_CODE Different city for city/street file CHAR 12 0 ADRCITY AD_CITYHNM
CHCKSTATUS City file test status CHAR 1 0 AD_CHECKST
Not Checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping CHAR 8 0 ADRREGGRP REGIOGROUP
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
POST_CODE2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
POST_CODE3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR 10 0 AD_PST1XT
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR 10 0 AD_PST2XT
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR 10 0 AD_PST3XT
PO_BOX PO Box CHAR 10 0 AD_POBX
DONT_USE_P PO Box Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USEP
PO_BOX_NUM Flag: PO Box Without Number CHAR 1 0 AD_POBXNUM
PO_BOX_LOC PO Box city CHAR 40 0 AD_POBXLOC
CITY_CODE2 City PO box code (City file) CHAR 12 0 ADRCITY AD_CIT2NUM
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) CHAR 3 0 T005S AD_POBXREG
PO_BOX_CTY PO Box of Country/Region CHAR 3 0 T005 AD_POBXCTY
POSTALAREA (Not Supported) Post Delivery District CHAR 15 0 AD_PSTLAR
TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
STREET Street CHAR 60 0 AD_STREET
DONT_USE_S Street Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USES
STREETCODE Street Number for City/Street File CHAR 12 0 ADRSTREET AD_STRNUM
STREETABBR (Not Supported) Abbreviation of Street Name CHAR 2 0 ADRSTRTYPE AD_STRABBR
HOUSE_NUM1 House Number CHAR 10 0 AD_HSNM1
HOUSE_NUM2 House number supplement CHAR 10 0 AD_HSNM2
HOUSE_NUM3 (Not supported) House Number Range CHAR 10 0 AD_HSNM3
STR_SUPPL1 Street 2 CHAR 40 0 AD_STRSPP1
STR_SUPPL2 Street 3 CHAR 40 0 AD_STRSPP2
STR_SUPPL3 Street 4 CHAR 40 0 AD_STRSPP3
LOCATION Street 5 CHAR 40 0 AD_LCTN
BUILDING Building (Number or Code) CHAR 20 0 AD_BLDNG
FLOOR Floor in building CHAR 10 0 AD_FLOOR
ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
LANGU Language Key LANG 1 0 T002 SPRAS
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
SORT1 Search Term 1 CHAR 20 0 AD_SORT1UL
SORT2 Search Term 2 CHAR 20 0 AD_SORT2UL
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
ADDRORIGIN (Not Supported) Address Data Source (Key) CHAR 4 0 TSAD6 AD_ORIGINA
EXTENSION1 Extension (only for data conversion) (e.g. data line) CHAR 40 0 AD_EXTENS1
EXTENSION2 Extension (only for data conversion) (e.g. telebox) CHAR 40 0 AD_EXTENS2
TIME_ZONE Address time zone CHAR 6 0 TTZZ AD_TZONE
TAXJURCODE Tax Jurisdiction CHAR 15 0 AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID CHAR 10 0 AD_ADDR_ID
REMARK Address notes CHAR 50 0 AD_REMARK1
LANGU_CREA Address record creation original language LANG 1 0 T002 AD_LANGUCR
PO_BOX_LOBBY PO Box Lobby CHAR 40 0 AD_PO_BOX_LBY
DELI_SERV_TYPE Type of Delivery Service CHAR 4 0 ADDRC_DELI_SERV AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR 10 0 AD_DELIVERY_SERVICE_NUMBER
COUNTY_CODE County code for county CHAR 8 0 ADRCOUNTY AD_CNTYNUM
COUNTY County CHAR 40 0 AD_COUNTY
TOWNSHIP_CODE Township code for Township CHAR 8 0 ADRTOWNSHIP AD_TWSHPNUM
TOWNSHIP Township CHAR 40 0 AD_TOWNSHIP
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
TEL_EXTENS First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
FAX_NUMBER First Fax No.: Area Code + Number CHAR 30 0 AD_FXNMBR1
FAX_EXTENS First fax no.: extension CHAR 10 0 AD_FXXTNS1
TEL_NUMCMP First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
TEL_EXTCMP First Telephone No.: Extension CHAR 10 0 AD_TLXTNS1
FAX_NUMCMP First Fax No.: Area Code + Number CHAR 30 0 AD_FXNMBR1
FAX_EXTCMP First fax no.: extension CHAR 10 0 AD_FXXTNS1
PERS_GROUP Person Group (Key) (Business Address Services) CHAR 4 0 * AD_GROUP_P
ADDR_GROUP Address Group (Key) (Business Address Services) CHAR 4 0 * AD_GROUP

USUSERALL foreign key relationships

Table Field Check Table Check Field
0 USUSERALL ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
0 USUSERALL ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
1 USUSERALL ADDR_COMP ADRC Addresses (Business Address Services) DATE_FROM
1 USUSERALL ADDR_COMP ADRC Addresses (Business Address Services) NATION
0 USUSERALL CITYH_CODE ADRCITY Postal cities COUNTRY
0 USUSERALL CITYH_CODE ADRCITY Postal cities CITY_CODE
1 USUSERALL CITYP_CODE ADRCITYPRT Postal districts CLIENT
1 USUSERALL CITYP_CODE ADRCITYPRT Postal districts COUNTRY
1 USUSERALL CITYP_CODE ADRCITYPRT Postal districts CITY_CODE
0 USUSERALL CITY_CODE ADRCITY Postal cities COUNTRY
0 USUSERALL CITY_CODE ADRCITY Postal cities CITY_CODE
1 USUSERALL CITY_CODE2 ADRCITY Postal cities COUNTRY
1 USUSERALL CITY_CODE2 ADRCITY Postal cities CITY_CODE
0 USUSERALL COUNTRY T005 Countries MANDT
0 USUSERALL COUNTRY T005 Countries LAND1
1 USUSERALL COUNTY_CODE ADRCOUNTY County codes CLIENT
1 USUSERALL COUNTY_CODE ADRCOUNTY County codes COUNTRY
1 USUSERALL COUNTY_CODE ADRCOUNTY County codes REGION
1 USUSERALL COUNTY_CODE ADRCOUNTY County codes COUNTY_CODE
0 USUSERALL DEFLT_COMM TSAC Communication Methods (Business Address Services) COMM_TYPE
1 USUSERALL DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types CLIENT
1 USUSERALL DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types DELI_SERV_TYPE
0 USUSERALL DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
0 USUSERALL DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
1 USUSERALL DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
1 USUSERALL DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
0 USUSERALL LANGU_CREA T002 Language Keys (Component BC-I18) SPRAS
1 USUSERALL LANGU_CR_P T002 Language Keys (Component BC-I18) SPRAS
0 USUSERALL LANGU_P T002 Language Keys (Component BC-I18) SPRAS
1 USUSERALL NAMCOUNTRY T005 Countries MANDT
1 USUSERALL NAMCOUNTRY T005 Countries LAND1
0 USUSERALL NAMEFORMAT T005N Name formats MANDT
0 USUSERALL NAMEFORMAT T005N Name formats LAND1
0 USUSERALL NAMEFORMAT T005N Name formats NAMEFORMAT
1 USUSERALL PERSORIGIN TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
1 USUSERALL PERSORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
0 USUSERALL PO_BOX_CTY T005 Countries MANDT
0 USUSERALL PO_BOX_CTY T005 Countries LAND1
1 USUSERALL PO_BOX_REG T005S Taxes: Region (Province) Key LAND1
0 USUSERALL REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
1 USUSERALL REGION T005S Taxes: Region (Province) Key LAND1
0 USUSERALL SEX TSAD15 Gender key (Business Address Services) GENDER
1 USUSERALL STREETABBR ADRSTRTYPE Street type CLIENT
1 USUSERALL STREETABBR ADRSTRTYPE Street type COUNTRY
0 USUSERALL STREETCODE ADRSTREET Streets CLIENT
0 USUSERALL STREETCODE ADRSTREET Streets COUNTRY
0 USUSERALL STREETCODE ADRSTREET Streets STRT_CODE
1 USUSERALL TIME_ZONE TTZZ Time zones TZONE
0 USUSERALL TITLE TSAD3 Forms of Address (Key) (Business Address Services) TITLE
1 USUSERALL TITLE_P TSAD3 Forms of Address (Key) (Business Address Services) TITLE
0 USUSERALL TOWNSHIP_CODE ADRTOWNSHIP Township codes COUNTRY
0 USUSERALL TOWNSHIP_CODE ADRTOWNSHIP Township codes REGION
0 USUSERALL TOWNSHIP_CODE ADRTOWNSHIP Township codes COUNTY_CODE
0 USUSERALL TOWNSHIP_CODE ADRTOWNSHIP Township codes TOWNSHIP_CODE
1 USUSERALL TRANSPZONE TZONE Customers: Regional zones MANDT
1 USUSERALL TRANSPZONE TZONE Customers: Regional zones LAND1
1 USUSERALL TRANSPZONE TZONE Customers: Regional zones ZONE1