Skip to Content
0
Former Member
Feb 13, 2014 at 06:46 AM

Problem in Select Query

33 Views

Hi Experts,

Can anybody suggest me in avoiding the loop in the below code.because, I am facing these kind of situations many times.

DATA : BEGIN OF LW_EKKO,

EBELN TYPE EBELN,

BEDAT TYPE BEDAT,

FRGGR TYPE FRGGR,

FRGRL TYPE FRGRL,

RELTM TYPE UZEIT,

CDOBJ TYPE CDOBJECTV,

END OF LW_EKKO.

DATA : LT_EKKO LIKE TABLE OF LW_EKKO.


DATA : BEGIN OF LW_CDHDRPO,

OBJECTCLAS TYPE CDOBJECTCL,

OBJECTID TYPE CDOBJECTV,

CHANGENR TYPE CDCHANGENR,

UDATE TYPE CDDATUM,

UTIME TYPE CDUZEIT,

END OF LW_CDHDRPO.

DATA : LT_CDHDRPO LIKE TABLE OF LW_CDHDRPO.

* REFRESH LT_EKKO.

* SELECT EBELN

* BEDAT

* FRGGR

* FRGRL INTO TABLE LT_EKKO FROM EKKO

* FOR ALL ENTRIES IN T_LAST_PO

* WHERE EBELN = T_LAST_PO-EBELN.


* LOOP AT LT_EKKO INTO LW_EKKO.

* LW_EKKO-CDOBJ = LW_EKKO-EBELN.

* MODIFY LT_EKKO FROM LW_EKKO TRANSPORTING CDOBJ.

* ENDLOOP.


* REFRESH LT_CDHDRPO.

* SELECT OBJECTCLAS

* OBJECTID

* CHANGENR

* UDATE

* UTIME

* FROM CDHDR

* INTO TABLE LT_CDHDRPO FOR ALL ENTRIES IN LT_EKKO

* WHERE OBJECTCLAS = 'EINKBELEG'

* AND OBJECTID = LT_EKKO-CDOBJ. "conversion needed here.. So only I have used the loop.


Please suggest how to remove the loop.


Regards,

Praveen G.V.S