- Home
- Resources
- SAP Tables
- EHSWAT_APPROVAL - MD: Waste Approval
SAP Table EHSWAT_APPROVAL
MD: Waste Approval
EHSWAT_APPROVAL (MD: Waste Approval) 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 EHSWAT_APPROVAL to other SAP tables.
Source: EHSWAT_APPROVAL (MD: Waste Approval)
EHSWAT_APPROVAL 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 |
Possible values
| X |
Indicator Is Active |
| NULL |
Indicator Is Inactive |
|
| PARKFLG |
Data Record Is Inactive |
ESEPARKFLG |
|
CHAR |
|
1 |
0 |
Possible values
| 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 |
|
| INTAPPNO |
Waste Approval |
EHSWAE_APPNOINT |
|
CHAR |
|
10 |
0 |
|
| APPSTATUS |
Processing Status of the Waste Approval |
EHSWAE_APWOS |
EHSWAC_APSTAT
|
CHAR |
|
5 |
0 |
|
| APPNO |
Waste Approval Number Assigned by Authority |
EHSWAE_APPNO |
|
CHAR |
|
20 |
0 |
|
| APC |
Waste Approval Type |
EHSWAE_APCAT |
EHSWAC_APPCAT
|
CHAR |
|
6 |
0 |
|
| APVALFROM |
Valid From |
EHSWAE_APVALFROM |
|
DATS |
|
8 |
0 |
|
| APVALTO |
Valid To |
EHSWAE_APVALTO |
|
DATS |
|
8 |
0 |
|
| APLWDG |
Dangerous Goods Regulation |
THME_LWDG |
THM063
|
CHAR |
|
12 |
0 |
|
| APMNCAT |
Disposal Document Type |
EHSWAE_MNCAT |
EHSWAC_MNCAT
|
CHAR |
|
6 |
0 |
|
EHSWAT_APPROVAL foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| EHSWAT_APPROVAL |
APC |
EHSWAT_APPROVAL |
MANDT |
EHSWAC_APPCAT |
CD: Waste Approval Types |
MANDT |
| EHSWAT_APPROVAL |
APC |
EHSWAT_APPROVAL |
APC |
EHSWAC_APPCAT |
CD: Waste Approval Types |
APC |
| EHSWAT_APPROVAL |
APLWDG |
EHSWAT_APPROVAL |
MANDT |
THM063 |
DG: Dangerous Goods Regulation |
MANDT |
| EHSWAT_APPROVAL |
APLWDG |
EHSWAT_APPROVAL |
APLWDG |
THM063 |
DG: Dangerous Goods Regulation |
LWDG |
| EHSWAT_APPROVAL |
APMNCAT |
EHSWAT_APPROVAL |
MANDT |
EHSWAC_MNCAT |
Disposal Documents: Types |
MANDT |
| EHSWAT_APPROVAL |
APMNCAT |
EHSWAT_APPROVAL |
APMNCAT |
EHSWAC_MNCAT |
Disposal Documents: Types |
MNCAT |
| EHSWAT_APPROVAL |
APPSTATUS |
EHSWAT_APPROVAL |
MANDT |
EHSWAC_APSTAT |
Waste Approval Processing Status |
MANDT |
| EHSWAT_APPROVAL |
APPSTATUS |
EHSWAT_APPROVAL |
APPSTATUS |
EHSWAC_APSTAT |
Waste Approval Processing Status |
APWOS |
| EHSWAT_APPROVAL |
MANDT |
EHSWAT_APPROVAL |
MANDT |
T000 |
Clients |
MANDT |
