cancel
Showing results for 
Search instead for 
Did you mean: 

Use of Subtotals?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

These tables are temporary table / structures.

Regds,

Rajesh Banka

Former Member
0 Kudos

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.