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 (
    ACCOUNTINGDOCUMENT,
    ADDRESSID,
    COMPANYCODE,
    FISCALYEAR,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXITEM,
    TAXITEMGROUPINGVERSION,
    TRANSACTIONTYPEDETERMINATION,
    _ADDRESSOBJECTTYPE,
    _ADDRESSPERSONNAME,
    _ADDRESSREPRESENTATIONCODE,
    _CORRESPONDENCELANGUAGE,
    _COUNTRY,
    _CURRENTDFLTEMAILADDRESS,
    _CURRENTDFLTFAXNUMBER,
    _CURRENTDFLTLANDLINEPHONENMBR,
    _CURRENTDFLTMOBILEPHONENUMBER,
    _DELIVERYSERVICETYPECODE,
    _EMAILADDRESS,
    _FAXNUMBER,
    _FORMOFADDRESS,
    _MAINWEBSITEURL,
    _PHONENUMBER,
    _POBOXADDRNONDELIVERABLEREASON,
    _POBOXDEVIATINGCOUNTRY,
    _POBOXDEVIATINGREGION,
    _PRFRDCOMMMEDIUMTYPE,
    _STREETADDRNONDELIVERABLERSN,
    _TAXTYPETEXT,
    _TIMEZONE,
    _TRANSPORTATIONZONE,
    _UNIFORMRESOURCEIDENTIFIER,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ADDITIONALSTREETPREFIXNAME,
    ADDRESSEEFULLNAME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    ADDRESSREPRESENTATIONCODE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINREPORTINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BUILDING,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERUUID,
    BUSINESSPLACE,
    BUSINESSPLACENAME,
    CAREOFNAME,
    CITY,
    CITYNAME,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTRYCURRENCY,
    COUNTRYNAME,
    CUSTOMERSUPPLIERADDRESS,
    DEFAULTEMAILADDRESS,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    DISTRICTNAME,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    FISCALPERIOD,
    FLOOR,
    FORMOFADDRESS,
    GLACCOUNT,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    ISREVERSAL,
    ISREVERSED,
    LATITUDE,
    LONGITUDE,
    LOWESTLEVELTAXJURISDICTION,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PAYMENTDATE,
    PAYMENTNOTE,
    PHONENUMBER,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTAL_CODE,
    POSTALCODE,
    POSTINGDATE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    REPORTINGCOUNTRY,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    ROOMNUMBER,
    SECONDARYREGIONNAME,
    STREET,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    SUPPLIERPAYTCURRENCYEXCHRATE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINRPTGCRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMTINADDITIONALCRCY1,
    TAXBASEAMTINADDITIONALCRCY2,
    TAXBOXSTRUCTURE,
    TAXCALCULATIONPROCEDURE,
    TAXISNOTDEDUCTIBLE,
    TAXITEMGROUP,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXPAYERNAME,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VALIDITYENDDATE,
    VILLAGENAME,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ADDRESSID, COMPANYCODE, FISCALYEAR, TAXBOX, TAXBOXSTRUCTURETYPE, TAXBOXSTRUCVALIDITYSTARTDATE, TAXCODE, TAXDECLNAMOUNTTYPE, TAXGROUP, TAXITEM, TAXITEMGROUPINGVERSION, TRANSACTIONTYPEDETERMINATION)
);