Feeding GL data from different source system into Finance Application

[Former Member]

Hi all,

I am trying to do an exercise where I am loading GL data from four different source system into finance application. I have data in the flat file and I can load it in finance application but the problem is the Account in all the four system have different lengths.

What should be my approach in such scenario and can I truncate the Account data using conversion file?

Any suggestion.

Regards,

Diksha.

[Former Member · Accepted solution]

Hi Diksha,

You can definitely maintain a conversion file to do this activity. You can use java script for this purpose. Please refer to the below link for further reference.

http://help.sap.com/saphelp_bpc75/helpdata/en/81/94a8a5febd40268d5c59b4fc31be37/content.htm

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan,

I tried doing this.

I want to truncate incoming data and only pick last few characters. so here is my conversion file

External -> XXXXXXXXXXXXXXXXXXEXTSALES

Internal->

Formula-> js: %external%.substring(19,8)

Please suggest.

Thanks,

Diksha.

[PatrickFavre · Accepted solution]

Hi,

In that case, you should choose to use 2 other options:

1) External -> XXXXXXXXXXXXXXXXXXEXTSALES

Internal-> EXTSALES

Formula->

It's here supposed that you maintain one row for each account.

2) External -> *

Internal-> js: %external%.substring(19,8)

Formula->

It's here supposed that you will always keep the same characters into Internal account for all external account.

No need to use the Formula column in both cases.

Hope this will help.

Best Regards,

Patrick

[Former Member · Accepted solution]

Hi Patrik,

I tried the second option using Java script. Here is my conversion file as suggested -

*INTERNAL -> *

EXTERNAL -> js: %external%.substring(19,8)

*FORMULA -> *

It gives me error

Rejected list

[DIMESION: Account]

js: %external%.substring(19,

[DIMESION: Category]

😎

I also tried doing this but it fails.

**INTERNAL -> *

**EXTERNAL -> *

FORMULA -> js: %external%.substring(19,8)

**INTERNAL -> *

*EXTERNAL ->

*FORMULA -> js: %external%.substring(19,8)*

I am not sure how make conversion file execute Java script. As when I put java script in internal column then it treats it like a string and when I put it in formula column I am not sure what should I put in internal column. If i keep my internal column empty then it gives me error. If I put * then it just copies the external format and does not execute the Java script and fails.

Please suggest.

Regards,

Diksha.

Edited by: Diksha Chopra on Jun 3, 2010 7:32 PM

Edited by: Diksha Chopra on Jun 3, 2010 7:36 PM

Edited by: Diksha Chopra on Jun 3, 2010 7:37 PM