How to create Secondary Index for VIEW
In Alv report, am extracting data from tabel COVP and join this table with another table CE4GM00_ACCT using for all entries.In both tables are joined by filed PAOBJNR(Profitability Segment Number (CO-PA))
select ....from ce4gm00_acct into table t_ce4gm00_acct..where paobjnr = t_covp-paobjnr.
But its taking long time to display the report .Caz it contains large amount of data.I already try with package statement .But no use.So i decide to go with Secondary Index.But COVP is Table View.How can create secondary index for View.But COVP having tables COBK and COEP. PAOBJNR from table COEP.if i create secondary index for COEP,then can it reflect in COVP view.
I want to get data from view COVP only.Kindly help me in this case.I want to update ASAP.