EWAELOCSD_NEW

Transparent Table Application Table
19 Fields 2 CDS Views

Allocation Table: Container Loc.Data <-> Sales Document Item

EWAELOCSD_NEW is an SAP database table in S/4HANA. Allocation Table: Container Loc.Data <-> Sales Document Item. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
EWA_ALY_I_CRV view inner
I_EWA_ContLocSalesContrAssgmt view_entity from BASIC Container allocation data

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY obknr EWAOBJKNR Object List
KEY obzae EWAOBJZA Object Counter
KEY bis BISZEITSCH Valid to
KEY timto TIMETO End time
ab ABZEITSCH Valid From
timfr TIMEFROM Start time
vbeln EWAVBELN_VA Sales Document
posnr EWAPOSNR_VA Item
equnr EQUNR Equipment
matnr MATNR Material
iloan ILOAN Loc/AccAssmt
servloc SERVLOC Container Loc.
ibase EWAIB_IBASE Installation
kunnr KUNNR Customer
cont_count CONT_COUNT No. containers
servfreqnr EOBJNR Object number
contshare CONTSHARE Container Port.
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.

-- Allocation Table: Container Loc.Data <-> Sales Document Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EWAELOCSD_NEW (
    MANDT,       -- Client [MANDT]
    OBKNR,       -- Object List [EWAOBJKNR]
    OBZAE,       -- Object Counter [EWAOBJZA]
    BIS,         -- Valid to [BISZEITSCH]
    TIMTO,       -- End time [TIMETO]
    AB,          -- Valid From [ABZEITSCH]
    TIMFR,       -- Start time [TIMEFROM]
    VBELN,       -- Sales Document [EWAVBELN_VA]
    POSNR,       -- Item [EWAPOSNR_VA]
    EQUNR,       -- Equipment [EQUNR]
    MATNR,       -- Material [MATNR]
    ILOAN,       -- Loc/AccAssmt [ILOAN]
    SERVLOC,     -- Container Loc. [SERVLOC]
    IBASE,       -- Installation [EWAIB_IBASE]
    KUNNR,       -- Customer [KUNNR]
    CONT_COUNT,  -- No. containers [CONT_COUNT]
    SERVFREQNR,  -- Object number [EOBJNR]
    CONTSHARE,   -- Container Port. [CONTSHARE]
    LOGIKNR,     -- Log. dev. no. [LOGIKNR]
    PRIMARY KEY (MANDT, OBKNR, OBZAE, BIS, TIMTO)
);

Learn More