_BUSINESSPARTNER

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 _BUSINESSPARTNER (
    BUSINESSPARTNER,
    _ACADEMICTITLETEXT,
    _ACADEMICTITLEVALUEHELP,
    _ACADEMICTITLEVH,
    _AUTHORIZATIONGROUP,
    _BPAUTHORIZATIONGROUPVH,
    _BPCATHELPTEXT,
    _BPGENDERTEXT,
    _BPGROUPINGTEXT,
    _BUSINESSPARTNERCATEGORY,
    _CATEGORYVALUEHELP,
    _COUNTRYTEXT,
    _COUNTRYVH,
    _FORMOFADDRORGVALUEHELP,
    _FORMOFADDRPERSNVALUEHELP,
    _GENDERVALUEHELP,
    _GROUPINGVALUEHELP,
    _LEGALFORMTEXT,
    _LEGALFORMVALUEHELP,
    ACADEMICTITLE,
    ACADEMICTITLE2,
    ACADEMICTITLENAME,
    ADDITIONALLASTNAME,
    AUTHORIZATIONGROUP,
    BIRTHDATE,
    BPCUSTMULTIADDRISACTIVE,
    BPFIRSTNAMESEARCHHELP,
    BPLASTNAMESEARCHHELP,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCATEGORYTEXT,
    BUSINESSPARTNERFOREDIT,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERGROUPING,
    BUSINESSPARTNERID,
    BUSINESSPARTNERIDBYEXTSYSTEM,
    BUSINESSPARTNERISBLOCKED,
    BUSINESSPARTNERISNOTRELEASED,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNEROCCUPATION,
    BUSINESSPARTNERTYPE,
    BUSINESSPARTNERUUID,
    BUSPARTADDRLANGUAGEISHIDDEN,
    BUSPARTGROUPDATAISHIDDEN,
    BUSPARTMARITALSTATUS,
    BUSPARTNATIONALITY,
    BUSPARTORGDATAISHIDDEN,
    BUSPARTPERSONDATAISHIDDEN,
    CITYNAME,
    COMPANYNAME,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTRYNAME,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    EMAILADDRESS,
    ENVRMTWASTEPARTNERFIRSTNAME,
    ENVRMTWASTEPARTNERLASTNAME,
    ENVRMTWASTEPARTNERNAME,
    FIRSTNAME,
    FORMOFADDRESS,
    FORMOFADDRESSORGANIZATION,
    FORMOFADDRESSPERSON,
    FULLNAME,
    GENDERCODENAME,
    GROUPBUSINESSPARTNERNAME1,
    GROUPBUSINESSPARTNERNAME2,
    HOUSENUMBER,
    INDEPENDENTADDRESSID,
    INDUSTRY,
    INTERNATIONALLOCATIONNUMBER1,
    ISBUSINESSPURPOSECOMPLETED,
    ISFEMALE,
    ISMALE,
    ISMARKEDFORARCHIVING,
    ISNATURALPERSON,
    ISNOTCONTRACTUALLYCAPABLE,
    ISSEXUNKNOWN,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LASTNAME,
    LEGALFORM,
    MDCHGPROCESSACTIVATIONTARGET,
    MDCHGPROCESSREPLICATIONSTATUS,
    MDCHGPROCESSVALIDATIONSTATUS,
    MIDDLENAME,
    NAMECOUNTRY,
    NAMEFORMAT,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    ORGANIZATIONFOUNDATIONDATE,
    ORGANIZATIONLIQUIDATIONDATE,
    PERSONFULLNAME,
    PERSONNUMBER,
    PHONENUMBER,
    PLANT,
    POSTALCODE,
    REGION,
    SEARCHTERM1,
    SEARCHTERM2,
    STREETNAME,
    TRADINGPARTNER,
    PRIMARY KEY (BUSINESSPARTNER)
);