standard FM to read data from DFKKZP & display at portal level ?

[Former Member]

Hi,

I am trying to find out the Standard Functional module to read data from DFKKZP & display at portal level, could not able to find any for my self.

we are developing a report to display the customer payments as on current date  as a portal page from FI_CA contract account.

Thought of checking before going for Z.

Thanks in Advance.

anilaa

[william_eastman · Accepted solution]

You could check fkk_get_last_payments.

[Former Member]

Thanks a lot William for the quick response.

what about the "ECP_PORTAL_ALV_PAYMENT_LIST"  ?

[AmlanBanerjee]

Hi Anilaa,

FM, ECP_PORTAL_ALV_PAYMENT_LIST, is used for retrieveing the payments for R/3 accounts, as it queries tables like, EKKO, EKPO, PAYR, BSEG etc. under the FM, ECP_PAYMENT_LIST_DATA.

Moreover, if your objective is to retrieve the FICA Customer payments, querying DFKKZP alone will not suffice,as if a payment document is clarified partially to different contarct accounts, you will not be able to get the status of those from DFKKZP.

I would rather recommend you to query DFKKOP to find the clearing documents with clearing reason 01. These are geniune payments.

You also need to take into account the clearing reason 08(Account Maintanance)/15 (Auto clearing).

At times, the payments are cleared through FPMA/ FP06.

So check if the account maintaince/auto clearing document has been cleared by an incoming payment or not. If yes, these will also be part of customer payments.

You can use FKK_ACCOUNT_BALANCE_COMPUTE to retirve the clearing information for a FICA contract account.

Hope it helps...

Thanks,
Amlan

[Former Member]

Thanks Amlan..It really Helps.