Skip to Content
1

RTC: account type property for reporting

Aug 15, 2017 at 03:39 AM

412

avatar image

Hi gurus:

I am working with RTC in S4H 1610 FS02 and I am the point where I have to use the acctype property (AST/LEQ/INC/EXP) but I wonder how I can use that here in bpc embedded? since all the reports from ACDOCC table are bex queries...I have found this slide:

but this is useful when you create manually a gl account hierarchy in BW but in my case (and I m sure it is the typical case for others) I m leveraging the FSV from S4H, I'd like to hear from other's experiences about this requirement.

Regards

Joseph

sign-reverse.jpg (72.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Gregor Dieckmann
Aug 15, 2017 at 08:50 AM
0

Hi Joseph,

BW has no build-in sign reversal logic, you have to model this with a master data attribute in your account dimension and with formula variables in queries. Check the blog

https://blogs.sap.com/2017/01/19/from-bpc-standard-to-bpc-embedded-reverse-sign-for-account-type-with-key-figure-model/

for more details.

Gregor

Share
10 |10000 characters needed characters left characters exceeded
Joseph Angulo Aug 15, 2017 at 02:46 PM
0

hi Gregor, good article, I saw it before but I understand that I have to create a bw hierarchy for this and use that hierarchy in my report but actually we are not creating any hierarchy un bw, we are leveraging FSV from S4H so I guess this solution does not apply in my scenario...correct me if I m wrong.

Joseph

Share
10 |10000 characters needed characters left characters exceeded
Lucas Costa Aug 17, 2017 at 10:10 PM
0

Hi Joseph,

The delivered /ERP/GL_ACCT is indeed, based on the FSV. Now the problem is that the signage handling hasn't been implemented in the standard virtual info object. If you take a look in the info object above, you will notice that the hierarchy is handled by ABAP via class CL_FCOM_IP_HRY_READER_GLACCT. This class retrieve hierarchy from tables HRRP_* (hence the need to perform t-code HRRP_REP - FIN Runtime Hierarchy Replicator to replicate FSV to the info object) and these tables do not hold the sign information.

To be able to retrieve the signage, you need to enhance this class (suggest creating a copy of it). The good news is that the interface in this class already support this sort of situation so the implementation would be pretty straight forward.

Check methods:

IF_RRHI_VIRT_HIER~GET_NODES_WITH_SIGNREVERSAL

In here, you can lookup table RTC_EXT_SKA1 to read the BPC account type or even SKA1 to read the account group and determine the sign.

Also, you will need to activate the signage capability in the method

IF_RRHI_VIRT_HIERARCHIES~GET_CAPABILITIES

Simply include the following line of code:

r_s_capablities-hiesignch = abap_true.

Cheers,

Lucas

Show 8 Share
10 |10000 characters needed characters left characters exceeded

Looks like a great workaround Lucas!

So do we agree that the workaround provided by SAP is not the best option? Since it requires to create the hierarchy in BW.

btw , do you consider that this abap effort (working with class CL_FCOM_IP_HRY_READER_GLACCT ) is significantly?

regards

Joseph

0

I don't consider the best approach, specially considering your situation (real-time consolidation) where every characteristic is virtual/NOT replicated. It wouldn't make sense to replicate one of the most important ones in the consolidation process...

The effort to implement the class is minimum. Simply implement those two methods above and it's done.

Find below an example of how the method IF_RRHI_VIRT_HIER~GET_NODES_WITH_SIGNREVERSAL:

clear l_s_node.
l_s_node = VALUE #(
iobjnm = '0HIER_NODE'
nodename = 'COAS400000000' ).
INSERT l_s_node INTO TABLE e_ts_signrev_nodes.

Where: COAS is the COA and 4* is the GL. Simply add a dynamic code to fill that info.

0

Hi Lucas,

This kind of code would hard code would hard code accounts with sign reversal.

FM RGRE_HIERARCHY_INIT_FBR can bring those accounts. Problem I have is to get hierarchy name in case there are multiple hierarchies for that InfoObject. Do you know solution to that problem?

Thank you,

Gersh

0

Hi Gersh,

I don't have experience with the FM you sent but the approach I sent is totally dynamic, reliable on the COA + GLs itself. This table that I mentioned RTC_EXT_SKA1, is a Real-time consolidation table that will store BPC like info such as the account types. This would be used to determine the signage.

In a virtual hierarchy based on the FSV the name of the hierarchy will be FSV id - you can get the FSV names in table T011 . In the hierarchy class CL_FCOM_IP_HRY_READER_GLACCT method IF_RRHI_VIRT_HIERARCHIES~GET_HEADERS you get see how to get the hierarchy name dynamically as well.

Cheers,

Lucas

0

Hi Lucas,

Customer is on 1511 which doesn't have RTC tables.

T011 has list of hierarchies as well as this Method returns a list of hierarchies. I need to know which hierarchy user selected in the report because different FSVs can have sign reversal set up differently.

Do you know how to find in GET_NODES_WITH_SIGNREVERSAL name of the FSV with which Query was called?

Thank you,

Gersh

0

Hi Gersh,

You can try SKA1 as well field KTOKS.

100 Asset Accounts
200 Liability Accounts (LEQ ---> would be reversed)
300 Equity Accounts (LEQ ---> would be reversed)
400 Revenue Accounts (INC ---> would be reversed)
500 COS Accounts
600 Expense Accounts

I haven't tested using the parameters from the FSV itself, but you can try running a test using table FAGL_011PC field SIGN.

Around hierarchy selected, not sure. Tried a few times debug that method but couldn't get trough. The class itself is triggered as soon as you open an application as part of the initialisation. But that method is never called.

Put a breakpoint on method IF_RRHI_VIRT_HIERARCHIES~GET_HEADERS you will realise that this class will handle all virtual hierarchies as soon as you start an application such BPC Rules or a workbook. Within that there is an internal table lt_hiers that will contain the hiers.

Still don't know how it works when the FSV contains Functional Areas as well. Really need to sit and go through the options. Will try to come with more details as soon as I get some time.

Class CL_RSRTS_HIERARCHY_SFLIGHT can be used as example. Also check note:

2156177 - Sign Revers for implemented Hierarchies

Cheers,

Lucas

0

Hi Lucas,

Method GET_NODES_WITH_SIGNREVERSAL is called when Formula variable based on Hierarchy property is calculated.

Luckily SAP just published an OSS Note 2531080 that solves this issue.

Regards,

Gersh

0

Hi Gersh, thanks for the note.

The approach in the note is pretty similar to what I've described, but I think the note is better for the sake of using the standard objects.

0
Rajesh Hemnani Oct 26, 2017 at 11:04 PM
0

Hi Guys

I am also facing this issue... Implemented the note 2531080. GL Account Sign Still not working

1. Introduced Formula variable with Hierarchy attribute

2. Formula variable is used in Calculated KF.

3. The query shows NONEX for this column.

I see my Hierarchy in the table HRRP_DIRECTORY. What else I am missing?

Thanks

Rajesh

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Rajesh, we have achieved this using some calculated KF on the bex query.

Regards

Joseph

0