EWAOBJH
Service Frequency -> Services (History for EWAOBJ)
EWAOBJH is an SAP database table in S/4HANA. Service Frequency -> Services (History for EWAOBJ). It contains 49 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_EWA_ServiceFrequencyItem | view_entity | from | EXTENSION | Service Frequency Item - Extension |
| I_EWA_ServiceFrqcyTimeSlice | view_entity | from | BASIC | Time Slice of Service Frequency |
Fields (49)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | objnr | EOBJNR | Object number | |||
| KEY | laufnr | LAUFNR | Service number | |||
| KEY | bis | BISZEITSCH | Valid to | |||
| ab | ABZEITSCH | Valid From | ||||
| timeframe | TIMEFRAME | Service window | ||||
| datechange | KENNZDATE | Date variable | ||||
| status_serv | STATUS_SERV | Service Status | ||||
| status_cust | STATUS_CUST | Customer Status | ||||
| starttime | START_TIME | Start time | ||||
| stoptime | STOP_TIME | End time | ||||
| cont_count | CONT_COUNT | No. containers | ||||
| route | EROUTE | Route | ||||
| route_sequence | ROUTE_SEQUENCE | Sequence | ||||
| date_concrete | DATE8 | Date | ||||
| product_area | PRODUCT_AREA | Service Area | ||||
| season_from | SEASON_FROM | Season from | ||||
| season_to | SEASON_TO | Season to | ||||
| cal_id | WFCID | Factory Cal. ID | ||||
| sfreplace | E_SF_REPLACE | Indicators | ||||
| service_type | SERVICE_TYPE | Service Type | ||||
| freqzus | E_FREQZUS | ServiceIntGpg | ||||
| waste_flag | WASTE_FLAG | Order Relevance | ||||
| ggvertrag | E_GUARANTOR_CONTRACT | Guarantor Ctr. | ||||
| route_lfnr | ROUTE_LFNR | No. Serv. Route | ||||
| route_bis | ROUTE_BISDAT | To Date ServRte | ||||
| capacitykind | EWA_CAPACITYKIND | Capacity Cat. | ||||
| service_group | SERVICE_GROUP | Serv. Grouping | ||||
| planned_time | PLDTIM | Time Planned | ||||
| planned_durt | SERVDUR | Serv. Duration | ||||
| tsl_guid | WLGUID | Link GUID | ||||
| weekly | WEEKLY | Weekly Interval | ||||
| monthly | MONTHLY | Day in Month | ||||
| month_count | MONTH_COUNT | Mthly Interval | ||||
| day_type | DAY_TYPE | Daily Serv. Type | ||||
| day_flag | DAY_FLAG | Daily | ||||
| week_flag | WEEK_FLAG | Weekly | ||||
| mnth_flag | MNTH_FLAG | Monthly | ||||
| flag1 | KENNZX | Indicators | ||||
| flag2 | KENNZX | Indicators | ||||
| flag3 | KENNZX | Indicators | ||||
| flag4 | KENNZX | Indicators | ||||
| flag5 | KENNZX | Indicators | ||||
| flag6 | KENNZX | Indicators | ||||
| flag7 | KENNZX | Indicators | ||||
| startdate | START | Start Date | ||||
| eweekday | EWEEKDAY | Weekday | ||||
| day_frequency | DYFRQ | Daily Freq | ||||
| dummy_ewa_servicefreqitm_ps | CFD_DUMMY | Dummy |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Service Frequency -> Services (History for EWAOBJ)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EWAOBJH (
MANDT, -- Client [MANDT]
OBJNR, -- Object number [EOBJNR]
LAUFNR, -- Service number [LAUFNR]
BIS, -- Valid to [BISZEITSCH]
AB, -- Valid From [ABZEITSCH]
TIMEFRAME, -- Service window [TIMEFRAME]
DATECHANGE, -- Date variable [KENNZDATE]
STATUS_SERV, -- Service Status [STATUS_SERV]
STATUS_CUST, -- Customer Status [STATUS_CUST]
STARTTIME, -- Start time [START_TIME]
STOPTIME, -- End time [STOP_TIME]
CONT_COUNT, -- No. containers [CONT_COUNT]
ROUTE, -- Route [EROUTE]
ROUTE_SEQUENCE, -- Sequence [ROUTE_SEQUENCE]
DATE_CONCRETE, -- Date [DATE8]
PRODUCT_AREA, -- Service Area [PRODUCT_AREA]
SEASON_FROM, -- Season from [SEASON_FROM]
SEASON_TO, -- Season to [SEASON_TO]
CAL_ID, -- Factory Cal. ID [WFCID]
SFREPLACE, -- Indicators [E_SF_REPLACE]
SERVICE_TYPE, -- Service Type [SERVICE_TYPE]
FREQZUS, -- ServiceIntGpg [E_FREQZUS]
WASTE_FLAG, -- Order Relevance [WASTE_FLAG]
GGVERTRAG, -- Guarantor Ctr. [E_GUARANTOR_CONTRACT]
ROUTE_LFNR, -- No. Serv. Route [ROUTE_LFNR]
ROUTE_BIS, -- To Date ServRte [ROUTE_BISDAT]
CAPACITYKIND, -- Capacity Cat. [EWA_CAPACITYKIND]
SERVICE_GROUP, -- Serv. Grouping [SERVICE_GROUP]
PLANNED_TIME, -- Time Planned [PLDTIM]
PLANNED_DURT, -- Serv. Duration [SERVDUR]
TSL_GUID, -- Link GUID [WLGUID]
WEEKLY, -- Weekly Interval [WEEKLY]
MONTHLY, -- Day in Month [MONTHLY]
MONTH_COUNT, -- Mthly Interval [MONTH_COUNT]
DAY_TYPE, -- Daily Serv. Type [DAY_TYPE]
DAY_FLAG, -- Daily [DAY_FLAG]
WEEK_FLAG, -- Weekly [WEEK_FLAG]
MNTH_FLAG, -- Monthly [MNTH_FLAG]
FLAG1, -- Indicators [KENNZX]
FLAG2, -- Indicators [KENNZX]
FLAG3, -- Indicators [KENNZX]
FLAG4, -- Indicators [KENNZX]
FLAG5, -- Indicators [KENNZX]
FLAG6, -- Indicators [KENNZX]
FLAG7, -- Indicators [KENNZX]
STARTDATE, -- Start Date [START]
EWEEKDAY, -- Weekday [EWEEKDAY]
DAY_FREQUENCY, -- Daily Freq [DYFRQ]
DUMMY_EWA_SERVICEFREQITM_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, OBJNR, LAUFNR, BIS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA