SAP-tabelreferentie
SADRP
Address Management: Personal DataBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel SADRP.
SAP-tabel SADRP heeft 3 primaire sleutelvelden: MANDT,ADRNR,NATIO.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
SADRP velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel ADRNR | Address | CHAR | 10 | 0 | * | ADRNR | |
| Sleutel NATIO | International address version ID | CHAR | 1 | 0 | * | INTER | |
| ANRED | Title | CHAR | 15 | 0 | ANRED | ||
| ABTEI | Addresses: Department | CHAR | 30 | 0 | DEPTM | ||
| COSTC | Addresses: Cost center | CHAR | 10 | 0 | COST_CT | ||
| ROOMN | Addresses: Room number | CHAR | 6 | 0 | ROOM_NR | ||
| BUILD | Addresses: Building number | CHAR | 6 | 0 | BUIL_NR | ||
| NAME1 | Name 1 | CHAR | 35 | 0 | NAME1_BAS | ||
| NAME2 | Name 2 | CHAR | 35 | 0 | NAME2_BAS | ||
| STDCOM | Addresses: Communication type | CHAR | 3 | 0 | COM_ART | ||
| SPRAS | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| CHNAM | Addresses: Changed by | CHAR | 12 | 0 | CH_NAM | ||
| CHDAT | Addresses: Change date | DATS | 8 | 0 | CH_DAT | ||
| CHTIM | Addresses: Changed at | TIMS | 6 | 0 | CH_TIM | ||
| CRNAM | Addresses: Created by | CHAR | 12 | 0 | CR_NAM | ||
| CRDAT | Addresses: Creation date | DATS | 8 | 0 | CR_DAT | ||
| CRTIM | Addresses: Creation time | TIMS | 6 | 0 | CR_TIM | ||
| KLASSE | Addresses: class assigned to an address | CHAR | 18 | 0 | SO_KLASSE | ||
| DBNAME | Addresses: System ID | CHAR | 10 | 0 | SYM_DST | ||
| CMPYADR | Addresses: Address Number | CHAR | 10 | 0 | SADR | CADNR | |
| ANREK | Addresses: Form of address key | CHAR | 2 | 0 | ANREK | ||
| SORT1 | Sort field | CHAR | 10 | 0 | SORTL_BAS | ||
| SORT2 | Sort field | CHAR | 20 | 0 | SORT20 | ||
| FNAME | A person's first name (Addresses) | CHAR | 35 | 0 | AD_FNAME | ||
| UCFNAME | A person's first name in uppercase (Addresses) | CHAR | 25 | 0 | AD_UCFNAME | ||
| LNAME | A person's last name (Addresses) | CHAR | 35 | 0 | AD_LNAME | ||
| UCLNAME | A person's last name (Addresses) | CHAR | 25 | 0 | AD_UCLNAME | ||
| UCABTEI | Department in Uppercase (Addresses) | CHAR | 25 | 0 | AD_UCABTEI | ||
| UCNAMECMPY | Company Name in Uppercase (Addresses) | CHAR | 25 | 0 | AD_UCNAMCP | ||
| USRTYPE | Flag: Person is internal SAP user | CHAR | 1 | 0 | AD_USRTYPE | ||
| REFNR | Address reference for alias names | CHAR | 10 | 0 | SADRP | ADRNR_REF |
/ Relaties
SADRP relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| SADRP | CMPYADR | SADR | Address Management: Company Data | MANDT |
| SADRP | CMPYADR | SADR | Address Management: Company Data | NATIO |
| SADRP | REFNR | SADRP | Address Management: Personal Data | MANDT |
| SADRP | REFNR | SADRP | Address Management: Personal Data | ADRNR |
| SADRP | REFNR | SADRP | Address Management: Personal Data | NATIO |
| SADRP | SPRAS | T002 | Language Keys (Component BC-I18) | SPRAS |