SAP ABAP Table EHSWAV_002 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure EHSWAV_002   Table Relationship Diagram
Short Description Generated Table for View    
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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 RECN EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
3 ACTN EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
4 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
5 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
6 AENNR ESEAENNR AENNR CHAR 12   0   Change Number  
7 DELFLG ESEDELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
8 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
9 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
10 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
11 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
12 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
13 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data  
14 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider  
15 RECNROOT EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
16 RECNMAST EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
17 BPWANO EHSWAE_BPWANO EHSWAD_BPWANO CHAR 10   0   Waste Generation, Waste Disposal, or Waste Transport  
18 MATNR EHSWAE_WASTE MATNR CHAR 18   0   Material That Represents the Waste MARA
19 AVRECOK EHSWAE_AVRECOK DATUM DATS 8   0   Date of Last Check  
20 AVRECPER EHSWAE_AVRECPER TEXT20 CHAR 20   0   Person Who Performed the Last Check  
21 CONGD EHSWAE_CONGD CHAR25 CHAR 25   0   Contact Person  
22 CONPHONE EHSWAE_CONPHONE TEXT30 CHAR 30   0   Contact Person: Telephone Number  
23 RECNSUBST ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
24 AVREC EHSWAE_AVREC X CHAR 1   0   Avoidability and Recoverability Checked  
25 AVOID EHSWAE_AVOID CHAR21 CHAR 21   0   Avoidability  
26 RECYCLE EHSWAE_RECYCLE CHAR21 CHAR 21   0   Recoverability  
27 DISPOSE EHSWAE_DISPOSE CHAR21 CHAR 21   0   Disposal  
28 DUTY EHSWAE_DUTCAT EHSWAD_DUTCAT CHAR 4   0   Condition Type  
29 DUTYNO EHSWAE_DUTYNO TEXT10 CHAR 10   0   Number of Condition Imposed by Authority  
30 WERK EHSWAE_WERKLGORT WERKS CHAR 4   0   Plant for Storage Location T001W
31 WASTORE EHSWAE_STORE LGORT CHAR 4   0   Storage Location for Waste T001L
32 MATNPART EHSWAE_MATNRPART CHAR18 CHAR 18   0   Waste Number at Waste Management Business Partner  
33 DISPROC EHSWAE_APDISPROC CHAR21 CHAR 21   0   Process Code  
34 DIRG EHSWAE_DIRG NUMC3 NUMC 3   0   Advanced Notice Period in Days  
35 GENRHY EHSWAE_GENRHY CHAR21 CHAR 21   0   Rhythm  
36 GENFRE EHSWAE_GENFRE CHAR21 CHAR 21   0   Frequency  
37 GENCYC EHSWAE_GENCYC CHAR21 CHAR 21   0   Cycle  
38 GEDIMIN EHSWAE_GEDIMIN MENG13 QUAN 13   3   Minimum Waste Quantity  
39 GEDIMINU EHSWAE_GEDIMINU MEINS UNIT 3   0   Unit of Measure for Minimum Waste Quantity T006
40 GEDIMAX EHSWAE_GEDIMAX MENG13 QUAN 13   3   Maximum Waste Quantity  
41 GEDIMAXU EHSWAE_GEDIMAXU MEINS UNIT 3   0   Unit of Measure for Maximum Waste Quantity T006
42 GEDIAV EHSWAE_GEDIAV MENG13 QUAN 13   3   Average Waste Quantity  
43 GEDIAVU EHSWAE_GEDIAVU MEINS UNIT 3   0   Unit of Measure for Average Waste Quantity T006
44 PARTNER EHSWAE_PARTNER EHSWAD_PARTNER CHAR 10   0   Business Partner for Waste Management  
45 RLTYP EHSWAE_WABPROLE BU_RLTYP CHAR 6   0   Business Partner Role in Waste Management TBZ0
46 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
47 MAKTX MAKTX TEXT40 CHAR 40   0   Material description  
48 RECN1 EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
49 ACTN1 EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
50 RECN2 EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
51 ACTN2 EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
52 MATNR1 MATNR MATNR CHAR 18   0   Material Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EHSWAV_002 GEDIAVU T006 MSEHI    
2 EHSWAV_002 GEDIMAXU T006 MSEHI    
3 EHSWAV_002 GEDIMINU T006 MSEHI    
4 EHSWAV_002 MANDT T000 MANDT    
5 EHSWAV_002 MATNR MARA MATNR    
6 EHSWAV_002 RLTYP TBZ0 RLTYP    
7 EHSWAV_002 SPRAS T002 SPRAS KEY 1 CN
8 EHSWAV_002 WASTORE T001L LGORT    
9 EHSWAV_002 WERK T001W WERKS    
History
Last changed by/on SAP  20130529 
SAP Release Created in