TDS Amount is not appearing in DME Output

[Former Member]

Dear Experts,

TDS Amount is not appearing in DME Output.

As per our requirement while sending payment information to bank we need to provide invoice wise details along with Net amount and TDS deduction amount.

Please assist me...

Thanks in advance,

Regards,

Balaji Bhonsle.

[Former Member · Accepted solution]

Hi Balaji,

To get the TDS (Withholding Tax) amount deducted on the payment, you can give FPAYP - QSTEU, but to get TDS from the Invoice documents, you will have to take ABAP help and write a function/exit module to get the TDS amount.

Thanks and Regards,

anit

[Former Member · Accepted solution]

Dear Anit,

Thanks for your response,

As you explained we need TDS amount from Invoice document. However we are not able to explain the correct logic to abap team to get tds amount in DME.

Could you please guide us if you have any inputs.

Thanks in advance,

Regards,

Balaji Bhonsle.

[Former Member · Accepted solution]

Hi,

Just check this out.

FUNCTION zfi_dmee_get_tds.

*"----

---

""Local Interface:

*" IMPORTING

*" VALUE(I_TREE_TYPE) TYPE DMEE_TREETYPE_ABA

*" VALUE(I_TREE_ID) TYPE DMEE_TREEID_ABA

*" VALUE(I_ITEM)

*" VALUE(I_PARAM)

*" VALUE(I_UPARAM)

*" REFERENCE(I_EXTENSION) TYPE DMEE_EXIT_INTERFACE_ABA

*" EXPORTING

*" REFERENCE(O_VALUE)

*" REFERENCE(C_VALUE)

*" REFERENCE(N_VALUE)

*" REFERENCE(P_VALUE)

*" TABLES

*" I_TAB

*"----

---

DATA : w_doc2r(10),

w_len TYPE i,

w_whamt TYPE with_item-wt_qbshh,

w_tds(15) TYPE c.

DATA : l_fpayp TYPE fpayp,

l_item TYPE dmee_paym_if_type,

l_regup TYPE regup.

*define a structure like doc2r.

DATA:BEGIN OF l_doc2r,

bukrs TYPE bkpf-bukrs,

belnr TYPE bkpf-belnr,

gjahr TYPE bkpf-gjahr,

END OF l_doc2r.

• Build up internal tables of payment documents

l_item = i_item.

l_fpayp = l_item-fpayp.

IF l_fpayp-qsteu IS NOT INITIAL.

• w_tds = l_fpayp-qsteu.

write l_fpayp-qsteu to w_tds left-justified.

o_value = w_tds.

• p_value = l_fpayp-qsteu.

CLEAR w_tds.

ELSE.

• Calculate the String Length

w_len = STRLEN( l_fpayp-doc2r ).

IF w_len >= 0.

l_doc2r = l_fpayp-doc2r.

ENDIF.

SELECT SINGLE wt_qbshh FROM with_item INTO w_whamt

WHERE bukrs = l_doc2r-bukrs AND

belnr = l_doc2r-belnr AND

gjahr = l_doc2r-gjahr AND

wt_withcd NE '' AND

wt_acco = l_fpayp-gpa2r.

IF sy-subrc = 0.

write w_whamt to w_tds left-justified.

• w_tds = w_whamt.

ENDIF.

o_value = w_tds.

• p_value = w_whamt.

CLEAR: w_tds, w_whamt.

ENDIF.

ENDFUNCTION.

Thanks and Regards,

anit

[Former Member · Accepted solution]

Dear Anit,

Heartly thanks for your help.

I am proceeding with tech team reg this......

If I faced any prob, I'll come to you again,

Again thanks for your help.

Regards,

Balaji Bhonsle.

[Former Member]

hi

check whether you have mapped the correct fields with the DME structure to populate the TDS amount

[Former Member]

hi

check that the DME file format that you have defined. in that have you defined the amount field have to be populated or not.

jaipal