Hi all ,
This is my code i have millons of records in MARA table . I dont have where condition for mara table also if loop that one it consumes lot of time . Is there any otheway to compare mara all entries which are suitale for cdpos with single attempt?
SELECT MATNR MTART ERSDA SPART ERNAM AENAM FROM MARA INTO TABLE IT_MARA.
Loop at it_mara => this statement consumes lot of time for me
SELECT * FROM cdpos INTO TABLE it_cdpos WHERE OBJECTID = it_mara-matnr
and tabname = 'mara' and fname = 'spart'.
loop at it_cdpos.