cancel
Showing results for 
Search instead for 
Did you mean: 

Query Output

Former Member
0 Kudos
45

Hi,

Can anyone please help me in understanding how to get the display of query in Bex for the following format attached.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Nicky,

You can create two structures in columns and define keyfigure In both the structure.

Using the structure will give you the required output.

Regards,

Amit

Former Member
0 Kudos

Hi Amit,

Can you help me with somewhat detail.

Loed
Active Contributor
0 Kudos

Hi Nicky,

Just drag your MATERIAL object in ROWS pane..Then drag your PLANT object in COLUMNS pane then below it is the structure of your KF..

Is this correct?

Regards,

Loed

Former Member
0 Kudos

Hi Nicky,

You need to drag the characteristic in the column and the you need to create a structure.

Then select the keyfigure using the "New selection".

Regards,

Amit

Former Member
0 Kudos

Hi,

I have a requirement of what I have attached in attachent. First screenshot is the output which we require and second screenshot is the objects already available in Query designer. Can you help out if that is possible in bex or not.

yasemin_kilinc
Active Contributor
0 Kudos

Hi Nicky,

I am not sure if you can apply this to your final requirement, but for the screen shot in your first post, you can simply create a top 1 condition on KF1 using only characteristic Plant. Maybe then you can apply this approach to your scenario.

Hope it gives an idea

Regards

Yasemin...