B1IF variable Creation

[Former Member]

Hi Experts,

Good Morning,

I want create Variable in B1if, then how to get the value for that variable through SQL Call.

Please help me out.

Thanks

Karthick

[Former Member]

Hi,

Good Morning

It's urgent please help me out.

Thanks

Karthick S

[Former Member]

Hi Karthick

I'm not sure what exactly do you need but in the first place you should open (to edit) any atom and locate button (third from left side) which, after clicking it, will open a new window with documentation about using variables. Or you can log in to B1iF, open new tab in your browser and use this link:

http://<your-server-name>:8080/B1iXcellerator/exec/dummy/com.sap.b1i.vplatform.ide/doc/B1iFW02ScenDe...

I guess all you need to know about variables is there. Check especially 3.3.7.3 section.

Kind regards,

Radek

[Former Member]

HI ,

Good Morning

I tried the below Xpath in my local variable but it's showing following error. if some one known solution for this please help me out.

Xpath:/vpf:Msg/vpf:Body/vpf:Payload[./@Role='C' and ./@id='atom1']/jdbc:ResultSet/jdbc:Row[1]/jdbc:LINENUM/text()

Error Msg:com.sap.b1i.utilities.UtilException: UTE001 Nested exception: com.sap.engine.lib.xml.util.NestedException: SQL exception (207 - Invalid column name 'NaN'. - S0001)

Thanks

Karthick S