Load Hierarchies using PSA

[Former Member]

Hello,

We are trying to enable the sign reversal characteristic (0SIGNCH) for a hierarchy in order to reverse signs of certain accounts during extraction.

The documentation refers to the following prerequisites:

"...the hierarchy must have flexible hierarchy structures. This is the case when the hierarchy is loaded via the PSA and, as a result, has transfer rules."

"A hierarchy DataSource from a SAP source system must support loading by using a PSA."

How can we determine if the hierarchy datasource supports PSA loads? Example?

Is there a way to enable PSA loads for hierarchies?

Thanks,

Adam

How can we enable

[Former Member · Accepted solution]

Hi Adam,

in the transfer rules (in the infosource created to upload your hierarchy) you can choose as transfer method PSA or IDoc...

Hope now is clearer !

Bye,

Roberto

[Former Member · Accepted solution]

Thanks for the reply Roberto,

This infosource is for 0COSTELMNT.

There is no Comm Structure or Transfer Rules for Hierarchies. Only the Transfer Structure is available. Thus, the Transfer Method option is not available.

Is the PSA transfer method set in the Datasource in R/3?

Thanks,

Adam

[Former Member · Accepted solution]

Hi Adam,

in the 'Special Features when Loading using the PSA' section inside the help for hierarchies you can read that "Prerequisites: a hierarchy DataSource from a SAP source system must support loading by using a PSA".

So, go in your R/3 and search the value of the field TFMETHODS in table ROOSOURCE for your hierarchy datasource...I think you will find '1' (Idoc only)...

Let me know if my doubt is confirmed!

Bye,

Roberto

[Former Member · Accepted solution]

Roberto,

Happy New Year!

This is what I suspected also. The DataSource in question (0COSTELMNT_0102_HIER) is enabled for Idoc only (TFMETHOD = '1'). The other options are 2-(PSA only) or 3-(Idoc and PSA).

Would it be possible to trick the system by manually changing this to 3? Or is this not recommended?

Thanks,

Adam

[Former Member · Accepted solution]

Hi Adam,

I never switch the transfer method so I never tested if such 'homemade' operation could really be useful...I made a little search on OSS and documentation, but I don't found any reference.

It is beyond doubt that it's not recommended and, honestly, I think also that a simple switch is not enough to let the system working with another method (if this method is not supported...)

Bye,

Roberto

[Former Member · Accepted solution]

Hi Adam,

I would NOT recommend tricking the system this way. The extractor needs to deliver different packages for IDOC and PSA and is not enabled to do this.

When the PSA method for hierarchies was introduced the development decided to enable this feature for only one extractor, I think it was EC-CS items or something similar because they wanted to make use of the new feature 'Signs on Nodes'. The other extractors were not changed and up to then there were no plans to change it.

If you need this you should contact development and ask for a solution. Maybe the problems aren't critical for 0COSTELMNT and you can change it, maybe they provide a solution with remote consulting, maybe they think your reasons are valid and they provide a note.

Best regards

Dirk

[Former Member · Accepted solution]

Roberto / Dirk

Thanks for the replies. I will explore this more with SAP development.

We have a requirement to reverse signs for certain hierarchy nodes and would like to do this within transfer rules for hierarchy extracts. But this is only possible for hierarchies that are PSA enabled. And as Dirk pointed out, this is only enabled for one hierarchy to date.

Another alternative we are exploring is to create a custom ABAP to selectively reverse nodes within a hierarchy.

Thanks again,

Adam

[Former Member · Accepted solution]

Hi Adam,

if you choose to create some ABAP lines, you can do this by putting your own code in the userexit provided in R/3 after data extraction (EXIT_SAPLRSAP_004)...

Bye,

Roberto

[kabordner · Accepted solution]

Adam,

I have been searching for answers to a similar problem. We need to do sign reversal on a node of a hierarchy that is being loaded from 0GL_ACCOUNT. That too seems to only have an IDOC extractor.

Could you tell me if you have found a work around for your problem? I have spent a few days trying to figure out what I could do to be able to have the signs reverse on our hierarchies, but have not gotten very far.

Any replies will be appreciated.

Thanks!

Karen