J_1ITDS SAP (Classic TDS - reference table) Table details

Dictionary Type: Table
Description: Classic TDS - reference table




ABAP Code to SELECT data from J_1ITDS
Related tables to J_1ITDS
Access table J_1ITDS




Table field list including key, data, relationships and ABAP select examples

J_1ITDS is a standard SAP Table which is used to store Classic TDS - reference table data and is available within R/3 SAP systems depending on the version and release level.

The J_1ITDS table consists of various fields, each holding specific information or linking keys about Classic TDS - reference table data available in SAP. These include J_1IRECTYP (Record type for TDS / Service tax), J_1IAWTYP (Object type of calling application), J_1IAWREF (Reference document number), J_1IAWORG (Reference organisational units).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1ITDS table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
J_1IRECTYPRecord type for TDS / Service tax J_1IRECTYPCHAR1J_1IRECTYP
J_1IAWTYPObject type of calling application J_1IAWTYPCHAR5Assigned to domainAWTYP
J_1IAWREFReference document number J_1IAWREFCHAR10ALPHAAWREFJ_1I_J_1IAWREF
J_1IAWORGReference organisational units J_1IAWORGCHAR10AWORG
J_1IFAWTYPObject type of calling application (FI) J_1IFAWTYPCHAR5Assigned to domainAWTYP
J_1IFAWREFAccounting Document J_1IFAWREFCHAR10ALPHAAWREF
J_1IFAWORGReference organisational units of FI J_1IFAWORGCHAR10AWORG
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
J_1IBUDATPosting date in the reference document J_1IBUDATDATS8DATUM
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
QSSKZWithholding Tax Code QSSKZCHAR2Assigned to domainQSSKZ
QSATZWithholding Tax Rate QSATZDEC4(2) PRZ22
J_1ITDSAMTTDS amount in local currency J_1ITDSAMTCURR13(2) WERTV7
J_1ISURAMTSurcharge amount J_1ISURAMTCURR13(2) WERTV7
J_1IBASAMTWitholding tax base amount J_1IBASAMTCURR13(2) WERTV7
J_1IBASLOCWitholding tax base amount in local currency J_1IBASLOCCURR13(2) WERTV7
J_1IORGAMTOriginal document amount J_1IORGAMTCURR13(2) WERTV7
J_1ITDCURRTDS currency J_1ITDCURRCUKY5Assigned to domainWAERS
J_1IFIYEARFiscal year J_1IFIYEARNUMC4GJAHRGJAHR
J_1ICDDOCReference number of clearing downpayment J_1ICDDOCCHAR10ALPHABELNR
J_1ICDYEARExcise year J_1IDOCYRNUMC4GJAHRGJAHR
J_1ITDSDOCTDS Certificate Number J_1ITDSDOCCHAR10CHAR10J_1I_J_1ITDSDOC
J_1ITDSINDTDS update indicator J_1ITDSINDCHAR1J_1ITDSIND
J_1ICSTATTDS certificate status J_1ICSTATCHAR1CHAR1_X
J_1ITDCHLNChallan Numbers J_1ITDCHLNCHAR10CHAR10
J_1ICHLNDTDate of challan on which TDS was paid J_1ICHLNDTDATS8CK_DATUM
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
J_1ITDINDETDS amt in co. currency as deducted during TDS posting J_1ITDINDECURR13(2) WERTV7
J_1ITDINPOTDS amt as paid to the govt. in co. currency J_1ITDINPOCURR13(2) WERTV7
J_1IPAYDUETax Payment due to Govt. ( TDS / Service tax ) J_1IPAYDUEDATS8DATS
J_1ITANNOTDSCAN of Collecting Company for TCS J_1ITANNOCHAR40CHAR40
J_1IREDINDIndicator to show TDS on reduced(R)/ normal(N) rate J_1IREDINDCHAR1CHAR1
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT

Key field Non-key field



How do I retrieve data from SAP table J_1ITDS using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1ITDS to SELECT all data from the table
DATA: WA_J_1ITDS TYPE J_1ITDS.

SELECT SINGLE *
FROM J_1ITDS
INTO CORRESPONDING FIELDS OF WA_J_1ITDS
WHERE...

How to access SAP table J_1ITDS

Within an ECC or HANA version of SAP you can also view further information about J_1ITDS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!