A018 Table

[Former Member]

Hi Experts,

I am extracting the data for the info record condition price from the table A018 like

SELECT lifnr

matnr

knumh

FROM a018

INTO TABLE i_a018

FOR ALL ENTRIES IN i_data

WHERE kschl = 'PB00'

AND lifnr = i_data-lifnr

AND matnr = i_data-matnr

AND datab LE p_prsdt

AND datbi GE p_prsdt.

IF NOT i_a018 IS INITIAL.

SORT i_a018.

SELECT knumh

kbetr

FROM konp

INTO TABLE i_konp

FOR ALL ENTRIES IN i_a018

WHERE knumh = i_a018-knumh

AND kschl = 'PB00'

AND loevm_ko NE 'X'.

ENDIF.

The i_data table is having apprx. 705000 materials. I scheduled the job for this program and it is running from last 4 days.

and i cant minimize the size of data as user wants to run it for all material. When i checked in the SM51 it is showing Action Sequential Read on Table KAPOL.

So is it mean my program is stuck at the Select query on A018. If so then what should i do to finished the job ASAP?

Please Help.

Thanks in Advance.

Abhishek Ingole

[Former Member]

Hi,

As far as i know you cannot do most to get the job finished until it gets finished by its own. But what you can try next time is that: select all the key fields from the A018 table though you donot require them. And also one more thing is that before you go for FOR ALL ENTRIES you should always sort the internal table which you are using by key fields and delete the adjacent duplicates comparing all fields of it.

Hope this helps.

Thanks,

Venkatesh.