BPC Conversion file

[former_member221145]

Hi Experts,

I am trying to acheieve the below condition in BPC conversion file using Java Script.

When GL account starts with 1 and ends with 1 and Value < 0 then GL+"L" Else GL

js:%external%.Value<0 ? %external%.toString()+"L": %external%.toString()

I have also tried the below

I have followed the syntax from the below threads

https://answers.sap.com/questions/11917893/conversion-file-question.html

https://answers.sap.com/questions/11288651/jsscript-in-conversion-files-with-if-then-else-syn.html?s...

https://www.w3schools.com/js/js_math.asp

Thank You,

[johnnbc]

How will it start with a 1 and be less than 0?

[N1kh1l]

what do you mean by value <0, do you mean the account balance is -ve ? if yes then you cant handle transaction data in javascript. You can only use javascript to do masterdata manipulation. For transaction data checks you have to use BADI (UJD_ROUTINE)

Nikhil

[former_member221145]

John, the condition which I have mentioned about account starts with 1 and ends with 1 is for the Account ID and the less than 0 is to check the balance of the Account is negative.

[former_member186338 · Accepted solution]

Value system variable can be used only in FORMULA column - not your case!

The only solution is to write UJD_ROUTINE BADI

P.S.

"I want to update the master data" - slightly confusing! May be you mean that you want to change target account?

[former_member221145 · Accepted solution]

Hi Vadim,

When the Asset account balance is less than 0 then I want to map the GL Account to a different account.

In my example 1???????1 is the account in my external. When balance for asset account I'd beginning with 1 and ending with 1 and the balance of such accounts is negative then map the GL to a different GL account.

Thanks,

Rohit

[former_member186338 · Accepted solution]

rohit.padala

That's what I assumed!

And you have a clear answer - write badi.

About 2 hours for ABAP developer. It's simple!

Old but useful document: https://cupdf.com/document/how-to-use-start-end-routine.html?page=1

Unable to find it on SAP site.