Implementation of Custom Retractor in Cost Center Planning

[Former Member]

Hi All,

I am facing a problem regarding Implementation of Custom Retractor.

In our Project TM1 Server which is presently existing is to be replaced by BI server for Cost Center Planning.

The value needs to be retracted back to the R/3 server for poplutaing the Source Table fields.

Now our Business requirement is best suited by implementing a Custom Retractor which would fetch the data from

BI back to R/3 Server.I have some queries regarding this implementation.

1> The Data load Function Module & Post Data Load Function Module which is implemented for Data loadinf into R/3 server

is written in which server (BI / R3)? If its written in R3 as the case seems them how the BI table type needs to be declared in the

function module?

2> What the Function Module is returning ..is it directly updating the DB table or returning a structure?

Our project is still in the Realisation Phase....So no development has began yet....

Eagerly waiting for your response.

Thanks a lot..

[Former Member · Accepted solution]

Hi.

Have you thought about RFC function on ECC side and invoke it from BI side ?

Why you have not use standard CO retractor ?

Regards.

[Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]

SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]

[SCN Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];

[Former Member · Accepted solution]

Hi Uryikin,

Thanks for your response.

Standard Retractor does not satisfy the Business requirement in full.

The RFC connection you have suggested is what we are implementing through RSPLAN function Type creation.

In the RSPLAN we are implementing a Class which will fetch the Data from the Infoobject.

This infoobject will be fed from the target Infocube. After this Class getting populated Mapping will be done b/w BI source fields and the R/3 source fields.

Now the problem arise when a Function Module needs to be created that will actually bring the data to R/3 side.

The server where Data Load function Module is to written is still unknown to me..

The Function Module Return type is also unknown...

As this is totally customised we have to identify the return type for submission of Blueprint...

Kindly refer to this link we are implementing this same steps only on different scenario...

http://www.docstoc.com/docs/25252336/MDX-The-Basis-for-SAP-NetWeaver-BI-Third-Party-Interfaces/

Please Reply...

[federico_blarasin · Accepted solution]

Hello Abhi

once I coded a program for a custom retractor, quite similar to:

/people/praveen.mayalur/blog/2006/08/24/how-to-retract-bps-data-back-to-r3-when-there-is-no-standard-retractor

The program is calling a function in R/3

BAPI_COSTACTPLN_POSTPRIMCOST

which is a BAPI for posting in the cost center accounting and it's on the R/3 server.

I think your methods are doing something similar.

Hope it helps.

[Former Member · Accepted solution]

Hi,

if there is a way on manually typing in the plandata, you might consider the transaction recorder. Using the TC you get some code fragments that might be surrounded by on implemented in some FM. This special FM might then be callef via RFC from the BI system retracting the data.

Cheers,

Yann