IF condition in reporting

[former_member1215196]

HI friends

I am creating report . i have one seanrio for example

if x= a

take values from y table

Else

x = balnk

take values from z table

How will i write this condition in report Please suggest to me.

Thanks for your sugesstion

Patel

[Former Member]

Hi Patel, I'm asking this just to get some clarity on your issue. Is this OLTP reports or BI? I guess this question is basically reg. R3 tables creation? If not, and its related with BI/W, you may need to create a relation, where you can use a function module; but as your conditions are simple, you may try using a table structure/view on R3 with related tables. In R3 system, Goto SE11 > View: 'Create' > Maintain View > Key in the related tables' feilds like ARTNR, MVKE using common tables: MSTA & MABW etc. Once you are done, just create a Data source in RS02. Replicate the datasource(s) on BI/BW systems selecting your Source system. Upload data from R3 & use the above simple IF conditions at transformations level (like start routine); Else, you may also try loading as 2 seperate data sources & use some joins to relate the data. Thanks.

[Former Member]

Hi Patel,

What is meant by Table here? Are you referring to an InfoProvider? Is this condition to be implemented in Query Designer?

--Priya

[former_member1215196]

Hi Priya

i am not referring any cube i want write in query only

[Former Member]

Hi Patel,

Ok, can you explain what is meant by Table here? I mean explain what logic you want to implement in the condition.

--Priya

[former_member1215196]

Hi Priya

Actually logic is this

IF Reversed (STKOZ) = X then get Activity to Confirm (ISM01-ISM02)X-1,If Reversed (STKOZ)= Blank then get (ISM01-ISM02)x1 per object and per activity to confirme .

How to write this logic in report

[Former Member]

Hi

i cant get what is the table but any how try this if it works in query.

(X=A *Y)) +(X= - *Z))

HERE ( IMPLIES IF AND * IMPLIES THEN + IMPLIES ELSE

HOPE THIS HELPS