SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Join Between DFKKOP and DFKKZP

Former Member
0 Kudos
1,621

I need to find the link between the table DFKKOP and DFKKZP. Actually I need to develop a report in which open items and payments will be shown. I am trying SQVI joins between them but did not found anything concrete yet.

4 REPLIES 4

Former Member
0 Kudos
584

Hello Ozair,

what exactly are you trying to do ?

There is a direct link between the 2 tables on the OPBEL.

Regards

Pierre-Yves

AmlanBanerjee
Active Contributor
0 Kudos
584

Hi Ozair,

I think a join b/w DFKKOP and DFKKZP will not help in your goal to achieve a report for OIs and payments.

I would recommend you to use Standard report FPO4 for your purpose.

This report has flexibility to produce OI's at a key date for a given set of BP's/CA's/Contract.

Also you can perform the aging analysis for the OI's as well.

Hope it helps...

Thanks,

Amlan

former_member199199
Active Participant
0 Kudos
584

Hi Ozair,

Using report FPO4 would be the best way to identify open items.

However if you want to create a custom report to extract open debit/payment items you can leverage below standard function modules:

FKK_ACCOUNT_BALANCE_COMPUTE

BAPI_CTRACCONTRACTACCOUNT_GBAL

Regards,

Bodhisattwa

0 Kudos
584

Hi All,

Actually I completed my report by connection ERDK and DFKKOP as clearing status and clearing is there in dfkkop.