Relation between EKET and EKBE other than doc numbers

[Former Member]

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

[Former Member]

If you are trying to develop a report.. this might not be the best wy to do it.. Instead go to ME2N and enter teh scope of list as EINT, and selection paramaters like WE102, WE106 or similar.. that'd suit your requirement