EWAOBJ

Transparent Table Application Table
50 Fields 2 CDS Views

Header Data for Service Frequency

EWAOBJ is an SAP database table in S/4HANA. Header Data for Service Frequency. It contains 50 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_EWA_ServiceFrequency view_entity from EXTENSION Service Frequency - Extension
I_EWA_ServiceFrequency view_entity from BASIC Service Frequency

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY objnr EOBJNR Object number
obknr OBJKNR Object list
obzae OBJZA Object counters
anlage ANLAGE Installation
operand E_OPERAND Operand
oplfdnr OPLFDNR Operand cons.no
servloc SERVLOC Container Loc.
matnr MATNR Material
equnr EQUNR Equipment
adrnr AD_ADDRNUM Address Number
changeable KENNZBEH Replaceable CC
product_area PRODUCT_AREA Service Area
waste_type WASTE_TYPE Waste
beh_type BEH_TYPE Container cat.
route_main EROUTE Route
logiknr LOGIKNR Log. dev. no.
devgrp BEHGRP Container Group
kompfakt E_FAKTOR Waste Bill.Fac.
rob EEWA_CLEAN_ROB Cleaning Object
winterlevel EEWA_WINTERLEVEL Wint.Maint.Lev.
regpolit REGPOLIT Pol.Reg.Str.El.
country LAND1 Country/Reg.
outl_con OUTL_CON Outline Contr.
wdplant EWAEL_WDPLANTNR WD Facility
waste_werks WERKS_D Plant
waste_lgort LGORTZ Dest: stor.loc.
ibase IB_IBASE Installed Base
ehs_partner EHS_PARTNER Partner
intappno EWA_EHS_APPNOINT Waste Approval
appno EWA_EHS_APPNO Waste Appr. No.
recn EWAEHS_GUID Unique ID No.
wakeyide EHS_WAKEYIDE Waste Code
wakeycatlg EHS_WAKEYCATLG Waste Catalog
mnamin EHS_MNAMIN Disp. Quantity
mnamqin EHS_MNAMQIN UoM for Outg.Qt
mnino_uns EWA_EHSWAE_MNINO Disposal Doc.
mnino_bgs EWA_EHSWAE_MNINO Disposal Doc.
transporter EHS_PARTNER Partner
disposer EHS_PARTNER Partner
recnwakey EHS_WAKEY Waste Code
e_werks WERKS_D Plant
e_lgort LGORT_D Location
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
dummy_ewa_servicefreq_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.

-- Header Data for Service Frequency
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EWAOBJ (
    MANDT,                     -- Client [MANDT]
    OBJNR,                     -- Object number [EOBJNR]
    OBKNR,                     -- Object list [OBJKNR]
    OBZAE,                     -- Object counters [OBJZA]
    ANLAGE,                    -- Installation [ANLAGE]
    OPERAND,                   -- Operand [E_OPERAND]
    OPLFDNR,                   -- Operand cons.no [OPLFDNR]
    SERVLOC,                   -- Container Loc. [SERVLOC]
    MATNR,                     -- Material [MATNR]
    EQUNR,                     -- Equipment [EQUNR]
    ADRNR,                     -- Address Number [AD_ADDRNUM]
    CHANGEABLE,                -- Replaceable CC [KENNZBEH]
    PRODUCT_AREA,              -- Service Area [PRODUCT_AREA]
    WASTE_TYPE,                -- Waste [WASTE_TYPE]
    BEH_TYPE,                  -- Container cat. [BEH_TYPE]
    ROUTE_MAIN,                -- Route [EROUTE]
    LOGIKNR,                   -- Log. dev. no. [LOGIKNR]
    DEVGRP,                    -- Container Group [BEHGRP]
    KOMPFAKT,                  -- Waste Bill.Fac. [E_FAKTOR]
    ROB,                       -- Cleaning Object [EEWA_CLEAN_ROB]
    WINTERLEVEL,               -- Wint.Maint.Lev. [EEWA_WINTERLEVEL]
    REGPOLIT,                  -- Pol.Reg.Str.El. [REGPOLIT]
    COUNTRY,                   -- Country/Reg. [LAND1]
    OUTL_CON,                  -- Outline Contr. [OUTL_CON]
    WDPLANT,                   -- WD Facility [EWAEL_WDPLANTNR]
    WASTE_WERKS,               -- Plant [WERKS_D]
    WASTE_LGORT,               -- Dest: stor.loc. [LGORTZ]
    IBASE,                     -- Installed Base [IB_IBASE]
    EHS_PARTNER,               -- Partner [EHS_PARTNER]
    INTAPPNO,                  -- Waste Approval [EWA_EHS_APPNOINT]
    APPNO,                     -- Waste Appr. No. [EWA_EHS_APPNO]
    RECN,                      -- Unique ID No. [EWAEHS_GUID]
    WAKEYIDE,                  -- Waste Code [EHS_WAKEYIDE]
    WAKEYCATLG,                -- Waste Catalog [EHS_WAKEYCATLG]
    MNAMIN,                    -- Disp. Quantity [EHS_MNAMIN]
    MNAMQIN,                   -- UoM for Outg.Qt [EHS_MNAMQIN]
    MNINO_UNS,                 -- Disposal Doc. [EWA_EHSWAE_MNINO]
    MNINO_BGS,                 -- Disposal Doc. [EWA_EHSWAE_MNINO]
    TRANSPORTER,               -- Partner [EHS_PARTNER]
    DISPOSER,                  -- Partner [EHS_PARTNER]
    RECNWAKEY,                 -- Waste Code [EHS_WAKEY]
    E_WERKS,                   -- Plant [WERKS_D]
    E_LGORT,                   -- Location [LGORT_D]
    ERDAT,                     -- Created On [ERDAT]
    ERNAM,                     -- Created By [ERNAM]
    AEDAT,                     -- Changed On [AEDAT]
    AENAM,                     -- Changed By [AENAM]
    BEGRU,                     -- AuthorizGroup [BEGRU]
    LOEVM,                     -- Delete [LOEVM]
    DUMMY_EWA_SERVICEFREQ_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, OBJNR)
);

Learn More