Skip to Content
avatar image
Former Member

Use of Subtotals?

Can anybody throw some light on the use of various subtotals available in a Pricing Procedure and how can these be leveraged best for BI and Invoice output reporting. I see that there are some standard sub totals available from 1 thru 9 and also A thru Z.

Any documentation on the same would be welcome.I would reward handsomely to those giving good information.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Mar 23, 2007 at 03:54 AM

    Hi,

    <b>Condition subtotal</b>

    Controls whether and in which fields condition amounts or subtotals (for example, a customer discount or the cost of a material) are stored.

    <b>

    Use</b>

    If the same fields are used to store different condition amounts, the system totals the individual amounts.

    <b>Example</b>

    These condition amounts or subtotals are used as a starting point for further calculations. You may, for example, want a subtotal of all the discounts included in the pricing of a sales order.

    Mohan

    Award points if it adds information.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2007 at 04:10 AM

    Subtotals store Condition value in temporary table, during the calculation of pricing.

    These tables are temporary table / structures.

    Regds,

    Rajesh Banka

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2007 at 04:19 AM

    Hi,

    When you observe the list of possible entries available for subtotal in Standard SAP, they say carry out pricing to KOMP - CMPRE, KOMP - BRTWR.

    In SAP, we have two tables called KOMP, KOMK. These tables contain the header and item data for pricing.

    These only communicate the transaction data with the pricing procedure.

    Whatever subtotal value you give, it means to send the value you get based on the condition type.

    If you take rebate for example, the subtotal we give is 7 so that the value of BONBA is carried to the table KOMP in the pricing procedure.

    Mohan

    Award points if it adds information.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2007 at 06:31 AM

    Dear Aniruddha,

    Subtotals store Condition value in temporary table, during the calculation of pricing.

    These tables are temporary table or structures.

    Do award points if you found them useful.

    Regards,

    Rakesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2007 at 10:00 AM

    Hi,

    Subtotals available in Pricing procedure if properly will help a lot for BI and Invoice output reporting. By assigning proper subtotals required for Invoice output and BW/BI, it will get stored in tables (mostly VBAP - order item table or VBRP - invoice item table). For example subtotal 1 (Carry over value to KOMP-KZWI1) will be stored in VBAP-KZWI1 and VBRP-KZWI1 (when Invoice is created). Similarly 7 ( Carry over value to KOMP-BONBA) will be stored in VBRP-BONBA (rebate basis). For reporting, we may need various subtotals. If it is not stored in a SAP table, we will have to calculate this subtotals by adding up the condition values which is cumbersome and has performance issues. For ex. Invoice output may require the total freight charges as a single line. We will have to add values from different conditions types which make up the freight cost and display if subtotal is not assigned for freight condition types.

    So prudent use of subtotals will help a lot (esp. where performance of the program is important) for reporting.

    Regards

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 29, 2007 at 08:34 AM

    Hi,

    Subtotal is a key where values will stores and updates in a purticular table and fields

    for ex: credit values will updates in table KOMP and field CMPRE

    regards

    bhaskar

    Add comment
    10|10000 characters needed characters exceeded