When MIGO received PO, how to link the PO Delivery Schedule period?

[Former Member]

Dear All,

I want get the PO Delivery Schedule of this schedule period received date. But in EKET only Delivery Date, Not have MKPF posting date. In EKBE, have posting date, But when EKET have some items, how to get the correct period posting date.

Thanks

Sun

[Former Member · Accepted solution]

you need to join EKBE and EKET table. with the help of ABAP team.

the reason behind is EKBE is History per Purchasing Document

where as EKET is Scheduling Agreement Schedule Lines

or if you have authorization then create query on your own by Tcode SQVI.

Edited by: deshamol on May 21, 2009 11:08 AM

[Former Member]

done

[Former Member]

Hey,

I am also looking for the same link. Can you please post how you established the linke between GR and Schedule line.

Thanks in advance,

JJ

[Former Member]

hi,

my question have not solved,Because i saw nobody to respond this issue for some days.so i closed this issue.

[Former Member]

EKET you will get after the creation of the PO.

But GR Posting date you will get once the GR will done,in EKBE.

Then Link the table EKET and EKBE to get the GR date.

Or with the refe. of PO no. hit the MSEG and MKPF.

[Former Member]

hi,all,

Thanks

i know used EKBE link EKET,but when EKET have some items,how EKBE linked the correct items?

Because i have case need to get received date-schedule date.

if PO only have one schedule line,then have no problem.but if have some schedule lines,the received date how to link the correct schedule line?

my idea is :used the received qty - schedule qty to get received date

[Former Member]

For example:

In PO 50xxxx. Delivery Schedule:

EKET

1. 04.01.2009 Sched.Qty 10.

2. 04.20.2009 Sched.Qty 20

EKBE.Received

1. 04.10.2009 Received 15. Material Doc No. 48xxx1

2. 04.15.2009 Received 15. Material Doc No. 48xxx2

My question is :How to Material Doc No. 48xxx1 linked the PO Delivery Schedule 1 (04.01.2009)