EWA_ORDER_HEAD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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