EHSWAT002 SAP table for – MD (BDT): Waste Generation/Disposal/Transport

Here we would like to draw your attention to EHSWAT002 table in SAP. As we know it is being mainly used with the SAP EHS-WA (Waste Management in EHS) component which is coming under EHS module (Environment, Health and Safety). EHSWAT002 is a SAP standard transp table used for storing MD (BDT): Waste Generation/Disposal/Transport related data in SAP. It comes under the package CBWA.

SAP EHSWAT002 table

Table EHSWAT002 technical data

TableEHSWAT002
Data storingMD (BDT): Waste Generation/Disposal/Transport
ModuleEHS
Sub ModuleEHS-WA
SAP PackageCBWA
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP EHSWAT002 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in EHSWAT002 table.

  • .INCLUDE : EHS: Structure for Standard Key Fields in Master Data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : GUID Number
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ACTN : GUID Number
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : EHS: Structure for general administrative information
  • VALFR : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : Valid-To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : GUID Number
    Its data type is CHAR (Character String) with field length 32
  • RECNMAST : GUID Number
    Its data type is CHAR (Character String) with field length 32
  • BPWANO : Waste Generation, Waste Disposal, or Waste Transport
    Its data type is CHAR (Character String) with field length 10
  • MATNR : Material That Represents the Waste
    Its data type is CHAR (Character String) with field length 18
  • AVRECOK : Date of Last Check
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AVRECPER : Person Who Performed the Last Check
    Its data type is CHAR (Character String) with field length 20
  • CONGD : Contact Person
    Its data type is CHAR (Character String) with field length 25
  • CONPHONE : Contact Person: Telephone Number
    Its data type is CHAR (Character String) with field length 30
  • RECNSUBST : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • AVREC : Avoidability and Recoverability Checked
    Its data type is CHAR (Character String) with field length 1
  • AVOID : Avoidability
    Its data type is CHAR (Character String) with field length 21
  • RECYCLE : Recoverability
    Its data type is CHAR (Character String) with field length 21
  • DISPOSE : Disposal
    Its data type is CHAR (Character String) with field length 21
  • DUTY : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • DUTYNO : Number of Condition Imposed by Authority
    Its data type is CHAR (Character String) with field length 10
  • WERK : Plant for Storage Location
    Its data type is CHAR (Character String) with field length 4
  • WASTORE : Storage Location for Waste
    Its data type is CHAR (Character String) with field length 4
  • MATNPART : Waste Number at Waste Management Business Partner
    Its data type is CHAR (Character String) with field length 18
  • DISPROC : Process Code
    Its data type is CHAR (Character String) with field length 21
  • DIRG : Advanced Notice Period in Days
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • GENRHY : Rhythm
    Its data type is CHAR (Character String) with field length 21
  • GENFRE : Frequency
    Its data type is CHAR (Character String) with field length 21
  • GENCYC : Cycle
    Its data type is CHAR (Character String) with field length 21
  • GEDIMIN : Minimum Waste Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • GEDIMINU : Unit of Measure for Minimum Waste Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GEDIMAX : Maximum Waste Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • GEDIMAXU : Unit of Measure for Maximum Waste Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GEDIAV : Average Waste Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • GEDIAVU : Unit of Measure for Average Waste Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3