TDS derivation / capturing in case of MIRO (Logistic) booking against Exp

[Former Member]

Hi,

There is a requirement of ours to prepare a TDS report showing the TDS at the time of Expense booking as well as advance payment.

While doing so we found 2 ways of TDS capturing

1. With FI entry (via BSIS & BSAS Table)

2. With logistic entry u2013 MIRO

We are facing a problem in case of the 2nd option hence need a help to derive the TDS in case of MIRO document.

Our criterion is to get total TDS on particular expenses. For e.g. if there are professional charges of Rs. 100000/- paid during the year then our report should show Rs. 5000/- as TDS deducted at the time of expense booking or TDS at the time of advance payment.

In case of GR, expense get book but the tax get deducted at the time of MIRO booking hence require a co-relation to capture the TDS (deducted in MIRO) on the basis of exp booking happened at the time of GR (MIGO).

Please guide us as which table we need to refer for logic development or BAPI or any function module to take into consideration.

Regards,

Parag

[ravichandran_iyer · Accepted solution]

You can refer EKBE table which is used to capture the PO history. There you have both Invoice (referred by category Q) and GR (referred by category E) in separate rows with their respective values. You have to use that info in conjunction with WITH_ITEM table which holds the WHT info, whereas, the relationship with WITH_ITEM table is via BSEG as you get the MIRO reference document number to FI document number there.

Ravi.