Kontakt

Ansicht
Dokumentation

KEQ7_KE2S - Summarization

KEQ7_KE2S - Summarization

Fill RESBD Structure from EBP Component Structure   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

This function is intended only for exceptionally large data volumes that are causing critical performance and data storage issues. It should only be used when absolutely necessary, since it restricts the flexibility of reporting.

If you decide to use this function, keep in mind that its effects cannot normally be reversed. The effects can be undesirable if the function is used incorrectly.

To avoid performance and data storage issues with large data volumes, you may need to reduce the number of line items and the number of profitability segments by defining a summarization for these elements.

In this section you can define a summarization of fields for G/L line item table ACDOCA containing the universal journal entry (G/L View). If an operating concern is activated for Margin Analysis the line items

based on Margin Analysis are posted to this table. In order to achieve that all characteristics are generated into table ACDOCA.

Since the level of summarization in table ACDOCA should be the same as that of the profitability segments, the summarization settings maintained here are used for profitability segment determination based on Margin Analysis.

You find these settings under Summarization of Account-Based Line Items and Profitability Segments.

Note: If you are using costing-based profitability analysis, the corresponding profitability segment determination utilizes these settings as well. In other words, summarization is the same regardless of whether you are using costing-based profitability analysis or Margin Analysis.

Even if you define a summarization of fields for table ACDOCA, costing-based line items continue to be posted to table CE1XXXX (where “XXXX” denotes your operating concern). This table uses the existing definition of line item summarization, which can be found under Summarization of Costing-Based Line Items.

The settings defined here also apply to distributed profitability analysis, which means that the same level of summarization is used with regard to the profitability segments in the distributed scenario.

If only costing-based profitability analysis is activated in an operating concern, line items in table ACDOCA are posted to highly aggregated objects called reconciliation objects (ACDOCA-OBJNR “AO….”). No characteristics are generated to table ACDOCA for this operating concern. If another operating concern existed for which Margin Analysis was activated, characteristics could be generated into table ACDOCA that are also contained in the costing-based operating concern. Nevertheless, for the G/L line items in the costing-based operating concern (the ones posted to reconciliation objects), no characteristics are filled in table ACDOCA and hence no summarization is needed. An exception to this are certain fixed characteristics already predefined in table ACDOCA that are filled by a sending application even if only costing-based CO-PA is active, for example the fields Sales Organization (VKORG) or Distribution Channel (VTWEG) of an SD billing document. In order to summarize such fields, you can use the Dependent Summarization of General Ledger View activity.

If profitability analysis is not active at all in a company code, the settings Summarization of Account-Based Line Items and Profitability Segments are not used. As for the costing-based-only case, use the Dependent Summarization of General Ledger View activity to summarize above-mentioned fixed fields like Sales Organization or Distribution Channel.

The existing summarization on table BSEG containing the classic journal entry (Entry View) still exists. A field which exists in both tables BSEG and ACDOCA can only be summarized in table ACDOCA if it is summarized in BSEG as well. A warning message is usually issued if this is not the case. Summarization of table BSEG can be found under Dependent Summarization of Entry View and Independent Summarization of Entry View.

Summarization of G/L line item table ACDOCA and profitability segments can be dependent or independent:

  • Dependent summarization:
A field can be summarized based on a combination of the reference transaction (AWTYP), document type (BLART), company code (BUKRS), and ledger (RLDNR). This allows you to summarize a field only in a particular document type and ledger, for example. This option is available for fields of table ACDOCA which may not be part of a CO-PA operating concern and for CO-PA characteristics if CO-PA is not active in a company code (see above). This option can be found under Dependent Summarization of General Ledger View.
  • Independent summarization:
A field can be used for summarization only based on the Operating Concern (ERKRS) and the Company Code (BUKRS). This option is used for all fields which are part of an operating concern, since profitability analysis does not recognize most of above-mentioned dimensions at the time the profitability segment is determined. Fields offered for independent summarization are customer-defined CO-PA characteristics and some fixed characteristics such as Sales Organization (VKORG), Distribution Channel (VTWEG), and Division (SPART), which are contained in every operating concern. Independent summarization therefore depends on the operating concern. This is the option you can find under Summarization of Account-Based Line Items and Profitability Segments.
  • If a field is maintained here, it is summarized in distributed CO-PA regardless of whether summarization is restricted to certain company codes or not.

Note that ACDOCA has two different fields for the material number:

  • MATNR is the material number for materials management, which is filled for example in material movements. It is not relevant for CO-PA.
  • MATNR_COPA is the product number for CO-PA. It identifies the product sold.

MATNR is therefore available for dependent summarization, whereas MATNR_COPA is only available for independent summarization (except for company codes where CO-PA is not active, as described above).

To avoid performance problems, we recommend excluding frequently occurring fields that have a different value with each posting and which are therefore not relevant for analysis. This applies for example to the sales order number for a repetitive manufacturer, or the customer and material for a retailer. For retailers, you can analyze at the customer group or product group level by excluding customers or products from the analysis. This can improve performance considerably.

We further recommend using document summarization of table BSEG and reducing the number of G/L line items in table ACDOCA as little as possible.

The fields you define for summarization of G/L line item table ACDOCA and profitability segments are not summarized in the following cases:

  • If the Material Ledger is active, line items relevant to the Material Ledger are never summarized in table ACDOCA.
  • Line items relevant to fixed assets are never summarized in table ACDOCA.
  • The customer number (KUNNR) is not summarized in table ACDOCA on debtor line items or if the customer is an affiliated party.
  • True and statistical account assignments are never summarized in table ACDOCA. For example, if you choose to summarize the Cost Center field, (RCNTR), this would not be initialized in G/L line items with true or statistical account assignment to cost center. For profitability segments containing the cost center characteristic, summarization takes place for both the G/L line item and the profitability segment, if the cost center is no statistical account assignment since the profitability segment is always a true account assignment.
  • Sales order (KDAUF) and sales order item (KDPOS) are never summarized on line items relevant to event-based revenue recognition as the functionality relies on these fields.
Note that this restriction may have a considerable impact on your data volume and performance in table ACDOCA.

  • This is a purely technical function which is intended to allow customers with very large data volumes to optimize their system performance by reducing the number of G/L line items in table ACDOCA and the number of profitability segments in table CE4XXXX (where “XXXX” denotes the operating concern). It should be used with caution because it is usually not possible to reverse its effects. The effects can be undesirable if the function is used incorrectly.
  • If Profitability Analysis is active, changes to summarization settings will result in the creation of additional profitability segments if new postings are made to profitability segments that had been posted to before the changes were made. This is especially the case when a characteristic that had been summarized before is removed. Also note that changes to summarization settings may result in error message KE 396 Inconsistency between a document field and the profitability segment number during posting.






PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 10280 Date: 20240523 Time: 185919     sap01-206 ( 223 ms )