SAP ABAP Table EHSWAT002 (MD (BDT): Waste Generation/Disposal/Transport)

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	TRANSP	Transparent table
Transparent table	EHSWAT002	Table Relationship Diagram
Short Description	MD (BDT): Waste Generation/Disposal/Transport

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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: Structure for general administrative information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	*
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
18	RECNMAST	☐	EHSBE_UUID_32	EHSBD_UUID_32	CHAR	32	0	GUID Number
19	BPWANO	☐	EHSWAE_BPWANO	EHSWAD_BPWANO	CHAR	10	0	Waste Generation, Waste Disposal, or Waste Transport
20	MATNR	☐	EHSWAE_WASTE	MATNR	CHAR	18	0	Material That Represents the Waste	MARA
21	AVRECOK	☐	EHSWAE_AVRECOK	DATUM	DATS	8	0	Date of Last Check
22	AVRECPER	☐	EHSWAE_AVRECPER	TEXT20	CHAR	20	0	Person Who Performed the Last Check
23	CONGD	☐	EHSWAE_CONGD	CHAR25	CHAR	25	0	Contact Person
24	CONPHONE	☐	EHSWAE_CONPHONE	TEXT30	CHAR	30	0	Contact Person: Telephone Number
25	RECNSUBST	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
26	AVREC	☐	EHSWAE_AVREC	X	CHAR	1	0	Avoidability and Recoverability Checked
27	AVOID	☐	EHSWAE_AVOID	CHAR21	CHAR	21	0	Avoidability
28	RECYCLE	☐	EHSWAE_RECYCLE	CHAR21	CHAR	21	0	Recoverability
29	DISPOSE	☐	EHSWAE_DISPOSE	CHAR21	CHAR	21	0	Disposal
30	DUTY	☐	EHSWAE_DUTCAT	EHSWAD_DUTCAT	CHAR	4	0	Condition Type	*
31	DUTYNO	☐	EHSWAE_DUTYNO	TEXT10	CHAR	10	0	Number of Condition Imposed by Authority
32	WERK	☐	EHSWAE_WERKLGORT	WERKS	CHAR	4	0	Plant for Storage Location	T001W
33	WASTORE	☐	EHSWAE_STORE	LGORT	CHAR	4	0	Storage Location for Waste	T001L
34	MATNPART	☐	EHSWAE_MATNRPART	CHAR18	CHAR	18	0	Waste Number at Waste Management Business Partner
35	DISPROC	☐	EHSWAE_APDISPROC	CHAR21	CHAR	21	0	Process Code
36	DIRG	☐	EHSWAE_DIRG	NUMC3	NUMC	3	0	Advanced Notice Period in Days
37	GENRHY	☐	EHSWAE_GENRHY	CHAR21	CHAR	21	0	Rhythm
38	GENFRE	☐	EHSWAE_GENFRE	CHAR21	CHAR	21	0	Frequency
39	GENCYC	☐	EHSWAE_GENCYC	CHAR21	CHAR	21	0	Cycle
40	GEDIMIN	☐	EHSWAE_GEDIMIN	MENG13	QUAN	13	3	Minimum Waste Quantity
41	GEDIMINU	☐	EHSWAE_GEDIMINU	MEINS	UNIT	3	0	Unit of Measure for Minimum Waste Quantity	T006
42	GEDIMAX	☐	EHSWAE_GEDIMAX	MENG13	QUAN	13	3	Maximum Waste Quantity
43	GEDIMAXU	☐	EHSWAE_GEDIMAXU	MEINS	UNIT	3	0	Unit of Measure for Maximum Waste Quantity	T006
44	GEDIAV	☐	EHSWAE_GEDIAV	MENG13	QUAN	13	3	Average Waste Quantity
45	GEDIAVU	☐	EHSWAE_GEDIAVU	MEINS	UNIT	3	0	Unit of Measure for Average Waste Quantity	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHSWAT002	GEDIAVU	T006	MSEHI
2	EHSWAT002	GEDIMAXU	T006	MSEHI
3	EHSWAT002	GEDIMINU	T006	MSEHI
4	EHSWAT002	MANDT	T000	MANDT
5	EHSWAT002	MATNR	MARA	MATNR
6	EHSWAT002	WASTORE	T001L	LGORT
7	EHSWAT002	WERK	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in