EKBE and EKBEH query
I am trying to create a query that summarizes the receipts of our purchase orders (PO) and scheduling agreements (SA) by date.
The issue -- the system has archived some of the SA into the EKBEH table so all I see in the EKBE is one line posted on the archive date. This does not allow me to correctly analyze the monthly receipts. I cannot determine a way to take the line from the EKBE table and link it to the details in the EKBEH table. Nor can I determine how the archive process runs (has not since May 2007); or reactivate the information to the EKBE table.
Current info set is EKBE - EKPO - EKKO. The grand totals are correct, just the monthly buckets are off.
Any assistance would be greatly appreciated -- points will be of course awarded.
Thanks in advance,