Skip to Content
0
Former Member
Jul 07, 2007 at 09:45 PM

question on EKBE table

168 Views

Hi All,

I am able to retrieve the goods receipt data and the invoice receipt data based on the field trans/event type (if 1 then it is goods receipt record, if 2 then it is an invoice receipt record). Actually all I wanted is ENTERED ON date.

Now I have

PO (po number, po line item) -


> Goods receipt Info (material no, entered on date). and

PO (po number, po line item) -


> Invoice receipt Info (material no, entered on date).

But how can I get the connection like this....

PO info -


> Goods receipt info -


> Invoice recipt Info

Please let me know if you have any suggestions.

Points are assured.

Thanks in advance...