TDS statement

[former_member221515]

Hello Experts

We do TDS (With holding tax deduction) on vendor payment advance and FB60 invoice.

We also do clearing.

Now my client require, TDS (or witholding tax statement) which will show these details.. List shud have

1. Name of Vendor

2. Vendor number

3. Invoice or Advance amount

4. WHT amount

5. Net amount (i.e. after deducting WHT)

6. Linkage of invoice and advance if downpayment clearing is done.

Please help. I tried one standard report S_P00_07000134. Its does not suffice my requirement. Please help

[former_member319435]

Hi Deepak,

I guess the data (as you have mentioned) can be displayed through t-code S_P00_07000134. Please expand the General Control and put the Spl. GL indicators. Then expand Output Control and Lists and create a layout in a variant in Withholding Tax Items with your required columns. For eg. select "One-line short form of formatted address" for getting the Vendor Name.

Please try it and let me know if you encounter any problem.

Thanks & Regards

Ramesh

[m_madhu]

HI

Try with use the New transaction code J1INEMIS.

To get the New transaction please deploy the below notes.

1556348 1584640  1592267 1596609 1608106 1615465 1634559

1640173 1695696  1708353 1727552 1762701 1813269 1847679

1849009

Please refer the below wiki page

http://wiki.sdn.sap.com/wiki/x/8oMEDg  (J1INEMIS )

please also refer the below thread

https://scn.sap.com/thread/2154356

Regards

Madhu M

[narasimhulu_konnipati]

Try with J1INMIS if nor develop the below Z report (You can also refer the table WITH_ITEM for more details on WHT amounts)

Technical	Filed description	Table name
BUKRS	Company code	BKPF
BELNR	Accounting doc number	BKPF
GJAHR	Fiscal year	BKPF
BUDAT	Posting date	BKPF
BLDAT	Document date	BKPF
PRCTR	Profit Center	BSEG
PSWBT	G/L Amount	BSEG
BUPLA	Business Place	BSIS
LIFNR	Account no of the Vendor	J_1IMOVEND
J_1IPANNO	PAN Number	J_1IMOVEND
NAME1	Vendor name	LFA1
QSREC	Recipient type	LFB1 / WITH_ITEM
QSCOD	Off WHT key	T059Z
WITHT	WHT Type	WITH_ITEM
WT_WITHCD	WHT Code	WITH_ITEM
WT_QSSHH	WHT base amount in LC	WITH_ITEM
WT_QBSHH	WHT Amount in LC	WITH_ITEM
QSATZ	WHT Tax Rate	WITH_ITEM

Thanks,

Narasimha