Digit no. are difference while data loading from bw to bpc..

[Former Member]

Hi Folks,

I am very fresher in Sap BPC .I have one scenario in bw (iC) side they have 10 digit account no.but in SAp bpc side they have 6 digit account no.while data loading how could be achieve this requirement means how to adjust 4 digit this no. Please let me know.

Thanks

Ishrat Akifa

[former_member186338]

Sorry, but what BPC you are using: BPC MS or BPC NW????

[former_member186338]

Accept-Unaccept-Accept-Unaccept? What was the idea behind???

[Former Member]

Thanks Guys .

I mean i have 10 digits account in BW side and BPC side have 6 digits..so while data loading how to remove 4 digit.??

Please help me.

Thanks

Ishrat Akifa

[alan_valenzuela · Accepted solution]

Hello, if you problem is your accounts have 10 digits in BW but your accounts have 6 digits in BPC, you need to use a conversion file.

If that is your situation, I let the next link https://help.sap.com/saphelp_boao22/helpdata/en/f9/c45de06faf1014878bae8cb0e91070/frameset.htm

[Former Member · Accepted solution]

Thanks .

I mean i have 10 digits account in BW side and BPC side have 6 digits..so while data loading how to remove 4 digit.??

Please help me.

Thanks

Ishrat Akifa

[alan_valenzuela · Accepted solution]

Hello, look you have to set up a conversion file, if you use BPC NW standard, you have to go, to next route.

Data Manager -> Conversion File -> New Conversion file

In the column EXTERNAL puts the accounts BW (10 digit) and the column INTERNAL puts the accounts BPC (6 digit) like this.

Then you have to set up the transformation file, here I let you a link the SAP help BPC

https://help.sap.com/saphelp_boao22/helpdata/en/f9/c45de06faf1014878bae8cb0e91070/frameset.htm

[former_member186338]

You can use JavaScript in conversion file like:

external internal
*        js:%external%.toString().slice(-6)

or, if you want to remove "1100" at the beginning of string:

external internal
*        js:%external%.toString().replace(/^1100/, "")

[Former Member]

Thanku so much Vadim.

[former_member186338]

akifa04

Then, please accept this answer as correct answer!

[former_member186338]

If you have some rule for conversion from 10 to 6 digits then it's better to use JavaScript in conversion file, not a table that is hard to maintain (like in alanvalenzuela sample)! But you have to explain required logic.

[Former Member]

Thanks Vadim For your advice.

I have around 1000 account they have 10 digit no.( e.g 1100254817) i want to remove 1100 so result would be come out 254817.If i will use conversion file its very hard to maintain all 1000 accounts in excel . They have any alternate way so i can achieve this?

Thanks

Ishrat Akifa

[former_member186338]

If you are talking about decimal digits in data values then in transformation file you can use rounding with: ROUNDAMOUNT

Clearly explained in help:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.34/en-US/f9c45de06faf1014878bae8cb...