Compound value for Set Hierarchy not filled 0GL_ACCOUNT

[Former Member]

Hello

I have created an extractor using in R/3 Transaction BW07 'Generating DataSource for Cust. Refs Set.Hierarchy', where

=> Field name = RACCT

=> Compounding Field name = KTOPL

Thus it is an extractor on a Set Hierarchy 0000 used for 0GL_ACCOUNT and compounded to Chart of Accounts.

According OSS Note 134975 I applied the requiered customer exit in EXIT_SAPLRSAP_004.

Now the issue is, that the value of chart of account isnt assigned to the hierarchy nodes at all. What is very curious and difficult to understand is:

- Checking the extraction in RSA3 (DataSource Checker)in debuggin modus I see in EXIT_SAPLRSAP_004, that the nodes are correctly modified and assigned to the internal table C_T_HIENODE and C_T_HIEINTV.

- However the output list in RSA3 doesnt show the changed values and shows the GL Account still without compounding values.

Does someone hava an idea, why it doesnt work?

Thanks a lot for your ideas and help

Christian

[Former Member · Accepted solution]

Hi,

Welcome to SDN

Hope you are doing the same..

*********************************

Add compound value to hierarchy leaves

LOOP AT C_T_HIENODE WHERE IOBJNM <> '0HIER_NODE'.

• Shift nodename right to get space for compound characteristic

SHIFT C_T_HIENODE-NODENAME RIGHT BY 2 PLACES.

• Put Chart of Accounts into first 4 places

C_T_HIENODE-NODENAME(2) = '01'. "<-- compound value

MODIFY C_T_HIENODE.

ENDLOOP.

******************************

Hope i m clr

Regards,

San!

[Former Member · Accepted solution]

Hello San

Thanks considering my issue. I could solve it by my own. But the OSS 134975 seems to show the wrong ABAP coding.

---> THAT IS THE CODING PROPOSED BY SAP OSS 134975

_______________________________________________

*>>>> START OF INSERTION <<<<

• Example program for CMOD-Exit EXIT_SAPLRSAP_004 - BW 2.0 and higher!

*

• In this example, Sets are extracted for DataSource 4R_SAKNR_0000_HIER

• they are compounded by a value of 'TEST' (for compound 0CHRT_ACCTS)

*

• The exit is called for any hierarchy extracted from OLTP to BW,

• therefore we have to make sure only desired FI-SL-Sets are modified.

• This information is available in I_DATASOURCE and I_S_HIEBAS.

*

IF I_DATASOURCE = '4R_SAKNR_0000_HIER' "<--- Your DataSource

AND I_S_HIEBAS-HCLASS = '0000'. "Hierarchy class of FI-SL-Sets

• Add compound value to hierarchy leaves

LOOP AT C_T_HIENODE WHERE IOBJNM <> '0HIER_NODE'.

• Shift nodename right to get space for compound characteristic

SHIFT C_T_HIENODE-NODENAME RIGHT BY 4 PLACES.

• Put chart of accounts into first 4 places

C_T_HIENODE-NODENAME(4) = 'TEST'. "<-- Your compound value

MODIFY C_T_HIENODE.

ENDLOOP.

• Add compound value to intervals in the same fashion

LOOP AT C_T_HIEINTV.

SHIFT C_T_HIEINTV-LEAFFROM RIGHT BY 4 PLACES.

C_T_HIEINTV-LEAFFROM(4) = 'TEST'. "<-- Your compound value

SHIFT C_T_HIEINTV-LEAFTO RIGHT BY 4 PLACES.

C_T_HIEINTV-LEAFTO(4) = 'TEST'. "<-- Your compound value

MODIFY C_T_HIEINTV.

ENDLOOP.

ENDIF.

*>>>> END OF INSERTION <<<<<<

--->CORRECTION OF CODING

_______________________________________

After the last ENLOOP statement I had to add:

C_T_HIENODE3[] = C_T_HIENODE[].

C_T_HIEINTV3[] = C_T_HIEINTV[].

Regards

Christian

[Former Member · Accepted solution]

Hello,

I am also considering the problem of de compounding infoobject (0CHRT_ACCTS) of <b>0ACCOUNT</b> that won't be filled in the hierarchy when I insert te ABAP code from OSS note 134975.

Like you said, the code SAP has given is not correct.

For that, I added the lines

C_T_HIENODE3[] = C_T_HIENODE[].

C_T_HIEINTV3[] = C_T_HIEINTV[].

after the last endloop, like you said.

But still, my hierarchy (from datasource 4R_SAKNR_0000_HIER) is not filled in the correct way; the compounding value is <u>concatenated</u> to the value of 0ACCOUNT and is not filled in the field 0CHRT_ACCTS of the hierarchy.

So, when you found the solution, is it possible that you have done some more than only added those two lines?

Could someone, please, give me the correct way of filling the field 0CHRT_ACCTS in the hierarchy of 0ACCOUNT?

thanx in advance,

Julie de Meyer