_ADDRESS
_ADDRESS is an SAP database table in S/4HANA. It contains 107 fields.
Fields (107)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Country | AddressCountry,Country,SECONDARYREGIONNAME | 38 |
| _Country | _Country | 1 | |
| _FormOfAddress | _FormOfAddress | 1 | |
| _Region | _Region | 1 | |
| AdditionalStreetPrefixName | AdditionalStreetPrefixName | 4 | |
| AdditionalStreetSuffixName | AdditionalStreetSuffixName | 4 | |
| AddressCity | AddressCity | 1 | |
| AddressCountry | AddressCountry | 1 | |
| AddressCountryText | AddressCountryText | 1 | |
| AddresseeFullName | AddresseeFullName,FullName | 7 | |
| AddressID | AddressID | 6 | |
| AddressPersonID | AddressPersonID | 1 | |
| AddressPostBoxUnusable | AddressPostBoxUnusable | 1 | |
| AddressRepresentationCode | AddressRepresentationCode | 1 | |
| AddressStreetUnusable | AddressStreetUnusable | 1 | |
| AddressTimeZone | AddressTimeZone | 9 | |
| Building | Building,building_id | 11 | |
| BusinessPartnerName1 | BusinessPartnerName1 | 5 | |
| BusinessPartnerName2 | BusinessPartnerName2 | 4 | |
| BusinessPartnerName3 | BusinessPartnerName3 | 3 | |
| BusinessPartnerName4 | BusinessPartnerName4 | 3 | |
| CareOfName | CareOfName | 5 | |
| city_code | city | 1 | |
| city2 | district_name | 1 | |
| CityCode | CityCode | 3 | |
| CityFileTestStatus | CityFileTestStatus | 1 | |
| CityName | AddressCity,City,CityName | 39 | |
| cityp_code | district | 1 | |
| CitySearch | CitySearch | 2 | |
| CompanyPostalCode | CompanyPostalCode | 6 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 11 | |
| CountryCode | CountryCode | 1 | |
| County | County | 5 | |
| CountyCode | CountyCode | 1 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 5 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 5 | |
| District | District | 5 | |
| DistrictName | District,DistrictName | 9 | |
| FaxNumber | FaxNumber | 2 | |
| Floor | Floor,floor_id | 10 | |
| FormattedAddress | Address,FormattedAddress | 4 | |
| FormOfAddress | FormOfAddress | 9 | |
| FullName | CyrillicName,FullName | 5 | |
| home_city | additional_city_name | 1 | |
| HomeCityName | HomeCityName | 4 | |
| house_num2 | additional_house_id | 1 | |
| HouseNumber | house_num1,HouseNumber | 34 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 7 | |
| langu | correspondence_language_code | 1 | |
| location | additional_street_suffix_name | 1 | |
| name_co | care_of_name | 1 | |
| name1 | first_line_name | 1 | |
| name2 | second_line_name | 1 | |
| name3 | third_line_name | 1 | |
| name4 | fourth_line_name | 1 | |
| Nation | Nation | 2 | |
| OrganizationName1 | OrganizationName1 | 5 | |
| OrganizationName2 | OrganizationName2 | 5 | |
| OrganizationName3 | OrganizationName3 | 5 | |
| OrganizationName4 | OrganizationName4 | 5 | |
| Person | Person | 2 | |
| PhoneNumber | PhoneNumber | 3 | |
| po_box | pobox_id | 1 | |
| po_box_loc | pobox_deviating_city_name | 1 | |
| po_box_num | pobox_indicator | 1 | |
| POBox | POBox | 13 | |
| POBoxAddrNonDeliverableReason | AddressPostBoxUnusable | 1 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 5 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 5 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 5 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 5 | |
| POBoxLobbyName | POBoxLobbyName | 5 | |
| POBoxPostalCode | POBoxPostalCode | 12 | |
| post_code2 | pobox_postal_code | 1 | |
| post_code3 | company_postal_code | 1 | |
| PostalCode | post_code1,PostalCode | 38 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 5 | |
| regiogroup | region_group | 1 | |
| Region | Region,State | 26 | |
| RegionalStructureCheckStatus | CityFileTestStatus | 1 | |
| RoomNumber | room_id,RoomNumber | 10 | |
| SearchTerm1 | SearchTerm1 | 3 | |
| SecondaryRegion | CountyCode | 1 | |
| SecondaryRegionName | BPCountyText,County,SecondaryRegionName | 5 | |
| sort1 | search_term_1 | 1 | |
| sort2 | search_term_2 | 1 | |
| str_suppl1 | street_prefix_name | 1 | |
| str_suppl2 | additional_street_prefix_name | 1 | |
| str_suppl3 | street_suffix_name | 1 | |
| StreetAddrNonDeliverableReason | AddressStreetUnusable | 1 | |
| streetcode | street | 1 | |
| StreetName | Street,StreetName | 35 | |
| StreetPrefixName | StreetPrefixName | 4 | |
| StreetPrefixName1 | StreetPrefixName,StreetPrefixName1 | 4 | |
| StreetPrefixName2 | AdditionalStreetPrefixName,StreetPrefixName2 | 4 | |
| StreetSearch | StreetSearch | 2 | |
| StreetSuffixName | StreetSuffixName | 4 | |
| StreetSuffixName1 | StreetSuffixName,StreetSuffixName1 | 4 | |
| StreetSuffixName2 | AdditionalStreetSuffixName,StreetSuffixName2 | 4 | |
| TaxJurisdiction | TaxJurisdiction | 8 | |
| TertiaryRegion | TownshipCode | 1 | |
| TertiaryRegionName | TownshipName | 1 | |
| title | form_of_address | 1 | |
| TownshipCode | TownshipCode | 1 | |
| TownshipName | TownshipName | 1 | |
| TransportZone | TransportZone | 7 | |
| VillageName | HomeCityName | 1 |