Fetching Data dynamically based on Fiscal Year from Ztable

[gauravabap]

Hi Experts,

Good morning,

I have a requirement where I need to fetch data from more than one table (4-8) depending on the fiscal year and month the user gives on the selection screen.

Let's say, User has entered COMPANY CODE, MONTH and FISCAL YEAR as 2018, The report has to show the data for the last 4 years from the date and month (06/2018) and also the next 4 years of data.

The data will come from ZTABLES, Tables are maintained year wise.

This has to be a dynamic ALV report, if the user enters the month of July 2018 then it should show from July 2018 to the following four fiscal years and the same for the past year.

I hope you understand my requirement and if not Kindly do let me know I will try to elaborate more.

Thanks in advance,

Regards,

Gaurav Singh

[gauravabap]

Hi Experts,

Good morning,

I have a requirement where I need to fetch data from more than one table (4-8) depending on the fiscal year and month the user gives on the selection screen.

Let's say, User has entered COMPANY CODE, MONTH and FISCAL YEAR as 2018, The report has to show the data for the last 4 years from the date and month (06/2018) and also the next 4 years of data.

The data will come from ZTABLES, Tables are maintained year wise.

This has to be a dynamic ALV report, if the user enters the month of July 2018 then it should show from July 2018 to the following four fiscal years and the same for the past year.

I hope you understand my requirement and if not Kindly do let me know I will try to elaborate more.

Thanks in advance,

Regards,

Gaurav Singh

[FredericGirod]

What is your issu ? the SELECT, the ALV, ... ?

What did you already do ?

What is the structure of the table ?

.....

[Sandra_Rossi]

The question how to do a "dynamic SELECT" has already been asked in the forum.

[RaymondGiuseppi]

SELECT, Dynamic Token Specification (in online documentation)