Ansicht
Dokumentation

RCBUI002 - Conversion Program for Value Assignment and Assignment Tables

RCBUI002 - Conversion Program for Value Assignment and Assignment Tables

RFUMSV00 - Advance Return for Tax on Sales/Purchases   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

Description

To be able to use the substance database, you must execute this report after the Put to 3.0F:

For all releases for the delivery of the EHS substance database (3.0D to 3.0E), the RECN field from the ESTVA table is specified as key for the class category 100 or object ESTVA. This entry is found in the Classification Guide Customizing. This entry ensures that the Classification object is identical to the ESTVA-RECN field.

Because engineering change management is introduced at object level for Release 3.0F, the key for object ESTVA is also changed in Classification Customizing. As of Release 3.0F, this is composed of the RECN and ACTN fields from the ESTVA table, and constructs the object to be classified in RECN and ACTN. You find the object number in tables AUSP and KSSK. As ACTN is a NUMC field, zeros must be added to the object numbers in ACTN length (20 spaces).

How the report works

This report first processes the AUSP and then the KSSK. A temporary table with AUSP or KSSK structure is created in the database for this purpose. Then all records of class category 100 are read from the original table in blocks of 5,000 records, the data is converted and entered in the temporary table. The original records are deleted from the original table. If no further data is found in the original table, the contents of the temporary table are re-entered in the original table. This procedure is used for AUSP and KSSK in every system client.

Finally, the system checks if records of class category 100 in the original table correspond to those in the temporary table. If so, the temporary tables are deleted from the database.

Requirements

This report must run in the background. If not, it could terminate due to excessive run time. While the report is running, substance database transactions (CG*) must be locked. If this function is called from the release note, all substance database transactions (CG*) apart from transaction CGB8 must be locked. The last transaction cannot be locked, because it triggers the conversion. If conversion is carried out successfully, the report should not be executed again.

Output

The user who started the transaction receives a job log.

This should be checked for the following entries:

MsgId message
00516 job was started
00550 step 001 started (program RCBUI002, variant , user name)
C$793 creation of temporary table AUSP01 in the database
C$137 conversion of database table AUSP
C$792 conversion of table: AUSP client: 003 on: 18.09.1996 at: ...

The following two lines may appear several times.
Instead of , the number of converted records is output.
C$796 data records in temporary table AUSP01 client were...
C$796 data records in database table AUSP client were...

C$793 creation of temporary table KSSK01 in the database
C$137 conversion of database table KSSK
C$792 conversion of table: KSSK client: 003 on: 18.09.1996 at: ...

The following two lines may appear several times.
Instead of , the number of converted records is output.
C$796 data records in temporary table KSSK01 client were...
C$796 data records in database table KSSK client were...

C$137 conversion of database table AUSP is checked
C$137 database table AUSP was converted successfully
C$793 deletion of temporary table AUSP01 in the database
C$137 conversion of database table KSSK is checked
C$137 database table KSSK was converted successfully
C$793 deletion of temporary table KSSK01 in the database
00517 job was terminated

Example

For the conversion, two temporary tables are created in the database.
The names of the temporary tables are generated. The structure of the names is as follows: AUSP<2-digit number> and KSSK<2 digit number>.
Example for table names: AUSP01 and KSSK01

The contents of the OBJEK field in the AUSP and KSSK tables are converted. Up to now, the contents corresponded to the 20-space RECN field in the ESTVA table. In future, the OBJEK field will be composed of the RECN and ACTN fields (20 spaces).
Example:
========

OBJEK from tables AUSP and KSSK before conversion:
00000000000000004711
| |
+---------+--------+
|
RECN

OBJEK from tables AUSP and KSSK after conversion:
0000000000000000471100000000000000000000
| || |
+---------+--------++---------+--------+
| |
RECN ACTN






ROGBILLS - Synchronize billing plans   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 4888 Date: 20240601 Time: 093659     sap01-206 ( 84 ms )