Payment

[rajesh_vasudeb]

Dear Friends,

From which table and field can you pick the last amount recieved from a Business Partner ?

Regards,

Rajesh

[Former Member]

Rajesh,

DFKKZP, DFKKZK, DFKKOP need to be read together to derive Contract Account/BP Payments

Rgds

Rajendra

[rajesh_vasudeb]

Thank you Sir,

I was able to the pick the details of Bp from DFKKZP table but was not able to get the details clearly from DFKKOP table as the both aspects of an payment entry seems to posted there.

My requirement is to print the last amount paid by the BP in his next invoice.

Can you help me out?

Thanks and Regards,

Rajesh

[Former Member]

Use this function module to get the amount :

BAPI_CTRACCONTRACTACCOUNT_GBAL

Regards,

Shiva Kumar

[Former Member]

Try this Rajesh,

Table DFKKKO where Origin Key = 05 , 06 where CPUDT =Sysdat.

Get all OPBEL and pass in DFKKOP-OPBEL. Derive GPART.

It should work else add few more conditions as per your project requirement

Rgds

Rajendra

[Former Member]

Hi,

Try using FM FKK_READ_LAST_PAYMENTS. Import paramters are PB, CA, Contract. Keep the payment run flag checked, in case the BP is in direct debit. You would get get a list of all payments for the business partner. get the latest by sorting budat.

Hope this helps.

Thank you,

Binno Don Thomas

[Former Member]

Gud answer Binno. It is much appreciated.

Rgds

Rajendra

[rajesh_vasudeb]

Thank you, Sir

The Issue is resolved.

Rajesh

[Former Member]

Thank u Rajendra for the appreciation