Hi Experts,
I have a situation like this,
My client got database since from 1998. So his records crossed 20 Million in each table.
Now my situation is like this,
I have Budat(posting date) & matnr(Material) as my Selection screen.
I need to show the FG (Movement type 601) with billing documnet(VBRP).
The link is MKPF-XBLNR = VBRP-VGBEL.
but when I try to select the records from MKPF for a perticular month, because of overload(20 Million records) its taking more time(say 25-40 Sec).
But when I try get data from VBRP with help of XBLNR, Its "Time Exceeded" Runtime error,
I Even tried to concatinate some date, like let say my input is march, then I ristrict VBRP by FEB to APRIL for that particular year. Still not working.
Is there anyway to do this Job in SAP.
My Client's PRD is Almost 30Million Records in Each Table.
Version 4.7 EE..
Please Help me out.
Thanks & Regards,
Dileep .C