I_STRPWHLDGTAXITEM

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.

-- Withholding Tax Item View For Statutory Reporting
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPWHLDGTAXITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    WITHHOLDINGTAXCODE,
    WITHHOLDINGTAXTYPE,
    _BRANCH,
    _COMPANYCODE,
    _CUSTOMER,
    _JOURNALENTRY,
    _ONETIME,
    _OPERATIONALACCTGDOCITEM,
    _REPORTINGCURRENCY,
    _SUPPLIER,
    _WITHHOLDINGTAXCODE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AGGRGDWHLDGTAXAMTINCCCRCY,
    AGGRGDWHLDGTXBASEAMTINCCCRCY,
    AMOUNTINADDITIONALCURRENCY1,
    AMOUNTINADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINLOCALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BPCUSTOMERNAME,
    BUSINESSAREA,
    BUSINESSPARTNER,
    BUSINESSPARTNERCOUNTRY,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNUMBER,
    BUSINESSPLACE,
    CASHDISCOUNTAMTINCOCODECRCY,
    CITYNAME,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGITEM,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COUNTRY,
    CREDITOR,
    CUSTOMERNAME,
    DEBITCREDITCODE,
    DEBTOR,
    DEFAULTWHLDGTXRPTGDATEISACTIVE,
    DEPENDENCYNMBROFWHLDGTAXTYPE,
    DOCUMENTDATE,
    DOCUMENTISPARTIALEXEMPTED,
    DOCUMENTITEMTEXT,
    DOCUMENTREFERENCEID,
    DOWNPAYMENTISCLEARED,
    EMAILADDRESS,
    EXCHANGERATETYPE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    GLACCOUNT,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    IN_CLRGWITHHOLDINGTAXDATE,
    IN_CLRGWITHHOLDINGTAXDOCUMENT,
    IN_REFERENCEDOCUMENTNUMBER,
    IN_WHLDGTAXRECORDTYPETRANS,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISGROSSINGUP,
    ISNATURALPERSON,
    ISREVERSAL,
    ISREVERSED,
    ISSELFWHLDGTAX,
    ITEMISREPORTINGRELEVANT,
    LANGUAGE,
    NAME,
    OFFICIALWHLDGTAXCODE,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONFOUNDATIONDATE,
    PAYMENTISNOTIFIED,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTINGDATE,
    POSTINGKEY,
    REFERENCE3IDBYBUSINESSPARTNER,
    REGION,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REVERSEDOCUMENT,
    RPTGWHLDGTXBASEAMTINCOCODECRCY,
    SEARCHTERM1,
    SENDERACCOUNTINGDOCUMENT,
    SENDERCOMPANYCODE,
    SENDERFISCALYEAR,
    SENDERLOGICALSYSTEM,
    SPECIALGLCODE,
    SPECIALGLTRANSACTIONTYPE,
    SQNTLNMBROFWHLDGTAXTYPE,
    STREETNAME,
    SUPPLIER,
    SUPPLIERRECIPIENTTYPE,
    TAXAMOUNT,
    TAXAMOUNTINADDITIONALCURRENCY1,
    TAXAMOUNTINADDITIONALCURRENCY2,
    TAXAMOUNTINCOCODECRCY,
    TAXITEMISZERORATED,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TAXSECTION,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    WHLDGTAXAMTINADDLCRCY2,
    WHLDGTAXAMTINADDLCRCY3,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINADDLCRCY2,
    WHLDGTAXBASEAMTINADDLCRCY3,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WHLDGTAXBASEISENTEREDMANUALLY,
    WHLDGTAXBASEISINHERITED,
    WHLDGTAXCERTDATE,
    WHLDGTAXDEDUCTEDNETAMOUNT,
    WHLDGTAXDOCUMENTTYPE,
    WHLDGTAXEXMPTAMTINADDLCRCY2,
    WHLDGTAXEXMPTAMTINADDLCRCY3,
    WHLDGTAXEXMPTAMTINCOCODECRCY,
    WHLDGTAXEXMPTAMTINTRANSACCRCY,
    WHLDGTAXEXMPTCERTIFICATE,
    WHLDGTAXISENTEREDMANUALLY,
    WHLDGTAXITEMSTATUS,
    WHLDGTAXRPTGDATEISACTIVE,
    WHLDGTXDDCTDNETAMTINTRANSCRCY,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXEXMPTPERCENT,
    WITHHOLDINGTAXINCOMETYPE,
    WITHHOLDINGTAXPERCENT,
    WITHHOLDINGTAXREPORTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, WITHHOLDINGTAXCODE, WITHHOLDINGTAXTYPE)
);