Skip to Content

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

Displaying dynamic columns in the query output.

Hello,

Depending on current quarter output of the query would vary.

If current quarter is 'Q1'

O/p : InvQ1 Del BackQ1 BackQ2 BackQ3 BackQ4

If current quarter is 'Q2'

O/p : InvQ1 InvQ2 Del BackQ2 BackQ3 BackQ4

If current quarter is 'Q3'

O/p : InvQ1 InvQ2 InvQ3 Del BackQ3 BackQ4

If current quarter is 'Q4'

O/p : InvQ1 InvQ2 InvQ3 InvQ4 Del BackQ4

So, out of 9 columns, 6 columns would display at any given time depending on the current quarter.

Invoice of 4 quarters, Deliquency and Backlog of 4 quarters.

I am not getting any way how to display dynamic columns or hide unwanted/blank columns.

For the time being I have added all 9 columns in the query, and in the output unwanted columns shows blank.

Can anybody please suggest me how to display only 6 columns in the output depending on current quarter.

Thanks and Regards

Shilpa

Former Member
Former Member replied

hi shilpa,

you can hide the columns with all values having zeros by making the following setting:

In properties of structure, check "Also use zero suppression for structure elements" and In query properties under display tab, select suppression = active(all values=0) and effect on = columns

thanks,

Rk

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