1. Home
  2. Resources
  3. SAP Tables
  4. J_1ITDS - Classic TDS - reference table

SAP Table J_1ITDS

Classic TDS - reference table

J_1ITDS (Classic TDS - reference table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_1ITDS to other SAP tables.

Source: J_1ITDS (Classic TDS - reference table)

J_1ITDS table fields

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

J_1ITDS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1ITDS GSBER J_1ITDS MANDT TGSB Business Areas MANDT
J_1ITDS GSBER J_1ITDS GSBER TGSB Business Areas GSBER
J_1ITDS MANDT J_1ITDS MANDT T000 Clients MANDT