Table/Structure Field list used by SAP ABAP View USER_ADDR_IDAD3 (Users by Address Data (Type 3))
SAP ABAP View 
USER_ADDR_IDAD3 (Users by Address Data (Type 3)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
ADCP - BUILDING | Building (number or code) | |
| 2 | Table/Structure Field |
ADCP - BUILDING | Building (number or code) | |
| 3 | Table/Structure Field |
ADCP - DATE_TO | Valid-to date in current Release only 99991231 possible | |
| 4 | Table/Structure Field |
ADCP - DATE_TO | Valid-to date in current Release only 99991231 possible | |
| 5 | Table/Structure Field |
ADCP - DEFLT_COMM | Communication Method (Key) (Business Address Services) | |
| 6 | Table/Structure Field |
ADCP - DEFLT_COMM | Communication Method (Key) (Business Address Services) | |
| 7 | Table/Structure Field |
ADCP - DEPARTMENT | Department | |
| 8 | Table/Structure Field |
ADCP - DEPARTMENT | Department | |
| 9 | Table/Structure Field |
ADCP - FAX_EXTENS | First fax no.: extension | |
| 10 | Table/Structure Field |
ADCP - FAX_EXTENS | First fax no.: extension | |
| 11 | Table/Structure Field |
ADCP - FAX_NUMBER | First fax no.: dialling code+number | |
| 12 | Table/Structure Field |
ADCP - FAX_NUMBER | First fax no.: dialling code+number | |
| 13 | Table/Structure Field |
ADCP - FLOOR | Floor in building | |
| 14 | Table/Structure Field |
ADCP - FLOOR | Floor in building | |
| 15 | Table/Structure Field |
ADCP - FUNCTION | Function | |
| 16 | Table/Structure Field |
ADCP - FUNCTION | Function | |
| 17 | Table/Structure Field |
ADCP - ID_CODE | Short name for correspondence | |
| 18 | Table/Structure Field |
ADCP - ID_CODE | Short name for correspondence | |
| 19 | Table/Structure Field |
ADCP - IH_MAIL | Int. mail postal code | |
| 20 | Table/Structure Field |
ADCP - IH_MAIL | Int. mail postal code | |
| 21 | Table/Structure Field |
ADCP - ROOMNUMBER | Room or Appartment Number | |
| 22 | Table/Structure Field |
ADCP - ROOMNUMBER | Room or Appartment Number | |
| 23 | Table/Structure Field |
ADCP - SORT1 | (Not Supported) Search Term | |
| 24 | Table/Structure Field |
ADCP - SORT1 | (Not Supported) Search Term | |
| 25 | Table/Structure Field |
ADCP - SORT2 | (Not Supported) Search Term | |
| 26 | Table/Structure Field |
ADCP - SORT2 | (Not Supported) Search Term | |
| 27 | Table/Structure Field |
ADCP - SORT_PHN | (Not Supported) Phonetic Search Sort Field | |
| 28 | Table/Structure Field |
ADCP - SORT_PHN | (Not Supported) Phonetic Search Sort Field | |
| 29 | Table/Structure Field |
ADCP - SO_KEY | SAP-Office key | |
| 30 | Table/Structure Field |
ADCP - SO_KEY | SAP-Office key | |
| 31 | Table/Structure Field |
ADCP - TEL_EXTENS | First Telephone No.: Extension | |
| 32 | Table/Structure Field |
ADCP - TEL_EXTENS | First Telephone No.: Extension | |
| 33 | Table/Structure Field |
ADCP - TEL_NUMBER | First telephone no.: dialling code+number | |
| 34 | Table/Structure Field |
ADCP - TEL_NUMBER | First telephone no.: dialling code+number | |
| 35 | Table/Structure Field |
ADRC - ADDRESS_ID | (Not supported) Physical address ID | |
| 36 | Table/Structure Field |
ADRC - ADDRESS_ID | (Not supported) Physical address ID | |
| 37 | Table/Structure Field |
ADRC - ADDRNUMBER | Address number | |
| 38 | Table/Structure Field |
ADRC - ADDRNUMBER | Address number | |
| 39 | Table/Structure Field |
ADRC - ADDRORIGIN | (Not Supported) Address Data Source (Key) | |
| 40 | Table/Structure Field |
ADRC - ADDRORIGIN | (Not Supported) Address Data Source (Key) | |
| 41 | Table/Structure Field |
ADRC - ADDR_GROUP | Address Group (Key) (Business Address Services) | |
| 42 | Table/Structure Field |
ADRC - ADDR_GROUP | Address Group (Key) (Business Address Services) | |
| 43 | Table/Structure Field |
ADRC - BUILDING | Building (Number or Code) | |
| 44 | Table/Structure Field |
ADRC - BUILDING | Building (Number or Code) | |
| 45 | Table/Structure Field |
ADRC - CHCKSTATUS | City file test status | |
| 46 | Table/Structure Field |
ADRC - CHCKSTATUS | City file test status | |
| 47 | Table/Structure Field |
ADRC - CITY1 | City | |
| 48 | Table/Structure Field |
ADRC - CITY1 | City | |
| 49 | Table/Structure Field |
ADRC - CITY2 | District | |
| 50 | Table/Structure Field |
ADRC - CITY2 | District | |
| 51 | Table/Structure Field |
ADRC - CITYH_CODE | Different city for city/street file | |
| 52 | Table/Structure Field |
ADRC - CITYH_CODE | Different city for city/street file | |
| 53 | Table/Structure Field |
ADRC - CITYP_CODE | District code for City and Street file | |
| 54 | Table/Structure Field |
ADRC - CITYP_CODE | District code for City and Street file | |
| 55 | Table/Structure Field |
ADRC - CITY_CODE | City code for city/street file | |
| 56 | Table/Structure Field |
ADRC - CITY_CODE | City code for city/street file | |
| 57 | Table/Structure Field |
ADRC - CITY_CODE2 | City PO box code (City file) | |
| 58 | Table/Structure Field |
ADRC - CITY_CODE2 | City PO box code (City file) | |
| 59 | Table/Structure Field |
ADRC - COUNTRY | Country Key | |
| 60 | Table/Structure Field |
ADRC - COUNTRY | Country Key | |
| 61 | Table/Structure Field |
ADRC - EXTENSION1 | Extension (only for data conversion) (e.g. data line) | |
| 62 | Table/Structure Field |
ADRC - EXTENSION1 | Extension (only for data conversion) (e.g. data line) | |
| 63 | Table/Structure Field |
ADRC - EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | |
| 64 | Table/Structure Field |
ADRC - EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | |
| 65 | Table/Structure Field |
ADRC - FAX_EXTENS | First fax no.: extension | |
| 66 | Table/Structure Field |
ADRC - FAX_EXTENS | First fax no.: extension | |
| 67 | Table/Structure Field |
ADRC - FAX_NUMBER | First fax no.: dialling code+number | |
| 68 | Table/Structure Field |
ADRC - FAX_NUMBER | First fax no.: dialling code+number | |
| 69 | Table/Structure Field |
ADRC - FLOOR | Floor in building | |
| 70 | Table/Structure Field |
ADRC - FLOOR | Floor in building | |
| 71 | Table/Structure Field |
ADRC - HOME_CITY | City (different from postal city) | |
| 72 | Table/Structure Field |
ADRC - HOME_CITY | City (different from postal city) | |
| 73 | Table/Structure Field |
ADRC - HOUSE_NUM1 | House Number | |
| 74 | Table/Structure Field |
ADRC - HOUSE_NUM1 | House Number | |
| 75 | Table/Structure Field |
ADRC - HOUSE_NUM2 | House number supplement | |
| 76 | Table/Structure Field |
ADRC - HOUSE_NUM2 | House number supplement | |
| 77 | Table/Structure Field |
ADRC - HOUSE_NUM3 | (Not supported) House Number Range | |
| 78 | Table/Structure Field |
ADRC - HOUSE_NUM3 | (Not supported) House Number Range | |
| 79 | Table/Structure Field |
ADRC - LANGU | Language Key | |
| 80 | Table/Structure Field |
ADRC - LANGU | Language Key | |
| 81 | Table/Structure Field |
ADRC - LANGU_CREA | Address record creation original language | |
| 82 | Table/Structure Field |
ADRC - LANGU_CREA | Address record creation original language | |
| 83 | Table/Structure Field |
ADRC - LOCATION | Street 5 | |
| 84 | Table/Structure Field |
ADRC - LOCATION | Street 5 | |
| 85 | Table/Structure Field |
ADRC - NAME1 | Name 1 | |
| 86 | Table/Structure Field |
ADRC - NAME1 | Name 1 | |
| 87 | Table/Structure Field |
ADRC - NAME2 | Name 2 | |
| 88 | Table/Structure Field |
ADRC - NAME2 | Name 2 | |
| 89 | Table/Structure Field |
ADRC - NAME3 | Name 3 | |
| 90 | Table/Structure Field |
ADRC - NAME3 | Name 3 | |
| 91 | Table/Structure Field |
ADRC - NAME4 | Name 4 | |
| 92 | Table/Structure Field |
ADRC - NAME4 | Name 4 | |
| 93 | Table/Structure Field |
ADRC - NAME_CO | c/o name | |
| 94 | Table/Structure Field |
ADRC - NAME_CO | c/o name | |
| 95 | Table/Structure Field |
ADRC - NAME_TEXT | Converted name field (with form of address) | |
| 96 | Table/Structure Field |
ADRC - NAME_TEXT | Converted name field (with form of address) | |
| 97 | Table/Structure Field |
ADRC - PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | |
| 98 | Table/Structure Field |
ADRC - PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | |
| 99 | Table/Structure Field |
ADRC - PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | |
| 100 | Table/Structure Field |
ADRC - PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | |
| 101 | Table/Structure Field |
ADRC - PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | |
| 102 | Table/Structure Field |
ADRC - PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | |
| 103 | Table/Structure Field |
ADRC - POSTALAREA | (Not Supported) Post Delivery District | |
| 104 | Table/Structure Field |
ADRC - POSTALAREA | (Not Supported) Post Delivery District | |
| 105 | Table/Structure Field |
ADRC - POST_CODE1 | City postal code | |
| 106 | Table/Structure Field |
ADRC - POST_CODE1 | City postal code | |
| 107 | Table/Structure Field |
ADRC - POST_CODE2 | PO Box postal code | |
| 108 | Table/Structure Field |
ADRC - POST_CODE2 | PO Box postal code | |
| 109 | Table/Structure Field |
ADRC - POST_CODE3 | Company postal code (for large customers) | |
| 110 | Table/Structure Field |
ADRC - POST_CODE3 | Company postal code (for large customers) | |
| 111 | Table/Structure Field |
ADRC - PO_BOX | PO Box | |
| 112 | Table/Structure Field |
ADRC - PO_BOX | PO Box | |
| 113 | Table/Structure Field |
ADRC - PO_BOX_CTY | PO box country | |
| 114 | Table/Structure Field |
ADRC - PO_BOX_CTY | PO box country | |
| 115 | Table/Structure Field |
ADRC - PO_BOX_LOC | PO Box city | |
| 116 | Table/Structure Field |
ADRC - PO_BOX_LOC | PO Box city | |
| 117 | Table/Structure Field |
ADRC - PO_BOX_NUM | Flag: PO Box without number | |
| 118 | Table/Structure Field |
ADRC - PO_BOX_NUM | Flag: PO Box without number | |
| 119 | Table/Structure Field |
ADRC - PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | |
| 120 | Table/Structure Field |
ADRC - PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | |
| 121 | Table/Structure Field |
ADRC - REGIOGROUP | Regional structure grouping | |
| 122 | Table/Structure Field |
ADRC - REGIOGROUP | Regional structure grouping | |
| 123 | Table/Structure Field |
ADRC - REGION | Region (State, Province, County) | |
| 124 | Table/Structure Field |
ADRC - REGION | Region (State, Province, County) | |
| 125 | Table/Structure Field |
ADRC - ROOMNUMBER | Room or Appartment Number | |
| 126 | Table/Structure Field |
ADRC - ROOMNUMBER | Room or Appartment Number | |
| 127 | Table/Structure Field |
ADRC - SORT1 | Search Term 1 | |
| 128 | Table/Structure Field |
ADRC - SORT1 | Search Term 1 | |
| 129 | Table/Structure Field |
ADRC - SORT2 | Search Term 2 | |
| 130 | Table/Structure Field |
ADRC - SORT2 | Search Term 2 | |
| 131 | Table/Structure Field |
ADRC - SORT_PHN | (Not Supported) Phonetic Search Sort Field | |
| 132 | Table/Structure Field |
ADRC - SORT_PHN | (Not Supported) Phonetic Search Sort Field | |
| 133 | Table/Structure Field |
ADRC - STREET | Street | |
| 134 | Table/Structure Field |
ADRC - STREET | Street | |
| 135 | Table/Structure Field |
ADRC - STREETABBR | (Not Supported) Abbreviation of Street Name | |
| 136 | Table/Structure Field |
ADRC - STREETABBR | (Not Supported) Abbreviation of Street Name | |
| 137 | Table/Structure Field |
ADRC - STREETCODE | Street Number for City/Street File | |
| 138 | Table/Structure Field |
ADRC - STREETCODE | Street Number for City/Street File | |
| 139 | Table/Structure Field |
ADRC - STR_SUPPL1 | Street 2 | |
| 140 | Table/Structure Field |
ADRC - STR_SUPPL1 | Street 2 | |
| 141 | Table/Structure Field |
ADRC - STR_SUPPL2 | Street 3 | |
| 142 | Table/Structure Field |
ADRC - STR_SUPPL2 | Street 3 | |
| 143 | Table/Structure Field |
ADRC - STR_SUPPL3 | Street 4 | |
| 144 | Table/Structure Field |
ADRC - STR_SUPPL3 | Street 4 | |
| 145 | Table/Structure Field |
ADRC - TAXJURCODE | Tax Jurisdiction | |
| 146 | Table/Structure Field |
ADRC - TAXJURCODE | Tax Jurisdiction | |
| 147 | Table/Structure Field |
ADRC - TEL_EXTENS | First Telephone No.: Extension | |
| 148 | Table/Structure Field |
ADRC - TEL_EXTENS | First Telephone No.: Extension | |
| 149 | Table/Structure Field |
ADRC - TEL_NUMBER | First telephone no.: dialling code+number | |
| 150 | Table/Structure Field |
ADRC - TEL_NUMBER | First telephone no.: dialling code+number | |
| 151 | Table/Structure Field |
ADRC - TIME_ZONE | Address time zone | |
| 152 | Table/Structure Field |
ADRC - TIME_ZONE | Address time zone | |
| 153 | Table/Structure Field |
ADRC - TITLE | Form-of-Address Key | |
| 154 | Table/Structure Field |
ADRC - TITLE | Form-of-Address Key | |
| 155 | Table/Structure Field |
ADRC - TRANSPZONE | Transportation zone to or from which the goods are delivered | |
| 156 | Table/Structure Field |
ADRC - TRANSPZONE | Transportation zone to or from which the goods are delivered | |
| 157 | Table/Structure Field |
ADRP - ADDR_COMP | (not used) | |
| 158 | Table/Structure Field |
ADRP - ADDR_COMP | (not used) | |
| 159 | Table/Structure Field |
ADRP - CLIENT | Client | |
| 160 | Table/Structure Field |
ADRP - CLIENT | Client | |
| 161 | Table/Structure Field |
ADRP - CONVERTED | Status of Field 'Full Name' NAME_TEXT | |
| 162 | Table/Structure Field |
ADRP - CONVERTED | Status of Field 'Full Name' NAME_TEXT | |
| 163 | Table/Structure Field |
ADRP - DATE_FROM | Valid-from date - in current Release only 00010101 possible | |
| 164 | Table/Structure Field |
ADRP - DATE_FROM | Valid-from date - in current Release only 00010101 possible | |
| 165 | Table/Structure Field |
ADRP - INITIALS | "Middle Initial" or personal initials | |
| 166 | Table/Structure Field |
ADRP - INITIALS | "Middle Initial" or personal initials | |
| 167 | Table/Structure Field |
ADRP - LANGU | Language Key | |
| 168 | Table/Structure Field |
ADRP - LANGU | Language Key | |
| 169 | Table/Structure Field |
ADRP - LANGU_CREA | Address record creation original language | |
| 170 | Table/Structure Field |
ADRP - LANGU_CREA | Address record creation original language | |
| 171 | Table/Structure Field |
ADRP - NAMCOUNTRY | Country for name format rule | |
| 172 | Table/Structure Field |
ADRP - NAMCOUNTRY | Country for name format rule | |
| 173 | Table/Structure Field |
ADRP - NAME2 | Name of person at birth | |
| 174 | Table/Structure Field |
ADRP - NAME2 | Name of person at birth | |
| 175 | Table/Structure Field |
ADRP - NAMEFORMAT | Name format | |
| 176 | Table/Structure Field |
ADRP - NAMEFORMAT | Name format | |
| 177 | Table/Structure Field |
ADRP - NAMEMIDDLE | Middle name or second forename of a person | |
| 178 | Table/Structure Field |
ADRP - NAMEMIDDLE | Middle name or second forename of a person | |
| 179 | Table/Structure Field |
ADRP - NAME_FIRST | First name | |
| 180 | Table/Structure Field |
ADRP - NAME_FIRST | First name | |
| 181 | Table/Structure Field |
ADRP - NAME_LAST | Last name | |
| 182 | Table/Structure Field |
ADRP - NAME_LAST | Last name | |
| 183 | Table/Structure Field |
ADRP - NAME_LAST2 | Second surname of a person | |
| 184 | Table/Structure Field |
ADRP - NAME_LAST2 | Second surname of a person | |
| 185 | Table/Structure Field |
ADRP - NAME_TEXT | Full Name of Person | |
| 186 | Table/Structure Field |
ADRP - NAME_TEXT | Full Name of Person | |
| 187 | Table/Structure Field |
ADRP - NATION | Version ID for International Addresses | |
| 188 | Table/Structure Field |
ADRP - NATION | Version ID for International Addresses | |
| 189 | Table/Structure Field |
ADRP - NICKNAME | Nickname or name used | |
| 190 | Table/Structure Field |
ADRP - NICKNAME | Nickname or name used | |
| 191 | Table/Structure Field |
ADRP - PERSNUMBER | Person number | |
| 192 | Table/Structure Field |
ADRP - PERSNUMBER | Person number | |
| 193 | Table/Structure Field |
ADRP - PERSORIGIN | Personal data source (key) | |
| 194 | Table/Structure Field |
ADRP - PERSORIGIN | Personal data source (key) | |
| 195 | Table/Structure Field |
ADRP - PERS_GROUP | Person Group (Key) (Business Address Services) | |
| 196 | Table/Structure Field |
ADRP - PERS_GROUP | Person Group (Key) (Business Address Services) | |
| 197 | Table/Structure Field |
ADRP - PREFIX1 | Name Prefix (Key) | |
| 198 | Table/Structure Field |
ADRP - PREFIX1 | Name Prefix (Key) | |
| 199 | Table/Structure Field |
ADRP - PREFIX2 | 2nd name prefix (key) | |
| 200 | Table/Structure Field |
ADRP - PREFIX2 | 2nd name prefix (key) | |
| 201 | Table/Structure Field |
ADRP - PROFESSION | Profession | |
| 202 | Table/Structure Field |
ADRP - PROFESSION | Profession | |
| 203 | Table/Structure Field |
ADRP - SEX | Gender key | |
| 204 | Table/Structure Field |
ADRP - SEX | Gender key | |
| 205 | Table/Structure Field |
ADRP - SORT1 | Search Term 1 | |
| 206 | Table/Structure Field |
ADRP - SORT1 | Search Term 1 | |
| 207 | Table/Structure Field |
ADRP - SORT2 | Search Term 2 | |
| 208 | Table/Structure Field |
ADRP - SORT2 | Search Term 2 | |
| 209 | Table/Structure Field |
ADRP - SORT_PHN | (Not Supported) Phonetic Search Sort Field | |
| 210 | Table/Structure Field |
ADRP - SORT_PHN | (Not Supported) Phonetic Search Sort Field | |
| 211 | Table/Structure Field |
ADRP - TITLE | Form-of-Address Key | |
| 212 | Table/Structure Field |
ADRP - TITLE | Form-of-Address Key | |
| 213 | Table/Structure Field |
ADRP - TITLE_ACA1 | Academic Title: Key | |
| 214 | Table/Structure Field |
ADRP - TITLE_ACA1 | Academic Title: Key | |
| 215 | Table/Structure Field |
ADRP - TITLE_ACA2 | Second academic title (key) | |
| 216 | Table/Structure Field |
ADRP - TITLE_ACA2 | Second academic title (key) | |
| 217 | Table/Structure Field |
ADRP - TITLE_SPPL | Name supplement, e.g. noble title (key) | |
| 218 | Table/Structure Field |
ADRP - TITLE_SPPL | Name supplement, e.g. noble title (key) | |
| 219 | Table/Structure Field |
USR21 - BNAME | User Name in User Master Record | |
| 220 | Table/Structure Field |
USR21 - BNAME | User Name in User Master Record | |
| 221 | Table/Structure Field |
USR21 - IDADTYPE | Address Type of the Identity | |
| 222 | Table/Structure Field |
USR21 - IDADTYPE | Address Type of the Identity |
