_DFLTADDRRPRSTN

42 Fields

_DFLTADDRRPRSTN is an SAP database table in S/4HANA. It contains 42 fields.

Fields (42)

KeyField CDS FieldsUsed in Views
AddresseeFullName AddresseeFullName 2
AddressTimeZone AddressTimeZone 2
Building Building 2
CareOfName CareOfName 2
CityName CityName 6
CompanyPostalCode CompanyPostalCode 2
CorrespondenceLanguage CorrespondenceLanguage 4
Country Country 6
DeliveryServiceNumber DeliveryServiceNumber 2
DeliveryServiceTypeCode DeliveryServiceTypeCode 2
DistrictName District,DistrictName 4
Floor Floor 2
FormOfAddress FormOfAddress 4
HouseNumber HouseNumber 5
HouseNumberSupplementText HouseNumberSupplementText 2
OrganizationName1 BusinessPartnerName1,OrganizationName1 2
OrganizationName2 BusinessPartnerName2,OrganizationName2 2
OrganizationName3 BusinessPartnerName3,OrganizationName3 2
OrganizationName4 BusinessPartnerName4,OrganizationName4 2
PersonFamilyName PersonFamilyName 1
PersonGivenName PersonGivenName 1
POBox POBox 4
POBoxAddrNonDeliverableReason AddressPostBoxUnusable,POBoxAddrNonDeliverableReason 2
POBoxDeviatingCityName POBoxDeviatingCityName 2
POBoxDeviatingCountry POBoxDeviatingCountry 2
POBoxDeviatingRegion POBoxDeviatingRegion 2
POBoxIsWithoutNumber POBoxIsWithoutNumber 2
POBoxLobbyName POBoxLobbyName 2
POBoxPostalCode POBoxPostalCode 4
PostalCode PostalCode 4
PrfrdCommMediumType PrfrdCommMediumType 2
Region Region 4
RoomNumber RoomNumber 2
SecondaryRegionName County,SecondaryRegionName 2
StreetName StreetAddressName,StreetName 5
StreetPrefixName1 StreetPrefixName,StreetPrefixName1 3
StreetPrefixName2 AdditionalStreetPrefixName,StreetPrefixName2 3
StreetSuffixName1 StreetSuffixName,StreetSuffixName1 3
StreetSuffixName2 AdditionalStreetSuffixName,StreetSuffixName2 3
TaxJurisdiction TaxJurisdiction 4
TransportZone TransportZone 2
VillageName HomeCityName,VillageName 2

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 _DFLTADDRRPRSTN (
    ADDRESSEEFULLNAME,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    FLOOR,
    FORMOFADDRESS,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PERSONFAMILYNAME,
    PERSONGIVENNAME,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    ROOMNUMBER,
    SECONDARYREGIONNAME,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TRANSPORTZONE,
    VILLAGENAME
);

Learn More