_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,
    _CITYCODE,
    _COUNTRY,
    _COUNTYCODE,
    _FORMOFADDRESS,
    _REGION,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSCITY,
    ADDRESSCITYPOSTBOXCODE,
    ADDRESSCOUNTRY,
    ADDRESSCOUNTRYTEXT,
    ADDRESSEEFULLNAME,
    ADDRESSID,
    ADDRESSPOSTBOXUNUSABLE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSSTREETUNUSABLE,
    ADDRESSTIMEZONE,
    BUILDING,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CAREOFNAME,
    CITY_CODE,
    CITY2,
    CITYCODE,
    CITYFILETESTSTATUS,
    CITYNAME,
    CITYNUMBER,
    CITYP_CODE,
    CITYSEARCH,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRYCODE,
    COUNTY,
    COUNTYCODE,
    CUSTOMERSUPPLIERCITYNAME,
    CUSTOMERSUPPLIERPOSTALCODE,
    CUSTOMERSUPPLIERSTREETNAME,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    DISTRICTNAME,
    FAXNUMBER,
    FLOOR,
    FORMATTEDADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    HOME_CITY,
    HOMECITYNAME,
    HOUSE_NUM2,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    INVGCSMADDRBIZPRPSISCMPLTD,
    INVGCSMADDRCUSTPOSTCODEEXTN,
    INVGCSMADDRDIFFNTCITYNAME,
    INVGCSMADDRDISTRICTCODE,
    INVGCSMADDRESSID,
    INVGCSMADDREXTN1TEXT,
    INVGCSMADDREXTN2TEXT,
    INVGCSMADDRHOUSENUMBERRANGE,
    INVGCSMADDRNAMECAREOFTEXT,
    INVGCSMADDRNAMETEXT,
    INVGCSMADDRORIGIN,
    INVGCSMADDRPOBOXCODEEXTN,
    INVGCSMADDRPOSTDELIVDSTRCTCODE,
    INVGCSMADDRPOSTLCODEEXTN,
    INVGCSMADDRRECDLANGCRTNCODE,
    INVGCSMADDRREGIONGROUP,
    INVGCSMADDRREMARKTEXT,
    INVGCSMADDRSORTPHONE,
    INVGCSMADDRSTABBRCODE,
    INVGCSMADDRSTCODE,
    INVGCSMADDRVALIDFROMDATE,
    INVGCSMADDRVALIDTODATE,
    LANGU,
    LOCATION,
    MC_CITY1,
    MC_COUNTY,
    MC_NAME1,
    MC_STREET,
    MC_TOWNSHIP,
    MOBILEPHONENUMBER,
    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,
    REGIONALSTRUCTUREGROUP,
    ROOMNUMBER,
    SEARCHTERM1,
    SEARCHTERM2,
    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)
);