help in sd quary

[Former Member]

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 .

[Former Member · Accepted solution]

hi SHNYA !..

it would be better if u post this question in the abap forum, u might get the answer quickly..

Reward if Useful

Thanx & Regards.

Naren..

[Former Member · Accepted solution]

hi dasari

i just wont to now if i go to the right place in data base becouse i do that in smart form and its difficult to me to debug it

Regards

[Former Member · Accepted solution]

Hi,

As suggested by Narendra, you could get the answer in Abap forum or alternatively discuss the same with your collegues in Abap module.

It is difficult to get a solution here (not impossible).

regards,

Rajesh Banka

Reward points if helpful.

[Former Member]

hi frinds

i need to now if i in the right way i use smart form lb_bill_invoice and i wont to add another field of total sum when 100% discount

thankes