DOC

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 DOC (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    BILLINGDOCUMENT,
    BILLINGDOCUMENTLIST,
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    COMPANYCODE,
    DOCREF,
    FISCALYEAR,
    PT_SAFTDOCUMENTNUMBER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUPPLIER,
    WITHHOLDINGTAXINCOMETYPE,
    WITHHOLDINGTAXPERCENT,
    WITHHOLDINGTAXTYPE,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _BRANCH,
    _BUSINESSPARTNER,
    _CAPROVIDERCONTRACT,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTRACTACCOUNTPARTNER,
    _CUSTOMER,
    _CUSTOMERPAYMENTTERMS,
    _FISCALYEAR,
    _JOURNALENTRY,
    _ONETIME,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    ABSOLUTEEXCHANGERATE,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BILLINGDOCUMENTDATE,
    BUSINESSAREA,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CACLEARINGDATE,
    CACONTRACT,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CAPOSTINGDATE,
    CARECONCILIATIONACCOUNT,
    CAREFERENCEDOCUMENT,
    CASHDISCOUNTAMTINCOCODECRCY,
    CASTATISTICALITEMCODE,
    CASUBAPPLICATION,
    CHARTOFACCOUNTS,
    CITYNAME,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CONTRACTACCOUNT,
    COUNTRY,
    CREATEDBYUSER,
    CREDIT,
    CREDITOR,
    CREDITTR,
    CUSTOMER,
    CUSTOMERPAYMENTTERMS,
    DEBIT,
    DEBITCREDITCODE,
    DEBITTR,
    DEBTOR,
    DEPENDENCYNMBROFWHLDGTAXTYPE,
    DMBTR_SHL,
    DOCUMENTBILLINGSTATUS,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    EMAILADDRESS,
    EXCHANGERATE,
    EXCHANGERATEDATE,
    FISCALPERIOD,
    H_HWAER,
    INPUTFISCALYEAR,
    INVOICEAMOUNTINFRGNCURRENCY,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISREVERSAL,
    ISREVERSED,
    ITEMISREPORTINGRELEVANT,
    JAHRPER,
    KALNR,
    NAME,
    OFFICIALWHLDGTAXCODE,
    ORGANIZATIONBPNAME1,
    ORIGINALREFERENCEDOCUMENT,
    PKALNR,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTINGDATE,
    POSTINGKEY,
    REFERENCE3IDBYBUSINESSPARTNER,
    REFERENCEDOCUMENTTYPE,
    REGION,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    RU_BUDGETCLASSIFICATIONCODE,
    RU_SUPPLIERKPP,
    RU_TERRITORYCLASSFCTNOKTMO,
    RU_UNIFIEDTAXNOTICEPAYMENTVERS,
    RU_UNIFIEDTAXNOTICEPERIODCODE,
    RUNREF,
    SALESDOCUMENTDATE,
    SDDOCUMENTCATEGORY,
    SEARCHTERM1,
    SEGMENT,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    STREETNAME,
    SUPPLIERNAME,
    SUPPLIERRECIPIENTTYPE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXSECTION,
    TOTALGROSSAMOUNT,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WHLDGTAXDOCUMENTTYPE,
    WITHHOLDINGTAXAMOUNT,
    WITHHOLDINGTAXBASEAMOUNT,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, BILLINGDOCUMENT, BILLINGDOCUMENTLIST, CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, COMPANYCODE, DOCREF, FISCALYEAR, PT_SAFTDOCUMENTNUMBER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUPPLIER, WITHHOLDINGTAXINCOMETYPE, WITHHOLDINGTAXPERCENT, WITHHOLDINGTAXTYPE)
);