_ADDRESS

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 (
    COUNTRY,
    _COUNTRY,
    _FORMOFADDRESS,
    _REGION,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSCITY,
    ADDRESSCOUNTRY,
    ADDRESSCOUNTRYTEXT,
    ADDRESSEEFULLNAME,
    ADDRESSID,
    ADDRESSPERSONID,
    ADDRESSPOSTBOXUNUSABLE,
    ADDRESSREPRESENTATIONCODE,
    ADDRESSSTREETUNUSABLE,
    ADDRESSTIMEZONE,
    BUILDING,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CAREOFNAME,
    CITY_CODE,
    CITY2,
    CITYCODE,
    CITYFILETESTSTATUS,
    CITYNAME,
    CITYP_CODE,
    CITYSEARCH,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRYCODE,
    COUNTY,
    COUNTYCODE,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    DISTRICTNAME,
    FAXNUMBER,
    FLOOR,
    FORMATTEDADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    HOME_CITY,
    HOMECITYNAME,
    HOUSE_NUM2,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    LANGU,
    LOCATION,
    NAME_CO,
    NAME1,
    NAME2,
    NAME3,
    NAME4,
    NATION,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PERSON,
    PHONENUMBER,
    PO_BOX,
    PO_BOX_LOC,
    PO_BOX_NUM,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POST_CODE2,
    POST_CODE3,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGIOGROUP,
    REGION,
    REGIONALSTRUCTURECHECKSTATUS,
    ROOMNUMBER,
    SEARCHTERM1,
    SECONDARYREGION,
    SECONDARYREGIONNAME,
    SORT1,
    SORT2,
    STR_SUPPL1,
    STR_SUPPL2,
    STR_SUPPL3,
    STREETADDRNONDELIVERABLEREASON,
    STREETCODE,
    STREETNAME,
    STREETPREFIXNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSEARCH,
    STREETSUFFIXNAME,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGION,
    TERTIARYREGIONNAME,
    TITLE,
    TOWNSHIPCODE,
    TOWNSHIPNAME,
    TRANSPORTZONE,
    VILLAGENAME,
    PRIMARY KEY (COUNTRY)
);