_ADDRESS
_ADDRESS is an SAP database table in S/4HANA. It contains 139 fields.
Fields (139)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Country | AddressCountry,country | 37 |
| _CityCode | _CityCode | 1 | |
| _Country | _Country | 2 | |
| _CountyCode | _CountyCode | 1 | |
| _FormOfAddress | _FormOfAddress | 1 | |
| _Region | _Region | 2 | |
| AdditionalStreetPrefixName | AdditionalStreetPrefixName | 5 | |
| AdditionalStreetSuffixName | AdditionalStreetSuffixName | 5 | |
| AddressCity | AddressCity | 1 | |
| AddressCityPostBoxCode | AddressCityPostBoxCode | 1 | |
| AddressCountry | AddressCountry | 1 | |
| AddressCountryText | AddressCountryText | 1 | |
| AddresseeFullName | AddresseeFullName,FullName | 6 | |
| AddressID | AddressID | 4 | |
| AddressPostBoxUnusable | AddressPostBoxUnusable | 2 | |
| AddressStreetUnusable | AddressStreetUnusable | 2 | |
| AddressTimeZone | AddressTimeZone | 7 | |
| building | Building,building_id | 12 | |
| BusinessPartnerName1 | BusinessPartnerName1 | 9 | |
| BusinessPartnerName2 | BusinessPartnerName2 | 7 | |
| BusinessPartnerName3 | BusinessPartnerName3 | 6 | |
| BusinessPartnerName4 | BusinessPartnerName4 | 6 | |
| CareOfName | CareOfName | 5 | |
| city_code | city | 1 | |
| city2 | district_name | 1 | |
| CityCode | CityCode | 6 | |
| CityFileTestStatus | CityFileTestStatus | 2 | |
| CityName | AddressCity,City,CityName | 40 | |
| CityNumber | CityNumber | 1 | |
| cityp_code | district | 1 | |
| CitySearch | CitySearch | 3 | |
| CompanyPostalCode | CompanyPostalCode | 7 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 10 | |
| CountryCode | CountryCode | 1 | |
| County | County | 6 | |
| CountyCode | CountyCode | 2 | |
| CustomerSupplierCityName | CustomerSupplierCityName | 1 | |
| CustomerSupplierPostalCode | CustomerSupplierPostalCode | 1 | |
| CustomerSupplierStreetName | CustomerSupplierStreetName | 1 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 6 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 6 | |
| District | District | 6 | |
| DistrictName | District,DistrictName | 9 | |
| FaxNumber | FaxNumber | 2 | |
| floor | Floor,floor_id | 11 | |
| FormattedAddress | Address,FormattedAddress | 4 | |
| FormOfAddress | FormOfAddress | 8 | |
| FullName | BusinessPartner1FullName,FullName | 6 | |
| home_city | additional_city_name | 1 | |
| HomeCityName | HomeCityName | 5 | |
| house_num2 | additional_house_id | 1 | |
| HouseNumber | house_num1,HouseNumber | 34 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 8 | |
| InvgCsMAddrBizPrpsIsCmpltd | InvgCsMAddrBizPrpsIsCmpltd | 1 | |
| InvgCsMAddrCustPostCodeExtn | InvgCsMAddrCustPostCodeExtn | 1 | |
| InvgCsMAddrDiffntCityName | InvgCsMAddrDiffntCityName | 1 | |
| InvgCsMAddrDistrictCode | InvgCsMAddrDistrictCode | 1 | |
| InvgCsMAddressID | InvgCsMAddressID | 1 | |
| InvgCsMAddrExtn1Text | InvgCsMAddrExtn1Text | 1 | |
| InvgCsMAddrExtn2Text | InvgCsMAddrExtn2Text | 1 | |
| InvgCsMAddrHouseNumberRange | InvgCsMAddrHouseNumberRange | 1 | |
| InvgCsMAddrNameCareOfText | InvgCsMAddrNameCareOfText | 1 | |
| InvgCsMAddrNameText | InvgCsMAddrNameText | 1 | |
| InvgCsMAddrOrigin | InvgCsMAddrOrigin | 1 | |
| InvgCsMAddrPOBoxCodeExtn | InvgCsMAddrPOBoxCodeExtn | 1 | |
| InvgCsMAddrPostDelivDstrctCode | InvgCsMAddrPostDelivDstrctCode | 1 | |
| InvgCsMAddrPostlCodeExtn | InvgCsMAddrPostlCodeExtn | 1 | |
| InvgCsMAddrRecdLangCrtnCode | InvgCsMAddrRecdLangCrtnCode | 1 | |
| InvgCsMAddrRegionGroup | InvgCsMAddrRegionGroup | 1 | |
| InvgCsMAddrRemarkText | InvgCsMAddrRemarkText | 1 | |
| InvgCsMAddrSortPhone | InvgCsMAddrSortPhone | 1 | |
| InvgCsMAddrStAbbrCode | InvgCsMAddrStAbbrCode | 1 | |
| InvgCsMAddrStCode | InvgCsMAddrStCode | 1 | |
| InvgCsMAddrValidFromDate | InvgCsMAddrValidFromDate | 1 | |
| InvgCsMAddrValidToDate | InvgCsMAddrValidToDate | 1 | |
| langu | correspondence_language_code | 1 | |
| location | additional_street_suffix_name | 1 | |
| mc_county | mc_county | 1 | |
| mc_name1 | mc_name1 | 1 | |
| mc_township | mc_township | 1 | |
| MobilePhoneNumber | MobilePhoneNumber | 2 | |
| 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 | 3 | |
| OrganizationName1 | OrganizationName1 | 2 | |
| OrganizationName2 | OrganizationName2 | 2 | |
| OrganizationName3 | OrganizationName3 | 2 | |
| OrganizationName4 | OrganizationName4 | 2 | |
| Person | Person | 4 | |
| PhoneNumber | PhoneNumber | 5 | |
| 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 | 6 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 6 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 6 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 6 | |
| POBoxLobbyName | POBoxLobbyName | 6 | |
| POBoxPostalCode | POBoxPostalCode | 12 | |
| post_code2 | pobox_postal_code | 1 | |
| post_code3 | company_postal_code | 1 | |
| PostalCode | post_code1,PostalCode | 38 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 6 | |
| regiogroup | region_group | 1 | |
| Region | Region,State | 27 | |
| RegionalStructureCheckStatus | CityFileTestStatus | 1 | |
| roomnumber | room_id,RoomNumber | 11 | |
| SearchTerm1 | SearchTerm1 | 4 | |
| SearchTerm2 | SearchTerm2 | 1 | |
| SecondaryRegion | CountyCode | 1 | |
| SecondaryRegionName | BPCountyText,County,SecondaryRegionName | 6 | |
| sort1 | search_term_1,searchTerm1 | 2 | |
| sort2 | search_term_2,searchTerm2 | 2 | |
| 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 | 33 | |
| StreetPrefixName | StreetPrefixName | 5 | |
| StreetPrefixName1 | StreetPrefixName,StreetPrefixName1 | 3 | |
| StreetPrefixName2 | AdditionalStreetPrefixName,StreetPrefixName2 | 3 | |
| StreetSearch | StreetSearch | 3 | |
| StreetSuffixName | StreetSuffixName | 5 | |
| StreetSuffixName1 | StreetSuffixName,StreetSuffixName1 | 3 | |
| StreetSuffixName2 | AdditionalStreetSuffixName,StreetSuffixName2 | 3 | |
| TaxJurisdiction | TaxJurisdiction | 8 | |
| TertiaryRegion | TownshipCode | 1 | |
| TertiaryRegionName | TownshipName | 1 | |
| title | form_of_address | 1 | |
| TownshipCode | TownshipCode | 2 | |
| TownshipName | TownshipName | 2 | |
| TransportZone | TransportZone | 7 | |
| VillageName | HomeCityName | 1 |