_ADDRESSDEFAULTREPRESENTATION

20 Fields

_ADDRESSDEFAULTREPRESENTATION is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
AddresseeFullName AddresseeFullName 1
AddresseeName1 BusinessPartnerName1 2
AddresseeName2 BusinessPartnerName2 2
AddresseeName3 BusinessPartnerName3 2
AddresseeName4 BusinessPartnerName4 2
AddressObjectType AddressObjectType 1
AddressSearchTerm1 AddressSearchTerm1 2
AddressSearchTerm2 AddressSearchTerm2 2
CityName BPAddrCityName,CityName 8
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 5
DistrictName DistrictName 2
FormOfAddress BusinessPartnerFormOfAddress 2
HouseNumber HouseNumber 3
POBoxDeviatingCityName POBoxDeviatingCityName 2
PostalCode PostalCode 4
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
StreetName BPAddrStreetName,StreetName 5
TertiaryRegionName TownshipName 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 _ADDRESSDEFAULTREPRESENTATION (
    ADDRESSEEFULLNAME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSEENAME3,
    ADDRESSEENAME4,
    ADDRESSOBJECTTYPE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    CITYNAME,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DISTRICTNAME,
    FORMOFADDRESS,
    HOUSENUMBER,
    POBOXDEVIATINGCITYNAME,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    STREETNAME,
    TERTIARYREGIONNAME
);

Learn More