how to prepare sales order quantiti with free quantity reprot?

[Former Member]

Hi SAP Guru's,

I need to create a reprot that is based on special schemes like bye 2 get 1 free in that report client wants order quantity along with free quantity.

please help me to generate a report.

Hussain.

[former_member184701]

dear friend,

as far as i know there is no such report in standard.

so you have at least two ways:

1. build a sap query (use SQ02 and SQ01)

2. request abaper for custom report

from technical point of view i would suggest to operate with your particular 'free' item.

for example, in standrd it is AFNN item category, so run through VBAP looking for AFNN' records (VBAP-PSTYV = 'AFNN' for example) and get a quantities per position. of course, do not forget about VBAK table - you will get all important info from there, for example, the sales documnet type, date, sales area,...and you may look at VBFA (sales doc flow), KNA1 (customer) and other tables if you need some extra info.

good luck!