Summarize Data During Update (SAP Library - Entry title was not found)

Summarize Data During Update

In this section you can define how several items of a sender document should be summarized when they are updated in Profitability Analysis.

By summarizing document items posted to the same profitability segment, you can reduce the data volumne in the line item table in Profitability Analysis (CE1xxxx) significantly.

You can also improve runtimes for the update to Profitability Analysis using summarization.

Summarization is defined dependent on:

the activity (SD00 = billing document, RFBU = FI document, RMRP =

incoming invoice, RMWA = goods movement, RMWE = goods receipt order)

the document type (internal, external) and

the point at which summarization takes place 1 = after derivation/valuation
2 = before derivation/valuation

Summarization of financial accounting document items (RFBU) is only possible for internal documents and only after derivation and valution.

The system summarizes data that was posted to the same profitability segment (the same combination of characteristics). For financial accounting documents, the account or cost element is also used as a criterion.

You can only summarize data within the same sender document. Only the document number of the sender document is stored as information on the origin. Consequently, you can no longer see the corresponding item in Profitability Analysis.

Example

1. Billing document with summarization '1':

In Profitability Analysis, imputed sales commission is calculated on the basis of a quantity scale:

2% of revenue if quantity <=10 units

3% of revenue if quantity > 10 units

Item Material Amount Revenue Discount Prof. segment

10 M1 10 1000 10 4711

20 M2 5 5000 60 4819

30 M1 3 300 3 4711

Line item updated in CE1xxx:

Item Material Quantity Revenue Discount Imputed commission

1 M1 13 1300 13 26

2 M2 5 5000 60 100

2. FI document with summarization '1':

Item Deb/Crd Account Name Amount Prof. segment

1 D K100 Cust.100 1035

2 D 889000 Sales ded. 100 47880

3 C 800000 Sales rev. 1000 47880

4 C 175000 VAT 135

5 D K200 Cust.200 1035

6 D 889000 Sales ded. 100 47880

7 C 800000 Sales rev. 1000 47880

8 C 175000 VAT 135

9 D K300 Cust.300 2070

10 D 889000 Sales ded. 200 5019

11 C 800000 Sales rev. 2000 5019

12 C 175000 VAT 270

Line item updated in CE1xxx:

Item Account Revenue Sales ded. Prof. segment

1 800000 2000 0 47880

2 889000 0 200 47880

3 800000 2000 0 5019

4 889000 0 200 5019