How to retrieve main and sub transactions HVORG and TVORG for a payment document in FICA module.

[former_member556984]

Dear Experts,

I am in need of retrieving the main and sub transactions HVORG and TVORG for a payment document. Unfortunately, I couldn't find this information in the DFKKKO table. It seems to exist in DFKKOP, but when I search with "OPBEL," no results are found. However, the cleared documents appear when I search with "AUGBL." Could you please assist me in finding a solution to retrieve the operation principal and partial of the payment document?

Thank you very much.

[rahul_paldiwal2]

Hello Abdelbaset,

DFKKOP is an open items table i.e. it stores information for all transactions which were not cleared at the time of posting.

Example: Payment Document 1 = $ 500 clears the entire receivable, in this case you won't find the information of the payment document except the clearing document field for the receivable item

Payment document 2 = $ 500 , however this clears the receivable of $ 200 and the remaining $ 300 is uncleared , in this case you will find the payment document in the DFKKOP table.

Regards,
Rahul

[former_member556984]

Hi Rahul Paldiwal,

I appreciate your response. However, I would like to clarify that my requirement is to obtain the main transaction and sub transaction for the payment document. I have been unable to find this information anywhere in the existing data sources. I am wondering if there is a function module available that can take the OPBEL as a parameter and provide the corresponding DFKKOP-HVORG and DFKKOP-TVORG values specifically for the payment document, excluding cleared items.

Thank you for your assistance.

Best regards.