Discount value or percentage of a particular product hirerchy report from t

[Former Member]

Hi SD Guru's

I have created the Brand discount condition Type and assigned in the pricing procedure. Here we maintained seperate GL account for the brand discount.

we are providing the disconts material wise. Please let us know any standard report to fetch the value or % given to a particular brand (Product Hirerchy) from all the invoices

Regards,

C S Javali

[Former Member]

Answered Thans

[former_member183879]

Hi

You can have it using two tables not directly. YOu have to extract the values to xls sheet and then doa VLOOKUP to compare.

From VBRK, get the value of the field VBRK-KNUMV

Now go to KONV, give VBRK-KNUMV value as KONV-KNUMV and give your discount condition type as KONV-KSCHL.

And execute the query. You can get the values of the c.type from values KONV-KNUMV, KONV-KPOSN, KONV-KSCHL, KONV-KWERT and KONV-KBERT

Also, go to VBRP give the invoice number and get VBRP-VBELN, VBRP-MATNR, VBRP-POSNR, VBRP-PRODH

Now combine these three xls sheets to get the discount % and values given for each material and product hierarchy using vlookup functionality in xls sheet. You can use the following fields as common fields

VBRK-VBELN = VBRP-VBELN

VBRP-POSNR = KONV-KPOSN

VBRK-KNUMV = KONV-KNUMV

Using these three common fields, you can get all the values you want.