Skip to Content
0
Jun 11, 2018 at 07:52 PM

/ERP/GL_ACCT Account Signage in BPC Optimized for S/4HANA

1219 Views Last edit Jun 11, 2018 at 07:54 PM 3 rev

It is a universal requirement to display GL Account balances with signage according to their account types. That is: Credit balances on Liability or Income accounts should be displayed as positive, while Debit balances on Asset or Expense accounts should be displayed as positive.

In Standard BPC, one could use properties such as ACCTYP in combination with configuration like 'CreditPositive' to determine how to treat these values.

In Embedded BPC, this is much less convenient, but still possible by using the 'Reverse Sign for Nodes' hierarchy option, and specifying this property manually in the Account Hierarchy you maintain, and then creating formulas in BEx Query Designer, as described in this post from William Yu, or this other article, or this other article.

However, in BPC Optimized for S/4HANA, we are given a standard SAP-built InfoObject, /ERP/GL_ACCT to work with. It is a virtual characteristic, built on the HANA View RTC_C_GLACCOUNT, which specifies its master data. It also has a Local Hierarchy Implementation with class CL_FCOM_IP_HRY_READER_GLACCT, which takes the Hierarchy info from the Financial Statement Version (FSV) maintained in S4.

So this appears to mean that, as standard in BPC Optimized for S/4HANA, one cannot control the signage display of account values at all.

Questions:

1) Is the above correct? Can it really be the case that account signage cannot be controlled out of the box? Or am I just missing a simple option which does this as standard?

2) What is the suggested fix here? Is it advisable to modify the SAP Standard InfoObject? Would we need to create a custom hierarchy class to read/specify the node reversal property?

Any suggestions would be most welcome.