TCJ_WTAX_ITEMS

Transparent Table Application Table
58 Fields 1 CDS Views

Withholding Tax Items for Cash Journal Document Items

TCJ_WTAX_ITEMS is an SAP database table in S/4HANA. Withholding Tax Items for Cash Journal Document Items. It contains 58 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashJournalWhldgTaxItem view from BASIC View for table TCJ_WTAX_ITEMS

Fields (58)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
KEY cajo_number CJNR Cash Journal Number
KEY fisc_year GJAHR Fiscal Year
KEY posting_number CJBELNR Internal doc. number
KEY position_number CJBUZEI Item
KEY wtaxtype WITHT WTax Type
status CJWT_ITEM_STATUS Document status
vendor_no LIFNR Supplier
wt_key WT_KEY Grouping Key
witht WITHT WTax Type
wt_withcd WT_WITHCD W/Tax Code
wt_qsshh WT_BS W/Tax Base LC
wt_qsshb WT_BS1 W/Tax Base FC
wt_qssh2 WT_BS2 WT Base 2nd LC
wt_qssh3 WT_BS3 WT Base 3rd LC
wt_qbuihh WT_QBUIHH Manual W/Tax in LC
wt_qbuihb WT_QBUIHB Manual W/Tax in FC
wt_qbuih2 WT_QBUIH2 Manual W/Tax 2nd LC
wt_qbuih3 WT_QBUIH3 Manual W/Tax 3rd LC
wt_wdmbtr WT_AWT W/Tax Withheld (LC)
wt_wwrbtr WT_AWT1 W/Tax Withheld (FC)
wt_wdmbt2 WT_AWT2 W/Tax Withhld 2nd LC
wt_wdmbt3 WT_AWT3 W/tax amnt in 3rd LC
wt_basman WT_BASMAN W/Tax Base Man.
wt_amnman WT_AMNMAN WTax Amt Ent. Man.
wt_qbshh WT_WT WTax Amt in LC
wt_qbshb WT_WT1 WTax Amt in FC
wt_qbsh2 WT_WT2 WTax Amt 2nd LC
wt_qbsh3 WT_WT3 WTax Amt 3rd LC
wt_qbshha WT_WTA WTax Aux.Amt in LC
wt_qbshhb WT_WTB WTax Aux.Amt in LC
wt_stat WT_STAT Line Item Status
wt_qsfhh WT_EXMP WTax-Ex. Amt LC
wt_qsfhb WT_EXMP1 WTax-Ex. Amt FC
wt_qsfh2 WT_EXMP2 WTax-Ex.Amt 2nd LC
wt_qsfh3 WT_EXMP3 WTax-Ex. Amt 3rd LC
wt_wtexmn WT_EXNR Exemption Number
koart KOART Account type
wt_acco WT_ACNO Cust./Vend. Acct
hkont HKONT G/L Acct
hkont_opp HKONT G/L Acct
qsrec WT_QSREC Recipient Type
augbl AUGBL Clrng doc.
augdt AUGDT Clearing
wt_qszrt WT_EXRT Exemption Rate
text15 TEXT15 Text (15 characters)
qsatz WT_QSATZ WTax Rate
wt_slfwtpd WT_SLFWTPD Posted Self-W/Tax
wt_gruwtpd WT_GRUWTPD "Grossing Up" Pt
wt_opowtpd WT_OPOWTPD Posted as Deb./Cred.
wt_givenpd WT_GIVENPD WTax Amt Entered
ctnumber CTNUMBER WH Tax Cert. No.
wt_downc WT_DOWNC Down Payt Clearing
wt_resitem WT_RESITEM Residual Items
ctissuedate CTISSUEDATE WTax Certicate Date
wt_calc WT_CALC WT Calculated
wt_logsys WT_LOGSYS LOGSYS WTaxDet.

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 Items for Cash Journal Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCJ_WTAX_ITEMS (
    MANDT,            -- Client [MANDT]
    COMP_CODE,        -- Company Code [BUKRS]
    CAJO_NUMBER,      -- Cash Journal Number [CJNR]
    FISC_YEAR,        -- Fiscal Year [GJAHR]
    POSTING_NUMBER,   -- Internal doc. number [CJBELNR]
    POSITION_NUMBER,  -- Item [CJBUZEI]
    WTAXTYPE,         -- WTax Type [WITHT]
    STATUS,           -- Document status [CJWT_ITEM_STATUS]
    VENDOR_NO,        -- Supplier [LIFNR]
    WT_KEY,           -- Grouping Key [WT_KEY]
    WITHT,            -- WTax Type [WITHT]
    WT_WITHCD,        -- W/Tax Code [WT_WITHCD]
    WT_QSSHH,         -- W/Tax Base LC [WT_BS]
    WT_QSSHB,         -- W/Tax Base FC [WT_BS1]
    WT_QSSH2,         -- WT Base 2nd LC [WT_BS2]
    WT_QSSH3,         -- WT Base 3rd LC [WT_BS3]
    WT_QBUIHH,        -- Manual W/Tax in LC [WT_QBUIHH]
    WT_QBUIHB,        -- Manual W/Tax in FC [WT_QBUIHB]
    WT_QBUIH2,        -- Manual W/Tax 2nd LC [WT_QBUIH2]
    WT_QBUIH3,        -- Manual W/Tax 3rd LC [WT_QBUIH3]
    WT_WDMBTR,        -- W/Tax Withheld (LC) [WT_AWT]
    WT_WWRBTR,        -- W/Tax Withheld (FC) [WT_AWT1]
    WT_WDMBT2,        -- W/Tax Withhld 2nd LC [WT_AWT2]
    WT_WDMBT3,        -- W/tax amnt in 3rd LC [WT_AWT3]
    WT_BASMAN,        -- W/Tax Base Man. [WT_BASMAN]
    WT_AMNMAN,        -- WTax Amt Ent. Man. [WT_AMNMAN]
    WT_QBSHH,         -- WTax Amt in LC [WT_WT]
    WT_QBSHB,         -- WTax Amt in FC [WT_WT1]
    WT_QBSH2,         -- WTax Amt 2nd LC [WT_WT2]
    WT_QBSH3,         -- WTax Amt 3rd LC [WT_WT3]
    WT_QBSHHA,        -- WTax Aux.Amt in LC [WT_WTA]
    WT_QBSHHB,        -- WTax Aux.Amt in LC [WT_WTB]
    WT_STAT,          -- Line Item Status [WT_STAT]
    WT_QSFHH,         -- WTax-Ex. Amt LC [WT_EXMP]
    WT_QSFHB,         -- WTax-Ex. Amt FC [WT_EXMP1]
    WT_QSFH2,         -- WTax-Ex.Amt 2nd LC [WT_EXMP2]
    WT_QSFH3,         -- WTax-Ex. Amt 3rd LC [WT_EXMP3]
    WT_WTEXMN,        -- Exemption Number [WT_EXNR]
    KOART,            -- Account type [KOART]
    WT_ACCO,          -- Cust./Vend. Acct [WT_ACNO]
    HKONT,            -- G/L Acct [HKONT]
    HKONT_OPP,        -- G/L Acct [HKONT]
    QSREC,            -- Recipient Type [WT_QSREC]
    AUGBL,            -- Clrng doc. [AUGBL]
    AUGDT,            -- Clearing [AUGDT]
    WT_QSZRT,         -- Exemption Rate [WT_EXRT]
    TEXT15,           -- Text (15 characters) [TEXT15]
    QSATZ,            -- WTax Rate [WT_QSATZ]
    WT_SLFWTPD,       -- Posted Self-W/Tax [WT_SLFWTPD]
    WT_GRUWTPD,       -- "Grossing Up" Pt [WT_GRUWTPD]
    WT_OPOWTPD,       -- Posted as Deb./Cred. [WT_OPOWTPD]
    WT_GIVENPD,       -- WTax Amt Entered [WT_GIVENPD]
    CTNUMBER,         -- WH Tax Cert. No. [CTNUMBER]
    WT_DOWNC,         -- Down Payt Clearing [WT_DOWNC]
    WT_RESITEM,       -- Residual Items [WT_RESITEM]
    CTISSUEDATE,      -- WTax Certicate Date [CTISSUEDATE]
    WT_CALC,          -- WT Calculated [WT_CALC]
    WT_LOGSYS,        -- LOGSYS WTaxDet. [WT_LOGSYS]
    PRIMARY KEY (MANDT, COMP_CODE, CAJO_NUMBER, FISC_YEAR, POSTING_NUMBER, POSITION_NUMBER, WTAXTYPE)
);

Learn More