WITH_ITEM

Transparent Table Application Table
92 Fields 2 CDS Views

Witholding tax info per W/tax type and FI line item

WITH_ITEM is an SAP database table in S/4HANA. Witholding tax info per W/tax type and FI line item. It contains 92 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Withholdingtaxitem view from BASIC Withholding Tax Item
P_PL_StRpWhldgTaxItem view_entity from BASIC Poland Withholding Tax Private View

Fields (92)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
KEY buzei BUZEI Item
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_basman WT_BASMAN W/Tax Base Man.
wt_qsshhc WT_BSC Base LC Calcul.
wt_qsshbc WT_BS1C Base FC Calculation
wt_qssh2c WT_BS2C Base in 2nd LC Calc.
wt_qssh3c WT_BS3C Base in LC3 Calc.
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_amnman WT_AMNMAN WTax Amt Ent. Man.
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
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
text15 TEXT15 Text (15 characters)
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_accbs WT_ACCBS Acc. WT Base in LC
wt_accwt WT_ACCWT Accum. WT Amt in LC
wt_accwta WT_ACCWTA Accum. WT Amt in LC
wt_accwtha WT_ACCWTHA Accum. WT Amt in LC
wt_accbs1 WT_ACCBS Acc. WT Base in LC
wt_accwt1 WT_ACCWT Accum. WT Amt in LC
wt_accwta1 WT_ACCWTA Accum. WT Amt in LC
wt_accwtha1 WT_ACCWTHA Accum. WT Amt in LC
wt_accbs2 WT_ACCBS Acc. WT Base in LC
wt_accwt2 WT_ACCWT Accum. WT Amt in LC
wt_accwta2 WT_ACCWTA Accum. WT Amt in LC
wt_accwtha2 WT_ACCWTHA Accum. WT Amt in LC
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
j_1af_wt_repbs J_1AF_WT_REPBS W/tax rep base LC
wt_calc WT_CALC WT Calculated
wt_logsys WT_LOGSYS LOGSYS WTaxDet.
_dataaging DATA_TEMPERATURE Data Aging
fiwtco_pen_vol_dedo FIWTCO_PEN_VOL_DEDO Pen. Cont.
vol_contribution VOL_CONTRIBUTION Volun. Pens. Contri.
co_max_deduction CO_MAX_DEDUCTION Max. Ded.
fiwtco_mand_base FIWTCO_MAND_BASE Mand Contr Base
fiwtco_labor_exemp FIWTCO_LABOUR_EXEMP Labour exm
j_1bwhtcollcode J_1BWHTCOLL Coll. Code
j_1bwhtrate J_1BTXRATE Tax Rate
j_1bwht_bs J_1BWHT_BS_FI_CS WT Base from NF
j_1bwhtaccbs J_1BWHT_ACCRB_FI_CS Accum w/tax RB in LC
j_1bwhtaccbs1 J_1BWHT_ACCRB_FI_CS Accum w/tax RB in LC
j_1bwhtaccbs2 J_1BWHT_ACCRB_FI_CS Accum w/tax RB in LC
j_1iintchln J_1IINTCHLN Challan Number
j_1iintchdt J_1IINTCHDT Challan Date
j_1iewtrec J_1IEWTREC Record type for EWT
j_1ibuzei BUZEI Item
j_1icertdt J_1ICERTDT Cert. Date
j_1iclramt J_1ICLRAMT Amount Cleared
j_1irebzg REBZG Invoice Ref.
j_1isuramt J_1ISURAMT Surcharge AMT
fiwtin_par_exem FIWTIN_PAR_EXEM_IND Partial Exemption
fiwtin_acc_flag FIWTIN_ACC_FLAG Accumulation flag

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.

-- Witholding tax info per W/tax type and FI line item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WITH_ITEM (
    MANDT,                -- Client [MANDT]
    BUKRS,                -- Company Code [BUKRS]
    BELNR,                -- Document Number [BELNR_D]
    GJAHR,                -- Fiscal Year [GJAHR]
    BUZEI,                -- Item [BUZEI]
    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_BASMAN,            -- W/Tax Base Man. [WT_BASMAN]
    WT_QSSHHC,            -- Base LC Calcul. [WT_BSC]
    WT_QSSHBC,            -- Base FC Calculation [WT_BS1C]
    WT_QSSH2C,            -- Base in 2nd LC Calc. [WT_BS2C]
    WT_QSSH3C,            -- Base in LC3 Calc. [WT_BS3C]
    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_AMNMAN,            -- WTax Amt Ent. Man. [WT_AMNMAN]
    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]
    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]
    TEXT15,               -- Text (15 characters) [TEXT15]
    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_ACCBS,             -- Acc. WT Base in LC [WT_ACCBS]
    WT_ACCWT,             -- Accum. WT Amt in LC [WT_ACCWT]
    WT_ACCWTA,            -- Accum. WT Amt in LC [WT_ACCWTA]
    WT_ACCWTHA,           -- Accum. WT Amt in LC [WT_ACCWTHA]
    WT_ACCBS1,            -- Acc. WT Base in LC [WT_ACCBS]
    WT_ACCWT1,            -- Accum. WT Amt in LC [WT_ACCWT]
    WT_ACCWTA1,           -- Accum. WT Amt in LC [WT_ACCWTA]
    WT_ACCWTHA1,          -- Accum. WT Amt in LC [WT_ACCWTHA]
    WT_ACCBS2,            -- Acc. WT Base in LC [WT_ACCBS]
    WT_ACCWT2,            -- Accum. WT Amt in LC [WT_ACCWT]
    WT_ACCWTA2,           -- Accum. WT Amt in LC [WT_ACCWTA]
    WT_ACCWTHA2,          -- Accum. WT Amt in LC [WT_ACCWTHA]
    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]
    J_1AF_WT_REPBS,       -- W/tax rep base LC [J_1AF_WT_REPBS]
    WT_CALC,              -- WT Calculated [WT_CALC]
    WT_LOGSYS,            -- LOGSYS WTaxDet. [WT_LOGSYS]
    _DATAAGING,           -- Data Aging [DATA_TEMPERATURE]
    FIWTCO_PEN_VOL_DEDO,  -- Pen. Cont. [FIWTCO_PEN_VOL_DEDO]
    VOL_CONTRIBUTION,     -- Volun. Pens. Contri. [VOL_CONTRIBUTION]
    CO_MAX_DEDUCTION,     -- Max. Ded. [CO_MAX_DEDUCTION]
    FIWTCO_MAND_BASE,     -- Mand Contr Base [FIWTCO_MAND_BASE]
    FIWTCO_LABOR_EXEMP,   -- Labour exm [FIWTCO_LABOUR_EXEMP]
    J_1BWHTCOLLCODE,      -- Coll. Code [J_1BWHTCOLL]
    J_1BWHTRATE,          -- Tax Rate [J_1BTXRATE]
    J_1BWHT_BS,           -- WT Base from NF [J_1BWHT_BS_FI_CS]
    J_1BWHTACCBS,         -- Accum w/tax RB in LC [J_1BWHT_ACCRB_FI_CS]
    J_1BWHTACCBS1,        -- Accum w/tax RB in LC [J_1BWHT_ACCRB_FI_CS]
    J_1BWHTACCBS2,        -- Accum w/tax RB in LC [J_1BWHT_ACCRB_FI_CS]
    J_1IINTCHLN,          -- Challan Number [J_1IINTCHLN]
    J_1IINTCHDT,          -- Challan Date [J_1IINTCHDT]
    J_1IEWTREC,           -- Record type for EWT [J_1IEWTREC]
    J_1IBUZEI,            -- Item [BUZEI]
    J_1ICERTDT,           -- Cert. Date [J_1ICERTDT]
    J_1ICLRAMT,           -- Amount Cleared [J_1ICLRAMT]
    J_1IREBZG,            -- Invoice Ref. [REBZG]
    J_1ISURAMT,           -- Surcharge AMT [J_1ISURAMT]
    FIWTIN_PAR_EXEM,      -- Partial Exemption [FIWTIN_PAR_EXEM_IND]
    FIWTIN_ACC_FLAG,      -- Accumulation flag [FIWTIN_ACC_FLAG]
    PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI, WITHT)
);

Learn More