_STANDARDADDRESS

25 Fields

_STANDARDADDRESS is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
AdditionalStreetPrefixName AdditionalStreetPrefixName 2
AdditionalStreetSuffixName AdditionalStreetSuffixName,Location 3
AddressTimeZone AddressTimeZone 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerName3 BusinessPartnerName3 1
BusinessPartnerName4 BusinessPartnerName4 1
CityName CityName 2
CompanyPostalCode CompanyPostalCode 1
CorrespondenceLanguage CorrespondenceLanguage 3
Country Country 2
District District 1
FaxNumber FaxNumber 1
HouseNumber HouseNumber 4
Person Person 1
PhoneNumber PhoneNumber 1
POBox POBox 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 2
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 2
SearchTerm1 SearchTerm1 1
SearchTerm2 SearchTerm2 1
StreetName StreetName 2
StreetPrefixName StreetPrefixName 2
StreetSuffixName StreetSuffixName 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 _STANDARDADDRESS (
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSTIMEZONE,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CITYNAME,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DISTRICT,
    FAXNUMBER,
    HOUSENUMBER,
    PERSON,
    PHONENUMBER,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    SEARCHTERM1,
    SEARCHTERM2,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSUFFIXNAME
);

Learn More