Conversion routine in BW for getting converted value for Partner Function

[Former Member]

Hello Gurus,

I have a requirement in BW to display both the unconverted and converted values for Partner Function (PARVW field). I created a datasource in ECC based on the TPAR table and am bringing over the unconverted values. Now I need to also bring in the converted values. Here is my example:

Converted Unconverted Text

PY RG Payer

BP RE Bill-To-Party

SP AG Sold-To-Party

Is there an equivalent Function Module to 'CONVERSION_EXIT_PARVW_OUTPUT' in BW that I could use in my routine to populate the converted value to a compounded Infoobject that I created in BW? BW does not have the above mentioned Function Module. It would be very helpful if you could also send me the code for the routine to do this conversion. Thank you.

Edited by: Alnick on Sep 14, 2009 1:09 PM

[Former Member · Accepted solution]

Hi,

We have also searched for it and finally ended up in doing the routine as follows.

IF partner function 'AG'

then result = 'SP'

for those which has external and internal format different.

BI Doesnt have customer partner table information KNVP. if they would have designed then possibly we will have partner function internal and external format. As they dont have it in BI only we have to customize it according to your requirement.

Hope this helps for you.

Thanks,

Arun

[Former Member · Accepted solution]

Hi Arun,

Thanks for your reply. Your recommended was my 2nd option but I was wondering if there is a maintenance free way of using a conversion function module. This way if anything changes I do not have to go back and change my routine.

Thanks,

Al

[dennis_scoville4]

There are a couple of options to handle this:

1) Change the source of your generic DataSource to extract data from the TPAUM table, which has both the converted and unconverted Partner Functions on it. This could be a source as Master Data Attribute and Master Data Text DataSources.

2) Change the source to your generic DataSource to extract data from a custom view of TPAR and TPAUM. This could be a source as Master Data Attribute and Master Data Text DataSources.

3) Add a User Exit in CMOD to your DataSource of TPAR to do a lookup on TPAUM.

4) Extract TPAUM as a separate DataSource and use that for joining with the TPAR data in SAP BW.

[Former Member]

Hello Dennis,

Using TPAUM table is an excellent idea for creating a View or creating a datasource directly from the table and doing a lookup in BW. However TPAUM is not a transparent table and therefore I cannot create a view or a datasource on ECC side. Any other suggestions to get the entries in thsi table in BW?

I assigned points.

Thanks,

Al

[dennis_scoville4]

I forgot that TPAUM is a pooled table. In that case, you can still use that table as the source for a DataSource, but you'd have to create a custom extraction structure and Function Module to extract the data from it. We had to do this for an extraction of A016 data.

1) Create an extraction structure that looks just like the TPAUM table (MANDT or Client isn't necessary but won't hurt anything).

2) Generate/activate the extraction structure.

3) Create a Function Module, using Function Module RSAX_BIW_GET_DATA_SIMPLE as a template.

Here's a pretty good article on creating a generic DataSource using a Function Module: [http://www.sdn.sap.com/irj/scn/index;jsessionid=(J2EE3417800)ID0647168250DB11004317103980282734End?rid=/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8df33&overridelayout=true]

[Former Member]

Thank you Dennis for your solution and the link to the article on Function Module. We decided to maintain the converted values in BW instead of the creation of function module. We only have few conversion values to maintain. It seemed burdensome to create Fm and write code. Points have been assigned.