WITH_ITEM
Quellensteuerinfo pro Qst.Typ und FI-Belegposition
WITH_ITEM is an SAP database table in S/4HANA. Quellensteuerinfo pro Qst.Typ und FI-Belegposition. It contains 71 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_Withholdingtaxitem | view | from | BASIC | Withholding Tax Item |
| P_PL_StRpWhldgTaxItem | view_entity | from | BASIC | Poland Withholding Tax Private View |
Fields (71)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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.
-- Quellensteuerinfo pro Qst.Typ und FI-Belegposition
-- 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]
PRIMARY KEY (MANDT, BUKRS, BELNR, GJAHR, BUZEI, WITHT)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA