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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | SY | MANDT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| 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 | CITYH_CODE | * |
ADRCITY
Postal cities
|
CLIENT | |
| USUSERALL | CITYH_CODE | USUSERALL | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| USUSERALL | CITYH_CODE | USUSERALL | CITYH_CODE |
ADRCITY
Postal cities
|
CITY_CODE |
| 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 | CITYP_CODE | * |
ADRCITYPRT
Postal districts
|
CLIENT | |
| USUSERALL | CITY_CODE | USUSERALL | CITY_CODE |
ADRCITY
Postal cities
|
CITY_CODE |
| USUSERALL | CITY_CODE | * |
ADRCITY
Postal cities
|
CLIENT | |
| USUSERALL | CITY_CODE | USUSERALL | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| USUSERALL | CITY_CODE2 | * |
ADRCITY
Postal cities
|
CLIENT | |
| USUSERALL | CITY_CODE2 | USUSERALL | COUNTRY |
ADRCITY
Postal cities
|
COUNTRY |
| USUSERALL | CITY_CODE2 | USUSERALL | CITY_CODE2 |
ADRCITY
Postal cities
|
CITY_CODE |
| USUSERALL | COUNTRY | * |
T005
Countries
|
MANDT | |
| USUSERALL | COUNTRY | USUSERALL | COUNTRY |
T005
Countries
|
LAND1 |
| USUSERALL | COUNTY_CODE | USUSERALL | COUNTY_CODE |
ADRCOUNTY
County codes
|
COUNTY_CODE |
| 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 | 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 | USUSERALL | DONT_USE_S |
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 | 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 | USUSERALL | NAMCOUNTRY |
T005
Countries
|
LAND1 |
| USUSERALL | NAMCOUNTRY | ADRP | CLIENT |
T005
Countries
|
MANDT |
| USUSERALL | NAMEFORMAT | USUSERALL | NAMEFORMAT |
T005N
Name formats
|
NAMEFORMAT |
| USUSERALL | NAMEFORMAT | ADRP | CLIENT |
T005N
Name formats
|
MANDT |
| USUSERALL | NAMEFORMAT | USUSERALL | NAMCOUNTRY |
T005N
Name formats
|
LAND1 |
| USUSERALL | PERSORIGIN | * |
TSAD6
Source Address or Personal Data (Business Address Services)
|
CLIENT | |
| USUSERALL | PERSORIGIN | USUSERALL | PERSORIGIN |
TSAD6
Source Address or Personal Data (Business Address Services)
|
ORIGIN |
| USUSERALL | PO_BOX_CTY | * |
T005
Countries
|
MANDT | |
| USUSERALL | PO_BOX_CTY | USUSERALL | PO_BOX_CTY |
T005
Countries
|
LAND1 |
| 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 | PO_BOX_REG | USUSERALL | PO_BOX_REG |
T005S
Taxes: Region (Province) Key
|
BLAND |
| USUSERALL | REGIOGROUP | * |
ADRREGGRP
Regional structure grouping
|
CLIENT | |
| USUSERALL | REGIOGROUP | USUSERALL | REGIOGROUP |
ADRREGGRP
Regional structure grouping
|
REGIOGROUP |
| USUSERALL | REGION | USUSERALL | REGION |
T005S
Taxes: Region (Province) Key
|
BLAND |
| USUSERALL | REGION | * |
T005S
Taxes: Region (Province) Key
|
MANDT | |
| USUSERALL | REGION | USUSERALL | COUNTRY |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| USUSERALL | STREETABBR | * |
ADRSTRTYPE
Street type
|
CLIENT | |
| USUSERALL | STREETABBR | USUSERALL | COUNTRY |
ADRSTRTYPE
Street type
|
COUNTRY |
| USUSERALL | STREETABBR | USUSERALL | STREETABBR |
ADRSTRTYPE
Street type
|
STRTYPEAB |
| USUSERALL | STREETCODE | USUSERALL | STREETCODE |
ADRSTREET
Streets
|
STRT_CODE |
| USUSERALL | STREETCODE | * |
ADRSTREET
Streets
|
CLIENT | |
| USUSERALL | STREETCODE | USUSERALL | COUNTRY |
ADRSTREET
Streets
|
COUNTRY |
| 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 | 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 | TOWNSHIP_CODE | USUSERALL | TOWNSHIP_CODE |
ADRTOWNSHIP
Township codes
|
TOWNSHIP_CODE |
| USUSERALL | TOWNSHIP_CODE | SYST | MANDT |
ADRTOWNSHIP
Township codes
|
CLIENT |
| USUSERALL | TRANSPZONE | * |
TZONE
Customers: Regional zones
|
MANDT | |
| USUSERALL | TRANSPZONE | USUSERALL | COUNTRY |
TZONE
Customers: Regional zones
|
LAND1 |
| USUSERALL | TRANSPZONE | USUSERALL | TRANSPZONE |
TZONE
Customers: Regional zones
|
ZONE1 |