_STANDARDORGANIZATIONADDRESS

_STANDARDORGANIZATIONADDRESS is an SAP database table in S/4HANA. It contains 13 fields.

Fields (13)

KeyField CDS FieldsUsed in Views
AddresseeFullName AddresseeFullName 1
AddresseeName1 AddresseeName1 1
AddresseeName2 AddresseeName2 1
AddressRepresentationCode AddressRepresentationCode 1
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
AddressTimeZone AddressTimeZone 1
CityName CityName 2
Country Country 1
HouseNumber HouseNumber 1
PostalCode PostalCode 2
Region Region 1
StreetName StreetName 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 _STANDARDORGANIZATIONADDRESS (
    ADDRESSEEFULLNAME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSREPRESENTATIONCODE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    CITYNAME,
    COUNTRY,
    HOUSENUMBER,
    POSTALCODE,
    REGION,
    STREETNAME
);