BEx variable input value

[Former Member]

Hi,

I have created a BEx Query, now based on selection screen inputs.

Selection Screen Inputs:

MATNR -

PLANT-

SLEVEL-(User Input Value) Mandatory

Now when i select inputs at the time of running query eg;

MATNR - 'ABC'

PLANT-'A123'

SLEVEL-'0.55' (User Input Value)

Now my report should look like this.

MATNR | PLANT | SLEVEL

ABC A123 0.55

ABC A123 0.55

Here SLEVEL value shld be user input value. How to achive this?

[former_member188325 · Accepted solution]

HI,

Drag and drop material and plant into rows of Query designer.Hope u know how to create variles for the same.if not,let me know.

now create a formula variable (SLEVEL)in columns (from context menu of KF structure) with replacement type 'user entry/default value'.Then user would be able to enter some value which appears in Query out.

Pl dont forget to reward points if it helps.

[Former Member · Accepted solution]

Hi,

Using Formula varible and Boolean expression concept you can get it.

1) Define a formula varible with user entry.

2) USe the varaible in the expression ,for ex:

FV2 = (fORMULAVARIABLE == SLEVEL ) * SLEVEL

3) PUT CONDITION on FV2 not equal to 0.

OR

Simply use Condition Varaible.

With rgds,

Anil Kumar Sharma .P

Message was edited by: Anil Kumar Sharma

[Former Member · Accepted solution]

Hi Murali,

Thanks for your answer..Yes now its working.

But now i want to do some validations for SLEVEL. Eaxmple if the Input value is Greater than >1 then shlould promp to enter value less then <1.

Can this be handled in Formula? Else do i have to write user exits.

Regards

[former_member188325 · Accepted solution]

hi,

i dont think we can handle validations in formula here.

But in the text of formula variable we can have text like

SLEVEL(Pl enter value > 1)....something like this.

thnaks

[former_member188325]

HI,

Drag and drop material and plant into rows of Query designer.Hope u know how to create variles for the same.if not,let me know.

now create a formula variable (SLEVEL)in columns (from context menu of KF structure) with replacement type 'user entry/default value'.Then user would be able to enter some value which appears in Query out.

Pl dont forget to reward points if it helps.

[Former Member]

Hi Brinda

u can obtain this by resticting object i.e by right clicking object u can select restrict, there u can create variables.

go through these help links

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a563fe09411d2acb90000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a56a7e09411d2acb90000e829fbfe/content.htm

Regards

kiran