Show TOC

 Archiving CO-PA Transaction Data

Definition

When you generate an operating concern in Profitability Analysis (CO-PA), the system automatically generates the following archiving objects and the corresponding write, delete, and reload programs (xxxx is the name of the operating concern):

  • For costing-based Profitability Analysis :

    • COPAA_xxxx

    • COPAB_xxxx

    • COPA1_xxxx

  • For account-based Profitability Analysis : COPA2_xxxx

  • For Profitability Segments : COPAC_xxxx

    Note Note

    The archiving objects COPAA_xxxx and COPAB_xxxx replace the archiving object COPA1_xxxx.

    Although the archiving object COPA1_xxxx can still be used, we recommend only using the new archiving objects. For example, only these archiving objects have an IMG activity for preparing archiving in Customizing, whereas the archiving object COPA1_xxxx does not.

    End of the note.

Structure

You can archive the following tables in costing-based Profitability Analysis :

  • Actual line items (table(s) CE1xxxx) with the archiving object COPAA_xxxx or COPA1_xxxx (not recommended)

  • Plan line items (table(s) CE2xxxx) with the archiving object COPAA_xxxx or COPA1_xxxx (not recommended)

  • Segment level (table(s) CE3xxxx) with the archiving object COPAB_xxxx or COPA1_xxxx (not recommended)

  • Transaction-based distribution (table CEALE01) with the archiving object COPAA_xxxx or COPA1_xxxx (not recommended)

    Table CEAL01 can only be archived if distributed Profitability Analysis (with ALE) is active and data is distributed by transaction. Table CEALE01 in the target system contains the references to the line items in the sender system.

    Note Note

    For background information on tables in costing-based Profitability Analysis, see Database Tables for CO-PA Transaction Data .)

    End of the note.

In account-based Profitability Analysis , you can use archiving object COPA2_xxxx to archive the following:

  • CO line items (tables concerned: COEP, COEJ, COBK)

  • Totals record tables (tables concerned: COSS, COSP, COKA)

For both forms of Profitability Analysis , you can use archiving object COPAC_xxxx or COPA1_xxxx (not recommended) to archive the following:

  • Profitability segments (table(s) concerned: CE4xxxx)

  • Account assignment number (tables concerned: CE4xxxx_ACCT, CE4xxxx_FLAG)

To restrict the data to be archived, you can select different selection parameters in archiving. For this, you can choose from some fixed selection parameters (see Creating Archive Files (CO-PA) ). Moreover, in Customizing for Profitability Analysis under Start of the navigation path Tools Next navigation step Utilities Next navigation step Prepare Archiving End of the navigation path , you can select characteristics from the profitability segment characteristics (segment level characteristics) and define them as selection parameters.

Integration

Archive Information System (AS)

Since the archiving objects in Profitability Analysis depend on the operating concern (which is generated at customer) and on the Customizing settings under Start of the navigation path Tools Next navigation step Utilities Next navigation step Prepare Archiving End of the navigation path , the corresponding information structures and the field catalog must also be generated for the Archive Information System (AS).

The information structure and the field catalog are generated on the basis of the data object definition that you created in the IMG activity Prepare Archiving . From the technical standpoint, a data object corresponds to all data records in an archive file with the same combination of parameter values. With an optimal data object definition, the time required for AS to access the data in the archive can be reduced considerably. For more information, see the documentation on the IMG activity Prepare Archiving .

The information structure and the field catalog are also generated in the IMG activity Prepare Archiving . The following archiving objects are generated for the individual archiving objects:

  • Archiving object COPAA_xxxx: Field catalog and information structure SAP_COPAA_xxxx

  • Archiving object COPAB_xxxx: Field catalog SAP_COPAB_xxxx

  • Archiving object COPA2_xxxx: Field catalog and information structure SAP_COPA2_xxxx

In order that it be possible to use the information structures in a production system, they then have to be activated in AS. For more information about information structures, see Using the Archive Information System . For information about field catalogs, see under Field Catalogs .

Recommendation Recommendation

To display archived data from the segment level (table CE3xxxx), you can (and should) use the Information System in Profitability Analysis . Here, you can define profitability reports that access the archive. When you define a profitability report (see Defining Profitability Reports ), you activate the selection Use archived data on the Options tab page.

To display archived data from line items (tables CE1xxxx, CE2xxxx for costing-based Profitability Analysis and COEP, COEJ, COBK for account-based Profitability Analysis), you can and should use the transactions for displaying line items: KE24, KE25, and KE30 (for reports based on line items). You can display the data from the archive once you have set the Archive indicator in the menu under Start of the navigation path Extras Next navigation step Data Source End of the navigation path .

End of the recommendation.