1. Home
  2. Resources
  3. SAP Tables
  4. EHSWAT002 - MD (BDT): Waste Generation/Disposal/Transport

SAP Table EHSWAT002

MD (BDT): Waste Generation/Disposal/Transport

EHSWAT002 (MD (BDT): Waste Generation/Disposal/Transport) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EHSWAT002 to other SAP tables.

Source: EHSWAT002 (MD (BDT): Waste Generation/Disposal/Transport)

EHSWAT002 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
RECN GUID Number EHSBE_UUID_32 CHAR 32 0
ACTN GUID Number EHSBE_UUID_32 CHAR 32 0
VALFR Valid-From Date ESEVALFR DATS 8 0
VALTO Valid-To Date ESEVALTO DATS 8 0
AENNR Change Number ESEAENNR CHAR 12 0
DELFLG Deletion Indicator ESEDELFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
PARKFLG Data Record Is Inactive ESEPARKFLG CHAR 1 0
X Indicator Is Active
NULL Indicator Is Inactive
CRDAT Created On ESECRDAT DATS 8 0
CRNAM Created By ESECRNAM CHAR 12 0
UPDDAT Changed On ESEUPDDAT DATS 8 0
UPDNAM Last Changed By ESEUPDNAM CHAR 12 0
SRSID Source of Data ESESRSID CHAR 10 0
OWNID Data Provider ESEVENDRID CHAR 10 0
RECNROOT GUID Number EHSBE_UUID_32 CHAR 32 0
RECNMAST GUID Number EHSBE_UUID_32 CHAR 32 0
BPWANO Waste Generation, Waste Disposal, or Waste Transport EHSWAE_BPWANO CHAR 10 0
MATNR Material That Represents the Waste EHSWAE_WASTE MARA CHAR 18 0
AVRECOK Date of Last Check EHSWAE_AVRECOK DATS 8 0
AVRECPER Person Who Performed the Last Check EHSWAE_AVRECPER CHAR 20 0
CONGD Contact Person EHSWAE_CONGD CHAR 25 0
CONPHONE Contact Person: Telephone Number EHSWAE_CONPHONE CHAR 30 0
RECNSUBST Sequential Number of Data Record ESERECN NUMC 20 0
AVREC Avoidability and Recoverability Checked EHSWAE_AVREC CHAR 1 0
X Yes
NULL No
AVOID Avoidability EHSWAE_AVOID CHAR 21 0
RECYCLE Recoverability EHSWAE_RECYCLE CHAR 21 0
DISPOSE Disposal EHSWAE_DISPOSE CHAR 21 0
DUTY Condition Type EHSWAE_DUTCAT CHAR 4 0
DUTYNO Number of Condition Imposed by Authority EHSWAE_DUTYNO CHAR 10 0
WERK Plant for Storage Location EHSWAE_WERKLGORT T001W CHAR 4 0
WASTORE Storage Location for Waste EHSWAE_STORE T001L CHAR 4 0
MATNPART Waste Number at Waste Management Business Partner EHSWAE_MATNRPART CHAR 18 0
DISPROC Process Code EHSWAE_APDISPROC CHAR 21 0
DIRG Advanced Notice Period in Days EHSWAE_DIRG NUMC 3 0
GENRHY Rhythm EHSWAE_GENRHY CHAR 21 0
GENFRE Frequency EHSWAE_GENFRE CHAR 21 0
GENCYC Cycle EHSWAE_GENCYC CHAR 21 0
GEDIMIN Minimum Waste Quantity EHSWAE_GEDIMIN QUAN 13 3
GEDIMINU Unit of Measure for Minimum Waste Quantity EHSWAE_GEDIMINU T006 UNIT 3 0
GEDIMAX Maximum Waste Quantity EHSWAE_GEDIMAX QUAN 13 3
GEDIMAXU Unit of Measure for Maximum Waste Quantity EHSWAE_GEDIMAXU T006 UNIT 3 0
GEDIAV Average Waste Quantity EHSWAE_GEDIAV QUAN 13 3
GEDIAVU Unit of Measure for Average Waste Quantity EHSWAE_GEDIAVU T006 UNIT 3 0

EHSWAT002 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EHSWAT002 GEDIAVU EHSWAT002 MANDT T006 Units of Measurement MANDT
EHSWAT002 GEDIAVU EHSWAT002 GEDIAVU T006 Units of Measurement MSEHI
EHSWAT002 GEDIMAXU EHSWAT002 MANDT T006 Units of Measurement MANDT
EHSWAT002 GEDIMAXU EHSWAT002 GEDIMAXU T006 Units of Measurement MSEHI
EHSWAT002 GEDIMINU EHSWAT002 MANDT T006 Units of Measurement MANDT
EHSWAT002 GEDIMINU EHSWAT002 GEDIMINU T006 Units of Measurement MSEHI
EHSWAT002 MANDT EHSWAT002 MANDT T000 Clients MANDT
EHSWAT002 MATNR EHSWAT002 MANDT MARA General Material Data MANDT
EHSWAT002 MATNR EHSWAT002 MATNR MARA General Material Data MATNR
EHSWAT002 WASTORE EHSWAT002 MANDT T001L Storage Locations MANDT
EHSWAT002 WASTORE EHSWAT002 WERK T001L Storage Locations WERKS
EHSWAT002 WASTORE EHSWAT002 WASTORE T001L Storage Locations LGORT
EHSWAT002 WERK EHSWAT002 MANDT T001W Plants/Branches MANDT
EHSWAT002 WERK EHSWAT002 WERK T001W Plants/Branches WERKS