WHT_ITEMS

26 Fields

WHT_ITEMS is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY WithholdingTaxType WithholdingTaxType 1
AdditionalCurrency1 AdditionalCurrency1 1
AdditionalCurrency2 AdditionalCurrency2 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
DocumentDate DocumentDate 1
IsReversal IsReversal 1
IsReversed IsReversed 1
ItemIsReportingRelevant ItemIsReportingRelevant 1
PostingDate PostingDate 1
ReportingCurrency ReportingCurrency 1
Supplier Supplier 1
TransactionCurrency TransactionCurrency 1
VATRegistration VATRegistration 1
WhldgTaxAmtInAddlCrcy2 WhldgTaxAmtInAddlCrcy2 1
WhldgTaxAmtInAddlCrcy3 WhldgTaxAmtInAddlCrcy3 1
WhldgTaxAmtInCoCodeCrcy WhldgTaxAmtInCoCodeCrcy 1
WhldgTaxAmtInTransacCrcy WhldgTaxAmtInTransacCrcy 1
WhldgTaxBaseAmtInAddlCrcy2 WhldgTaxBaseAmtInAddlCrcy2 1
WhldgTaxBaseAmtInAddlCrcy3 WhldgTaxBaseAmtInAddlCrcy3 1
WhldgTaxBaseAmtInCoCodeCrcy WhldgTaxBaseAmtInCoCodeCrcy 1
WhldgTaxBaseAmtInTransacCrcy WhldgTaxBaseAmtInTransacCrcy 1
WhldgTaxDocumentType WhldgTaxDocumentType 1

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_ITEMS (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    WITHHOLDINGTAXTYPE,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    AMOUNTINCOMPANYCODECURRENCY,
    DOCUMENTDATE,
    ISREVERSAL,
    ISREVERSED,
    ITEMISREPORTINGRELEVANT,
    POSTINGDATE,
    REPORTINGCURRENCY,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    WHLDGTAXAMTINADDLCRCY2,
    WHLDGTAXAMTINADDLCRCY3,
    WHLDGTAXAMTINCOCODECRCY,
    WHLDGTAXAMTINTRANSACCRCY,
    WHLDGTAXBASEAMTINADDLCRCY2,
    WHLDGTAXBASEAMTINADDLCRCY3,
    WHLDGTAXBASEAMTINCOCODECRCY,
    WHLDGTAXBASEAMTINTRANSACCRCY,
    WHLDGTAXDOCUMENTTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, WITHHOLDINGTAXTYPE)
);

Learn More