Hierarchy Extraction of FI-SL Set with Compounding - Conversion Errors

[Former Member]

We need to extract a hierarchy for G/L Account based on sets created in R/3 Transaction GS01 (set class 0000). I have used R/3 Transaction BW07 to create the data source. The BW InfoObject 0GL_Account is compounded with 0CHRT_ACCTS.

SAP Note 134975 says to execute compounding in a customer exit. We have created a project for the SAP enhancement RSAP0001 and implemented program ZXRSAU04. Do I need to add any code to this program? (The note refers to an attachment, but there is no attachment to note 134975.)

When I extract the hierarchy to BW, I get an error in the second step of the process -- "start update of master data hierarchy." The error is "The technical node name for node id 00000002 is not consistent for conversion exit ALPHA , which is stored with InfoObject 0GL_ACCOUNT ." I have checked the Conversion box for 0GL_Account in the transfer rules, but still get the error.

Anyone able to help?

(Note: If I create the data source without compounding, I can extract it successfully, but then all GL Accounts fall into the Unassigned category because they don't have any values for the compounded InfoObject Chart of Accounts.)

[Former Member · Accepted solution]

See attached source code to the note. It contains the following.

• 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.

[Former Member · Accepted solution]

Thank you Brad. I will have to learn to come back and click the Solved it on my own button, since I had resolved this back in June.

One thing that folks should know if they use compounding is that you do not see the compounding value when you use RSA1HCAT to check your extract. But it works when you actually pull the hierarchy into BW.