12-16-2014 7:57 AM
Hi Team,
In debit note report we have taken MSEG table for post date & movement type. Now there is performance issue due heavy data in MSEG.
Which table we can use to replace MSEG table?
Kindly suggest.
Regards,
Mahesh
12-16-2014 8:42 AM
12-16-2014 9:18 AM
Sir , I need the table which can be used as a replacement for the table MSEG. Rest program will remain unchanged.
Kindly suggest a table which will give me Posting date & Movement type for a particular debit note,.
Regards,
Mahesh
12-16-2014 9:22 AM
Hi Mahesh,
Consult your functional consultant for the same. He can give you better alternative.
12-16-2014 12:13 PM
12-16-2014 12:24 PM
12-16-2014 4:50 PM
Hi Mahesh,
Create Secondary Index in table, Include the index in select statement.
Regards,
Venkat.
12-16-2014 5:02 PM
There is an index on the posting date already (BUD), but it has probably not been created in the database. You could try getting your basis people to create the index in the database.
Rob