Calculate Account Balance for Account Change

[Former Member]

Hi All,

We need to calculate the account balance to identify account change details from a base date till run date .

For Example Old balance is available on a particular base line Date : 10/11/2010 , Run Date : 16/11/2010. new postings / reversals / clearing / reset etc done since base line date/time till run date /time .

Here client doesn't want to go for the normal approach selection from DFKKOP due to performance issue .

Change doc tables CDHDR and CDPOS also can't be use due to not knowing which field value may get change during account change process. So please suggest and alternative solution for this , if any idea .

Thanks

[AmlanBanerjee]

Hi Sachin,

You can use the FM-FKK_ACCOUNT_BALANCE_COMPUTE for the purpose.

This FM has a start date , Start time , End date and End time as entry parameters

You can use-

Start date -Baseline date

Start time-00:00:00

End date-Run date

End time-23:59:59.

to get only the new transactions that have been passed into the account for that period.

Hope it helps..

Thanks,

Amlan

[william_eastman]

Sachin:

There is no way around DFKKOP access - that is where the documents exist which make up the balance. Any balance determination will use it. You can either code your own selection, or use the bapis/functions which already exist. I would caution that they typically get more info than necessary, especially for a simple calculation.

regards,

bill.