Skip to Content

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

Last Consumption & Last receipt date logic


I am facing some issue while developing BI Stock report where user wants last consumption date & last receipt date in the report.

But issue is that when i am going to develop BI query how can i differentiate date for both consumption & receipt because consumption & receipt has differentiate with movement type (suppose Mov type : 101 is for receipt & 261 is for consumption then if i use exceptional aggregation and put last value & reference char as Mov type then all 101 & 261 mov type data will come.

Please guide for developing last consuption & last receipt date logic



Former Member

Helpful Answer

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