Question Re: Digit no. are difference while data loading from bw to bpc.. in Financial Management Q&A

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

Former Member — Tue, 07 May 2019 09:06:24 GMT

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

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

former_member186338 — Tue, 07 May 2019 09:38:17 GMT

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/f9c45de06faf1014878bae8cb0e91070.html

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

former_member186338 — Tue, 07 May 2019 10:06:19 GMT

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

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

alan_valenzuela — Tue, 07 May 2019 14:15:03 GMT

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

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

former_member186338 — Tue, 07 May 2019 21:30:34 GMT

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

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

Former Member — Wed, 08 May 2019 09:27:25 GMT

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

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

Former Member — Wed, 08 May 2019 14:38:22 GMT

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

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

alan_valenzuela — Wed, 08 May 2019 14:56:18 GMT

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

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

former_member186338 — Wed, 08 May 2019 16:06:32 GMT

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.

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

Former Member — Thu, 09 May 2019 07:36:14 GMT

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

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

former_member186338 — Thu, 09 May 2019 08:36:34 GMT

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/, "")

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

Former Member — Fri, 10 May 2019 18:35:16 GMT

Thanku so much Vadim.

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

former_member186338 — Fri, 10 May 2019 19:00:05 GMT

akifa04

Then, please accept this answer as correct answer!