I need a Query for unit Price in Sales Quotation

[former_member616261]

I need a Query in Sap B1

I need a query which shows me the unit Price ,itemcode,cardcode if i make a Sales Quotation. I have to give to this query Business Partner Code and Item number...the query musst research price list, period and volume Discounts, Discount Groups, Special Prices.

Now i have only the special Prices.query now i need Discount Groups Query. Can anybode help me please?

and i need a file or an url for relationship tables

[former_member616261]

Thank you for your answer but it cannot help me. I have add a Discount Group but the query shows me "No data was found.."

[dinesh-pn]

Dear Unal,

Please refer this thread, this might help you

https://answers.sap.com/questions/2139487/discount-groups-query-question.html

Thank you