Skip to Content

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

Two time periods in one query

Hello all,

I have one query which select material movements within a time period. Therefore I have the characteristic 0CALDAY and variable 0I_DAYS.

Is it possible to enter two time periods at once in order to analyse material movements for two time periods and buils a difference between both.

I could do this with two queries in a workbook, but I want to do this in one single query.

Any ideas would be great.

Best Regards,

Stefan from Munich/Germany

Former Member replied


Yes, use a structure.

Have 0CALDAY in both selection in a structure, one with a variable that prompts for the first time period and the second with a different variable that prompts for the second time period.

If you put two ranges on the characteristic outside of a variable you wont be able to compare the two values as they will all run into each other.



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