How to display Valid to and Valid from dates for 0Equipment in Bex Query

we want Valid to date and Valid From Date Fields in our report for 0Equipment. so that we can find during this particular period where exactly the equipment is located or its status.

Suppose say equipment 1

is in location delhi from 1st april to 5th april and

in mumbai from 6th april to 10th april

i want to display in my report like below

Equip Number Date to Date from location

equip1 10th april 6ht april mumbai

equip1 5th april 1st april Delhi

date to and date from are fields for time dependent equipment data

regards