_ORGNAMEPOSTALADDRESS

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 _ORGNAMEPOSTALADDRESS (
    _COUNTRY,
    _REGION,
    ADDRESSCHANGEDBYUSER,
    ADDRESSCHANGEDONDATETIME,
    ADDRESSCREATEDBYUSER,
    ADDRESSCREATEDONDATETIME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSEENAME3,
    ADDRESSEENAME4,
    ADDRESSGROUP,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    DISTRICTNUMBER,
    FLOOR,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYCODE,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    REGIONALSTRUCTURECHECKSTATUS,
    REGIONALSTRUCTUREGROUP,
    ROOMNUMBER,
    SECONDARYREGION,
    SECONDARYREGIONNAME,
    STREET,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGION,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VILLAGE,
    VILLAGENAME
);