SAP ABAP Table BAPI1078_PRODUCT_RELEASE (BAPI Structure Dangerous Goods Product Release)

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	BAPI1078_PRODUCT_RELEASE	Table Relationship Diagram
Short Description	BAPI Structure Dangerous Goods Product Release

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	FUNCTION	☐	MSGFN	MSGFN	CHAR	3	0	Function
2	PRIMARYKEY	☐	ESEPKEY	ESDPKEY	NUMC	20	0	Artificial Primary Key for Specification Tables in BAPIs
3	FOREIGNKEY	☐	ESEFKEY	ESDPKEY	NUMC	20	0	Artificial Foreign Key in Specification Tables for BAPIs
4	FLGPRIMKEY	☐	ESEFLGPKEY	ESDFLAG	CHAR	1	0	Data Record Created with Artificial Primary Key
5	FLGFRGNKEY	☐	ESEFLGFKEY	ESDFLAG	CHAR	1	0	New Parent Record Was Created
6	RECORD_NO	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
7	CHNGSTATUS	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
8	VALID_FROM	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
9	VALID_TO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
10	CHANG_NO	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
11	DEL_IND	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
12	PARK_IND	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
13	CREATED_ON	☐	ESECRDAT	DATUM	DATS	8	0	Created On
14	CREATED_BY	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
15	CHANGD_ON	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
16	CHANGD_BY	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
17	DATAORIGIN	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
18	DATA_PROV	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
19	RECNO_ROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
20	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
21	DANGODREG	☐	THME_LWDG	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation	THM063
22	PACKAGE_MATNR	☐	CBDUE_PACKMAT	MATNR	CHAR	18	0	Packing Material	MARA
23	DATA_ORIGIN	☐	ADGE_DAOR	ADGD_DAOR	CHAR	1	0	Data Origin (Filling and Distribution)
24	PRIO_ALTERN	☐	CBDUE_PRIO_ALTERN	NUMC2	NUMC	2	0	Priority of Release
25	FLG_RELEASED	☐	CBDUE_FLG_RELEASED	X	CHAR	1	0	Product Released for Regulation
26	FLG_TRANS_PERM	☐	CBDUE_FLG_TRANS_PERM	X	CHAR	1	0	Transport Not Permitted
27	FLG_NO_DG	☐	CBDUE_FLG_NO_DG	X	CHAR	1	0	Not Dangerous Goods
28	FLG_LQ	☐	CBDUE_FLG_LQ	X	CHAR	1	0	Limited Quantity
29	FLG_RQ	☐	CBDUE_FLG_RQ	X	CHAR	1	0	Reportable Quantity
30	INSTRUCT_ENCLOSURE	☐	CBDUE_INSTR_ENCL	CBUND_INSTR_ENCL	CHAR	10	0	Actual Instruction for Enclosure	CCUNC115
31	FLG_SGL_PACK	☐	CBDUE_FLG_SGL_PACK	X	CHAR	1	0	Single Packaging
32	PACOD	☐	CBDUE_PACOD	CBUND_PACOD	CHAR	10	0	Actual Packaging Code	CCUNC121
33	QUANT_OUT	☐	CBDUE_QUANT_OUT	HMD_QUAN	QUAN	8	2	Quantity Single/Outer Packaging
34	U_QUANT_OUT	☐	CBDUE_U_QUANT_OUT	MEINS	UNIT	3	0	Unit of Measurement for Quantity Outer Packaging	T006
35	UISO_QUANT_OUT	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	*
36	PACK_NOTE	☐	CBDUE_PACK_NOTE	CBDUD_FIELD_WITH_PHRASE	CHAR	21	0	Note for Release
37	RECN_SUB	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
38	RECN_CLASS	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
39	FLG_CC	☐	CBDUE_FLG_CC	X	CHAR	1	0	Consumer Commodity
40	FLAG_PACKED_PRODUCT	☐	CBDUE_FLG_PACKED	X	CHAR	1	0	Packed Goods
41	DANGGODCAT	☐	CBDUE_TRANSP_TYPE	HMD_MOS	NUMC	3	0	Actual Transport Type	THM003
42	APPROVAL_CODE	☐	CBDUE_APPROVAL_CODE	CHAR72	CHAR	72	0	Full UN Packaging Code
43	SUBID_DG_CLASS	☐	ADGE_SUBID_CLASS	CHAR12	CHAR	12	0	Key (ID) of Dangerous Goods Classification
44	MAT_DAMAGED_CL7	☐	ADGE_MAT_DAMAGED_CL7	ADGD_YES_NO_NOT_DEFINED	CHAR	1	0	Damaged Material (Class 7)
45	MATNR_REPLACE	☐	ADGE_MATNR_REPLACE	MATNR	CHAR	18	0	Material Number of Replacement Material	*
46	MAX_GROSS_WEIGHT	☐	ADGE_MAX_GROSS_WEIGHT	HMD_QUAN	QUAN	8	2	Maximum Gross Mass
47	MAX_GROSS_WGHT_U	☐	ADGE_U_MAX_GROSS_WGHT	MEINS	UNIT	3	0	Unit for Maximum Gross Mass	T006
48	MAX_GROSS_WGHT_ISO	☐	ADGE_I_MAX_GROSS_WGHT	ISOCD_UNIT	CHAR	3	0	Unit of Maximum Gross Mass - ISO	T006I
49	EMV_DYN	☐	EHS_ADGE_EMV	EHS_ADGD_CODE	CHAR	1	0	Electromagnetic Compatibility
50	LTSK_DYN	☐	EHS_ADGE_LTSK	EHS_ADGD_CODE	CHAR	1	0	Air Transport Safety Code
51	EXPL_NET_DYN	☐	ADGE_EXPL_NET_DYN	EHS_ADGD_Q93	QUAN	9	3	Net Explosive Substance Mass
52	EXPL_NET_DYN_U	☐	EHS_ADGE_EXPL_NET_U	MEINS	UNIT	3	0	Unit for Net Explosive Substance Mass	T006
53	EXPL_NET_DYN_ISO	☐	EHS_ADGE_EXPL_NET_U_ISO	ISOCD_UNIT	CHAR	3	0	Unit for Net Explosive Substance Mass - ISO	T006I
54	MAX_ACTIVITY_SGL_DYN	☐	ADGE_MAX_ACT_SGL_DYN	ADGD_QUAN_11_4	QUAN	11	4	Maximum Activity: Item
55	MAX_ACTIVITY_SGL_DYN_U	☐	ADGE_MAX_ACT_SGL_DYN_U	MEINS	UNIT	3	0	Maximum Activity Unit: Item	T006
56	MAX_ACTIVITY_SGL_DYN_ISO	☐	ADGE_MAX_ACT_SGL_DYN_I	ISOCD_UNIT	CHAR	3	0	Unit for Maximum Activity of Item - ISO	T006I
57	ACTIVITY_SGL_DYN_UNLIMIT	☐	ADGE_ACT_SGL_DYN_UNLIMIT	ESDFLAG	CHAR	1	0	Maximum Activity of Item Unlimited
58	MAX_ACTIVITY_PACK_DYN	☐	ADGE_MAX_ACT_PACK_DYN	ADGD_QUAN_11_4	QUAN	11	4	Maximum Activity: Package
59	MAX_ACTIVITY_PACK_DYN_U	☐	ADGE_MAX_ACT_PACK_DYN_U	MEINS	UNIT	3	0	Maximum Activity Unit: Package	T006
60	MAX_ACTIVITY_PACK_DYN_ISO	☐	ADGE_MAX_ACT_PACK_DYN_I	ISOCD_UNIT	CHAR	3	0	Unit for Maximum Activity of Package - ISO	T006I
61	ACTIVITY_PACK_DYN_UNLIMIT	☐	ADGE_ACT_PACK_DYN_UNLIMIT	ESDFLAG	CHAR	1	0	Maximum Activity of Package Unlimited
62	EXCEPT_PACK_OPT	☐	ADGE_EXCEPT_PACK_OPT	ESDFLAG	CHAR	1	0	Excepted Package: Optional
63	DG_USE_CASE	☐	ADGE_DG_USE_CASE	ADGD_DG_USE_CASE	CHAR	1	0	Dangerous Goods: Use
64	PRIO_DYNCL	☐	ADGE_PRIO_DYNCL	NUMC2	NUMC	2	0	Priority of Dynamic Classification
65	EXPL_NET_MAX_DYN	☐	ADGE_MAX_NEM_DYN	EHS_ADGD_Q93	QUAN	9	3	Maximum Net Explosive Substance Mass
66	EXPL_NET_MAX_DYN_U	☐	ADGE_MAX_NEM_DYN_U	MEINS	UNIT	3	0	Unit of Maximum Net Explosive Substance Mass	T006
67	EXPL_NET_MAX_DYN_U_ISO	☐	ADGE_MAX_NEM_DYN_I	ISOCD_UNIT	CHAR	3	0	Unit of Maximum Net Explosive Substance Mass - ISO	T006I
68	FLG_EQ	☐	ADGE_EXC_QUANT	X	CHAR	1	0	Excepted Quantity
69	DGREL_TRANSIND01	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
70	DGREL_TRANSIND02	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
71	DGREL_TRANSIND03	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
72	DGREL_TRANSIND04	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
73	DGREL_TRANSIND05	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
74	DGREL_TRANSIND06	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
75	DGREL_TRANSIND07	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport
76	DGREL_TRANSIND08	☐	ADGE_TRANSPORT_INDICATOR	ADGD_TRANSPORT_INDICATOR	CHAR	10	0	Indicator for Transport

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI1078_PRODUCT_RELEASE	DANGGODCAT	THM003	MOS		1	CN
2	BAPI1078_PRODUCT_RELEASE	DANGODREG	THM063	LWDG		1	CN
3	BAPI1078_PRODUCT_RELEASE	DATAORIGIN	TCG56	SRSID		1	CN
4	BAPI1078_PRODUCT_RELEASE	EXPL_NET_DYN_ISO	T006I	ISOCODE
5	BAPI1078_PRODUCT_RELEASE	EXPL_NET_DYN_U	T006	MSEHI
6	BAPI1078_PRODUCT_RELEASE	EXPL_NET_MAX_DYN_U	T006	MSEHI
7	BAPI1078_PRODUCT_RELEASE	EXPL_NET_MAX_DYN_U_ISO	T006I	ISOCODE
8	BAPI1078_PRODUCT_RELEASE	INSTRUCT_ENCLOSURE	CCUNC115	INSTR_ENCL		1	CN
9	BAPI1078_PRODUCT_RELEASE	MATERIAL	MARA	MATNR		1	CN
10	BAPI1078_PRODUCT_RELEASE	MAX_ACTIVITY_PACK_DYN_ISO	T006I	ISOCODE		1	CN
11	BAPI1078_PRODUCT_RELEASE	MAX_ACTIVITY_PACK_DYN_U	T006	MSEHI
12	BAPI1078_PRODUCT_RELEASE	MAX_ACTIVITY_SGL_DYN_ISO	T006I	ISOCODE		1	CN
13	BAPI1078_PRODUCT_RELEASE	MAX_ACTIVITY_SGL_DYN_U	T006	MSEHI
14	BAPI1078_PRODUCT_RELEASE	MAX_GROSS_WGHT_ISO	T006I	ISOCODE
15	BAPI1078_PRODUCT_RELEASE	MAX_GROSS_WGHT_U	T006	MSEHI
16	BAPI1078_PRODUCT_RELEASE	PACKAGE_MATNR	MARA	MATNR		1	CN
17	BAPI1078_PRODUCT_RELEASE	PACOD	CCUNC121	PACKCODE		1	CN
18	BAPI1078_PRODUCT_RELEASE	U_QUANT_OUT	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	600