Accounts payable 0FI_AP_20

[Former Member]

Hello All,

We have the requirement to provide ending Accounts payable on balance sheet by vendor

Currently we have BI Content vendor balances(0FI_AP_20)Which keyfigure do we need to use to show ending accounts payable on balance sheet.

will it be 0balance??

Please advice.

Thanks,

VRaj

[Former Member · Accepted solution]

Hi,

Following linnk should help you in deciding the field for the balance keyfigure :-

http://help.sap.com/saphelp_em70/helpdata/en/24/c3aff842154ab08fa15737d6ae28ee/frameset.htm

From data source 0FI_AP_20 you get cumulative balance from field

UM01K Cumulated balance

However its Calculated from the balances of the previous periods

You can use this field which is mapped to 0BALANCE or you can use formula also as suggested in above post if you want to calculate balance which is not based on the previous periods.

Navesh

[Former Member]

Hi,VR

you can use the field "UM01H" to show ending accounts payable on balance sheet.

[anindya_bose]

Hello VR

Balance should be a Formula = Debit Posting ( 0DEBIT) - Credit Postings( 0CREDIT)

0BALANCE represents cumulative Balance

Regards

Anindya