_ADDRESS_2

18 Fields

_ADDRESS_2 is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AddressPersonID AddressPersonID 6
KEY AddressRepresentationCode AddressRepresentationCode 6
_Country _Country 1
_Region _Region 1
_TimeZone _TimeZone 1
AddresseeFullName AddresseeFullName,FullName 9
AddressID AddressID 6
AddressSearchTerm1 SearchTerm1 1
AddressSearchTerm2 SearchTerm2 1
AddressTimeZone AddressTimeZone 6
CityName CityName 12
CorrespondenceLanguage CorrespondenceLanguage 3
Country Country 12
HouseNumber HouseNumber 11
PostalCode PostalCode 11
Region Region 9
StreetName StreetName 12
TaxJurisdiction TaxJurisdiction 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 _ADDRESS_2 (
    ADDRESSPERSONID,
    ADDRESSREPRESENTATIONCODE,
    _COUNTRY,
    _REGION,
    _TIMEZONE,
    ADDRESSEEFULLNAME,
    ADDRESSID,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    CITYNAME,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    HOUSENUMBER,
    POSTALCODE,
    REGION,
    STREETNAME,
    TAXJURISDICTION,
    PRIMARY KEY (ADDRESSPERSONID, ADDRESSREPRESENTATIONCODE)
);

Learn More