Want to know about the behavior of the standard report program RC1AVGE1

[Former Member]

Hi Gurus,

How exactly the report program RC1AVGE1 works ? How can I verify what it does. All I know about it is that it determines the reports with potential changes & stores them in the database table. What table exactly it is  & how can I also verify that in terms of this reports functionality what substance were changed, which phrases were changed, which substances were changed due to phrase changed due to phrase changes, how it determines the  reports for the changed substances & how it determines the report for the changed generation variant. Kindly be little elaborative in your responses to enable me to check/verify the changed data in tables in understanding this report better.

Thanking in advance.

Regards,

Anshul Kawatra

[former_member198518 · Accepted solution]

Hello Anshul,

The worklists can be generated manually or scheduled automatically.

Worklists are generated automatically using programs RC1AVGE1 and RC1AVGE2.

The program RC1AVGE1 determines the reports that could be affected by a change to a substance or phrase, so-called reports with potential changes. The program RC1AVGE2 then determines whether the reports with potential changes that you selected have actually been affected by a change to a substance or a phrase.

Report RC1AVGE1 determines the reports with potential changes and stores them in a database table. It proceeds as follows:

- It determines the relevant checking period
- It determines which specifications were changed in this period
- It determines which phrases were changed in this period
- It determines which specifications were changed due to phrase changes
- It determines which report templates were changed due to the phrase changes
- It determines which report generation variants were changed due to report template changes
- It determines which specifications changed because they contain changed specifications as components or reference specifications
- It determines the reports for the changes specifications
- It determines the reports for the changed report generation variants
- It calls a customer exit RC1A0001 to filter the determined reports with potential changes.
In the customer exit interface, the reports are transferred to five tables, depending on the reason for the change. The individual objects that led to the selection of the report are recorded in each of the five tables so that you can access this information in the customer exit.

- It determines the reports with potential changes that were not graded by the filter function
- It saves the reports with potential changes in a database table:

When saving the reports with potential changes, the system checks whether the report was already saved as a report with potential changes.
If the report was not yet saved, it is saved.
If the report was saved, the report program RC1AVGE1 checks whether the report has already been processed by report program RC1AVGE2. If so, the report is saved again. If not, the report is not saved.

All the steps described above are logged by report RC1AVGE1. You can use the environment parameter AVGEN_SHOW_MSG to determine in the IMG activity Specify Environment Parameters whether only reports with potential changes, or all changes are to be displayed in the log.

You can find more detailed information about these reports in the IMG Activity "Set Up Jobs for Generating Worklists".

I hope this helps!

Best Regards,

Camila Zilles

[Former Member · Accepted solution]

Hi Camila,

Thanks for the answer!

But the question remains - What are all the standard tables that are impacted by this report program that would help me in understanding how this program works by verifying the data stored in those tables & understand it's behavior & function better.

As mentioned in the response "Report RC1AVGE1 determines the reports with potential changes and stores them in a database table." What exactly is this database table.

Any further input from your side that would enable me to understand, verify so that I could use this report program would be great help.

Thanks & Kind Regards,

Anshul

[JuanCarlosDelga · Accepted solution]

Hi Anshul,

Extending Camila answer:

The SAP system takes into account only released report templates.

The SAP system determines the changes to specifications and phrases as follows:

Changes to Specifications

1. The SAP system determines all specifications whose data was modified in the relevant time frame.
2. When determining the other specifications in which a changed specification is used, the SAP system checks the following areas:

• Reference relationships
• Inheritance relationships
• Listings and compositions
• Transport classifications

3.      The SAP system determines all report bodies that refer to the changed specifications.

4.      Reports are checked to determine if the changes made to the specification data is relevant to them. Only these reports enter the worklist as newly generated reports.

Changes to Phrases

The SAP system makes changes to phrase data as follows:

1. The system determines all phrases that were changed in the relevant time frame. If a phrase status is specified for the phrase, the system checks whether the PhSymExpan (Expansion of Phrase Symbol in Report) indicator is set for the status in the IMG activity Specify Phrase Status. If it is, the phrase is taken into account, otherwise it is not taken into account.
2. Reports in which the phrases were originally created as phrase symbols enter the worklist immediately as newly generated reports.
3. The system then determines the specifications in which the changed phrases are used.
4. All reports that refer to these specifications are then selected.
5. The system checks the reports to determine whether the changed phrase data is relevant to them. Only these reports enter the worklist as newly generated reports. 

The report informs the table TCGC0.

Remember tha t in EHS table keys don't have a meaning as in the rest of modules.

Regards,

JCD

[christoph_bergemann]

Dear Anshul

only on the top: do not try to "change" the process ! It is a very complex one ! The two reports. RC1AVGE1 and RC1AVGE2 are linked to each other.  (please check ther very good explanations of Camila and Juan);

May be check: SAP Library (or similar links)

C.B.