| CLIENT |
Client |
CLNT |
3 |
0 |
T000
|
MANDT
|
|
| PERSNUMBER |
Person Number |
CHAR |
10 |
0 |
|
AD_PERSNUM
|
|
| DATE_FROM |
Valid-from date - in current Release only 00010101 possible |
DATS |
8 |
0 |
|
AD_DATE_FR
|
|
| NATION |
Version ID for International Addresses |
CHAR |
1 |
0 |
TSADV
|
AD_NATION
|
|
| DATE_TO |
Valid-to date in current Release only 99991231 possible |
DATS |
8 |
0 |
|
AD_DATE_TO
|
|
| TITLE |
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 |
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 |
TSAD2
|
AD_TITLE1
|
|
| TITLE_ACA2 |
Second academic title (key) |
CHAR |
4 |
0 |
TSAD2
|
AD_TITLE2
|
|
| PREFIX1 |
Name Prefix (Key) |
CHAR |
4 |
0 |
TSAD4
|
AD_PREFIX
|
|
| PREFIX2 |
2nd name prefix (key) |
CHAR |
4 |
0 |
TSAD4
|
AD_PREFIX2
|
|
| TITLE_SPPL |
Name supplement, e.g. noble title (key) |
CHAR |
4 |
0 |
TSAD5
|
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 |
Language Key |
LANG |
1 |
0 |
T002
|
SPRAS
|
|
| PERS_GROUP |
Person Group (Key) (Business Address Services) |
CHAR |
4 |
0 |
TSAD8
|
AD_GROUP_P
|
|
| FLAGGROUPS |
Flag: There are other person group assignments |
CHAR |
1 |
0 |
|
AD_FLGGP_P
|
|
| SORT1 |
Search Term 1 |
CHAR |
20 |
0 |
|
AD_SORT1
|
|
| SORT2 |
Search Term 2 |
CHAR |
20 |
0 |
|
AD_SORT2
|
|
| SORT_PHN |
(Not Supported) Phonetic Search Sort Field |
CHAR |
20 |
0 |
|
AD_SRTPHN
|
|
| ADDR_COMP |
(not used) |
CHAR |
10 |
0 |
|
AD_ADDRCOM
|
|
| ADDR_PERS |
(not used) |
CHAR |
10 |
0 |
|
AD_ADDRPER
|
|
| FLPERSTEL |
Flag: person has personal telephone numbers |
CHAR |
1 |
0 |
|
AD_FLPTEL
|
|
| FLPERSCOMM |
Flag: Person has personal comm. numbers (apart from Tel.) |
CHAR |
1 |
0 |
|
AD_FLPCOMM
|
|
| PERSORIGIN |
Personal data source (key) |
CHAR |
4 |
0 |
TSAD6
|
AD_ORIGINP
|
|
| MC_NAMEFIR |
First Name in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_NMFI
|
|
| MC_NAMELAS |
Last Name in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_NMLA
|
|
| MC_NAME2 |
Field NAME2 in Uppercase for Matchcode |
CHAR |
25 |
0 |
|
AD_MC_NAM2
|
|
| LANGU_CREA |
Address record creation original language |
LANG |
1 |
0 |
|
AD_LANGUCR
|
|
| ADRP_UUID |
UUID Used in the Address |
RAW |
16 |
0 |
|
AD_UUID
|
|
| UUID_BELATED |
Indicator: UUID created later |
CHAR |
1 |
0 |
|
AD_UUID_BELATED
|
|
UUID was created when the address was created |
| X |
UUID was created later |
|
| ID_CATEGORY |
Category of an Address ID |
CHAR |
1 |
0 |
|
AD_ID_CATEGORY
|
|
Normal AddressID |
| I |
Internal AddressID of Instance Sharing Address |
|
| ADRP_ERR_STATUS |
Error Status of Address |
CHAR |
1 |
0 |
|
AD_ERR_STATUS
|
|
Address is consistent |
| E |
Address contains data with errors |
| W |
Address contains data that produces warnings |
|
| _DATAAGING |
Data Filter Value for Data Aging |
DATS |
8 |
0 |
|
DATA_TEMPERATURE
|
|