0CMMT_ITEM_FMCI_PU_HIER Syntax Error for Generated Program

[Former Member]

Hi Experts,

I am trying to simulate the 0CMMT_ITEM_FMCI_PU_HIER extractor using RSA3 tcode. Howerver, the following error was issued:

Message:RJ028 Error 6 in function module RSS_PROGRAM_GENERATE

While debugging the code, I was able to pin point exactly where it was erroring. In function module, RSS_TEMPLATE_INSTANTIATE, there is a SYNTAX-CHECK for a generated program. Apparently the generated program has syntax error. Below is a snippet of the generated program:

PROGRAM GP45NSX4KBG4XF231MKVQISJ278 MESSAGE-ID R3.

----

---

• Generated subroutines for hierarchy data transfer

• BW release >= 3.0

----

---

• Template.............: RSAPTH3

*

• DataSource...........: 0CMMT_ITEM_FMCI_PU_HIER

• Source system........:

• Target system........:

• Global unique ID.....: 45NSX4KBG4XF231MKVQISJ278

• Transfer method......: C

*

• Generation program...: %_T00JM0

• Generation date......: 05/02/2007

• Generation time......: 10:52:03

• Generation release...: 640

• Generated by.........: XXXXXXXX

----

---

• Includes and type pools

INCLUDE LRSAPD00.

TYPE-POOLS: RSAP, RSAOT, RSUDT, RSFH. "FH

• Types declaration for generic. structures

TYPES:

<b>TY_S_HEADER LIKE ,</b>

TY_S_HEADER_TEXT LIKE ,

TY_S_NODE LIKE ,

TY_S_NODE_TEXT LIKE ,

TY_S_HEADER_TS LIKE ,

TY_S_HEADER_TEXT_TS LIKE ,

TY_S_NODE_TS LIKE ,

TY_S_NODE_TEXT_TS LIKE ,

TY_T_HEADERS TYPE TY_S_HEADER OCCURS 0,

TY_T_HEADER_TEXTS TYPE TY_S_HEADER_TEXT OCCURS 0,

TY_T_NODES TYPE TY_S_NODE OCCURS 0,

The syntax error occurs when declaring TY_S_HEADER. (Statement concluding with "...LIKE" ended unexpectedly.)

<b>Since this is a generated program how would I go about fixing the syntax error?</b>

Any help will be greatly appreciated.

Thanks,

BQ

[Former Member · Accepted solution]

It appears like extraction structure is not active....activate your datasource in RSA5 and try again...

Regards

[Former Member]

Hi,

here you go: https://websmp101.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=705212&_NLANG...

regards

Siggi

[Former Member]

Hi -

I'm getting the same error for 0CRM_ORGUNIT_HR01_HIER.

I'm doing a RSA3 in CRM and giving the above structure and getting the Error 6 mentioned above.

I also did a SE38 and executed RSA1HCAT. When I do that, I see a 'red' dot in the Hierarchy tab.

How do I fix this? I checked the OSS note mentioned above but this seems like an old one.

We're in ECC 6.0 and BI 7.0.

Any ideas any one please?

[Former Member]

Hi,

For this problem look at the note: 632920.

Regards,

Srikanth.

[Former Member]

I have got the same problem.

And I have tried the method all above , also can't solve the problem.

Coule any one can help me?

Thanks!~

[former_member21257]

Hi,

This Rj028 / error 6 indicates that you were testing hierarchy datasources.

Please don't use transaction RSA3 for testing or checking the extraction of hierarchy datasources. This transaction is not meant for checking hierarchies, as it can lead to the error you have mentioned above.

Instead use the report RSA1HCAT, to check hierarchies and to display

the following:

1.Meta data

2.Hierarchy tree

3.Hierarchy list

RSA1HCAT is a pure display report which cannot change the hierarchy, & won't influence the display in RSA3. It will not change whether the error is given or not in RSA3.

See attached SAP Note 483878 for further details.

Rgds,

Colum

[Former Member]

Hi,

To view this hierarchy you cannot use RSA3.

Go to SE38 and run program RSA1HCAT, then you will be able to see it.

Br.

[Former Member]

Same problem here with 0CRM_ORGUNIT_HR01_HIER. Did you also try to do a load with the datasource from BI? I found that after replicating the datasource and scheduling a load from BI, the extractor does yield results. That could mean that the extractor itself does work correctly.

If anyone finds an answer as to why RSA3 doesn't work I would greatly appreciate it.

[Former Member]

I activated the datasource again, but the error is still occuring.

Thanks,

BQ

[Former Member]

hello everybody,

I've got exactly the same problem!....any idea?

kind regards

rasec