Skip to Content
0
Former Member
Mar 25, 2008 at 10:01 AM

Doubt on simple select query

35 Views

Hello experts,

please check this code.

CHECK NOT T_DELIVERIES[] IS INITIAL.

SELECT MANDT VBELV POSNV VBELN POSNN INTO TABLE T_VBFA FROM VBFA

FOR ALL ENTRIES IN T_DELIVERIES

WHERE VBELN EQ T_DELIVERIES-VBELN

AND POSNN EQ T_DELIVERIES-POSNR

*{ INSERT DE1K903920 2

AND VBELV EQ T_OUTPUT-VBELV

AND POSNV EQ T_OUTPUT-POSNV

*} INSERT

AND ( VBTYP_V EQ 'C' OR VBTYP_V 'H' ). "AO03

SORT T_VBFA BY VBELN VBELV.

Check the inserted lines and let me know whether it is correct or not.