SAP ABAP Table EHSWAS_MNSELECT (Waste Manifest: Structure for Selection)

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_MNSELECT	Table Relationship Diagram
Short Description	Waste Manifest: Structure for Selection

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	MNNOSEL	☐	EHSWAE_MNNOSEL	EHSWAD_MNINO	CHAR	15	0	Disposal Document
2	MNINO	☐	EHSWAE_MNINO	EHSWAD_MNINO	CHAR	15	0	Disposal Document
3	MNCAT	☐	EHSWAE_MNCAT	EHSWAD_MNCAT	CHAR	6	0	Disposal Document Type	EHSWAC_MNCAT
4	MNSTATUS	☐	EHSWAE_MNSTATUS	EHSWAD_MNSTATUS	CHAR	5	0	Disposal Document Status	EHSWAC_MNSTATUS
5	WABPROLE	☐	EHSWAE_WABPROLE	BU_RLTYP	CHAR	6	0	Business Partner Role in Waste Management	TBZ0
6	PARTNER	☐	EHSWAE_PARTNERSEL	EHSWAD_PARTNERSEL	CHAR	15	0	Authority-Assigned or Internal Number for Partner
7	SELDATEDEL	☐	EHSWAE_SELDATEDEL	FLAG	CHAR	1	0	Handover Date for Disposal Document
8	SELDATEADO	☐	EHSWAE_SELDATEADO	FLAG	CHAR	1	0	Takeover Date for Disposal Document
9	SELDATEREC	☐	EHSWAE_SELDATEREC	FLAG	CHAR	1	0	Acceptance Date for Disposal Document
10	SELDATEPRN	☐	EHSWAE_SELDATEPRN	FLAG	CHAR	1	0	Print Date for Disposal Document
11	SELDATEXP	☐	EHSWAE_MNEXPIRE	FLAG	CHAR	1	0	Date Disposal Document Returned
12	SELDATELOW	☐	EHSWAE_SELDATELOW	DATUM	DATS	8	0	Start of Selection Period
13	SELDATEHIGH	☐	EHSWAE_SELDATEHIGH	DATUM	DATS	8	0	End of Selection Period
14	.INCLUDE	☐				0	0	Structure for Waste Manifest Fields
15	INTAPPNO	☐	EHSWAE_APPNOINT	EHSWAD_APPNOINT	CHAR	10	0	Waste Approval
16	APPNO	☐	EHSWAE_APPNO	EHSWAD_APPNO	CHAR	20	0	Waste Approval Number Assigned by Authority
17	APCAT	☐	EHSWAE_APCAT	EHSWAD_APCAT	CHAR	6	0	Waste Approval Type	EHSWAC_APPCAT
18	APPSEL	☐	EHSWAE_APPSEL	EHSWAD_APPNO	CHAR	20	0	Authority-Assigned or Internal Waste Approval No.
19	.INCLUDE	☐				0	0	Waste Manifest: Waste Code
20	RECNMASTER	☐	EHSWAE_MNMASTER	EHSBD_UUID_32	CHAR	32	0	RECN with Reference to Header Record for Disposal Documents
21	MNKEYPOS	☐	EHSWAE_MNKEYPOS	NUM3	NUMC	3	0	Item Number of Waste Code
22	RECNWAKEY	☐	EHSWAE_WAKEY	ESDRECN	NUMC	20	0	Waste Code (RECN)
23	MNWAKEY	☐	EHSWAE_WAKEYIDE	TEXT132	CHAR	132	0	Waste Code
24	MNWAKEYQREL	☐	EHSWAE_MNWAKEYQREL	X	CHAR	1	0	Waste Code Relevant to Quantity Update
25	MNARCH	☐	EHSWAE_MNARCH	X	CHAR	1	0	Disposal Document Has Been Stored
26	MNCAN	☐	EHSWAE_MNCAN	X	CHAR	1	0	Disposal Document Has Been Canceled
27	MNMATNR	☐	EHSWAE_WASTE	MATNR	CHAR	18	0	Material That Represents the Waste	MARA
28	MNSIGNBPMN	☐	EHSWAE_SIGNBPMN	CHAR15	CHAR	15	0	Signatory at Business Partner for Waste Management
29	MNVHSIGN	☐	EHSWAE_MNVHSIGN	CHAR15	CHAR	15	0	License Plate Number
30	MNDRIVER	☐	EHSWAE_MNDRIVER	CHAR35	CHAR	35	0	Driver's Name
31	MNORDNO	☐	EHSWAE_MNORDNO	CHAR20	CHAR	20	0	Order Number for Waste Management Business Partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHSWAS_MNSELECT	APCAT	EHSWAC_APPCAT	APC
2	EHSWAS_MNSELECT	MNCAT	EHSWAC_MNCAT	MNCAT
3	EHSWAS_MNSELECT	MNMATNR	MARA	MATNR	KEY
4	EHSWAS_MNSELECT	MNSTATUS	EHSWAC_MNSTATUS	MNSTATUS
5	EHSWAS_MNSELECT	WABPROLE	TBZ0	RLTYP

History

Last changed by/on	SAP	20130529
SAP Release Created in