Skip to Content
0
Former Member
Aug 25, 2008 at 03:56 PM

Link between EKBE and EKET for the below scenario

425 Views

Hi all

We have a requirement to display schedule line number(eket-etenr) for purchase order and for each history of quantities in table EKBE (ekbe-ebeln ,ekbe-ebelp). Please suggest how we can link these two tables,

As i need to display the eket-etenr upto the quantity confirmed on latest date..

The example is below for quantity 81.

If Purshase history is

EKET-menge EKET- etenr

81 --- 0001

5 -


0002

10 --- 0003

date move-typ EKBE-menge cum-sum ETENR

01/26/2004 101 10 10 0001

01/26/2004 101 10 20 0001

01/27/2004 101 20 40 0001

01/27/2004 101 20 60 0001

01/30/2005 101 10 70 0001

03/31/2005 101 1 71 0001

03/31/2005 101 10 81 0001

04/01/2005 101 9 90 0001

11/20/2006 102 -9 81 0001

06/04/2006 101 3 84 0002

06/05/2006 101 1 85 0002

06/06/2006 102 -1 -1 84 0002

06/07/2006 101 3 87 0003

06/08/2006 101 9 96 0003

We need to display EKET-ETENr for each ekbe entry whenever the quantity is delivered til that line.

Pleae suggest possible ways.

Regards,

Latha.