Need data- multiple customers the same way as it appears in fpl9 chronology

[Former Member]

Hello All,

I need data for multiple customers in the same manner as it appears in FPL9 chronology. Has anyone worked on tit before. Please could you share the logic...how it can be extracted from tables or query or abap report.

Regards,

Charvi

[murtuza_chhatariya]

You will have to query on the tables DFKKOP, DFKKOPK, DFKKKO.

In DFKKKO, you will get document's header.

In DFKKOP, you will get document's data.

In DFKKOPK, you will get G/L items like payment etc

[Former Member]

Hi Mutuza,

Thanks for your reply. Please can you let me know how can we identify the returns other than dfkkrp table.

Regards,

Charvi Sanghavi

[Former Member]

Hi,

To get chronology data, use following snippet of code .In lt_acc_chrono you will get all chronology data which is comming in FPL9 screen.

CALL FUNCTION 'FKK_CRM_ACCOUNT_TOTALS'

EXPORTING

iv_gpart = gv_gpart

iv_vkont = x_vkont

iv_profil = 'ALL_LO'

iv_init = 'X'

TABLES

rt_totals = lt_totals

rt_bapi_ret = lt_return

EXCEPTIONS

OTHERS = 1.

IF sy-subrc = 0.

CALL FUNCTION 'FKK_CRM_ACCOUNT_CHRLIST'

EXPORTING

iv_gpart = gv_gpart

TABLES

rt_account_chr = lt_acc_chrono

rt_bapi_ret = lt_return

EXCEPTIONS

OTHERS = 1.

endif.

To get any data which is comming in FPL9 screen, use FM ' FKK_ACCOUNT_BALANCE_COMPUTE '

Ex :

CALL FUNCTION 'FKK_ACCOUNT_BALANCE_COMPUTE'

EXPORTING

i_vkont = vkont

i_gpart = gpart

i_vtref = vtref

i_start_date = '00010101'

i_start_time = '000000'

i_end_date = '99991231'

i_end_time = '235959'

IMPORTING

e_sum_openitems = gw_output-fpl9_balance

TABLES

t_postab = gt_postab.

Hope it helps...

Cheers !!

Rajesh

Edited by: Rajesh Gumpena on Aug 5, 2011 10:33 AM