EWATDEVLOC

Transparent Table Application Table
24 Fields 1 CDS Views

Provisional Container/Container Location Allocation

EWATDEVLOC is an SAP database table in S/4HANA. Provisional Container/Container Location Allocation. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWA_ProvisionalContAssgmt view_entity from BASIC Provisionally Assigned Container

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ordernr EORDERNR WD Order
KEY laufnr LFNDR Item number
aufnr AUFNR Order
matnr_neu BEHTYPNEU New Cont. Cat.
geraet_neu BEHNEU New container
devgrp_neu DEVGRP Device group
matnr_alt BEHTYPALT Old Cont. Cat.
geraet_alt BEHALT Old container
devgrp DEVGRP Device group
devloc DEVLOC Device Location
einbdat EINBDAT Install. date
ausbdat AUSBDAT Removal date
lvorm LVORM Deletion Ind.
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
pobjnr J_OBJNR Object number
planned_time PLDTIM Time Planned
ibase IB_IBASE Installed Base
logiknr LOGIKNR Log. dev. no.

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.

-- Provisional Container/Container Location Allocation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EWATDEVLOC (
    MANDT,         -- Client [MANDT]
    ORDERNR,       -- WD Order [EORDERNR]
    LAUFNR,        -- Item number [LFNDR]
    AUFNR,         -- Order [AUFNR]
    MATNR_NEU,     -- New Cont. Cat. [BEHTYPNEU]
    GERAET_NEU,    -- New container [BEHNEU]
    DEVGRP_NEU,    -- Device group [DEVGRP]
    MATNR_ALT,     -- Old Cont. Cat. [BEHTYPALT]
    GERAET_ALT,    -- Old container [BEHALT]
    DEVGRP,        -- Device group [DEVGRP]
    DEVLOC,        -- Device Location [DEVLOC]
    EINBDAT,       -- Install. date [EINBDAT]
    AUSBDAT,       -- Removal date [AUSBDAT]
    LVORM,         -- Deletion Ind. [LVORM]
    ERDAT,         -- Created On [ERDAT]
    ERNAM,         -- Created By [ERNAM]
    AEDAT,         -- Changed On [AEDAT]
    AENAM,         -- Changed By [AENAM]
    BEGRU,         -- AuthorizGroup [BEGRU]
    LOEVM,         -- Delete [LOEVM]
    POBJNR,        -- Object number [J_OBJNR]
    PLANNED_TIME,  -- Time Planned [PLDTIM]
    IBASE,         -- Installed Base [IB_IBASE]
    LOGIKNR,       -- Log. dev. no. [LOGIKNR]
    PRIMARY KEY (MANDT, ORDERNR, LAUFNR)
);

Learn More