EHSWAT_APPWAKEY SAP (MD: Waste Permit Waste Code) Table details
Dictionary Type: Table
Description: MD: Waste Permit Waste Code
Description: MD: Waste Permit Waste Code
ABAP Code to SELECT data from EHSWAT_APPWAKEY
Related tables to EHSWAT_APPWAKEY
Access table EHSWAT_APPWAKEY
Related tables to EHSWAT_APPWAKEY
Access table EHSWAT_APPWAKEY
Table field list including key, data, relationships and ABAP select examples
EHSWAT_APPWAKEY is a standard SAP Table which is used to store MD: Waste Permit Waste Code data and is available within R/3 SAP systems depending on the version and release level.
The EHSWAT_APPWAKEY table consists of various fields, each holding specific information or linking keys about MD: Waste Permit Waste Code data available in SAP. These include MANDT (Client), RECN (GUID Number), ACTN (GUID Number), VALFR (Valid-From Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP EHSWAT_APPWAKEY table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RECN | GUID Number | EHSBE_UUID_32 | CHAR | 32 | EHSBD_UUID_32 | ||||
ACTN | GUID Number | EHSBE_UUID_32 | CHAR | 32 | EHSBD_UUID_32 | ||||
VALFR | Valid-From Date | ESEVALFR | DATS | 8 | DATUM | ||||
VALTO | Valid-To Date | ESEVALTO | DATS | 8 | DATUM | ||||
AENNR | Change Number | ESEAENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
DELFLG | Deletion Indicator | ESEDELFLG | CHAR | 1 | ESDFLAG | ||||
PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | ESDFLAG | ||||
CRDAT | Created On | ESECRDAT | DATS | 8 | DATUM | ||||
CRNAM | Created By | ESECRNAM | CHAR | 12 | USNAM | ||||
UPDDAT | Changed On | ESEUPDDAT | DATS | 8 | DATUM | ||||
UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 12 | USNAM | ||||
SRSID | Source of Data | ESESRSID | CHAR | 10 | Assigned to domain | ESDSRSID | |||
OWNID | Data Provider | ESEVENDRID | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ||
RECNROOT | GUID Number | EHSBE_UUID_32 | CHAR | 32 | EHSBD_UUID_32 | ||||
RECNWAKEY | Waste Code (RECN) | EHSWAE_WAKEY | NUMC | 20 | ALPHA | ESDRECN | |||
APWAKEY | Waste Code | EHSWAE_WAKEYIDE_SHORT | CHAR | 30 | TEXT30 | ||||
APCKQUAN | Alert Quantity | EHSWAE_APCKQUAN | QUAN | 13(3) | MENG13 | ||||
APCKU | Unit of Measure for Alert Quantity | EHSWAE_APCKU | UNIT | 3 | T006 | CUNIT | MEINS | ||
APDISQUAN | Quantity Disposed Of | EHSWAE_APDISQUAN | QUAN | 13(3) | MENG13 | ||||
APDISU | Unit of Measure for Quantity Disposed Of | EHSWAE_DISU | UNIT | 3 | T006 | CUNIT | MEINS | ||
APPQUAN | Total Licensed Quantity for the Approval and Waste Code | EHSWAE_APPQUAN | QUAN | 13(3) | MENG13 | ||||
APPQUANU | Unit of Measure for Licensed Quantity | EHSWAE_PERU | UNIT | 3 | T006 | CUNIT | MEINS | ||
APDISCAT | Type of disposal | EHSWAE_APDISCAT | CHAR | 21 | CHAR21 | ||||
APDISMETH | Disposal Method | EHSWAE_APDISMETH | CHAR | 21 | CHAR21 | ||||
APDISPROC | Process Code | EHSWAE_APDISPROC | CHAR | 21 | CHAR21 | ||||
APFRE | Frequency of Removal | EHSWAE_APFRE | CHAR | 21 | CHAR21 | ||||
RECNSUBST | Specification (RECN) with Declaration Analysis Data | EHSWAE_RECNAPSUBST | NUMC | 20 | ALPHA | ESDRECN | |||
APPACCAT | Packaging Category | EHSWAE_APACCAT | CHAR | 21 | CHAR21 | ||||
APPDISPREAS | Reason for Disposal of Waste | EHSWAE_DISPREAS | CHAR | 21 | CHAR21 | ||||
APWAKEYORD | Sort Sequence and Default Setting for Waste Code | EHSWAE_APWAKEYORD | NUMC | 4 | NUMC4 |
Key field | Non-key field |
How do I retrieve data from SAP table EHSWAT_APPWAKEY using ABAP code
The following ABAP code Example will allow you to do a basic selection on EHSWAT_APPWAKEY to SELECT all data from the tableDATA: WA_EHSWAT_APPWAKEY TYPE EHSWAT_APPWAKEY.
SELECT SINGLE *
FROM EHSWAT_APPWAKEY
INTO CORRESPONDING FIELDS OF WA_EHSWAT_APPWAKEY
WHERE...
How to access SAP table EHSWAT_APPWAKEY
Within an ECC or HANA version of SAP you can also view further information about EHSWAT_APPWAKEY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects