EHS_DGTM2_APPEND_03 SAP (Structure-Append Dangerous Goods Append Table EhP3) Append Structure details

Dictionary Type: Append Structure
Description: Structure-Append Dangerous Goods Append Table EhP3




ABAP Code to SELECT data from EHS_DGTM2_APPEND_03
Related tables to EHS_DGTM2_APPEND_03
Access table EHS_DGTM2_APPEND_03




Append Structure field list including key, data, relationships and ABAP select examples

EHS_DGTM2_APPEND_03 is a standard SAP Append Structure which is used to store Structure-Append Dangerous Goods Append Table EhP3 data and is available within R/3 SAP systems depending on the version and release level.

The EHS_DGTM2_APPEND_03 table consists of various fields, each holding specific information or linking keys about Structure-Append Dangerous Goods Append Table EhP3 data available in SAP. These include TEXTPATT_PROF01 (Text Pattern Profile 01), TEXTPATT01 (Dangerous Goods Text Pattern 01), TEXTPATT_PROF02 (Text Pattern Profile 02), TEXTPATT02 (Dangerous Goods Text Pattern 02).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP EHS_DGTM2_APPEND_03 append structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TEXTPATT_PROF01Text Pattern Profile 01 ADGE_TEXTPATT_PROF01CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT01Dangerous Goods Text Pattern 01 ADGE_PTXTPATT01CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF02Text Pattern Profile 02 ADGE_TEXTPATT_PROF02CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT02Dangerous Goods Text Pattern 02 ADGE_PTXTPATT02CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF03Text Pattern Profile 03 ADGE_TEXTPATT_PROF03CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT03Dangerous Goods Text Pattern 03 ADGE_PTXTPATT03CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF04Text Pattern Profile 04 ADGE_TEXTPATT_PROF04CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT04Dangerous Goods Text Pattern 04 ADGE_PTXTPATT04CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF05Text Pattern Profile 05 ADGE_TEXTPATT_PROF05CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT05Dangerous Goods Text Pattern 05 ADGE_PTXTPATT05CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF06Text Pattern Profile 06 ADGE_TEXTPATT_PROF06CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT06Dangerous Goods Text Pattern 06 ADGE_PTXTPATT06CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF07Text Pattern Profile 07 ADGE_TEXTPATT_PROF07CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT07Dangerous Goods Text Pattern 07 ADGE_PTXTPATT07CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF08Text Pattern Profile 08 ADGE_TEXTPATT_PROF08CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT08Dangerous Goods Text Pattern 08 ADGE_PTXTPATT08CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF09Text Pattern Profile 09 ADGE_TEXTPATT_PROF09CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT09Dangerous Goods Text Pattern 09 ADGE_PTXTPATT09CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF10Text Pattern Profile 10 ADGE_TEXTPATT_PROF10CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT10Dangerous Goods Text Pattern 10 ADGE_PTXTPATT10CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF11Text Pattern Profile 11 ADGE_TEXTPATT_PROF11CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT11Dangerous Goods Text Pattern 11 ADGE_PTXTPATT11CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF12Text Pattern Profile 12 ADGE_TEXTPATT_PROF12CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT12Dangerous Goods Text Pattern 12 ADGE_PTXTPATT12CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF13Text Pattern Profile 13 ADGE_TEXTPATT_PROF13CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT13Dangerous Goods Text Pattern 13 ADGE_PTXTPATT13CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF14Text Pattern Profile 14 ADGE_TEXTPATT_PROF14CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT14Dangerous Goods Text Pattern 14 ADGE_PTXTPATT14CHAR21CBDUD_FIELD_WITH_PHRASE
TEXTPATT_PROF15Text Pattern Profile 15 ADGE_TEXTPATT_PROF15CHAR10TDG91ADGD_TEXTPATT_PROF
TEXTPATT15Dangerous Goods Text Pattern 15 ADGE_PTXTPATT15CHAR21CBDUD_FIELD_WITH_PHRASE
ABS_ACTAbsolute Activity ADGE_ABS_ACTQUAN11(4) ADGD_QUAN_11_4
ABS_ACT_UUnit of Absolute Activity ADGE_ABS_ACT_UUNIT3T006CUNITMEINS
REL_SPEC_ACTRelative Specific Activity ADGE_REL_SPEC_ACTQUAN11(4) ADGD_QUAN_11_4
REL_SPEC_ACT_UUnit of Relative Specific Activity ADGE_REL_SPEC_ACT_UUNIT3T006CUNITMEINS
CONTAMINATIONContamination ADGE_CONTAMINATIONQUAN8(3) ADGD_QUAN_8_3
CONTAMINATION_UUnit of Contamination ADGE_CONTAMINATION_UUNIT3T006CUNITMEINS
DOSE_RATERadiation Level (Unpacked) ADGE_DOSE_RATEQUAN9(5) ADGD_QUAN_9_5
DOSE_RATE_UUnit of Radiation Level (Unpacked) ADGE_DOSE_RATE_UUNIT3T006CUNITMEINS
MAX_ACT1A1 Activity Limit ADGE_MAX_ACT1QUAN11(4) ADGD_QUAN_11_4
MAX_ACT1_UA1 Activity Limit: Unit ADGE_MAX_ACT1_UUNIT3T006CUNITMEINS
ACT1_UNLIMITA1 Activity Limit: Unlimited ADGE_ACT1_UNLIMITCHAR1ESDFLAG
MAX_ACT2A2 Activity Limit ADGE_MAX_ACT2QUAN11(4) ADGD_QUAN_11_4
MAX_ACT2_UA2 Activity Limit: Unit ADGE_MAX_ACT2_UUNIT3T006CUNITMEINS
ACT2_UNLIMITA2 Activity Limit: Unlimited ADGE_ACT2_UNLIMITCHAR1ESDFLAG
ACT_SUB_PACKActivity Concentration for Substances in Excepted Packages ADGE_ACT_SUB_PACKQUAN11(4) ADGD_QUAN_11_4
ACT_SUB_PACK_UActivity Concentration Unit for Substances in Excepted Pkgs ADGE_ACT_SUB_PACK_UUNIT3T006CUNITMEINS
MAX_ACT_CONSGActivity Limit for Exempt Consignment ADGE_MAX_ACT_CONSGQUAN11(4) ADGD_QUAN_11_4
MAX_ACT_CONSG_UUnit of Activity Limit for Exempt Consignment ADGE_MAX_ACT_CONSG_UUNIT3T006CUNITMEINS
MULT_ACT_SGLMultiplier Activity Limit Item ADGE_MULT_ACT_SGLDEC11(7) ADGD_DEC_11_7
REF_ACT_SGLReference Value for Multiplier Item ADGE_REF_ACT_SGLCHAR2ADGD_REF_ACT
MULT_ACT_PACKMultiplier Activity Limit Package ADGE_MULT_ACT_PACKDEC11(7) ADGD_DEC_11_7
REF_ACT_PACKReference Value for Multiplier Package ADGE_REF_ACT_PACKCHAR2ADGD_REF_ACT
MAX_CONT_AContamination Limit (Alpha) ADGE_MAX_CONT_AQUAN8(3) ADGD_QUAN_8_3
MAX_CONT_A_UUnit of Contamination Limit (Alpha) ADGE_MAX_CONT_A_UUNIT3T006CUNITMEINS
MAX_CONT_B_GContamination Limit (Beta, Gamma) ADGE_MAX_CONT_B_GQUAN8(3) ADGD_QUAN_8_3
MAX_CONT_B_G_UUnit of Contamination Limit (Beta, Gamma) ADGE_MAX_CONT_B_G_UUNIT3T006CUNITMEINS
MAX_DOSE_UNPLimit Radiation Level Unpacked ADGE_MAX_DOSE_UNPQUAN9(5) ADGD_QUAN_9_5
MAX_DOSE_UNP_UUnit of Limit Radiation Level Unpacked ADGE_MAX_DOSE_UNP_UUNIT3T006CUNITMEINS
DIST_DOSE_UNPMeasured Distance for Limit Unpacked ADGE_DIST_DOSE_UNPQUAN5(3) ADGD_QUAN_5_3
DIST_DOSE_UNP_UUnit of Measured Distance for Limit Unpacked ADGE_DIST_DOSE_UNP_UUNIT3T006CUNITMEINS
NO_DIST_UNPMeasurement Unpacked at Surface ADGE_NO_DIST_UNPCHAR1ESDFLAG
MAX_DOSE_PACKLimit Radiation Level Packed ADGE_MAX_DOSE_PACKQUAN9(5) ADGD_QUAN_9_5
MAX_DOSE_PACK_UUnit of Limit Radiation Level Packed ADGE_MAX_DOSE_PACK_UUNIT3T006CUNITMEINS
DIST_DOSE_PACKMeasured Distance for Limit Packed ADGE_DIST_DOSE_PACKQUAN5(3) ADGD_QUAN_5_3
DIST_DOSE_PACK_UUnit of Measured Distance for Limit Packed ADGE_DIST_DOSE_PACK_UUNIT3T006CUNITMEINS
NO_DIST_PACKMeasurement Packed at Surface ADGE_NO_DIST_PACKCHAR1ESDFLAG
MAX_ACT_SGL_DCMaximum Activity: Item ADGE_MAX_ACT_SGL_DCQUAN11(4) ADGD_QUAN_11_4
MAX_ACT_SGL_U_DCMaximum Activity Unit: Item ADGE_MAX_ACT_SGL_DYN_UUNIT3T006CUNITMEINS
ACT_SGL_UNLIM_DCMaximum Activity of Item Unlimited ADGE_ACT_SGL_UNLIM_DCCHAR1ESDFLAG
MAX_ACT_PAC_DCMaximum Activity: Package ADGE_MAX_ACT_PAC_DCQUAN11(4) ADGD_QUAN_11_4
MAX_ACT_PAC_U_DCMaximum Activity Unit: Package ADGE_MAX_ACT_PACK_DYN_UUNIT3T006CUNITMEINS
ACT_PAC_UNLIM_DCMaximum Activity of Package Unlimited ADGE_ACT_PAC_UNLIM_DCCHAR1ESDFLAG
EXCPT_PAC_OPT_DCExcepted Package: Optional ADGE_EXCPT_PAC_OPT_DCCHAR1ESDFLAG
MAX_GRS_WGHT_DCMaximum Gross Mass ADGE_MAX_GRS_WGHT_DCQUAN8(2) HMD_QUAN
U_MAX_GRS_WGT_DCUnit for Maximum Gross Mass ADGE_U_MAX_GROSS_WGHTUNIT3T006CUNITMEINS
EXCEPTID01Exception to Dangerous Goods Regulations 01 ADGE_EXCEPTID01CHAR18ADGD_EXCEPTID
EXCEPTID02Exception to Dangerous Goods Regulations 02 ADGE_EXCEPTID02CHAR18ADGD_EXCEPTID
EXCEPTID03Exception to Dangerous Goods Regulations 03 ADGE_EXCEPTID03CHAR18ADGD_EXCEPTID
EXCEPTID04Exception to Dangerous Goods Regulations 04 ADGE_EXCEPTID04CHAR18ADGD_EXCEPTID
EXCEPTID05Exception to Dangerous Goods Regulations 05 ADGE_EXCEPTID05CHAR18ADGD_EXCEPTID
EXCEPTID06Exception to Dangerous Goods Regulations 06 ADGE_EXCEPTID06CHAR18ADGD_EXCEPTID
EXCEPTID07Exception to Dangerous Goods Regulations 07 ADGE_EXCEPTID07CHAR18ADGD_EXCEPTID
EXCEPTID08Exception to Dangerous Goods Regulations 08 ADGE_EXCEPTID08CHAR18ADGD_EXCEPTID
EXCEPTID09Exception to Dangerous Goods Regulations 09 ADGE_EXCEPTID09CHAR18ADGD_EXCEPTID
EXCEPTID10Exception to Dangerous Goods Regulations 10 ADGE_EXCEPTID10CHAR18ADGD_EXCEPTID
ACT_EMIS_TYPERadioactive Emission Type ADGE_ACT_EMIS_TYPECHAR3ADGD_ACT_EMIS_TYPE
MAX_NEM_DCMaximum Net Explosive Substance Mass ADGE_MAX_NEM_DCQUAN9(3) EHS_ADGD_Q93
MAX_NEM_U_DCUnit of Maximum Net Explosive Substance Mass ADGE_MAX_NEM_DC_UUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



How do I retrieve data from SAP append structure EHS_DGTM2_APPEND_03 using ABAP code?

As EHS_DGTM2_APPEND_03 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on EHS_DGTM2_APPEND_03 as there is no data to select. You could however select data from any tables that this append structure has been assigned too.

How to access SAP table EHS_DGTM2_APPEND_03

Within an ECC or HANA version of SAP you can also view further information about EHS_DGTM2_APPEND_03 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!