1. SAP Tutorial
  2. FI Module

J_1ITDS SAP table for – Classic TDS – reference table

Here we would like to draw your attention to J_1ITDS table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1ITDS is a SAP standard transp table used for storing Classic TDS – reference table related data in SAP. It comes under the package J1IN.

SAP J_1ITDS table

Table J_1ITDS technical data

TableJ_1ITDS
Data storingClassic TDS – reference table
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1IN
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1ITDS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_1ITDS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • J_1IRECTYP : Record type for TDS / Service tax
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • J_1IAWTYP : Object type of calling application
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • J_1IAWREF : Reference document number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • J_1IAWORG : Reference organisational units
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • J_1IFAWTYP : Object type of calling application (FI)
    Its data type is CHAR (Character String) with field length 5
  • J_1IFAWREF : Accounting Document
    Its data type is CHAR (Character String) with field length 10
  • J_1IFAWORG : Reference organisational units of FI
    Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • J_1IBUDAT : Posting date in the reference document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • QSATZ : Withholding Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • J_1ITDSAMT : TDS amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • J_1ISURAMT : Surcharge amount
    Its data type is CURR (Currency Field) with field length 13
  • J_1IBASAMT : Witholding tax base amount
    Its data type is CURR (Currency Field) with field length 13
  • J_1IBASLOC : Witholding tax base amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • J_1IORGAMT : Original document amount
    Its data type is CURR (Currency Field) with field length 13
  • J_1ITDCURR : TDS currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • J_1IFIYEAR : Fiscal year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • J_1ICDDOC : Reference number of clearing downpayment
    Its data type is CHAR (Character String) with field length 10
  • J_1ICDYEAR : Excise year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • J_1ITDSDOC : TDS Certificate Number
    Its data type is CHAR (Character String) with field length 10
  • J_1ITDSIND : TDS update indicator
    Its data type is CHAR (Character String) with field length 1
  • J_1ICSTAT : TDS certificate status
    Its data type is CHAR (Character String) with field length 1
  • J_1ITDCHLN : Challan Numbers
    Its data type is CHAR (Character String) with field length 10
  • J_1ICHLNDT : Date of challan on which TDS was paid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • J_1ITDINDE : TDS amt in co. currency as deducted during TDS posting
    Its data type is CURR (Currency Field) with field length 13
  • J_1ITDINPO : TDS amt as paid to the govt. in co. currency
    Its data type is CURR (Currency Field) with field length 13
  • J_1IPAYDUE : Tax Payment due to Govt. ( TDS / Service tax )
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • J_1ITANNO : TDSCAN of Collecting Company for TCS
    Its data type is CHAR (Character String) with field length 40
  • J_1IREDIND : Indicator to show TDS on reduced(R)/ normal(N) rate
    Its data type is CHAR (Character String) with field length 1
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6

    • J_1ITDS related tables

    • J_1IEWT_ECFLAG : Separate Tax code for Ecess
    • J_1ISTATECD : State Codes; e-Filing, Localization India
    • J_1ITDSTXC : TDS – Withholding taxcode and section relationship
    • J_1ICHIDTX : Text Table for Chapter ID
    • J_1IEWT_COLLCODE : Collection Codes for TCS
    • J_1IMOVEND : Vendor Master Excise Additional Data
    • J_1ITDS : Classic TDS – reference table
    • J_1ICHPTER : Chapter ID Master
    • J_1IMTCHID : Combination of Material Number and Chapter ID
    • J_1IMOCUST : Customer Master Excise Additional Data
    • J_1IEWT_ECESS1 : Education Cess Rates
    • J_1IEWT_TT_COLL : Mapping tax types to collection codes for TCS
    • J_1ISTATECDT : State Code Texts; e-Filing India Localization
    • J_1IRSNCODEM : Exemption Reason Code; e-Filing India Localization
    • J_1ICERTIF : TDS certificate information
    • J_1ISECCO_ADDL : Additional section code data for India eFiling
    • J_1IEXCTAX : Tax calc. – Excise tax rates
    • J_1IEWT_ACKN_N : Acknowledgement numbers for quarterly returns filed
    • J_1IEICOVE : Excise indicator determination for company and vendor
    • J_1IMODDET : Modvat Determination Table (Input Material->Output Material)

    J_1ITDS related transaction codes under SAP package J1IN

    • J1IE : Number range maintenance: J_1ITDSNO
    • J1IY : Maintain W.taxcode and Section .
    • J1ICCERT : Certificate Print -Regular Vendors
    • S_AL0_96000176 : IMG activity: J_1ITDSDUE
    • J1INEMIS : Withholding Tax Info. System India
    • S_AL0_96000175 : IMG activity: J_1ITDSTXC
    • J1ICCAN : Certificate cancel (Classical)
    • J1ICOTV : Certificate Print-One time vendors
    • J1INACKN : Maintain Acknowledgement Numbers
    • S_EBS_44000445 : Withholding tax information system I
    • J1IX : Excise Invoice Verification WO PO
    • J1IN : India Version Tax Deduction at Sourc
    • J1IZ : Maintain W. Tax Section info.
    • J1IC194C : Annual Return under section 194c
    • J1INQEFILE : Quarterly E-returns (India)
    • J1ICREP : Certificate Reprint(Classical)
    • J1INC : Tax Deduction at Source: Classic
    • J1ITDUE : Payment Due date customising

    Related References

    Related Tutorials

    J_1ICERTIF SAP table for – TDS certificate information

    J_1ICERTIF table in SAP FI (Localization in FI) module. This table is used for storing data of TDS certificate information....

    J_1IEWTPROV SAP table for – Table for TDS provisions

    J_1IEWTPROV table in SAP FI (Localization in FI) module. This table is used for storing data of Table for TDS...

    J_1ITDSSEC SAP table for – TDS Sections

    J_1ITDSSEC table in SAP FI (Localization in FI) module. This table is used for storing data of TDS Sections. See...

    J_1ITDSTXC SAP table for – TDS – Withholding taxcode and section relationship

    J_1ITDSTXC table in SAP FI (Localization in FI) module. This table is used for storing data of TDS - Withholding...

    J_1IEWTHKONT SAP table for – Table for for TDS provisions Accounts / Loss Accounts

    J_1IEWTHKONT table in SAP FI (Localization in FI) module. This table is used for storing data of Table for for...

    J_1IEWT_MIGRATE SAP table for – Map Classic tax code to EWT Tax type – Tax codes

    J_1IEWT_MIGRATE table in SAP FI (Localization in FI) module. This table is used for storing data of Map Classic tax...

    J1INC SAP tcode for – Tax Deduction at Source: Classic

    J1INC tcode in SAP FI (Localization in FI) module. This transaction code is used for Tax Deduction at Source: Classic....

    «
    »