Master data load of 0ASSET in BW to BPC

[Former Member]

Hi All,

I am trying to do the master data load from BW to BPC for 0ASSET.

Now 0ASSET has 2 compounding objects Company Code and Asset Main.

I need Asset Main as my ID. Below is the length of all the 3 objects.

Company Code  4

Asset Main        12

Asset                 4

I tried writting a Script as below in the mapping part of the transformation file.

ID=*IF(ID(1:4)=*STR(AE01) then ID(5:12);ID)

Here AE01 is the company code which I am expecting will become the first part of ID.

But this does not seem to be working.

I had done similart thing for Cost center where Controlling area was the compounded object and it worked there but it is not working for Asset.

And here I have 2 compounding objects.

If any has any one faced similar issues or have any idea on getting this resolved then request you to please help.

Thanks,

Nayan

[Former Member]

Hi Andy,

Reject list only gives the first line with Compnay Code AE01 that I have filtered and nothing else.

This is what I tried next. I created a transformation file as below without conversion file.

You can see the result I get as the output above.

Then I added the below conversion file.

Then I get the below result.

Baiscally I need 12 characters which I get in between for 0ASSET_MAIN which I am not able to get.

[former_member186338]

DELIMITER=TAB for loads from BW

[Former Member]

Tried TAB as well. Does not work.

[former_member186338]

"Does not work" - screenshots?

[Former Member]

Hi Nayan,

try ID=0COMP_CODE+0ASSET_MAIN

why do you add ID again? you don't need that.

also beware of internal and external formats, you won't get your 12 char by concatenating those 2.

comp_code is 4, asset_main is 12, so if you add them together you get 16!

Andy

[Former Member]

Hi Andy,

Below is the transformation file.

Below is the conversion file.

And this is the error Message I get.

Let me know if you need any more details.

[former_member186338]

Incorrect conversion file - only first line will work!

after first * no more lines are processed.

[Former Member]

whats in the rejected list?

[Former Member]

Hi Nayan,

what is the error?

Andy

[former_member186338]

"But this does not seem to be working." - screenshots of transformation validation results...