Ansicht
Dokumentation
Data Conversion from 4.0B to 4.5A for Dangerous Goods Management ( RELN45A_40B_GGA_RELCHANG )
rdisp/max_wprun_time - Maximum work process run time Vendor Master (General Section)This documentation is copyright by SAP AG.
Short text
Data Conversion from 4.0B to 4.5A for Dangerous Goods Management
Description
This release note describes how to convert the application and Customizing tables for dangerous goods master data.
As the structures of the Customizing and application tables have changed, you will need to convert the table data in the following cases:
- If you use dangerous goods management in a productive 4.0A/B system
- If you have prepared for your productive system using existing master data and Customizing table entries
Changes to the Interface
- The Dangerous goods regulation data field has been included as a data field that needs to be maintained
- You no longer need to maintain the Mode of transport category and Validity area data fields in the application and the Mode of transport category in Customizing (for example, defining a dangerous goods class in the IMG activity). You now make the definitions via the respective dangerous goods regulation only.
This change means you can maintain dangerous goods data more easily and exactly using the relevant valid dangerous goods regulation.
Note- The system prevents you from making entries such as the mode of transport category Inland waterway or the validity area World directly when you create a dangerous goods master data record.
Dependent functions
The relationships between the old key that is made up of the mode of transport category and validity area and the new key dangerous goods regulation are stored in a central Customizing table Dangerous goods regulation (THM063).
For dangerous goods regulations such as IATA or CFR that apply for a number of mode of transport categories, you can maintain different keys in the IMG activity Define Dangerous Goods Regulations if the data records have different mode of transport categories.
As you may have to intervene in the conversion process, we have made sure that no XPRAs (table conversion programs) were used.
In Customizing tables, the data from the old tables is converted into new tables.
Notes- You do not have to fill these new tables at the time you change to release 4.5A; this can also be done at a later stage.
- You must carry out the conversion for productive systems.
Damage caused to data by errors
Data conversion is necessary for the new structures created for the dangerous goods master and Customizing tables.
A key change has been carried out for both the dangerous goods master (DGTMD) and the Customizing tables. The entities are dependent on the dangerous goods regulation (and possibly on other attributes) and no longer on the mode of transport category and/or validity area.
The Customizing tables for the dangerous goods master which are not dependent on regulations are not affected by the conversion.
Effects on Customizing
New Customizing tables have been created for the dangerous goods master. You no longer actively use the old Customizing tables. You do not therefore need to run an automatic XPRA. Instead, reports are made available for both the above areas, thereby keeping the database consistent.
The assignment of the dangerous goods regulations to the appropriate mode of transport categories and validity areas is important. Before conversion, you should construct an assignment table using the existing data. You can also maintain this table manually, if necessary.
Changes in procedure
There are eight steps to the data conversion:
Constructing the Customizing Table for Dangerous Goods Regulations (THM063):
- Step 1: Convert the old Customizing table for dangerous goods regulations (TDG63).
- Step 2: Check and maintain the new Customizing table for dangerous goods regulations (THM063).
Constructing the Application Table for Dangerous Goods Material Master Data (DGTMD):
- Step 3: Check whether you can convert the dangerous goods material master data (DGTMD) at a later stage.
- Step 4: Convert the table for dangerous goods material master data (DGTMD).
Constructing the Regulation-Dependent Customizing Tables:
- Step 5: Convert the regulation-dependent Customizing tables.
- Step 6: Maintain the regulation-dependent Customizing tables.
Checking the Referential Integrity (Data Consistency):
- Step 7: Maintain the dangerous goods master (DGTMD).
- Step 8: Automatic check for referential integrity.
- Steps 1 through 8 must be carried out in the order given.
- However, after each step, you can restart the procedure again from the previous step:
- After checking whether the dangerous goods master can be converted (step 3), you can start again with step 2 (maintaining the dangerous goods regulations).
- After checking the referential integrity (step 8), you can maintain the Customizing (step 6) and the master data (step 7) again.
Step 1 - Converting the old Customizing table for dangerous goods regulations (TDG63)
Note- You may not need to carry out step 1 if, for example, there is no data or data you no longer require in the Derivations of Regulations (TDG63) table.
You carry out step 1 to detect data conflicts and maintain data in the new Customizing table (THM063).
Data conflicts arise if, for example, you have assigned a number of mode of transport categories to a validity area for the CFR regulation.
In this case, you must maintain the data in the new Customizing table (THM063) (step 2) by defining different keys for each combination of mode of transport category and validity area.
Note- You must also maintain the data in the new Customizing table (THM063) (step 2) if not all the combinations of mode of transport category and validity area already used were maintained in the old Customizing table (TDG63).
In the following example for step 1, the data that would cause a data conflict are shown in italics. A data conflict would arise because the CFR mode of transport categories 01 (road) and 02 (rail) are assigned to the validity area USA for the dangerous goods regulation CFR.
Source table:
Old Customizing table TDG63 (derivation of regulations)
MTransCat | V.Area | DGReg. | ||
---|---|---|---|---|
01 | EU | ADR | ||
01 | DE | GGVS | ||
01 | USA | CFR | ||
02 | EU | RID | ||
02 | DE | GGVE | ||
02 | USA | CFR |
Target table:
New Customizing table THM063 (dangerous goods regulations)
GGV | MTransCat | V.Area | |
---|---|---|---|
ADR | 01 | EU | |
GGVS | 01 | DE | |
CFR | 01 | USA | |
RID | 02 | EU | |
GGVE | 02 | DE | |
CFR | 02 | USA |
Activities
To convert the data in the old TDG63 Customizing table to the data in the new THM063 Customizing table, proceed as follows:
-
Call transaction DGU1.
The DG-Mat: Conversion of DG Regulations Table TDG63 to THM063 screen appears. - Set the Conversion indicator.
- If you set the Deletion of existing entries indicator, existing entries in the target table THM063 are deleted.
- Choose Execute.
Step 2 - Checking and maintaining the new Customizing table THM063
The data in the dangerous goods regulation Customizing table (THM063) is used for converting the dangerous goods material master (application table DGTMD) and other Customizing tables that are dependent on the mode of transport category at a later stage.
Note- Enter a unique secondary key for the mode of transport category/validity area combination (for example, CFR_01) to create a unique 1:1 relationship between this combination and the respective dangerous goods regulation.
Example
In the following example, the secondary keys CFR_1 and CFR_2 (italics) are entered in the Customizing table THM063 (dangerous goods regulations) with the corresponding mode of transport categories.
GGV | MTransCat | V.Area | |
---|---|---|---|
ADR | 01 | EU | |
GGVS | 01 | DE | |
RID | 02 | EU | |
GGVE | 02 | DE | |
CFR_1 | 01 | USA | |
CFR_2 | 02 | USA |
Activities
-
Call the IMG activity Define Dangerous Goods Regulations to check and maintain the table.
The DG: Dangerous Goods Regulation Dialog: Overview screen appears. - Enter the required dangerous goods regulation together with the appropriate validity area and mode of transport category.
- Save your entries.
Step 3 - Checking whether you can convert the dangerous goods material master data (DGTMD application table) at a later stage
Note- If the conversion of the dangerous goods material master data (DGTMD) produces errors in the data, you must then check and edit the Customizing table THM063 (step 2).
In this step, you can use the check routine Check for consistency to determine whether the dangerous goods material master data conversion will run successfully.
- If the check confirms that the conversion will be successful, you can convert the dangerous goods master (step 4).
- If not, you must adapt the Customizing table THM063 (step 2) or the dangerous goods master (DGTMD).
- An entry in the application table of the dangerous goods master (DGTMD) is only relevant if the combination of mode of transport category and validity area is not part of a dangerous goods regulation.
Activities
-
Call transaction DGUD.
The DG-Mat: Check Referential Integrity for Converted Customizing Tables screen appears. -
Check whether the Check for consistency indicator is set.
Select the data you want to check:
- Transport categories
- Dangerous goods classes, letters
- Danger labels
- Hazard identification numbers
- Choose Execute.
Step 4 - Converting the table for dangerous goods material master data (DGTMD)
In the following example, the old field contents (DGReg. column) are overwritten by the entries in the Customizing table THM063 (italics).
Example
DGTMD application table before conversion
Material | MTransCat | V.Area | DGReg. | |||
---|---|---|---|---|---|---|
4711 | 01 | EU | ADR | |||
4711 | 01 | EU | ||||
4712 | 01 | DE | GGVS | |||
4712 | 01 | DE | ADR | |||
4712 | 02 | EU | ||||
4712 | 02 | DE | GGVE | |||
4715 | 01 | USA | CFR | |||
4715 | 02 | USA | ||||
DGTMD application table after conversion
Material | DGReg. | MTransCat | V.Area | |||
---|---|---|---|---|---|---|
4711 | ADR | 01 | EU | |||
4711 | ADR | 01 | EU | |||
4712 | GGVS | 01 | DE | |||
4712 | GGVS | 01 | DE | |||
4712 | RID | 02 | EU | |||
4712 | GGVE | 02 | DE | |||
4715 | CFR_1 | 01 | USA | |||
4715 | CFR_2 | 02 | USA | |||
Note
- If a combination of mode of transport category and validity area exists in the DGTMD application table which is not entered in the Customizing table THM063 (dangerous goods regulations), the data in the application table for the dangerous goods material master (DGTMD) is only partly converted. Maintain the entries in the Customizing table THM063 (step 2).
Activities
-
Call transaction DGUM.
The DG-Mat: Convert DG Regulation to DG material master data table DGTMD screen appears.
A list of the converted data from the master data table (DGTMD) is displayed if you activated the conversion first (transaction DGU1).
Step 5 - Converting the regulation-dependent Customizing tables
Convert the data from the following Customizing tables:
* Transport Categories (TDG03/04)
* Dangerous Goods Classes (TDG09/10)
* Dangerous Goods Letters (TDG11/12)
* Danger Labels (TDG17/18)
* Hazard Identification Numbers (TDG31/32)
These Customizing tables are converted using the dangerous goods master data.
Example
The application table for the dangerous goods material master (DGTMD) can have the following contents:
Mat. | DGReg. | MTransCat | V.Area | TransCat1 | TransCat2 | HazIDNo. | |||
---|---|---|---|---|---|---|---|---|---|
4711 | ADR | 01 | EU | 2 | 22 | ||||
4711 | ADR | 01 | EU | 2 | 1 | 23 | |||
4712 | GGVS | 01 | DE | 2 | 4 | 223 | |||
4712 | GGVS | 01 | DE | 1 | 22 | ||||
4712 | RID | 02 | EU | 1 | 3 | 22 | |||
4712 | GGVE | 02 | DE | 3 | 224 | ||||
4715 | CFR_1 | 01 | USA | 2 | 22 | ||||
The conversion of the data in the transport categories Customizing table (TDG03/04) may look like the table below:
TDG03/04
MTransCat | TransCat | Description |
---|---|---|
01 | 1 | tank |
01 | 2 | packaged |
02 | 1 | tank |
02 | 3 | in bulk |
02 | 4 | in containers |
THM003/004
DGReg. | TransCat | Description | |
---|---|---|---|
ADR | 1 | tank | |
GGVS | 1 | tank | |
ADR | 2 | packaged | |
GGVS | 2 | packaged | |
CFR_1 | 2 | packaged | |
RID | 1 | tank | |
RID | 3 | in bulk | |
GGVE | 3 | in bulk |
Notes
- You can call the conversion report again at any time as the old data still exists in the system.
- You should delete the entries in the target tables before restarting the system by setting the relevant indicator in the reports.
In the example, the following regulation-dependent Customizing data is not converted:
- The last entry in the TDG03/04 Customizing tables cannot be converted, as it is not used in the dangerous goods master application table (DGTMD). The system logs this in the report.
- The data for transport category 4 for mode of transport category 01 (road) and transport category 2 for mode of transport category 02 (rail) cannot be converted as these transport categories did not exist in the source table. Data conflicts of this type can occur, for example, if you delete data in the corresponding Customizing table.
-
The hazard identification number Customizing table (TDG31/32) cannot access the mode of transport categories. The following example illustrates the process using the ADR and GGVS regulations:
TDG31/32
HazIDNo | Description |
---|---|
20 | inert gas |
22 | refrigerated gas |
223 | refrigerated, combustible gas |
23 | combustible gas |
THM031/032
DGReg. | HazIDNo | Description |
---|---|---|
ADR | 22 | refrigerated gas |
GGVS | 22 | refrigerated gas |
RID | 22 | refrigerated gas |
CFR_1 | 22 | refrigerated gas |
GGVS | 223 | refrigerated gas |
ADR | 23 | combustible gas |
CFR_2 | 23 | combustible gas |
The following Customizing data was not converted:
- The entry Hazard identification number 20 could not be converted as it is not used in the dangerous goods master application table (DGTMD).
- The entry Hazard identification number 224 (for GGVE) could not be converted as it does not exist in the Customizing table.
Activities
- Call transaction DGU0.
The DG-Mat: Conversion to Regulation-Dependent Customizing Tables screen appears.
- Set the indicator for the Customizing tables you want to convert:
- Transport categories
- DG classes and letters
- Danger labels
- Hazard identification numbers
- Set the Delete target entries first indicator if you want to delete the entries in the corresponding Customizing tables.
- Choose Execute.
Step 6 - Maintaining the regulation-dependent Customizing tables
The contents of the regulation-dependent Customizing tables are generated using the dangerous goods master application table (DGTMD).
Notes- Delete the entries that are not valid with regard to dangerous goods laws.
- Check and maintain any generated entries that differ by moving on to step 7 and maintaining the DGTMD application table. Then convert the Customizing tables again (step 5).
Activities
Call the following IMG activities:
Step 7 - Maintaining the dangerous goods master application table (DGTMD)
Check all entries in the dangerous goods master application table (DGTMD) and maintain the entries if necessary.
Note- Take care with the entries that were generated first (step 5) and then deleted (step 6).
- You can use the transaction SE16 to search for the relevant data records and change or delete them in the screen.
Step 8 - Automatic check for referential integrity
To guarantee referential integrity between the converted data in Customizing and in the application, carry out the following check:
Activities
- Call transaction DGUC.
The DG-Mat: Check Referential Integrity for Converted Customizing Tables screen appears.
- Check whether the Check for referential integrity indicator is set.
- Set the indicator for the Customizing tables that you want to check.
- Choose Execute.
CL_GUI_FRONTEND_SERVICES - Frontend Services General Material Data
This documentation is copyright by SAP AG.
Length: 35084 Date: 20240426 Time: 074434 sap01-206 ( 240 ms )