Vendor Schedule Agreement link between material and scheduling number

Hi,

I have to prepare vendor schedule agreement report having the following inputs

1. material - matnr

2. run date e.g item delivery date -- > eket-eint

3.schedule Agreement number --> eket-ebeln

Am able to get the data in schedule agreement table--> eket. we have to run the report on

1. weekly forecast

2. monthly forecast.

I want to know the link between the material and the schedule agreement number.We can check the material using

MD04 transaction and the schedule line for it.

Thanks,

Rajat Kumar Sharma