SAP table J_1ITDS (Classic TDS - reference table)

SAP table J_1ITDS has 5 primary key fields being MANDT,J_1IRECTYP,J_1IAWTYP,J_1IAWREF,J_1IAWORG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
J_1IRECTYP Record type for TDS / Service tax CHAR 1 0 J_1IRECTYP
C Downpayment clearing
D Downpayment
G SR/IR provision
I Invoice
J SR/IR DP clearing against provision
K SR/IR provision clearing
M Credit Memo
P Payment
J_1IAWTYP Object type of calling application CHAR 5 0 * J_1IAWTYP
J_1IAWREF Reference document number CHAR 10 0 J_1IAWREF
J_1IAWORG Reference organisational units CHAR 10 0 J_1IAWORG
J_1IFAWTYP Object type of calling application (FI) CHAR 5 0 * J_1IFAWTYP
J_1IFAWREF Accounting Document CHAR 10 0 J_1IFAWREF
J_1IFAWORG Reference organisational units of FI CHAR 10 0 J_1IFAWORG
BUKRS Company Code CHAR 4 0 * BUKRS
GSBER Business Area CHAR 4 0 TGSB GSBER
J_1IBUDAT Posting date in the reference document DATS 8 0 J_1IBUDAT
LIFNR Account Number of Supplier CHAR 10 0 * LIFNR
QSSKZ Withholding Tax Code CHAR 2 0 * QSSKZ
QSATZ Withholding Tax Rate DEC 4 2 QSATZ
J_1ITDSAMT TDS amount in local currency CURR 13 2 J_1ITDSAMT
J_1ISURAMT Surcharge amount CURR 13 2 J_1ISURAMT
J_1IBASAMT Witholding tax base amount CURR 13 2 J_1IBASAMT
J_1IBASLOC Witholding tax base amount in local currency CURR 13 2 J_1IBASLOC
J_1IORGAMT Original document amount CURR 13 2 J_1IORGAMT
J_1ITDCURR TDS currency CUKY 5 0 * J_1ITDCURR
J_1IFIYEAR Fiscal year NUMC 4 0 J_1IFIYEAR
J_1ICDDOC Reference number of clearing downpayment CHAR 10 0 J_1ICDDOC
J_1ICDYEAR Excise year NUMC 4 0 J_1IDOCYR
J_1ITDSDOC TDS Certificate Number CHAR 10 0 J_1ITDSDOC
J_1ITDSIND TDS update indicator CHAR 1 0 J_1ITDSIND
TDS not posted
P TDS paid
R TDS reversed
X TDS posted
J_1ICSTAT TDS certificate status CHAR 1 0 J_1ICSTAT
J_1ITDCHLN Challan Numbers CHAR 10 0 J_1ITDCHLN
J_1ICHLNDT Date of challan on which TDS was paid DATS 8 0 J_1ICHLNDT
BLART Document Type CHAR 2 0 * BLART
J_1ITDINDE TDS amt in co. currency as deducted during TDS posting CURR 13 2 J_1ITDINDE
J_1ITDINPO TDS amt as paid to the govt. in co. currency CURR 13 2 J_1ITDINPO
J_1IPAYDUE Tax Payment due to Govt. ( TDS / Service tax ) DATS 8 0 J_1IPAYDUE
J_1ITANNO TDSCAN of Collecting Company for TCS CHAR 40 0 J_1ITANNO
J_1IREDIND Indicator to show TDS on reduced(R)/ normal(N) rate CHAR 1 0 J_1IREDIND
EBELN Purchasing Document Number CHAR 10 0 * EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 * EBELP
USNAM User Name CHAR 12 0 * USNAM
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM

J_1ITDS foreign key relationships

Table Field Check Table Check Field
0 J_1ITDS GSBER TGSB Business Areas MANDT
0 J_1ITDS GSBER TGSB Business Areas GSBER
1 J_1ITDS MANDT T000 Clients MANDT