Skip to Content
avatar image
Former Member

TOTAL INTERNAL PRICE (VPRS) IN QUERY

HI

I have created a query related to invoice. How can I extract the total amount of the the internal PRICE (VPRS) for each invoice?

this internal price allows me to calculate the margin (NET VALUE- INTERNAL PRICE) for every invoice in my query.

Thanks in advance

PLEASE IS IT POSSIBLE WITHOUT ABAP DEVELOPMENT

Edited by: Maher Gabsi on Feb 2, 2012 12:46 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Feb 02, 2012 at 11:57 AM

    hi

    check in the query there is a tab called enhancement.

    you can use those enhancement for calculation etc.,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2012 at 12:49 PM

    Yes, without enhancement you can achieve this.

    To have a provision for Gross Profit calculation in your pricing procedure for the billing.

    For instance, refer Profit Margin in standard Pricing Procedure RVAA01, step no 950.

    Where, routine 11 can be assigned in atl cal type in at the end of the pricing procedure for the profit margin for the item. This routine will calculated the profit margin for a line item. Where, cost of the item will be deducted from the net value.

    To achieve a report on that.

    You can further have Subtotal field assign for it, say, 6 - Carry over value to KOMP-KZWI6.

    So, this field will take the value of KOMP-KZWI6 to VBAP-KZWI6 at sales order item level.

    Thus, In SE16N, by using table-field combination of VBAP-KZWI6, you can take the value to report or use value of that combination.

    If you want to have look on enhancement part, kindly refer following SDN thread discussed earlier this year:

    -

    Regards

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2012 at 01:01 PM

    Hi

    See the Note 547570 - FAQ: VPRS in pricing and 1365939 - VPRS logic and Customizing settings in SD to know the customizing of your system. So, check in records of your VBRP table (check WAVWR field). See also SAP Note 1022966 - FAQ for the 'Subto' column (KZWIW) in the pricing procedure.

    I hope this helps you

    Regards

    Eduardo

    Add comment
    10|10000 characters needed characters exceeded