_ADDRESSDETAILS

_ADDRESSDETAILS is an SAP database table in S/4HANA. It contains 43 fields.

Fields (43)

KeyField CDS FieldsUsed 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
);