scheduling agreement tables

[Former Member]

Hi,

I need to retrieve the condition types of the scheduling agreement.

It was in KONP,But there is no link field for each Scheduling agreement.

I donmt want BAPI for this.Only thing i need a query between the tables.

[GauthamV · Accepted solution]

Use combination of EKKO,EKPO,EKET,KONP tables.

[Former Member]

Hi ,

To get condition type for scheduling agreement first go to table A016, enter the appropriate details, scheduling agreement number , item and get the condition record number (KNUMH).With this condition record number go to table KONP and enter condition record number in KNUMH.This is the unique key in both the tables.here you will get condition types.

Thanks

Tejaswini Khante

[Former Member]

Hi,

Try like this, I hope scheduling details are stored in VBEP table, then get the vbeln from there and get condition record no

from VBAK & get item details from VBAP for that vbeln. Then with that condition record no and item chk the table KONP.

I hope it solve ur problem.

Regards,

Senthil