Report for manually overriding pricing

[Former Member]

Hi Gurus,

I want to create a  report to view all of the manually overridden pricing that is done by the Billing Team. which tables do I refer to, where do I start,

Your input or suggestions are highly appreciated.

Thanks

Nidhish

[Lakshmipathi · Accepted solution]

Hope you know how to table join in SQVI.  There table join VBRK and VBRP and do the following :-

Selection fields (Input parameter)

• Billing Type
• Created On
• Sales Organization
• Manual price change (VBRP-MPROK)  - set the variant "Not equal to"

List field (Output fields)

• Line Item number
• Material number
• Quantity
• Net Value
• Manual price change (VBRP-MPROK)

With the above input parameters, execute SQVI so that system will list out only those billing documents where the condition type value has been changed manually.  Once the report populates, you can validate by checking in individual billing document where go to condition tab and double click on that so that system will show "Condition origin" as "Manually entered"

G. Lakshmipathi

[former_member212707]

Goto VBAK and enter your sales order number and get corresponding document condition number (VBAK-KNUMV). Pass this into KONV table and get all the conditions for whom KONV-KHERK = C (Manual)

This should list out all the conditions that were manually entered for that sales order. Hope this helps

Thanks,

Ravin

[former_member184701]

did you try t-code FB04 ?

[Former Member]

Hi PPIO,

I am looking at SD billing document level

Thanks