Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Vendor Schedule Agreement link between material and scheduling number

Former Member

‎11-11-2011 5:12 AM

0 Kudos

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

1 REPLY 1

Former Member

‎11-11-2011 5:29 AM

0 Kudos

You can inner join EKKO, EKPO, EKET tables or join view MASSEKPO with EKET and restrict the selection to scheduling agreement by specifying EKKO-BSTYP = 'L'. EKPO has a secondary index by MATNR so you should be able to query scheduling agreements by specifying EKPO-MATNR in where clause.

EKET contains scheduling agreement schedule lines, but it should be queried via EKKO and EKPO as MATNR is available in only EKPO and the indicator for scheduling agreement is available only in EKKO-BSTYP = 'L'

You can get a list of unique materials from MARA (material master) / MARD (stocks) and can then use them to query EKKO - EKPO - EKET inner join