EWA_ORDER_HEAD

Transparent Table Application Table

Header Table for Waste Disposal Order

EWA_ORDER_HEAD is an SAP database table in S/4HANA. Header Table for Waste Disposal Order. It contains 61 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_EWA_WasteDisposalOrder view_entity from EXTENSION Waste Disposal Order - Extn
EWA_ALY_P_EOH view from Table EWA_ORDER_HEAD
I_EWA_WasteDisposalOrder view_entity from BASIC Waste disposal orders

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ordernr EORDERNR WD Order
order_date EORDER_DATE Order date
planed_start EWASTART Pld start time
planed_end EWAEND Pld finish time
capab EEWA_CAPAB Capacity No.
route EROUTE Route
waste_type1 WASTE_TYPE Waste
eprem_order_targ EPREMISE_TARGET Targ. No. Prem.
evol_order_targ EVOL_ORDER_TARGET Planned volume
vol_unit_targ VOL_UNIT Volume unit
econt_order_targ ECONT_ORDER_TARGET Plnd no. cont.
etime_order_targ ETIME_ORDER_TARGET Pld duration
meizt_targ MEIZT Trav. times
edist_order_targ EDIST_ORDER_TARGET Pld distance
medst_targ MEDST UoM-Distance
ewght_order_targ EWGHT_ORDER_TARGET Planned weight
weight_unit_targ WEIGHT_UNIT Unit of weight
eorder_status EORDER_STATUS Status
winterlevel EEWA_WINTERLEVEL Wint.Maint.Lev.
diffcult DIFFCULT Note
hobjnr J_OBJNR Object number
wdplant EWAEL_WDPLANTNR WD Facility
waste_werks WERKS_D Plant
waste_lgort LGORTZ Dest: stor.loc.
ordertxt ORDERTEXT Order Text
ordergenarea EWADORDERGENAREA Generation Area
ebeln_sc EBELN Purchasing Doc.
ebelp_sc EBELP Item
mblnr_sc MBLNR Material Doc.
mjahr_sc MJAHR Mat. Doc. Year
vbeln_sc VBELN_VA Sales Document
posnr_sc POSNR_VA Item
actual_date EORDER_ACTDATE ActWDOrderDate
actual_route EROUTE_ACT Route
actual_start EWA_ACTSTART Actual ST
actual_end EWA_ACTEND Actual FT
pause E_PAUSEN Break Length
text1 TEXT30 Text
text2 TEXT30 Text
werk WERKS_D Plant
evol_order_act EVOL_ORDER_ACTUAL Actual volume
vol_unit_act VOL_UNIT Volume unit
econt_order_act ECONT_ORDER_ACTUAL Act. no. cont.
etime_order_act ETIME_ORDER_ACTUAL Actual Duration
edist_order_act EDIST_ORDER_ACTUAL Actual distance
medst_act MEDST UoM-Distance
ewght_order_act EWGHT_ORDER_ACTUAL Actual Weight
weight_unit_act WEIGHT_UNIT Unit of weight
konnr_sc KONNR Agreement
ktpnr_sc KTPNR Agreement Item
bstmg_sc BSTMG PO Quantity
bstme_sc BSTME Order Unit
konnrsls_sc EWASUBCNTRSLSCNTRVBELN Sales Contract
ktpnrsls_sc EWASUBCNTRSLSCNTRPOSNR Sales Contract Item
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete

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 Table for Waste Disposal Order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EWA_ORDER_HEAD (
    MANDT,             -- Client [MANDT]
    ORDERNR,           -- WD Order [EORDERNR]
    ORDER_DATE,        -- Order date [EORDER_DATE]
    PLANED_START,      -- Pld start time [EWASTART]
    PLANED_END,        -- Pld finish time [EWAEND]
    CAPAB,             -- Capacity No. [EEWA_CAPAB]
    ROUTE,             -- Route [EROUTE]
    WASTE_TYPE1,       -- Waste [WASTE_TYPE]
    EPREM_ORDER_TARG,  -- Targ. No. Prem. [EPREMISE_TARGET]
    EVOL_ORDER_TARG,   -- Planned volume [EVOL_ORDER_TARGET]
    VOL_UNIT_TARG,     -- Volume unit [VOL_UNIT]
    ECONT_ORDER_TARG,  -- Plnd no. cont. [ECONT_ORDER_TARGET]
    ETIME_ORDER_TARG,  -- Pld duration [ETIME_ORDER_TARGET]
    MEIZT_TARG,        -- Trav. times [MEIZT]
    EDIST_ORDER_TARG,  -- Pld distance [EDIST_ORDER_TARGET]
    MEDST_TARG,        -- UoM-Distance [MEDST]
    EWGHT_ORDER_TARG,  -- Planned weight [EWGHT_ORDER_TARGET]
    WEIGHT_UNIT_TARG,  -- Unit of weight [WEIGHT_UNIT]
    EORDER_STATUS,     -- Status [EORDER_STATUS]
    WINTERLEVEL,       -- Wint.Maint.Lev. [EEWA_WINTERLEVEL]
    DIFFCULT,          -- Note [DIFFCULT]
    HOBJNR,            -- Object number [J_OBJNR]
    WDPLANT,           -- WD Facility [EWAEL_WDPLANTNR]
    WASTE_WERKS,       -- Plant [WERKS_D]
    WASTE_LGORT,       -- Dest: stor.loc. [LGORTZ]
    ORDERTXT,          -- Order Text [ORDERTEXT]
    ORDERGENAREA,      -- Generation Area [EWADORDERGENAREA]
    EBELN_SC,          -- Purchasing Doc. [EBELN]
    EBELP_SC,          -- Item [EBELP]
    MBLNR_SC,          -- Material Doc. [MBLNR]
    MJAHR_SC,          -- Mat. Doc. Year [MJAHR]
    VBELN_SC,          -- Sales Document [VBELN_VA]
    POSNR_SC,          -- Item [POSNR_VA]
    ACTUAL_DATE,       -- ActWDOrderDate [EORDER_ACTDATE]
    ACTUAL_ROUTE,      -- Route [EROUTE_ACT]
    ACTUAL_START,      -- Actual ST [EWA_ACTSTART]
    ACTUAL_END,        -- Actual FT [EWA_ACTEND]
    PAUSE,             -- Break Length [E_PAUSEN]
    TEXT1,             -- Text [TEXT30]
    TEXT2,             -- Text [TEXT30]
    WERK,              -- Plant [WERKS_D]
    EVOL_ORDER_ACT,    -- Actual volume [EVOL_ORDER_ACTUAL]
    VOL_UNIT_ACT,      -- Volume unit [VOL_UNIT]
    ECONT_ORDER_ACT,   -- Act. no. cont. [ECONT_ORDER_ACTUAL]
    ETIME_ORDER_ACT,   -- Actual Duration [ETIME_ORDER_ACTUAL]
    EDIST_ORDER_ACT,   -- Actual distance [EDIST_ORDER_ACTUAL]
    MEDST_ACT,         -- UoM-Distance [MEDST]
    EWGHT_ORDER_ACT,   -- Actual Weight [EWGHT_ORDER_ACTUAL]
    WEIGHT_UNIT_ACT,   -- Unit of weight [WEIGHT_UNIT]
    KONNR_SC,          -- Agreement [KONNR]
    KTPNR_SC,          -- Agreement Item [KTPNR]
    BSTMG_SC,          -- PO Quantity [BSTMG]
    BSTME_SC,          -- Order Unit [BSTME]
    KONNRSLS_SC,       -- Sales Contract [EWASUBCNTRSLSCNTRVBELN]
    KTPNRSLS_SC,       -- Sales Contract Item [EWASUBCNTRSLSCNTRPOSNR]
    ERDAT,             -- Created On [ERDAT]
    ERNAM,             -- Created By [ERNAM]
    AEDAT,             -- Changed On [AEDAT]
    AENAM,             -- Changed By [AENAM]
    BEGRU,             -- AuthorizGroup [BEGRU]
    LOEVM,             -- Delete [LOEVM]
    PRIMARY KEY (MANDT, ORDERNR)
);