SAP table EWAOBJ (Header Data for Service Frequency)
SAP table EWAOBJ has 2 primary key fields being MANDT,OBJNR.
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 | |
| OBJNR | Number of service frequency | CHAR | 10 | 0 | EOBJNR | ||
| OBKNR | Object list number | INT8 | 19 | 0 | * | OBJKNR | |
| OBZAE | Object list counters | INT4 | 10 | 0 | OBJZA | ||
| ANLAGE | Installation | CHAR | 10 | 0 | ANLAGE | ||
| OPERAND | Operand | CHAR | 10 | 0 | E_OPERAND | ||
| OPLFDNR | Consecutive number of an operand | NUMC | 4 | 0 | OPLFDNR | ||
| SERVLOC | Location of Container | CHAR | 30 | 0 | SERVLOC | ||
| MATNR | Material Number | CHAR | 40 | 0 | MATNR | ||
| EQUNR | Equipment Number | CHAR | 18 | 0 | EQUNR | ||
| ADRNR | Address Number | CHAR | 10 | 0 | * | AD_ADDRNUM | |
| CHANGEABLE | Container category can be replaced | CHAR | 1 | 0 | KENNZBEH | ||
| PRODUCT_AREA | Service Area | CHAR | 2 | 0 | * | PRODUCT_AREA | |
| WASTE_TYPE | Waste | CHAR | 40 | 0 | WASTE_TYPE | ||
| BEH_TYPE | Container category | CHAR | 40 | 0 | BEH_TYPE | ||
| ROUTE_MAIN | Planned Waste Disposal Order Route | CHAR | 10 | 0 | EROUTE | ||
| LOGIKNR | Logical device number | NUMC | 18 | 0 | LOGIKNR | ||
| DEVGRP | Container Group | CHAR | 8 | 0 | * | BEHGRP | |
| KOMPFAKT | Waste Billing Factor | CHAR | 12 | 0 | E_FAKTOR | ||
| ROB | Cleaning Object | CHAR | 16 | 0 | EEWA_CLEAN_ROB | ||
| WINTERLEVEL | Winter Maintenance Level | CHAR | 3 | 0 | * | EEWA_WINTERLEVEL | |
| REGPOLIT | Political regional structure element | CHAR | 8 | 0 | REGPOLIT | ||
| COUNTRY | Country/Region Key | CHAR | 3 | 0 | * | LAND1 | |
| OUTL_CON | Outline Contract | CHAR | 10 | 0 | OUTL_CON | ||
| WDPLANT | Identification of Waste Disposal Facility | CHAR | 20 | 0 | EWA_EL_WDPLANT | EWAEL_WDPLANTNR | |
| WASTE_WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| WASTE_LGORT | Destination: Storage location in plant | CHAR | 4 | 0 | T001L | LGORTZ | |
| IBASE | IBase: Number of the Installed Base/IBase | NUMC | 18 | 0 | IB_IBASE | ||
| EHS_PARTNER | Waste Management Business Partner | CHAR | 10 | 0 | EHS_PARTNER | ||
| INTAPPNO | Waste Approval | CHAR | 10 | 0 | EWA_EHS_APPNOINT | ||
| APPNO | Authority-Assigned Waste Approval Number | CHAR | 20 | 0 | EWA_EHS_APPNO | ||
| RECN | Unique ID Number for Integration with EHS | CHAR | 32 | 0 | EWAEHS_GUID | ||
| WAKEYIDE | Waste Code | CHAR | 132 | 0 | EHS_WAKEYIDE | ||
| WAKEYCATLG | Waste Catalog | CHAR | 132 | 0 | EHS_WAKEYCATLG | ||
| MNAMIN | Disposal Quantity (Planning) | QUAN | 13 | 3 | EHS_MNAMIN | ||
| MNAMQIN | Unit of Measure for Outgoing Quantity | UNIT | 3 | 0 | * | EHS_MNAMQIN | |
| MNINO_UNS | Disposal Document | CHAR | 15 | 0 | EWA_EHSWAE_MNINO | ||
| MNINO_BGS | Disposal Document | CHAR | 15 | 0 | EWA_EHSWAE_MNINO | ||
| TRANSPORTER | Waste Management Business Partner | CHAR | 10 | 0 | EHS_PARTNER | ||
| DISPOSER | Waste Management Business Partner | CHAR | 10 | 0 | EHS_PARTNER | ||
| RECNWAKEY | Waste Code (RECN) | NUMC | 20 | 0 | EHS_WAKEY | ||
| E_WERKS | Plant | CHAR | 4 | 0 | WERKS_D | ||
| E_LGORT | Storage location | CHAR | 4 | 0 | * | LGORT_D | |
| 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 |
EWAOBJ foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 EWAOBJ | MANDT | T000 | Clients | MANDT |
| 1 EWAOBJ | WASTE_LGORT | T001L | Storage Locations | MANDT |
| 1 EWAOBJ | WASTE_LGORT | T001L | Storage Locations | WERKS |
| 0 EWAOBJ | WASTE_WERKS | T001W | Plants/Branches | MANDT |
| 0 EWAOBJ | WASTE_WERKS | T001W | Plants/Branches | WERKS |
| 1 EWAOBJ | WDPLANT | EWA_EL_WDPLANT | Waste Disposal Facility | .INCLUDE |
| 1 EWAOBJ | WDPLANT | EWA_EL_WDPLANT | Waste Disposal Facility | MANDT |