WHT

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 WHT (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    WITHHOLDINGTAXCODE,
    WITHHOLDINGTAXTYPE,
    _ACCOUNTINGDOCUMENTTYPETEXT,
    _BRANCH,
    _COMPANYCODE,
    _CUSTOMER,
    _JOURNALENTRY,
    _ONETIME,
    _OPERATIONALACCTGDOCITEM,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    _TRANSACTIONTYPESTDGLACCT,
    _WITHHOLDINGTAXCODE,
    ABSOLUTEEXCHANGERATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGDOCUMENTTYPENAME,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AGGRGDWHLDGTAXAMTINCCCRCY,
    AGGRGDWHLDGTXBASEAMTINCCCRCY,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINLOCALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BPCUSTOMERNAME,
    BUSINESSAREA,
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    CASHDISCOUNTAMTINCOCODECRCY,
    CHANGEDONLONGDATETIME,
    CHARTOFACCOUNTS,
    CITIZENWHLDGTAXAMTINCOCODECRCY,
    CITYNAME,
    CLEAREDINVOICENUMBER,
    CLEAREDINVOICEYEAR,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDATECALENDARYEAR,
    CLEARINGDOCFISCALYEAR,
    CLEARINGINVOICE,
    CLEARINGITEM,
    CLEARINGJOUNRALENTRY,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    CLRDDOWNPAYMENTREQUIREDFLAG,
    CLRDPRTLPAYTREQUIREDFLAG,
    COMPANYCODENAME,
    COUNTRY,
    CREDITOR,
    CUSTOMER,
    CUSTOMERNAME,
    DEBITCREDITCODE,
    DEBTOR,
    DEFAULTWHLDGTXRPTGDATEISACTIVE,
    DEPENDENCYNMBROFWHLDGTAXTYPE,
    DOCUMENTDATE,
    DOCUMENTISPARTIALEXEMPTED,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    DOWNPAYMENTISCLEARED,
    DOWNPAYMENTREQUIREDFLAG,
    EMAILADDRESS,
    EXCHANGERATETYPE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    GLACCOUNT,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    IN_CLRGWITHHOLDINGTAXDATE,
    IN_CLRGWITHHOLDINGTAXDOCUMENT,
    IN_REFERENCEDOCUMENTNUMBER,
    IN_WHLDGTAXRECORDTYPETRANS,
    INVOICEDOCUMENT,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISGROSSINGUP,
    ISNATURALPERSON,
    ISREVERSAL,
    ISREVERSED,
    ISSELFWHLDGTAX,
    ITEMISREPORTINGRELEVANT,
    LANGUAGE,
    LASTCHANGEDBYUSER,
    NAME,
    NEWWHLDGTAXREPORTINGDATE,
    OFFICIALWHLDGTAXCODE,
    OLDWHLDGTAXREPORTINGDATE,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONFOUNDATIONDATE,
    ORIGINALREFERENCEDOCUMENT,
    PAYMENTISNOTIFIED,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTINGDATE,
    POSTINGDATEYEAR,
    POSTINGKEY,
    REFERENCE3IDBYBUSINESSPARTNER,
    REGION,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REPORTINGYEAR,
    REVERSEDOCUMENT,
    RPTGWHLDGTXBASEAMTINCOCODECRCY,
    SEARCHTERM1,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    SQNTLNMBROFWHLDGTAXTYPE,
    STATRYRPTRUNSTATUS,
    STREETNAME,
    SUPPLIER,
    SUPPLIERRECIPIENTTYPE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXITEMISINCLUDED,
    TAXITEMISZERORATED,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TAXRATE,
    TAXSECTION,
    TOTALNUMBEROFCOMMENTS,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    USERDESCRIPTION,
    VATREGISTRATION,
    WHGDTAXCALCULATIONTIMEPOINT,
    WHLDGTAXAMTINADDLCRCY2,
    WHLDGTAXAMTINADDLCRCY3,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINADDLCRCY2,
    WHLDGTAXBASEAMTINADDLCRCY3,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WHLDGTAXBASEISENTEREDMANUALLY,
    WHLDGTAXBASEISINHERITED,
    WHLDGTAXCERTDATE,
    WHLDGTAXCERTSGNTRDATE,
    WHLDGTAXCODENAME,
    WHLDGTAXDEDUCTEDNETAMOUNT,
    WHLDGTAXDOCUMENTTYPE,
    WHLDGTAXEXMPTAMTINADDLCRCY2,
    WHLDGTAXEXMPTAMTINADDLCRCY3,
    WHLDGTAXEXMPTAMTINCOCODECRCY,
    WHLDGTAXEXMPTAMTINTRANSACCRCY,
    WHLDGTAXEXMPTCERTIFICATE,
    WHLDGTAXISENTEREDMANUALLY,
    WHLDGTAXITEMSTATUS,
    WHLDGTAXREFERENCETEXT,
    WHLDGTAXRPTGDATEISACTIVE,
    WHLDGTXDDCTDNETAMTINTRANSCRCY,
    WHLDGTXINTERMEDIARYCMTMTDATE,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXDELIVERYTYPE,
    WITHHOLDINGTAXEXMPTPERCENT,
    WITHHOLDINGTAXINCOMETYPE,
    WITHHOLDINGTAXPERCENT,
    WITHHOLDINGTAXREPORTINGDATE,
    WITHHOLDINGTAXREPORTINGYEAR,
    WITHHOLDINGTAXSUPPLIERTYPE,
    WITHHOLDINGTAXTRANSACTIONYEAR,
    WITHHOLDINGTAXTYPENAME,
    WT_POSTM,
    YEARMONTH,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, WITHHOLDINGTAXCODE, WITHHOLDINGTAXTYPE)
);