Is it possible to delete/truncate the table entries of these tables "REPOLOAD, REPOSRC, REPOTEXT, D010INC, D010TAB" ?

 Upon analyzing the database's top tables, I discovered that table "REPOLOAD" contains almost 30+ GB of disk space. 

I found a useful Snote while searching 

2610985 - [Summary&FAQ] Large table size: REPOLOAD, REPOSRC, REPOTEXT, D010INC, D010TABnull

2193457. In case RS_LOAD_FORMAT_ADM doesn't exist in the system,

2324429 to check/delete obsolete loads manually.

Symptom

It has been noticed that REPOLOAD, REPOSRC, REPOTEXT, D010INC and D010TAB tables have huge amount of data in the system.

Environment

SAP NetWeaver release independent

Resolution

1. What are these tables used for?

REPOLOAD stores the ABAP program loads and REPOSRC stores the ABAP program source code. Find details in the Wiki page Understanding Program Load. The table REPOTEXT stores the Text Elements of the programs.

When an ABAP program load is generated, the tables D010TAB and D010INC are also updated. These tables contain the information about the includes and DDIC objects the load of a specific program depends on. These tables do not contain any entries for programs for which no load was generated. The tables D010TAB and D010INC play a central part in dependency management. For details, check SAP Note 1230076.

 

2. Is it possible to delete/truncate the table entries of these tables?

SAP does not recommend to delete contents from these tables unless SAP support ask you to do so.

If the REPOLOAD entries are lost, the system will face performance issues since all the entries of the table(program loads) will need to be re-created (it can be repaired with the regeneration of the programs, either manually or running SGEN, see KBA 1989778 for further information).

All the ABAP programs are stored in REPOSRC, so deleting the entries of REPOSRC mean deleting ABAP programs, which will definitely damage the system.

The tables D010TAB and D010INC are same, the dependence between ABAP programs and DDIC objects will be lost if the entries are deleted.

 

3. How to cleanup these tables?

As mentioned above, these tables store critical information, normally the data cannot be reduced.

But it is still possible that these tables contains obsolete entries:

 - Report RS_LOAD_FORMAT_ADM can be used to check whether there are obsolete data in REPOLOAD, D010INC, and D010TAB. The report can also be used to delete obsolete data. For details, see SAP Note 2193457. In case RS_LOAD_FORMAT_ADM doesn't exist in the system, check KBA 2324429 to check/delete obsolete loads manually.

4. Whether the table size in my system is normal?

Here are some samples:

NW750 - EHP8 FOR SAP ERP 6.0:

These two systems are just our internal test system which doesn't have any production business. So in real customer systems, it is normal that you have a much bigger size than above.

5. Suddenly the size of REPOLOAD, D010INC, D010TAB are growing quite fast. Why?

Most likely somebody executed a mass generation by SGEN or SAMT.


6. Table REPOLOAD has many entries for platform ID (MACH) equal to 0. Why?

REPOLOAD entries with MACH = 0 are used for precompiled headers and should not be deleted.

7. Index REPOLOAD~SRC exists and consume a lot of space. Why?

This is related to the ABAP Source Search in ABAP Development Tools for Eclipse (ADT). If this is not needed, the business function must be deactivate. See SAP Note 1918229 for further information.

See Also

• SAP Note 1918229 - ABAP Source Search: Enable via Business Function
• KBA 2324429 - Manually cleaning the ABAP Load table (Repoload)
• KBA 1989778 - FAQ: SGEN
• SAP Note 1230076 - Generation of ABAP loads: Tips for the analysis
• SAP Note 2193457 - Job DELETE_OLD_LOAD_FORMAT/tables REPOLOAD, D010INC, and D010TAB grow

How to change the host name of the URL when calling SAP Fiori launchpad from the transaction code /n/ui2/flp ?

 "The Connection for This Site is Not Secure" error when accessing SAP Fiori launchpad from the transaction code /n/ui2/flp ? 

or

How to change the hostname of the URL when calling SAP Fiori launchpad from the transaction code /n/ui2/flp

Error : 

1. Access the SAP GUI
2. Run the transaction code SM30
3. Maintain the table HTTPURLLOC
4. Input /sap/bc/ui2/flp  in the "Application" field
5. Input the target hostname in the field "Host Name", the format is test.sap.com, there is no "https://" or port
6. Input the port number in the "Port" field. However, if you are not using any port number in the URL when calling the target host, it doesn't mean there is no port, it is just using the default port which is 443. in this case, please input 443
7. Please note, changes are not cross all clients. The same has to be done for each client separately 

Thanks 

Rupesh Chavan

What is TCI ( SAP Note Transport-Based Correction Instructions ) and it use ?

SAP Note transport-based correction instruction (TCI) is a new way to deliver ABAP correction instructions to customer in a flexible manner

Up to now, we use the following ways to deliver the corrections : 

• SAP Notes automatic correction instructions

• SAP Notes manual correction instructions

• Support packages (SP)

A :  Comparison: Standard delivery methods and TCI

SAP Note with Correction Instructions Support Package

• Contains very specific, single corrections

• Freely defined dependencies

• CI can be valid for an SP range and can depend on other CIs

• Can be implemented automatically for all supported objects

• Objects that are not supported must be implemented manually and requires developer knowledge. 

Support Package

Contains all corrections that were made after a previous SP shipment

• Corrects the release or the previous SP

• Is imported automatically

Transport- based correction instructions have the following qualities

• ABAP transport with a set of attributes

• Set of objects of one software component version

• Planned deliveries with assembly and validation

• Created out of correction code line

• Only dedicated functionality affected

• Validity is restricted to a certain SP Range

• Dependencies to other corrections and SPs can be defined

• Integrated into standard correction and upgrade process

Availability of TCI in SAP NetWeaver Releases

TCIs are supported with the following SAP NetWeaver releases and products that are based on these releases:

• SAP NetWeaver 7.00 SP09

• SAP NetWeaver 7.01 SP05

• SAP NetWeaver 7.02 SP06

• SAP NetWeaver 7.31 SP01

• SAP NetWeaver 7.40 SP02

• All higher SAP NetWeaver releases from 7.50 onwards

Requirements of TCI

• You can apply a TCI to one software component version only.

• You furthermore need an additional SPAM access authorization for the import that includes one of the following SPAM roles:

o SAP_OCS_STD (complete SPAM access authorizations)

o SAP_OCS_TCI_IMPORT (minimal SPAM access authorization for TCI Import)

Enabling Note Assistant for SAP Note Transport-Based Correction Instructions

Enabling the Note Assistant for SAP Note TCI varies for different releases

Please more information about enabling the NA for TCI for different SAP_BASIS

For SAP_BASIS release 700, 701, and 702, see Enabling Note Assistant for TCI for Lower SAP_BASIS Releases (700, 701, 702)

• For SAP_BASIS release 731 to 751, see Enabling Note Assistant for TCI for SAP_BASIS Releases 731 Onwards.

• SAP_BASIS release 752 SP 00 onwards, bootstrap is enabled by default, and no user action is needed in this regard.

Thanks 

Rupesh Chavan