Data in BW

[Former Member]

Vasu , your title has no relevance to the issue at hand - please use more descriptive titles for better answers

Hi I have data coming from Source system like '0001' and that I need to manupulate as 'US Customer' in BW if it is '0001' as 'US Customer','0002' as 'IND Cusatomer' like this.But the field for '0001' is defined as NUMC.Please help me to write routine and where to write the routine and what the IO to be definied in BW.

Edited by: Arun Varadarajan on Jan 27, 2009 8:00 PM

[Former Member]

if numc infoobject = 0001 then

BWobject = US customer

if if numc infoobject = 0002 then

BWobject = IND coustomer etc .

Crete BW infoobject as char .

Edited by: Ranganath Gulipalli on Jan 27, 2009 3:31 PM

[Former Member]

Thanks for the quick response and also for the suggestion.

But The field available in source CRM is in NUMC and the IO created in BW is Char.

Does it work if I map with routine to maipulate as said above?

[Former Member]

Yes it should work . Go ahead and give a try .

[Former Member]

Hi Vasu...

Yes u can do that...........While doing mapping.......U hav the following options .......

Direct Assignment

Constants

Formula

Reading Master Data

Routine

If the type of the field in the source and the target is different...........u can use Routine........The field is filled by the transformation routine you have written.....

Regards,

Debjani.........

[Former Member]

But During the activation of records in ODS the request is not getting activated and I checked in monitor I am getting a message like characteristics ZINTNTL and ZOPTY contains invalid characters .But whatever I assigned in routine are all allowed.There are just a alphabetes with '/' in between.

[Former Member]

As the check for the Lower case was not made in the IO So I was getting that error.

Now I made that check and it is working fine.

Thanks for the quick response all of you provided.

Thanks again.