Report to view the Payment lots created/processed on particular day with the source of payment lot

[Former Member]

Hi,

I have searched in SAP & Previous posts not able to find the Report/Transaction which will help you to view the  Payment Lots created/Processed on particular day with the source of the payment lot.

I want segregate the payment lots which are created through FPB7.

Thanks In Advance.

Regards,

anilaa

[ivor_martin · Accepted solution]

HI,

You can create a Quickviewer Query using Transaction code SQVI to query tables DFKKZP and DFKKZK. Have selection criteria for date and list criteria Payment Lot, date and Creation User ID, Amount.

You can then generate a report program from the Query and have a User execute it using SE38.

I hope this helps.

Regards,

Ivor Martin

[rahul_paldiwal2]

Hello Anilaa,

There is nothing standard I am aware of.

For our project we build a custom report at the header and the item level.

Header level gave details on all payments processed for a given day and the ability to drill down at each payments. If it is a ongoing business requirement try this route or if you are using Business Intelligence , then you can get it done over there.

Regards,
Rahul

[former_member199199]

Hi Anilaa,

Please explore transaction FP30H by enhancing the search query.

Regards

Bodhisattwa

[rahul_paldiwal2]

Hey Bodhisattwa,

Where exactly is this transaction in the SAP menu ?

Regards,
Rahul

[former_member199199]

Hi Rahul,

Not sure why this is not in SAP menu whereas FP30 and Fp30C is avilable. I reckon due to the reason that it is an entirely user specific setting.

But I am sure this will work with proper search crietria. You can give it a try.

Regards

Bodhisattwa

[former_member199199]

Hi all,

Just another note, please check the view V_FP30H_SEARCH where fields of DFKKZP are provided which are allowed by default for search.

So in the field 'search query' just populate the value of any of these fields and it will provide you the payment lot item details.

For better understanding, please go through the documentation of this transaction.

Hope it helps.

Regards

Bodhisattwa

[former_member261786]

Hi Rahul,

Check this access menu node - Accounting - Financial Accounting - Contract Accounts Receivable and Payable - Payments - Clarification Activities - FP30H - Find Payment (User-Defined Search).

Yahh...based on document date or other search term, we can get list of payment lots processed.

Regards,

Hari

[rahul_paldiwal2]

Thanks Hari, the menu path you mentioned is to find individual payments ( FP30) . As mentioned by Bodhisattwa, FP30H is not in the SAP menu.

[Former Member]

Thanks Everyone. Appreciated your help & Time.  

[william_eastman]

Anilaa:

is this thread answered?  Please mark it so.

regards,

bill.

[Former Member]

Sorry should have done before. It has been taken care.

Thanks,

anilaa