cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Bex Query Designer Year to date

former_member576227
Discoverer
0 Kudos

Hi all

I am trying to build a report that shows 2018 vs 2017 year to date. Of course 2018 will show the 2018 YTD number, however I cannot get 2017 to show the YTD number. I don't want the user to select any year or month, when the query refreshes it should just pickup the correct dates.

I tried putting a structure in using Invoice Year and then selecting Current Year -1 but that does not work. Any Suggestions?

Thanks

James

Accepted Solutions (0)

Answers (4)

Answers (4)

nora_roch
Contributor

Hi James,

check out the Feature 'Current Member Variable'.

Cheers,

Nora

former_member576227
Discoverer
0 Kudos

Hi Ashu

Thanks for getting back to me. I am pretty new to the Bex Query designer, so when you say RSRT what are you referring to?

former_member576227
Discoverer
0 Kudos

Hi Ashu

Thanks for getting back to me. I am pretty new to the Bex Query designer, so when you say RSRT what are you referring to?

cornelia_lezoch
Active Contributor
0 Kudos

RSRT is a transaction where queries can be executed withing the backend and more detailed info is available

ashu33
Participant
0 Kudos

Hi James ,

Just to Start with.

Can you please Check Info Tab in RSRT what year it is picking for PYTD?