Skip to Content
0
Former Member
Aug 02, 2007 at 11:06 AM

SELECT QUERY-URGENT!!!

22 Views

Hi,

Please respond on this ASAP.

SELECT SINGLE PRODH FROM MVKE INTO MVKE-PRODH WHERE

MATNR = VBDPR-MATNR.

IF SY-SUBRC EQ 0.

IF MVKE-PRODH NE SPACE.

IF MVKE-PRODH(5) EQ '00003'.

V_WINDSHIELDS = V_WINDSHIELDS + V_INV_QTY.

V_WINDSHIELDS_TOTAL = V_WINDSHIELDS_TOTAL + V_INV_QTY.

ELSEIF MVKE-PRODH(5) EQ '00004'.

V_TEMPERED = V_TEMPERED + V_INV_QTY.

V_TEMPERED_TOTAL = V_TEMPERED_TOTAL + V_INV_QTY.

ELSEIF MVKE-PRODH(5) EQ '00005'.

V_MOLDINGS = V_MOLDINGS + V_INV_QTY.

V_MOLDINGS_TOTAL = V_MOLDINGS_TOTAL + V_INV_QTY.

ENDIF.

ENDIF.

ENDIF.

this is the logic

i want to know if we are using sel single and

if there are more entries in MVKE

then too it will pick 1st always

then what is the alternate,