Free Goods Analysis/Report

[Former Member]

Dear Experts,

I would like to generate a report to view all key combinations maintained for free goods. Is there a standard configuration to set up Free Goods report like Pricing Report (V/LA)? If I go to transaction VBN1 and select Condition Info, I would not be able to see the details of the condition record. What I would like to achieve is a report where i can view all condition record details (quantity of free goods, minimum qty, and etc) for all key combinations. Please advice. Thanks!

[Former Member · Accepted solution]

Hi

To run the report through z Tcode, you can make the query using t.code SQVI & table KONDN as suggested by Ankur. Select the select screen parameters as required viz Discount Condition type,sales deal, promotion, sales quote etc. & Define the tcode for query through SE93

Aternatively

you can find /note you access seqcence & respective tables of your condition type

Go to SE16 enter the table no. prefix with KOTN followed by table no.

E'g for table no 010 use KOTN010.

This will give all records of that table/access seq >condition type

You can also create the query using t.code SQVI using KOTN*** & KONDN table(s)

Regards

Tejpal Singh

Edited by: TEJPAL SINGH on Jun 2, 2009 2:09 PM

[Former Member]

Use Table KONDN with KNRNM as Free goods quantity & KNRMM as Minimum quantity.

It will help you.

Best Regards,

Ankur