how to know how much discount have given to customers ( only discounts) in the last month

[Former Member]

Dear sd experts

Any T.code is there if i want to know how much discount have given to customers ( only discounts) in the last month

how it is possible .. I have checked in OBXI but i am not able to find

plz forgive me if it is basic question .. thanks a lot

[jignesh_mehta3 · Accepted solution]

Hello,

It is ideal to create a Z-Report for requirements like this. Ensure that in the Z-Report the cancelled Invoice & the original Invoices (of the Cancelled Invoice are ignored).

You can also refer to below link displaying a sample ABAP code for Sales Discount Report: http://wiki.sdn.sap.com/wiki/display/Snippets/Sales+Discount+Report

Thanks,

Jignesh Mehta

[moazzam_ali]

Hi Venu

I want to know that whether you have maintained different GL for your different discount conditions? If yes then you can easily get the desired result in FBL3N. There you will find the posting date, amount and customer number or may be invoice number in reference or assignment field as per your configuration. You can extrat data on Excel file and manipulate it as per your requirement. For this you have to make sure first that you have different G/L for the discount condition which you want to check.

Another way is to create a Query report in SQVI by using Logical databaseVFV and select condition type in selection screen and amount in output. As mentioned by Jignesh pleasebe careful with reversal and return documents.

Thank$