SAP ABAP Table EHSWAS_MNBGS (Structure German Waste Manifest)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-WA (Application Component) Waste Management
     ⤷ CBWA (Package) EH&S: Waste Management

Basic Data

Table Category	INTTAB	Structure
Structure	EHSWAS_MNBGS	Table Relationship Diagram
Short Description	Structure German Waste Manifest

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: Structure for Standard Key Fields in Master Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☐	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
4	ACTN	☐	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
5	.INCLUDE	☐				0	0	EHS: Gen. Admin. Information without Engineering Change Mgmt
6	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
7	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
8	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
9	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
10	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
11	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
12	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	*
13	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
14	RECNROOT	☐	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
15	.INCLUDE	☐				0	0	Structure for Waste Manifest Fields
16	INTAPPNO	☐	EHSWAE_APPNOINT	EHSWAD_APPNOINT	CHAR	10	0	Waste Approval
17	APPNO	☐	EHSWAE_APPNO	EHSWAD_APPNO	CHAR	20	0	Waste Approval Number Assigned by Authority
18	APCAT	☐	EHSWAE_APCAT	EHSWAD_APCAT	CHAR	6	0	Waste Approval Type	EHSWAC_APPCAT
19	.INCLUDE	☐				0	0	Waste Manifest: Header Data Structure
20	MNINO	☐	EHSWAE_MNINO	EHSWAD_MNINO	CHAR	15	0	Disposal Document
21	MNCAT	☐	EHSWAE_MNCAT	EHSWAD_MNCAT	CHAR	6	0	Disposal Document Type	EHSWAC_MNCAT
22	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
23	MNSTATUS	☐	EHSWAE_MNSTATUS	EHSWAD_MNSTATUS	CHAR	5	0	Disposal Document Status	*
24	MNNOCTRY	☐	EHSWAE_MNNOCTRY	EHSWAD_MNNOCTRY	CHAR	15	0	Disposal Document Number Assigned by a Transreg. Authority
25	MNNOST	☐	EHSWAE_MNNOST	EHSWAD_MNNOST	CHAR	15	0	Disposal Document Number Assigned by a Regional Authority
26	MNAPNO	☐	EHSWAE_RECNAPP	EHSBD_UUID_32	CHAR	32	0	Waste Approval (RECN)	EHSWAT_APPROVAL
27	MNTXT	☐	EHSWAE_MNTXT	X	CHAR	1	0	Texts Exist
28	MNTXT2	☐	EHSWAE_MNTXT	X	CHAR	1	0	Texts Exist
29	MNTXT3	☐	EHSWAE_MNTXT	X	CHAR	1	0	Texts Exist
30	MNTXT4	☐	EHSWAE_MNTXT	X	CHAR	1	0	Texts Exist
31	MNCONTDG	☐	EHSWAE_NCDG	X	CHAR	1	0	Disposal Document Contains Dangerous Goods
32	MNLWDG1	☐	EHSWAE_LWDG1	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation for Preliminary Leg	THM063
33	MNLWDG2	☐	EHSWAE_LWDG2	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation for Main Leg	THM063
34	MNLWDG3	☐	EHSWAE_LWDG3	HMD_LWDG	CHAR	12	0	Dangerous Goods Regulation for Subsequent Leg	THM063
35	MNDATAUTH	☐	EHSWAE_MNDATAUTH	DATUM	DATS	8	0	Date of Dispatch to Authority
36	MNACC	☐	EHSWAE_MNACC	X	CHAR	1	0	Shipment not Accepted by Disposer
37	MNAMINTO	☐	EHSWAE_MNAMINTO	MENG13	QUAN	13	3	Total Outgoing Quantity
38	MNAMINTOU	☐	EHSWAE_MNAMINTOU	MEINS	UNIT	3	0	Unit of Measure for Total Outgoing Quantity	*
39	MNAMEXTO	☐	EHSWAE_MNAMEXTO	MENG13	QUAN	13	3	Total Quantity Disposed Of
40	MNAMEXTOU	☐	EHSWAE_MNAMEXTOU	MEINS	UNIT	3	0	Unit of Measure for Total Quantity Disposed Of	*
41	MNDATEPRN	☐	EHSWAE_MNDATEPRN	DATUM	DATS	8	0	Print Date for Disposal Document
42	MNARCH	☐	EHSWAE_MNARCH	X	CHAR	1	0	Disposal Document Has Been Stored
43	MNCAN	☐	EHSWAE_MNCAN	X	CHAR	1	0	Disposal Document Has Been Canceled
44	MNDATREC	☐	EHSWAE_MNDATREC	NUMC3	NUMC	3	0	Return Within
45	MNDATEREC	☐	EHSWAE_MNDATEREC	DATUM	DATS	8	0	Date Disposal Document Returned
46	.INCLUDE	☐				0	0	Waste Manifest: Structure - Waste Item Data
47	MNWAPOS	☐	EHSWAE_MNWAPOS	NUMC6	NUMC	6	0	Unique Waste Item Number on Disposal Document
48	MNMATNR	☐	EHSWAE_WASTE	MATNR	CHAR	18	0	Material That Represents the Waste	MARA
49	MNAMIN	☐	EHSWAE_MNAMIN	MENG13	QUAN	13	3	Outgoing quantity
50	MNAMQIN	☐	EHSWAE_MNAMQIN	MEINS	UNIT	3	0	Unit of Measure for Outgoing Quantity	T006
51	MNAMEX	☐	EHSWAE_MNAMEX	MENG13	QUAN	13	3	Waste Quantity Disposed Of
52	MNAMQEX	☐	EHSWAE_MNAMQEX	MEINS	UNIT	3	0	Unit of Measure for Waste Quantity Disposed of and Reported	T006
53	MNPACNUM	☐	EHSWAE_MNPACNUM	NUM3	NUMC	3	0	Number of Packaging Units or Containers
54	MNPACCAT	☐	EHSWAE_MNPACCAT	CHAR21	CHAR	21	0	Packaging or Container Category
55	MNPOSDGTXT	☐	EHSWAE_MNPOSDGTXT	FLAG	CHAR	1	0	Text Available for Dangerous Goods Data
56	MNPOSDGFLG	☐	EHSWAE_MNPOSDGFLG	FLAG	CHAR	1	0	Material is Dangerous Goods
57	ISHEAD	☐	EHSWAE_MNISHEAD	X	CHAR	1	0	Entry Is Not an Item; Relates to Entire Disposal Document
58	MNBAL	☐	EHSWAE_MNBAL	X	CHAR	1	0	Waste Management Business Partner Is Relevant for Waste LCA
59	.INCLUDE	☐				0	0	Waste Manifest: Waste Code
60	RECNMASTER	☐	EHSWAE_MNMASTER	EHSBD_UUID_32	CHAR	32	0	RECN with Reference to Header Record for Disposal Documents
61	MNKEYPOS	☐	EHSWAE_MNKEYPOS	NUM3	NUMC	3	0	Item Number of Waste Code
62	RECNWAKEY	☐	EHSWAE_WAKEY	ESDRECN	NUMC	20	0	Waste Code (RECN)
63	MNWAKEY	☐	EHSWAE_WAKEYIDE	TEXT132	CHAR	132	0	Waste Code
64	MNWAKEYQREL	☐	EHSWAE_MNWAKEYQREL	X	CHAR	1	0	Waste Code Relevant to Quantity Update
65	CREID	☐	EHSWAE_BPID	CHAR15	CHAR	15	0	Number Assigned by Authority for Partner
66	CREDATEDEL	☐	EHSWAE_MNDATEDEL	DATUM	DATS	8	0	Handover Date for Disposal Document
67	CRESIGN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management
68	CARR1ID	☐	EHSWAE_BPID	CHAR15	CHAR	15	0	Number Assigned by Authority for Partner
69	CARR1DATEADO	☐	EHSWAE_MNDATEADO	DATUM	DATS	8	0	Takeover Date for Disposal Document
70	CARR1SIGN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management
71	DISPID	☐	EHSWAE_BPID	CHAR15	CHAR	15	0	Number Assigned by Authority for Partner
72	DISPDATEACC	☐	EHSWAE_MNDATEACC	DATUM	DATS	8	0	Acceptance Date for Disposal Document
73	DISPSIGN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management
74	CARR2ID	☐	EHSWAE_BPID	CHAR15	CHAR	15	0	Number Assigned by Authority for Partner
75	CARR2DATEADO	☐	EHSWAE_MNDATEADO	DATUM	DATS	8	0	Takeover Date for Disposal Document
76	CARR2SIGN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management
77	CARR3ID	☐	EHSWAE_BPID	CHAR15	CHAR	15	0	Number Assigned by Authority for Partner
78	CARR3DATEADO	☐	EHSWAE_MNDATEADO	DATUM	DATS	8	0	Takeover Date for Disposal Document
79	CARR3SIGN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management
80	STORID	☐	EHSWAE_BPID	CHAR15	CHAR	15	0	Number Assigned by Authority for Partner
81	STORDATEADO	☐	EHSWAE_MNDATEADO	DATUM	DATS	8	0	Takeover Date for Disposal Document
82	STORDATEDEL	☐	EHSWAE_MNDATEDEL	DATUM	DATS	8	0	Handover Date for Disposal Document
83	STORSIGN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHSWAS_MNBGS	APCAT	EHSWAC_APPCAT	APC
2	EHSWAS_MNBGS	MANDT	T000	MANDT
3	EHSWAS_MNBGS	MNAMQEX	T006	MSEHI	KEY
4	EHSWAS_MNBGS	MNAMQIN	T006	MSEHI	KEY
5	EHSWAS_MNBGS	MNAPNO	EHSWAT_APPROVAL	MANDT	KEY
6	EHSWAS_MNBGS	MNCAT	EHSWAC_MNCAT	MNCAT
7	EHSWAS_MNBGS	MNLWDG1	THM063	LWDG	KEY
8	EHSWAS_MNBGS	MNLWDG2	THM063	LWDG	KEY
9	EHSWAS_MNBGS	MNLWDG3	THM063	LWDG	KEY
10	EHSWAS_MNBGS	MNMATNR	MARA	MATNR	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in