Skip to Content
0
Former Member
Aug 09, 2007 at 07:59 PM

help in sd quary

10 Views

hallow

i new in sd and i wont to sum to invoice amount total when the supplier give to customer 100% discount

i wont to now if i do that o.k. & go to the right place i data base.

L_KNUMV TYPE KNUMV,

L_KWERT TYPE table of string,

v_KWERT type NETWR,

i_KWERT type NETWR.

SELECT SINGLE KNUMV

FROM VBRK

INTO L_KNUMV

WHERE VBELN = is_bil_invoice-hd_gen-bil_number

AND NETWR = 0.

SELECTsum (KWERT )

FROM KONV

INTO L_KWERT

WHERE KNUMV = L_KNUMV

AND KSCHL = 'ZMTG'

group by KWERT .