_SUPPLIER

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 _SUPPLIER (
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    BUSINESSPARTNERUUID,
    COMPANYCODE,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    _BUSINESSPARTNER,
    _SUPPLIERACCOUNTGROUP,
    _SUPPLIERACCOUNTGROUPTEXT,
    _SUPPLIERTOBUSINESSPARTNER,
    ACCOUNTINGCLERKEMAILADDRESS,
    ACCOUNTISBLOCKEDFORPOSTING,
    ADDRESSID,
    ALTERNATIVEPAYEEACCOUNTNUMBER,
    ALTERNATIVEPAYEEISALLOWED,
    BIRTHDATE,
    BPADDRCITYNAME,
    BPADDRSTREETNAME,
    BPSUPPLIERFULLNAME,
    BPSUPPLIERNAME,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    CITYNAME,
    CMMDTYEXPNSERVICEPROVIDERNAME,
    COMPANYNAME,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DATA_CTRLR1,
    DATA_CTRLR10,
    DATA_CTRLR2,
    DATA_CTRLR3,
    DATA_CTRLR4,
    DATA_CTRLR5,
    DATA_CTRLR6,
    DATA_CTRLR7,
    DATA_CTRLR8,
    DATA_CTRLR9,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELETIONINDICATOR,
    EVALDRECEIPTSETTLEMENTISACTIVE,
    FAXNUMBER,
    FULLNAME,
    INDUSTRY,
    ISBUSINESSPURPOSECOMPLETED,
    ISNATURALPERSON,
    ISONETIMEACCOUNT,
    NAME1,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYMENTISBLOCKEDFORSUPPLIER,
    PAYMENTREASON,
    PHONENUMBER1,
    PHONENUMBER2,
    POSTALCODE,
    POSTINGISBLOCKED,
    PROCMTHUBSUPPLIERNAME,
    PURCHASINGISBLOCKED,
    REGION,
    RESPONSIBLETYPE,
    SORTFIELD,
    STREETNAME,
    SUPLRPROOFOFDELIVRLVTCODE,
    SUPLRQLTYINPROCMTCERTFNVALIDTO,
    SUPLRQUALITYMANAGEMENTSYSTEM,
    SUPPLIER_NAME,
    SUPPLIERCORPORATEGROUP,
    SUPPLIERFULLNAME,
    SUPPLIERISPLANTRELEVANT,
    SUPPLIERISSUBRANGERELEVANT,
    SUPPLIERLANGUAGE,
    SUPPLIERNAME,
    SUPPLIERPLANT,
    SUPPLIERPROCUREMENTBLOCK,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBER6,
    VATREGISTRATION,
    VENDOR_BEGRU,
    XDCSET,
    PRIMARY KEY (AUTHORIZATIONGROUP, BUSINESSPARTNER, BUSINESSPARTNERUUID, COMPANYCODE, SUPPLIER, SUPPLIERACCOUNTGROUP)
);