I_WITHHOLDINGTAXITEM

CDS View
41 Fields 14 CDS Views

Withholding Tax Item

I_WITHHOLDINGTAXITEM is a CDS View in S/4HANA. Withholding Tax Item. It contains 41 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
C_AR_StRpVATForm731ItemLogC view left_outer CONSUMPTION Argentina VAT Form 731 with Rptd item log data
C_TH_StRpWhldgTaxItemCube view_entity inner CONSUMPTION Withholding Tax Item View for Thailand
I_DueTaxAndWithholdingTaxItemC view left_outer COMPOSITE View to display Due Tax and Withholding Tax Items
P_CountOfSameTaxInvDoc2 view left_outer CONSUMPTION
P_DueTaxItemCountAndWhdgTaxItm view from CONSUMPTION
P_MX_DefTaxPaymntWhldngDetails view inner CONSUMPTION
P_MY_CREDITMEMO view_entity inner COMPOSITE
P_PaytRcpt_WhldgTax view_entity from COMPOSITE
P_PH_PRWithholdingTax view from COMPOSITE
P_StRpManageWhldgTaxItem view_entity from COMPOSITE
P_StRpWhldgTaxItem view_entity from COMPOSITE
P_TH_CreditMemo view_entity inner COMPOSITE
P_VE_WithholdingTaxItem view from COMPOSITE
R_MngJrnlEntrWhgdTaxItem view_entity from COMPOSITE Withholding Tax Item

Fields (41)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 5
KEY AccountingDocumentItem AccountingDocumentItem 4
KEY CompanyCode CompanyCode 5
KEY FiscalYear FiscalYear 3
KEY WithholdingTaxType WithholdingTaxType 7
_CompanyCode _CompanyCode 2
_WithholdingTaxCode _WithholdingTaxCode 1
ClearingDate ClearingDate 1
CompanyCodeCurrency CompanyCodeCurrency,ReportingCurrency 4
Country Country 2
CustomerSupplierAccount BusinessPartner,CustomerSupplierAccount 2
DocumentCurrency DocumentCurrency 4
DocumentIsPartialExempted DocumentIsPartialExempted 1
DownPaymentIsCleared DownPaymentIsCleared 1
FinancialAccountType FinancialAccountType 2
GLAccount GLAccount 2
IN_ClrgWithholdingTaxDate IN_ClrgWithholdingTaxDate 1
IN_ClrgWithholdingTaxDocument IN_ClrgWithholdingTaxDocument 1
IN_ReferenceDocumentNumber IN_ReferenceDocumentNumber 1
IN_WhldgTaxRecordTypeTrans IN_WhldgTaxRecordTypeTrans 1
IsGrossingUp IsGrossingUp 2
IsSelfWhldgTax IsSelfWhldgTax 2
RptgWhldgTxBaseAmtInCoCodeCrcy RptgWhldgTxBaseAmtInCoCodeCrcy 1
SupplierRecipientType SupplierRecipientType 3
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy 5
WhldgTaxAmtInTransacCrcy WhldgTaxAmtInTransacCrcy 2
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy 4
WhldgTaxBaseAmtInTransacCrcy WhldgTaxBaseAmtInTransacCrcy 1
WhldgTaxBaseIsEnteredManually WhldgTaxBaseIsEnteredManually 1
WhldgTaxCertDate WhldgTaxCertDate 1
WhldgTaxExmptAmtInAddlCrcy2 WhldgTaxExmptAmtInAddlCrcy2 1
WhldgTaxExmptAmtInAddlCrcy3 WhldgTaxExmptAmtInAddlCrcy3 1
WhldgTaxExmptAmtInCoCodeCrcy WhldgTaxExmptAmtInCoCodeCrcy 2
WhldgTaxExmptAmtInTransacCrcy WhldgTaxExmptAmtInTransacCrcy 1
WhldgTaxExmptCertificate WhldgTaxExmptCertificate 1
WhldgTaxIsEnteredManually WhldgTaxIsEnteredManually 1
WhldgTaxItemStatus WhldgTaxItemStatus 1
WithholdingTaxCertificate WithholdingTaxCertificate 3
WithholdingTaxCode WithholdingTaxCode 3
WithholdingTaxExmptPercent WithholdingTaxExmptPercent 1
WithholdingTaxPercent WithholdingTaxPercent 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WITHHOLDINGTAXITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    WITHHOLDINGTAXTYPE,
    _COMPANYCODE,
    _WITHHOLDINGTAXCODE,
    CLEARINGDATE,
    COMPANYCODECURRENCY,
    COUNTRY,
    CUSTOMERSUPPLIERACCOUNT,
    DOCUMENTCURRENCY,
    DOCUMENTISPARTIALEXEMPTED,
    DOWNPAYMENTISCLEARED,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    IN_CLRGWITHHOLDINGTAXDATE,
    IN_CLRGWITHHOLDINGTAXDOCUMENT,
    IN_REFERENCEDOCUMENTNUMBER,
    IN_WHLDGTAXRECORDTYPETRANS,
    ISGROSSINGUP,
    ISSELFWHLDGTAX,
    RPTGWHLDGTXBASEAMTINCOCODECRCY,
    SUPPLIERRECIPIENTTYPE,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WHLDGTAXBASEISENTEREDMANUALLY,
    WHLDGTAXCERTDATE,
    WHLDGTAXEXMPTAMTINADDLCRCY2,
    WHLDGTAXEXMPTAMTINADDLCRCY3,
    WHLDGTAXEXMPTAMTINCOCODECRCY,
    WHLDGTAXEXMPTAMTINTRANSACCRCY,
    WHLDGTAXEXMPTCERTIFICATE,
    WHLDGTAXISENTEREDMANUALLY,
    WHLDGTAXITEMSTATUS,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXCODE,
    WITHHOLDINGTAXEXMPTPERCENT,
    WITHHOLDINGTAXPERCENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, WITHHOLDINGTAXTYPE)
);

Learn More