The EWATSPCMPNTSF table in SAP ERP or S/4HANA stores Service Frequency data. There are total 22 fields in EWATSPCMPNTSF table. The Service Frequency table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EWATSPCMPNTSF table. It is in IS-U: Waste and Recycling Service Product Generator (EEWA_SPG) ABAP package and is part of the Master Data (IS-U-WA-MD) module.
SAP EWATSPCMPNTSF Table Fields
Following is the list of fields that are available in SAP EWATSPCMPNTSF table. The primary key fields of the table are MANDT (Client), COMPONENT (Service Product Component), SERVICEFREQUENCY (Service Product Component Service Frequency).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| COMPONENT | Service Product Component | EWADSPCOMPONENT | EWATSPCOMPONENT | CHAR (20) |
| SERVICEFREQUENCY | Service Product Component Service Frequency | EWADSPSERVICEFREQUENCY | CHAR (20) | |
| SERVICETYPE | Service Type | SERVICE_TYPE | TESERVICETYPE | CHAR (2) |
| SERVICECAT | Service Category | SERVICE_CAT | CHAR (2) | |
| WEEKLY | Weekly Service Interval | WEEKLY | CHAR (2) | |
| MONTHLY | Day in Month for Service | MONTHLY | CHAR (2) | |
| MONTH_COUNT | Frequency of Service in Months | MONTH_COUNT | CHAR (2) | |
| DAY_TYPE | Type of Daily Service (Single/Periodic) | DAY_TYPE | CHAR (1) | |
| DAY_FLAG | Service for service frequency occurs daily | DAY_FLAG | CHAR (1) | |
| WEEK_FLAG | Service for service frequency occurs weekly | WEEK_FLAG | CHAR (1) | |
| MNTH_FLAG | Service for service frequency occurs monthly | MNTH_FLAG | CHAR (1) | |
| FLAG1 | Indicators | KENNZX | CHAR (1) | |
| FLAG2 | Indicators | KENNZX | CHAR (1) | |
| FLAG3 | Indicators | KENNZX | CHAR (1) | |
| FLAG4 | Indicators | KENNZX | CHAR (1) | |
| FLAG5 | Indicators | KENNZX | CHAR (1) | |
| FLAG6 | Indicators | KENNZX | CHAR (1) | |
| FLAG7 | Indicators | KENNZX | CHAR (1) | |
| STARTDATE | Date on Which Waste Disposal Service Begins | START | DATS (8) | |
| EWEEKDAY | Weekday of Service | EWEEKDAY | NUMC (1) | |
| DAY_FREQUENCY | Daily Frequency | DYFRQ | NUMC (3) |
