EHSWAT_APPROVAL SAP table for – MD: Waste Approval

Here we would like to draw your attention to EHSWAT_APPROVAL 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). EHSWAT_APPROVAL is a SAP standard transp table used for storing MD: Waste Approval related data in SAP. It comes under the package CBWA.

SAP EHSWAT_APPROVAL table

Table EHSWAT_APPROVAL technical data

TableEHSWAT_APPROVAL
Data storingMD: Waste Approval
ModuleEHS
Sub ModuleEHS-WA
SAP PackageCBWA
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP EHSWAT_APPROVAL 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 EHSWAT_APPROVAL 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
  • INTAPPNO : Waste Approval
    Its data type is CHAR (Character String) with field length 10
  • APPSTATUS : Processing Status of the Waste Approval
    Its data type is CHAR (Character String) with field length 5
  • APPNO : Waste Approval Number Assigned by Authority
    Its data type is CHAR (Character String) with field length 20
  • APC : Waste Approval Type
    Its data type is CHAR (Character String) with field length 6
  • APVALFROM : Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • APVALTO : Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • APLWDG : Dangerous Goods Regulation
    Its data type is CHAR (Character String) with field length 12
  • APMNCAT : Disposal Document Type
    Its data type is CHAR (Character String) with field length 6