GESTIÓN - MARCO TEÓRICO - MARCO REFERENCIAL

6 MARCO REFERENCIAL

6.2 MARCO TEÓRICO

6.2.8 GESTIÓN

4.4.1.1 DBERDZ, DBERDL, DBERDLB: Print Document Line Items

DBERDL contains the print document line items, DBERDLB references of print document line items to billing document line items. Both tables were created as part of a redesign process for Release 4.61 and replace table DBERDZ used up until that release.

4.4.1.1.1 Prevention

During the creation and clearing of partial bills, print document line items are generated per due date and sub- transaction. This information is however summarized in the printed invoice, so that per contract only one amount is printed on the actual invoice form. To save space in table DBERDL, it makes sense to use this summarization already when the print document is created. In the case of a partial bill, all line items that belong to the same contract and have the same due date are summarized. In the case of a periodic bill the line items are summarized per contract. For more information on how you can use summarization, and to view an example, see SAP Note 613520.

4.4.1.1.2 Aggregation

Cannot be used.

4.4.1.1.3 Deletion

Simulated print documents can be deleted with transaction ESIMD (program REA_SIM_DEL). Depending on the number of simulated print documents in the system and assuming that they have a similar amount of line items as actual print documents, you may use this method to considerably reduce the amount of storage space used. Simulated print documents are not taken into account during the archiving of print documents.

4.4.1.1.4 Archiving

Print documents can only be archived with the following two archiving objects: ISU_PRDOCL archives the print document line items, and ISU_PRDOCH archives the print document headers (tables ERDK, ERDB, ERDO, DBERDR and DBERDU).

The advantage of this division is that print document line items, which make up the largest part of the data volume, can be archived much earlier than print document headers. Even if the print document line items have been archived it is still possible to work on the print documents with IS-U standard transactions, because the document headers are still in the database. This is possible only if at least one active and filled archive

information structure exists, based on the delivered field catalog SAP_ISU_PRDOCL. The only exception here are mass reversals, which are no longer possible after the print document line items have been archived. You should therefore only archive the line items of those print documents for which you do not need to perform any more mass reversals. You can still reverse individual print documents.

Print documents should be archived in the following order: 1. Print document line items (ISU_PRDOCL)

2. Print document headers (ISU_PRDOCH)

When you archive print document headers the print document is completely deleted from the database and can later only be displayed. It can no longer be reversed after archiving. You must archive print document headers before you can archive billing document line items (see below).

Retention Period

To prevent their database tables from getting too big, print document line items should be archived in relatively short intervals, especially if you are using short billing periods (monthly or bimonthly). You must set different retention periods for the print document line items and print document headers. When you enter the retention period for the print document headers, the system automatically checks, whether it is greater than the retention period of the corresponding print document line items.

There are two options for defining your retention periods:

In Customizing for the Industry Solution Component Utilities under Tools Archiving Define Retention

Periods for Archiving Objects

In Archive Administration (transaction SARA) under Customizing Application-Specific Customizing We recommend that you enter a shorter retention period for reversed documents than for other print documents. This will help you clear out some data from the database as early as possible.

4.4.1.2 DBERCHZ, DBERCHZ1-8: Billing Document Line Items

As of Release 4.62 billing document line items are stored in tables DBERCHZ1 – DBERCHZ4. These tables replace the table DBERCHZ that was used before, because this table had become difficult to handle due to large data volumes. The fields of table DBERCHZ were distributed across tables DBERCHZ1 – DBERCHZ4 and the distribution is based on semantics. This implies that for one document line item not necessarily all tables are updated.

In addition, we now have tables DBERCHZ5 – DBERCHZ8, whose structure is exactly like the structure of the above-named tables. These additional tables are used for less important document line items that are not archived (for example counter readings, general calculation steps, etc.). The data in these tables can be deleted after the billing documents have been archived.

The billing document headers are stored in table ERCH. Tables ERCHC, ERCHO, ERCHP and DBERCHU also belong to this family.

4.4.1.2.1 Prevention

Experience has shown that in a production system usually more document line items are written than are actually necessary. You should therefore check the importance of the document line items that are written in your system and perhaps reduce their number. This can help you considerably curtail the growth of the corresponding tables. As part of the SAP extension EBIA0001 it is possible to delete line items that are not relevant for the creation of budget billing plans already during the document creation stage. For more information see SAP Note 613006.

In addition you can set the indicator NOT_ARCHIV for billing line items that should not be archived. The indicator can be set in IS-U Customizing, under Tools System Modifications User-Defined Function

Extension for Billing User-Defined Variant Programs Define Line Item Types. If this indicator is set, the billing document line items for the specified line item type are saved in special files and will be deleted instead

of archived after the bill printout. This helps reduce the amount of data that is to be kept in the system (for example for the purpose of reversals) and the archiving processes can be sped up.

4.4.1.2.2 Aggregation

Cannot be used.

4.4.1.2.3 Deletion

Simulated billing documents can be deleted using transaction ESIMD.

4.4.1.2.4 Archiving

Billing document line items are archived using archiving object ISU_BILLZ, billing document headers with ISU_BILL. Archiving should be done in the following order:

1. Print document line items (ISU_PRDOCL) 2. Print document headers (ISU_PRDOCH) 3. Billing document line items (ISU_BILLZ) 4. Billing document headers (ISU_BILL)

Billing documents with archived line items can only be displayed in the system. They cannot be reversed.

Retention Period

Set the retention period of billing document headers so that you do not have to perform reversals of the documents. Also make sure that at least one billing document of an earlier period remains in the system. The invoicing process requires such a document to determine the current billing period. We recommend that you use a shorter retention period for reversed documents than for other print documents, to clear out the database as soon as possible.

Set the retention period in Customizing. You can find the path in the section for print document line items.

Displaying Archived Billing Documents

Just like archived print documents (see above) archived billing documents can be displayed using the billing document display transaction (EA22). The function for displaying print documents whose headers have been archived, is available using Goto Billing Document from Archive.