SAP table EWA_EL_WDPLANT (Waste Disposal Facility)
SAP table EWA_EL_WDPLANT has 2 primary key fields being MANDT,WDPLANTNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| WDPLANTNR | Identification of Waste Disposal Facility | CHAR | 20 | 0 | EWAEL_WDPLANTNR | ||
| WDPLANTTYPE | Type of Waste Disposal Facility | CHAR | 20 | 0 | TEWA_EL_004 | EWAEL_WDPLANTTYPE | |
| ISXENOWDPLANT | External Facility | CHAR | 1 | 0 | EWAEL_ISXENOWDPLANT | ||
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | LFA1 | LIFNR | |
| TPLNR | Functional Location | CHAR | 30 | 0 | IFLOT | TPLNR | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| LGORT | Storage location | CHAR | 4 | 0 | T001L | LGORT_D | |
| LGNUM | Warehouse Number / Warehouse Complex | CHAR | 3 | 0 | T300 | LGNUM | |
| PERSA | Personnel Area | CHAR | 4 | 0 | T500P | PERSA | |
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |
| SPART | Division | CHAR | 2 | 0 | TSPA | SPART | |
| KAPNAME | Capacity name | CHAR | 8 | 0 | KAPNAME | ||
| KAPART | Capacity category | CHAR | 3 | 0 | TC26 | KAPART | |
| KUNNR | Customer Number | CHAR | 10 | 0 | KNA1 | KUNNR | |
| DISPOSER_RECN | Unique ID Number | CHAR | 32 | 0 | * | EWAEL_UUID_32 | |
| DISPOSER_ACTN | Unique ID Number | CHAR | 32 | 0 | * | EWAEL_UUID_32 | |
| WEIGHINGFORM | Smart Form for Weighing Form | CHAR | 30 | 0 | EWAEL_WEIGHINGFORM | ||
| PCKGOODSFORM | Smart Form for General Cargo Entry | CHAR | 30 | 0 | EWAEL_PCKGOODSFORM | ||
| DESCRIPTION | Description | CHAR | 254 | 0 | EWAEL_DESCRIPTION | ||
| EKORG | Purchasing organization | CHAR | 4 | 0 | T024E | EKORG | |
| EKGRP | Purchasing Group | CHAR | 3 | 0 | T024 | EKGRP | |
| NRO_WNUMBER | Number Range Object for Facility Related Weighing Number | CHAR | 10 | 0 | TNRO | EWAEL_DNRO_WNUMBER | |
| NRR_WNUMBER | Number Range Interval for Facility Related Weighing Number | CHAR | 2 | 0 | EWAEL_DNRR_WNUMBER | ||
| WDF_OBJNR | Object number | CHAR | 22 | 0 | * | J_OBJNR | |
| HANDLINGTIME | Processing Time | TIMS | 6 | 0 | EWAEL_HANDLINGTIME | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| BEGRU | Authorization Group | CHAR | 4 | 0 | BEGRU | ||
| LOEVM | Deletion Indicator | CHAR | 1 | 0 | LOEVM |
EWA_EL_WDPLANT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EWA_EL_WDPLANT | EKGRP | T024 | Purchasing Groups | EKGRP |
| 1 EWA_EL_WDPLANT | EKORG | T024E | Purchasing Organizations | EKORG |
| 0 EWA_EL_WDPLANT | KAPART | TC26 | Capacity category | MANDT |
| 1 EWA_EL_WDPLANT | KUNNR | KNA1 | General Data in Customer Master | MANDT |
| 1 EWA_EL_WDPLANT | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| 0 EWA_EL_WDPLANT | LGNUM | T300 | WM Warehouse Numbers | MANDT |
| 0 EWA_EL_WDPLANT | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| 1 EWA_EL_WDPLANT | LGORT | T001L | Storage Locations | MANDT |
| 1 EWA_EL_WDPLANT | LGORT | T001L | Storage Locations | WERKS |
| 0 EWA_EL_WDPLANT | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 EWA_EL_WDPLANT | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 EWA_EL_WDPLANT | MANDT | T000 | Clients | MANDT |
| 0 EWA_EL_WDPLANT | NRO_WNUMBER | TNRO | Definition of number range objects | OBJECT |
| 1 EWA_EL_WDPLANT | PERSA | T500P | Personnel Areas | MANDT |
| 1 EWA_EL_WDPLANT | PERSA | T500P | Personnel Areas | PERSA |
| 0 EWA_EL_WDPLANT | SPART | TSPA | Organizational Unit: Sales Divisions | MANDT |
| 0 EWA_EL_WDPLANT | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| 1 EWA_EL_WDPLANT | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| 1 EWA_EL_WDPLANT | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| 0 EWA_EL_WDPLANT | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| 0 EWA_EL_WDPLANT | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| 1 EWA_EL_WDPLANT | WDPLANTTYPE | TEWA_EL_004 | Type of Waste Disposal Facility | MANDT |
| 1 EWA_EL_WDPLANT | WDPLANTTYPE | TEWA_EL_004 | Type of Waste Disposal Facility | WDPLANTTYPE |
| 0 EWA_EL_WDPLANT | WERKS | T001W | Plants/Branches | MANDT |
| 0 EWA_EL_WDPLANT | WERKS | T001W | Plants/Branches | WERKS |