Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dynamic Status (How to do it Query?)

Dear BW Experts,

We have a Sales Query in which we have to display Sales Order No and its status adjacent to it.

Report Layout:

(show).........(hide) .........(hide).........(hide).........(show)

Order#......Crd Blck ........Dlv Blk.........Bil Blk.......Status

The requirement is that this status should be populated dynamically based on the values of Credit Block & Delivery Block and Billing Block. The columns for these blocks would be hidden. And only Status column would be shown to the user.

We have to follow certain ranking for deciding status. For example: If credit block is populated then status should be shown as Credit Block. If it is blank, then we have to check if Delivery Block is populated. If it is, then we would display status as delivery block. If Delivery Block column is blank then we have to check billing block and populate status as billing block if billing block is this.

Please do not suggest to use Macros. We have to display this report in Web/Portal.

Can somebody please tell how we can do this at query level?



Edited by: X Z on Sep 12, 2008 1:28 PM

Edited by: X Z on Sep 12, 2008 1:29 PM

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question