SAP Table EHSWAT000
MD (BDT): Master Table for the Waste Management Master Data
EHSWAT000 (MD (BDT): Master Table for the Waste Management Master Data) 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 EHSWAT000 to other SAP tables.
EHSWAT000 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
|
||||||
PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | 0 |
Possible values
|
||||||
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 | |||||||
PARTNER | Business Partner for Waste Management | EHSWAE_PARTNER | CHAR | 10 | 0 | |||||||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | 0 | |||||||
AUGRP | Authorization Group for Waste Management Business Partner | EHSWAE_AUGRP | CHAR | 4 | 0 |
EHSWAT000 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
EHSWAT000 | MANDT | EHSWAT000 | MANDT | T000 | Clients | MANDT |