SAP ABAP Table RDGAPITMD (DG: API Structure DGTMD)
Hierarchy
BBPCRM (Software Component) BBPCRM
   EHS-DGP (Application Component) Dangerous Goods Management
     CBDG (Package) PI-EH&S Dangerous Goods Management
Basic Data
Table Category INTTAB    Structure 
Structure RDGAPITMD   Table Relationship Diagram
Short Description DG: API Structure DGTMD    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   EHS: Standard Fields for EHS API Structures  
2 ERRORMODE ESEERRMODE CHAR1 CHAR 1   0   Indicator: Error or warning in an API function  
3 ERRORINFO NUMC4 NUMC4 NUMC 4   0   Count parameters  
4 ERRORCLASS SYMSGID ARBGB CHAR 20   0   Message Class *
5 ERRORPARAM CHAR30 CHAR30 CHAR 30   0   30 Characters  
6 LOGLOCKMOD ESELGLCKMD CHAR1 CHAR 1   0   Logical Lock Mode  
7 EXTINFO ESEEXTINFO CHAR10 CHAR 10   0   External Information  
8 LINEMOD ESELINEMOD CHAR1 CHAR 1   0   Processing status or mode of a record/step loop line  
9 .INCLUDE       0   0   DG: Dangerous Goods Master  
10 .INCLUDE       0   0   EHS: Structure for key info of master data  
11 MANDT MANDT MANDT CLNT 3   0   Client T000
12 RECN ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
13 ACTN ESEACTN ESDACTN NUMC 20   0   Sequential Number of the Change State  
14 .INCLUDE       0   0   DG: Structure for General Administration Information  
15 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
16 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
17 AENNR ESEAENNR AENNR CHAR 12   0   Change Number AENR
18 DELFLG ADGE_DELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
19 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
20 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
21 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
22 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
23 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
24 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data TCG56
25 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider *
26 RECNROOT ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
27 .INCLUDE       0   0   EHS: Logical Database Key to RDGKEY  
28 MATNR BASE_MATID BASD_MATID CHAR 40   0   Material or Product (Internal Key)  
29 MOT THME_MOT HMD_MOT NUMC 2   0   Dangerous Goods - Mode-of-Transport Category THM151
30 RVLID ESERVLID ESDRVLID CHAR 10   0   Validity Area TCG91
31 .INCLUDE       0   0   EHS: Application Data for Table DGTMD  
32 DGNHM THME_NHM HMD_NDG CHAR 1   0   Non-Dangerous Goods Full Transport THM159
33 DGCAO ADGE_DGCAO X CHAR 1   0   Only Cargo Air Transport Permitted  
34 TKUI THME_TKUI HMD_TKUI CHAR 3   0   Identification Number Type TDG73
35 DGNU THME_DGNU CHAR4 CHAR 4   0   Identification Number  
36 DGRES1 ADGE_RES CHAR12 CHAR 12   0   Hazard-Inducing Substance  
37 DGRES2 ADGE_RES CHAR12 CHAR 12   0   Hazard-Inducing Substance  
38 DGCL THME_DGCL HMD_DGCL CHAR 3   0   Dangerous Goods Class THM009
39 DGSC ADGE_DGSC CHAR6 CHAR 6   0   Dangerous Goods Subclass  
40 SDBC ADGE_SDBC NUMC4 NUMC 4   0   Hazard Item Number  
41 SLBE THME_SLBE NUMC4 NUMC 4   0   Hazard Item Number (Empty Transport)  
42 LDBC THME_LDBC HMD_LDBC CHAR 5   0   Classification Code THM011
43 LWDG THME_LWDG HMD_LWDG CHAR 12   0   Dangerous Goods Regulation THM063
44 STOSU ADGE_STOSU CHAR1 CHAR 1   0   Aggregate State for Transport  
45 COTMP ADGE_COTMP ADGD_Q82 QUAN 8   2   Control Temperature  
46 TPCUN ADGE_TPCUN MEINS UNIT 3   0   Temperature Unit (Control) T006
47 EMTMP ADGE_EMTMP ADGD_Q82 QUAN 8   2   Emergency Temperature  
48 TPEUN ADGE_TPEUN MEINS UNIT 3   0   Temperature Unit (Emergency) T006
49 FLTMP ADGE_FLTMP ADGD_Q82 QUAN 8   2   Flash Point  
50 TPFUN ADGE_TPFUN MEINS UNIT 3   0   Temperature Unit (Flame) T006
51 TPSNL ADGE_TPSNL ADGD_Q82 QUAN 8   2   Temperature Sensitivity (Lower Limit)  
52 TPSLU ADGE_TPSLU MEINS UNIT 3   0   Unit for temperature sensitivity (lower limit) T006
53 TPSNH ADGE_TPSNH ADGD_Q82 QUAN 8   2   Temperature sensitivity (upper limit)  
54 TPSHU ADGE_TPSHU MEINS UNIT 3   0   Temperature Unit (Sensitivity - Upper Limit) T006
55 DAIN1 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
56 DAIN2 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
57 DAIN3 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
58 DAIN4 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
59 DAIN5 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
60 DAIN6 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
61 DAIN7 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
62 DAIN8 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
63 DAIN9 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
64 DAIN10 ADGE_DAIN CHAR4 CHAR 4   0   Hazard Note  
65 COWE ADGE_COWE ADGD_COWE CHAR 1   0   Water Pollution Class TDG15
66 VBFC ADGE_VBFC ADGD_VBFC CHAR 4   0   VbF Class TDG35
67 SDCL ADGE_SDCL ADGD_SDCL CHAR 4   0   Storage Hazard Class TDG37
68 EINU ADGE_EINU CHAR7 CHAR 7   0   Tremcard Number  
69 EICN ADGE_EICN CHAR7 CHAR 7   0   Replacement Tremcard Number  
70 EMSN1 ADGE_EMSN1 CHAR7 CHAR 7   0   EmS/ERG Number 1  
71 EMSN2 ADGE_EMSN2 CHAR7 CHAR 7   0   EmS/ERG Number 2  
72 MFAG1 ADGE_MFAG1 CHAR4 CHAR 4   0   MFAG Number 1  
73 MFAG2 ADGE_MFAG2 CHAR4 CHAR 4   0   MFAG Number 2  
74 MOS1 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
75 MOS2 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
76 MOS3 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
77 MOS4 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
78 MOS5 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
79 MOS6 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
80 MOS7 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
81 MOS8 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
82 MOS9 THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
83 MOSA THME_MOS HMD_MOS NUMC 3   0   Dangerous Goods Transport Type THM003
84 HQTU ADGE_HQTU ADGD_Q82 QUAN 8   2   Maximum Quantity per Transport Unit  
85 HQTUN ADGE_HQTUN MEINS UNIT 3   0   Maximum Quantity Unit T006
86 PIN THME_PIN HMD_PIN CHAR 25   0   Packing Instruction Number THM075
87 PGRO THME_PGRO CHAR3 CHAR 3   0   Packing Group  
88 HNU THME_HNU HMD_HNU CHAR 4   0   Hazard Identification Number THM031
89 HPN1 THME_HPN1 HMD_HPN CHAR 10   0   Danger Label Number 1 THM017
90 HPN2 THME_HPN2 HMD_HPN CHAR 10   0   Danger Label Number 2 THM017
91 HPN3 THME_HPN3 HMD_HPN CHAR 10   0   Danger Label Number 3 THM017
92 HPN4 THME_HPN4 HMD_HPN CHAR 10   0   Danger Label Number 4 THM017
93 HPN5 THME_HPN5 HMD_HPN CHAR 10   0   Danger Label Number 5 THM017
94 HPN6 THME_HPN6 HMD_HPN CHAR 10   0   Danger Label Number 6 THM017
95 HPN7 THME_HPN7 HMD_HPN CHAR 10   0   Danger Label Number 7 THM017
96 LAB1 ADGE_LAB1 ADGD_LAB CHAR 7   0   Label Number 1 TDG29
97 LAB2 ADGE_LAB2 ADGD_LAB CHAR 7   0   Label Number 2 TDG29
98 LAB3 ADGE_LAB3 ADGD_LAB CHAR 7   0   Label Number 3 TDG29
99 LAB4 ADGE_LAB4 ADGD_LAB CHAR 7   0   Label Number 4 TDG29
100 LAB5 ADGE_LAB5 ADGD_LAB CHAR 7   0   Label Number 5 TDG29
101 LAB6 ADGE_LAB6 ADGD_LAB CHAR 7   0   Label Number 6 TDG29
102 LAB7 ADGE_LAB7 ADGD_LAB CHAR 7   0   Label Number 7 TDG29
103 LAB8 ADGE_LAB8 ADGD_LAB CHAR 7   0   Label Number 8 TDG29
104 LAB9 ADGE_LAB9 ADGD_LAB CHAR 7   0   Label Number 9 TDG29
105 LAB10 ADGE_LABA ADGD_LAB CHAR 7   0   Label Number 10 TDG29
106 KDGVS ADGE_KDGVS TDOBNAME CHAR 70   0   Text Key Highly Viscous Substances  
107 KDGNS ADGE_KDGNS TDOBNAME CHAR 70   0   Text Key Exemption for Named Substances  
108 KDGMP ADGE_KDGMP TDOBNAME CHAR 70   0   Text Key Marine Pollutant  
109 KDGEX ADGE_KDGEX TDOBNAME CHAR 70   0   Text Key Exceptions  
110 KDGHI ADGE_KDGHI TDOBNAME CHAR 70   0   Text key handling data  
111 KDGF1 ADGE_KDGF1 TDOBNAME CHAR 70   0   User-Defined Text Key 1  
112 KDGF2 ADGE_KDGF2 TDOBNAME CHAR 70   0   User-Defined Text Key 2  
113 KDGF3 ADGE_KDGF3 TDOBNAME CHAR 70   0   User-Defined Text Key 3  
114 KDGF4 ADGE_KDGF4 TDOBNAME CHAR 70   0   User-Defined Text Key 4  
115 KDGF5 ADGE_KDGF5 TDOBNAME CHAR 70   0   User-Defined Text Key 5  
116 KDGF6 ADGE_KDGF6 TDOBNAME CHAR 70   0   User-Defined Text Key 6  
117 KDGF7 ADGE_KDGF7 TDOBNAME CHAR 70   0   User-Defined Text Key 7  
118 KDGF8 ADGE_KDGF8 TDOBNAME CHAR 70   0   User-Defined Text Key 8  
119 KDGF9 ADGE_KDGF9 TDOBNAME CHAR 70   0   User-Defined Text Key 9  
120 KDGF10 ADGE_KDGFA TDOBNAME CHAR 70   0   User-Defined Text Key 10  
121 PAI THME_PAI HMD_QUAN QUAN 8   2   Limited Quantity (LQ) Inner Packaging  
122 PAIU THME_PAIU MEINS UNIT 3   0   Unit of Meas. for Limited Quantity (LQ) Inner Packaging T006
123 PAO THME_PAO HMD_QUAN QUAN 8   2   Limited Quantity (LQ) Outer Packaging  
124 PAOU THME_PAOU MEINS UNIT 3   0   Unit of Meas. for Limited Quantity (LQ) Outer Packaging T006
125 RQA ADGE_RQA ADGD_Q82 QUAN 8   2   Reportable Quantity  
126 RQU ADGE_RQU MEINS UNIT 3   0   Unit of measure for reportable quantities T006
127 PBI ADGE_PBI ADGD_PIH CHAR 1   0   Poisonous by Inhalation  
128 MINQ ADGE_MINQ ADGD_Q82 QUAN 8   2   Minimum Quantity for Listed Goods  
129 MINU ADGE_MINU MEINS UNIT 3   0   Unit of Measurement Minimum Quantity (Listed Goods) T006
130 MAXQ ADGE_MAXQ ADGD_Q82 QUAN 8   2   Maximum Quantity for Listed Goods  
131 MAXU ADGE_MAXU MEINS UNIT 3   0   Unit of Measurement Maximum Quantity (Listed Goods) T006
132 RELQ THME_RELQ HMD_QUAN QUAN 8   2   Exemption (ADR 1.1.3.6)  
133 RELU THME_RELU MEINS UNIT 3   0   Unit of Measure Quantity Limit T006
134 MULRQ THME_MULRQ NUMC4 NUMC 4   0   Multiplication Factor Exemption (ADR 1.1.3.6)  
135 RCHEM ADGE_RCHEM X CHAR 1   0   Notification Status (Law on Control of Toxic Substances)  
136 DGPTA ADGE_DGPTA X CHAR 1   0   Shipping by Mail Permitted  
137 DGTNA ADGE_DGTNA X CHAR 1   0   Transport Not Permitted  
138 DGWOS THME_WOS HMD_WOS CHAR 2   0   Processing Status for Basic Data and Master Data THM039
139 NHME THME_NHME HMD_NDG CHAR 1   0   Non-Dangerous Goods Empty Transport THM159
140 DGSHE ADGE_DGSHE CHAR4 CHAR 4   0   Schedule of Class 7  
141 PIMDG ADGE_PIMDG CHAR10 CHAR 10   0   Note on Regulation  
142 SOOWA ADGE_SOOWA ADGD_Q122 QUAN 12   2   Solubility of water  
143 USOOW ADGE_USOOW MEINS UNIT 3   0   Unit for solubility of water T006
144 DENFEE ADGE_DENFE ADGD_Q112 QUAN 11   2   Density I  
145 UDENFE ADGE_UDENF MEINS UNIT 3   0   Unit for density I T006
146 DENTWE ADGE_DENTW ADGD_Q112 QUAN 11   2   Density II  
147 UDENTW ADGE_UDENT MEINS UNIT 3   0   Unit for density II T006
148 DENFIF ADGE_DENFI ADGD_Q112 QUAN 11   2   Density III  
149 UDENFI ADGE_UDEFI MEINS UNIT 3   0   Unit for density III T006
150 BUDEN ADGE_BUDEN ADGD_Q112 QUAN 11   2   Bulk Density  
151 UBUDE ADGE_UBUDE MEINS UNIT 3   0   Unit for Bulk Density T006
152 BOPOI ADGE_BOPOI HMD_QUAN QUAN 8   2   Boiling Point  
153 UBOPO ADGE_UBOPO MEINS UNIT 3   0   Unit for Boiling Point T006
154 VISCO ADGE_VISCO ADGD_Q92 QUAN 9   2   Viscosity  
155 UVISC ADGE_UVISC MEINS UNIT 3   0   Unit for Viscosity T006
156 STPRES ADGE_STPRE ADGD_Q102 QUAN 10   2   Vapor Pressure  
157 USTPRE ADGE_USTPR MEINS UNIT 3   0   Unit for vapor pressure T006
158 HYGRO ADGE_HYGRO CHAR1 CHAR 1   0   Hygroscopicity  
159 MEPOI ADGE_MEPOI HMD_QUAN QUAN 8   2   Melting Point  
160 UMEPO ADGE_UMEPO MEINS UNIT 3   0   Unit for Melting Point T006
161 COOEX ADGE_COOEX HMD_QUAN QUAN 8   2   Coefficient of Expansion  
162 UCOOE ADGE_UCOOE MEINS UNIT 3   0   Unit for Coefficient of Expansion T006
163 MTMPF ADGE_MTMPF HMD_QUAN QUAN 8   2   Medium Temperature of Liquid During Filling  
164 UMTMP ADGE_UMTMP MEINS UNIT 3   0   Unit for medium filling temperature T006
165 STOPA THME_STOPA CHAR1 CHAR 1   0   Packaging Mark  
166 SPPRO THME_SPPRO CHAR5 CHAR 5   0   Special Provision  
167 MAPOL ADGE_MAPOL ADGD_MAPOL CHAR 2   0   Marine Pollutant  
168 PINLQ THME_PINLQ HMD_PIN CHAR 25   0   Packing Instruction Number for Limited Quantity (LQ) THM075
169 PASI THME_PASI HMD_QUAN QUAN 8   2   Maximum Quantity per Package  
170 UPASI THME_UPASI MEINS UNIT 3   0   Unit of Measurement for Single Packaging T006
171 PAGW THME_PAGW HMD_QUAN QUAN 8   2   Limited Quantity (LQ) Gross Weight  
172 UPAGW THME_UPAGW MEINS UNIT 3   0   Unit of Measurement for Limited Quantity (LQ) Gross T006
173 EXCEP ADGE_EXCEP CHAR40 CHAR 40   0   Exception and Agreement Number  
174 SCASE ADGE_SCASE X CHAR 1   0   Special Case (Packing Check)  
175 COLNO ADGE_COLNO X CHAR 1   0   Collective Number  
176 DGRES3 ADGE_RES CHAR12 CHAR 12   0   Hazard-Inducing Substance  
177 DGREMP ADGE_REMP CHAR12 CHAR 12   0   Hazard-inducing substance (marine pollutant)  
178 DGRERQ ADGE_RERQ CHAR12 CHAR 12   0   Hazard-inducing substance (reportable quantity)  
179 EIMDG ADGE_EIMDG CHAR4 CHAR 4   0   Regulation Edition  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RDGAPITMD AENNR AENR AENNR REF 1 CN
2 RDGAPITMD COWE TDG15 COWE REF 1 CN
3 RDGAPITMD DGCL THM009 DGCL REF 1 CN
4 RDGAPITMD DGNHM THM159 NDG REF 1 CN
5 RDGAPITMD DGWOS THM039 DGWOS REF 1 CN
6 RDGAPITMD HNU THM031 HNU REF 1 CN
7 RDGAPITMD HPN1 THM017 HPN REF 1 CN
8 RDGAPITMD HPN2 THM017 HPN REF 1 CN
9 RDGAPITMD HPN3 THM017 HPN REF 1 CN
10 RDGAPITMD HPN4 THM017 HPN REF 1 CN
11 RDGAPITMD HPN5 THM017 HPN REF 1 CN
12 RDGAPITMD HPN6 THM017 HPN REF 1 CN
13 RDGAPITMD HPN7 THM017 HPN REF 1 CN
14 RDGAPITMD HQTUN T006 MSEHI REF 1 CN
15 RDGAPITMD LAB1 TDG29 LAB REF 1 CN
16 RDGAPITMD LAB10 TDG29 LAB REF 1 CN
17 RDGAPITMD LAB2 TDG29 LAB REF 1 CN
18 RDGAPITMD LAB3 TDG29 LAB REF 1 CN
19 RDGAPITMD LAB4 TDG29 LAB REF 1 CN
20 RDGAPITMD LAB5 TDG29 LAB REF 1 CN
21 RDGAPITMD LAB6 TDG29 LAB REF 1 CN
22 RDGAPITMD LAB7 TDG29 LAB REF 1 CN
23 RDGAPITMD LAB8 TDG29 LAB REF 1 CN
24 RDGAPITMD LAB9 TDG29 LAB REF 1 CN
25 RDGAPITMD LDBC THM011 LDBC REF 1 CN
26 RDGAPITMD LWDG THM063 LWDG KEY 1 CN
27 RDGAPITMD MANDT T000 MANDT    
28 RDGAPITMD MAXU T006 MSEHI REF 1 CN
29 RDGAPITMD MINU T006 MSEHI REF 1 CN
30 RDGAPITMD MOS1 THM003 MOS REF 1 CN
31 RDGAPITMD MOS2 THM003 MOS REF 1 CN
32 RDGAPITMD MOS3 THM003 MOS REF 1 CN
33 RDGAPITMD MOS4 THM003 MOS REF 1 CN
34 RDGAPITMD MOS5 THM003 MOS REF 1 CN
35 RDGAPITMD MOS6 THM003 MOS REF 1 CN
36 RDGAPITMD MOS7 THM003 MOS REF 1 CN
37 RDGAPITMD MOS8 THM003 MOS REF 1 CN
38 RDGAPITMD MOS9 THM003 MOS REF 1 CN
39 RDGAPITMD MOSA THM003 MOS REF 1 CN
40 RDGAPITMD MOT THM151 MOT 1 CN
41 RDGAPITMD NHME THM159 NDG REF 1 CN
42 RDGAPITMD PAIU T006 MSEHI REF 1 CN
43 RDGAPITMD PAOU T006 MSEHI REF 1 CN
44 RDGAPITMD PIN THM075 PIN REF 1 CN
45 RDGAPITMD PINLQ THM075 PIN REF 1 CN
46 RDGAPITMD RELU T006 MSEHI REF 1 CN
47 RDGAPITMD RQU T006 MSEHI REF 1 CN
48 RDGAPITMD RVLID TCG91 RVLID    
49 RDGAPITMD SDCL TDG37 SDCL REF 1 CN
50 RDGAPITMD SRSID TCG56 SRSID REF 1 CN
51 RDGAPITMD TKUI TDG73 TKUI REF 1 CN
52 RDGAPITMD TPCUN T006 MSEHI REF 1 CN
53 RDGAPITMD TPEUN T006 MSEHI REF 1 CN
54 RDGAPITMD TPFUN T006 MSEHI REF 1 CN
55 RDGAPITMD TPSHU T006 MSEHI REF 1 CN
56 RDGAPITMD TPSLU T006 MSEHI REF 1 CN
57 RDGAPITMD UBOPO T006 MSEHI REF 1 CN
58 RDGAPITMD UBUDE T006 MSEHI REF 1 CN
59 RDGAPITMD UCOOE T006 MSEHI REF 1 CN
60 RDGAPITMD UDENFE T006 MSEHI REF 1 CN
61 RDGAPITMD UDENFI T006 MSEHI REF 1 CN
62 RDGAPITMD UDENTW T006 MSEHI REF 1 CN
63 RDGAPITMD UMEPO T006 MSEHI REF 1 CN
64 RDGAPITMD UMTMP T006 MSEHI REF 1 CN
65 RDGAPITMD UPAGW T006 MSEHI REF 1 CN
66 RDGAPITMD UPASI T006 MSEHI REF 1 CN
67 RDGAPITMD USOOW T006 MSEHI REF 1 CN
68 RDGAPITMD USTPRE T006 MSEHI REF 1 CN
69 RDGAPITMD UVISC T006 MSEHI REF 1 CN
70 RDGAPITMD VBFC TDG35 VBFC REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 600