Dear Experts,
I am making monthly consumption report, In which i am getting monthly data column wise for different month , here firstly i am fetching header mblnr date according to date from mkpf then i am fetching data from mseg.....
I have same mblnr in both tables..... Now i am using read statement like this.......
sort lt_mkpf by mblnr.
SORT lt_mseg BY mblnr.
LOOP AT lt_mkpf INTO lw_mkpf.
READ TABLE lt_mseg INTO lw_mseg WITH KEY mblnr = lw_mkpf-mblnr
mjahr = lw_mkpf-mjahr
BINARY SEARCH.
When I am debugging i am getting data in lw_mkpf but sy-subrc = 4 is coming and getting wrong data in final table by using these above statements..........
where as if i am using loop like this:
SORT lt_mkpf BY mblnr.
SORT lt_mseg BY mblnr.
LOOP AT lt_mkpf INTO lw_mkpf.
v_mkpf = lw_mkpf-mblnr.
LOOP AT lt_mseg INTO lw_mseg WHERE mblnr EQ v_mkpf.
with this i am getting right data........ But it takes lot of time to execute..........
Can you please guide me am i using read statement by wrong method. which one is the correct method which one shoul be used.........