1. Home
  2. Resources
  3. SAP Tables
  4. USUSERALL - Users with All Data for List Output

SAP Table USUSERALL

Users with All Data for List Output

USUSERALL (Users with All Data for List Output) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link USUSERALL to other SAP tables.

USUSERALL table fields

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

USUSERALL foreign key relationships

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