| CLIENT |
✔ |
Client |
MANDT |
CLNT |
3 |
T000 |
| PERSNUMBER |
✔ |
Person number |
AD_PERSNUM |
CHAR |
10 |
|
| DATE_FROM |
✔ |
Valid-from date - in current Release only 00010101 possible |
AD_DATE_FR |
DATS |
8 |
|
| NATION |
✔ |
Version ID for International Addresses |
AD_NATION |
CHAR |
1 |
TSADV |
| DATE_TO |
|
Valid-to date in current Release only 99991231 possible |
AD_DATE_TO |
DATS |
8 |
|
| TITLE |
|
Form-of-Address Key |
AD_TITLE |
CHAR |
4 |
TSAD3 |
| NAME_FIRST |
|
First name |
AD_NAMEFIR |
CHAR |
40 |
|
| NAME_LAST |
|
Last name |
AD_NAMELAS |
CHAR |
40 |
|
| NAME2 |
|
Name of person at birth |
AD_NAME2_P |
CHAR |
40 |
|
| NAMEMIDDLE |
|
Middle name or second forename of a person |
AD_NAMEMID |
CHAR |
40 |
|
| NAME_LAST2 |
|
Second surname of a person |
AD_NAMLAS2 |
CHAR |
40 |
|
| NAME_TEXT |
|
Full Name of Person |
AD_NAMTEXT |
CHAR |
80 |
|
| CONVERTED |
|
Status of Field 'Full Name' NAME_TEXT |
AD_NAMCONV |
CHAR |
1 |
|
| TITLE_ACA1 |
|
Academic Title: Key |
AD_TITLE1 |
CHAR |
4 |
TSAD2 |
| TITLE_ACA2 |
|
Second academic title (key) |
AD_TITLE2 |
CHAR |
4 |
TSAD2 |
| PREFIX1 |
|
Name Prefix (Key) |
AD_PREFIX |
CHAR |
4 |
TSAD4 |
| PREFIX2 |
|
2nd name prefix (key) |
AD_PREFIX2 |
CHAR |
4 |
TSAD4 |
| TITLE_SPPL |
|
Name supplement, e.g. noble title (key) |
AD_TITLES |
CHAR |
4 |
TSAD5 |
| NICKNAME |
|
Nickname or name used |
AD_NICKNAM |
CHAR |
40 |
|
| INITIALS |
|
"Middle Initial" or personal initials |
AD_INITS |
CHAR |
10 |
|
| NAMEFORMAT |
|
Name format |
AD_FORMAT |
CHAR |
2 |
T005N |
| NAMCOUNTRY |
|
Country for name format rule |
AD_NAMCTRY |
CHAR |
3 |
T005 |
| PROFESSION |
|
Profession |
AD_PROFESS |
CHAR |
40 |
|
| SEX |
|
Gender key |
AD_SEX |
CHAR |
1 |
|
| LANGU |
|
Language Key |
SPRAS |
LANG |
1 |
T002 |
| PERS_GROUP |
|
Person Group (Key) (Business Address Services) |
AD_GROUP_P |
CHAR |
4 |
TSAD8 |
| FLAGGROUPS |
|
Flag: There are other person group assignments |
AD_FLGGP_P |
CHAR |
1 |
|
| SORT1 |
|
Search Term 1 |
AD_SORT1 |
CHAR |
20 |
|
| SORT2 |
|
Search Term 2 |
AD_SORT2 |
CHAR |
20 |
|
| SORT_PHN |
|
(Not Supported) Phonetic Search Sort Field |
AD_SRTPHN |
CHAR |
20 |
|
| ADDR_COMP |
|
(not used) |
AD_ADDRCOM |
CHAR |
10 |
* |
| ADDR_PERS |
|
(not used) |
AD_ADDRPER |
CHAR |
10 |
* |
| FLPERSTEL |
|
Flag: person has personal telephone numbers |
AD_FLPTEL |
CHAR |
1 |
|
| FLPERSCOMM |
|
Flag: Person has personal comm. numbers (apart from Tel.) |
AD_FLPCOMM |
CHAR |
1 |
|
| PERSORIGIN |
|
Personal data source (key) |
AD_ORIGINP |
CHAR |
4 |
TSAD6 |
| MC_NAMEFIR |
|
First name in upper case for search help |
AD_MC_NMFI |
CHAR |
25 |
|
| MC_NAMELAS |
|
Last name in upper-case for search help |
AD_MC_NMLA |
CHAR |
25 |
|
| MC_NAME2 |
|
NAME2 field in upper case for matchcode |
AD_MC_NAM2 |
CHAR |
25 |
|
| LANGU_CREA |
|
Address record creation original language |
AD_LANGUCR |
LANG |
1 |
* |
| ADRP_UUID |
|
UUID Used in the Address |
AD_UUID |
RAW |
16 |
|
| UUID_BELATED |
|
Indicator: UUID was generated later |
AD_UUID_BELATED |
CHAR |
1 |
|
| ID_CATEGORY |
|
Category of an Address ID |
AD_ID_CATEGORY |
CHAR |
1 |
|
| ADRP_ERR_STATUS |
|
Error Status of Address |
AD_ERR_STATUS |
CHAR |
1 |
|