_ADDRESSDETAILS
_ADDRESSDETAILS is an SAP database table in S/4HANA. It contains 43 fields.
Fields (43)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _EmailAddress | _EmailAddress | 1 | |
| _FaxNumber | _FaxNumber | 1 | |
| _MobilePhoneNumber | _MobilePhoneNumber | 1 | |
| _PhoneNumber | _PhoneNumber | 1 | |
| _URLAddress | _URLAddress | 1 | |
| AdditionalStreetPrefixName | AdditionalStreetPrefixName | 1 | |
| AdditionalStreetSuffixName | AdditionalStreetSuffixName | 1 | |
| AddressID | AddressNumber | 1 | |
| AddressTimeZone | AddressTimeZone | 1 | |
| building | Building | 1 | |
| CareOfName | CareOfName | 1 | |
| CityCode | CityCode | 1 | |
| CityName | CityName | 1 | |
| CompanyPostalCode | CompanyPostalCode | 1 | |
| Country | Country | 1 | |
| County | County | 1 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 1 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 1 | |
| District | District | 1 | |
| floor | Floor | 1 | |
| FormOfAddress | FormOfAddress | 1 | |
| FullName | FullName | 1 | |
| HomeCityName | HomeCityName | 1 | |
| HouseNumber | HouseNumber | 1 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 1 | |
| Language | Language | 1 | |
| Person | Person | 1 | |
| POBox | POBox | 1 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 1 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 1 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 1 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 1 | |
| POBoxLobbyName | POBoxLobbyName | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostalCode | PostalCode | 1 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 1 | |
| Region | Region | 1 | |
| roomnumber | RoomNumber | 1 | |
| StreetName | StreetName | 1 | |
| StreetPrefixName | StreetPrefixName | 1 | |
| StreetSuffixName | StreetSuffixName | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TransportZone | TransportZone | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _ADDRESSDETAILS (
_EMAILADDRESS,
_FAXNUMBER,
_MOBILEPHONENUMBER,
_PHONENUMBER,
_URLADDRESS,
ADDITIONALSTREETPREFIXNAME,
ADDITIONALSTREETSUFFIXNAME,
ADDRESSID,
ADDRESSTIMEZONE,
BUILDING,
CAREOFNAME,
CITYCODE,
CITYNAME,
COMPANYPOSTALCODE,
COUNTRY,
COUNTY,
DELIVERYSERVICENUMBER,
DELIVERYSERVICETYPECODE,
DISTRICT,
FLOOR,
FORMOFADDRESS,
FULLNAME,
HOMECITYNAME,
HOUSENUMBER,
HOUSENUMBERSUPPLEMENTTEXT,
LANGUAGE,
PERSON,
POBOX,
POBOXDEVIATINGCITYNAME,
POBOXDEVIATINGCOUNTRY,
POBOXDEVIATINGREGION,
POBOXISWITHOUTNUMBER,
POBOXLOBBYNAME,
POBOXPOSTALCODE,
POSTALCODE,
PRFRDCOMMMEDIUMTYPE,
REGION,
ROOMNUMBER,
STREETNAME,
STREETPREFIXNAME,
STREETSUFFIXNAME,
TAXJURISDICTION,
TRANSPORTZONE
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA