Transaction FPO4 - where the data comes from?

[Former Member]

Welcome members,

as I am new in SAP, and found a lot of usefull information here, I put my first question today... wel...

I need to make a VISO report with the result of receivables for all liquide BuCo minus all payments are made until a specified date by country.

Well, I was said how to obtain the data. Just using FPO4 open balance list. I see the report result with the data I need in column Loc.curr.amount per country. But My question is: from which table this data is taken or how it is counted in the abap code? I am trying to debug the program, but it seems to be difficult for me to find the right table or tables.. Could you help me? I need to find the part of code I can modified to my report to display the same value...

Roman

[Former Member · Accepted solution]

Hi Roman

You question is not so clear. what is your requirement?

but the base table for this transaction (FPO4) is DFKKOP. all the open items comes from this table only.

[Former Member]

Hi Giri,

thank you for your answer. Finally I found the table too, but as I have only a little experiences, I dont know how to get the rights result..

I can see as a results of the transaction Item list FI-CA at key date. There are lins devided per country (sign **) and "Loc.curr.amount". This "Loc.curr.amount" i need to obtain in another report, but I do not know how to get this value from the table DFKKOP...

I feel lost..

[Former Member]

Roman,

The local currency amount is the value in field "BETRH" in table DFKKOP. However it is not really clear if you are looking for that or if you want to know how to get the correct items from table DFKKOP. If you need help with the correct selection please post a little more details so we can help you out.

Regards,

Arnoud