Skip to Content
0
Former Member
Apr 22, 2009 at 07:24 AM

Regarding select statement on structure

4474 Views

hi,

can we write select on structure?.........i hav to get condition record from konv(which is a structure) based on ekpo-ebeln.

for this i hav written code like this

IF NOT it_ekpo IS INITIAL.

SELECT knumv

kposn

kschl

kbetr

waers

KWERT

FROM konv

INTO TABLE it_konv

FOR ALL ENTRIES IN it_ekpo

WHERE knumv = it_ekpo-ebeln

  • and kposn = it_ekpo-ebelp

AND ( kschl EQ 'ZPF3' OR kschl EQ 'ZVAT'

OR kschl EQ 'ZCSR' OR kschl EQ 'ZFR3' ).

IF sy-subrc EQ 0.

SORT it_konv BY knumv kposn.

ENDIF.

ENDIF.