EAML_D_LFE_DATA

Transparent Table Application Table
30 Fields 1 CDS Views

Linear Asset Management - Database

EAML_D_LFE_DATA is an SAP database table in S/4HANA. Linear Asset Management - Database. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_LinearAssetManagementData view from BASIC Linear Asset Management Data

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY obart EAML_OBART Object Type
KEY tabkey EAML_TABKEY Table Key
start_point EAML_START_POINT_SI Start Point SI
end_point EAML_END_POINT_SI End Point SI
linear_length EAML_LINEAR_LENGTH_SI Length SI
linear_unit EAML_LINEAR_UNIT UoM
marker_start EAML_MARKER_START_POINT St.Marker
marker_dist_sta EAML_MARKER_DISTANCE_START_SI Dist.St.M.
marker_end EAML_MARKER_END_POINT End Marker
marker_dist_end EAML_MARKER_DISTANCE_END_SI Dist.E.Mkr
marker_dist_unit EAML_MARKER_DISTANCE_UNIT UoM
lrpid EAML_LRPID Lin.Ref.Pattern
offset1_type EAML_OFFSET1_TYPE_CODE Type Offset 1
offset1_value EAML_OFFSET1_VALUE_SI Offset 1
offset1_unit EAML_OFFSET1_UNIT UoM Offset 1
offset2_type EAML_OFFSET2_TYPE_CODE Type Offset 2
offset2_value EAML_OFFSET2_VALUE_SI Offset 2
offset2_unit EAML_OFFSET2_UNIT UoM Offset 2
start_point_i START_POINT_I Start Point Origin
end_point_i END_POINT_I End Point Origin
linear_length_i LINEAR_LENGTH_I Length Origin
linear_unit_i LINEAR_UNIT_I UoM Origin
lrpid_i LRPID_I LRP Origin
offset1_type_i OFFSET1_TYPE_I Type Offset 1 Orig
offset1_value_i OFFSET1_VALUE_I Offset 1 Origin
offset1_unit_i OFFSET1_UNIT_I UoM Offset 1 Origin
offset2_type_i OFFSET2_TYPE_I Type Offset 2 Orig
offset2_value_i OFFSET2_VALUE_I Offset 2 Origin
offset2_unit_i OFFSET2_UNIT_I UoM Offset 2 Origin

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.

-- Linear Asset Management - Database
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EAML_D_LFE_DATA (
    MANDT,             -- Client [MANDT]
    OBART,             -- Object Type [EAML_OBART]
    TABKEY,            -- Table Key [EAML_TABKEY]
    START_POINT,       -- Start Point SI [EAML_START_POINT_SI]
    END_POINT,         -- End Point SI [EAML_END_POINT_SI]
    LINEAR_LENGTH,     -- Length SI [EAML_LINEAR_LENGTH_SI]
    LINEAR_UNIT,       -- UoM [EAML_LINEAR_UNIT]
    MARKER_START,      -- St.Marker [EAML_MARKER_START_POINT]
    MARKER_DIST_STA,   -- Dist.St.M. [EAML_MARKER_DISTANCE_START_SI]
    MARKER_END,        -- End Marker [EAML_MARKER_END_POINT]
    MARKER_DIST_END,   -- Dist.E.Mkr [EAML_MARKER_DISTANCE_END_SI]
    MARKER_DIST_UNIT,  -- UoM [EAML_MARKER_DISTANCE_UNIT]
    LRPID,             -- Lin.Ref.Pattern [EAML_LRPID]
    OFFSET1_TYPE,      -- Type Offset 1 [EAML_OFFSET1_TYPE_CODE]
    OFFSET1_VALUE,     -- Offset 1 [EAML_OFFSET1_VALUE_SI]
    OFFSET1_UNIT,      -- UoM Offset 1 [EAML_OFFSET1_UNIT]
    OFFSET2_TYPE,      -- Type Offset 2 [EAML_OFFSET2_TYPE_CODE]
    OFFSET2_VALUE,     -- Offset 2 [EAML_OFFSET2_VALUE_SI]
    OFFSET2_UNIT,      -- UoM Offset 2 [EAML_OFFSET2_UNIT]
    START_POINT_I,     -- Start Point Origin [START_POINT_I]
    END_POINT_I,       -- End Point Origin [END_POINT_I]
    LINEAR_LENGTH_I,   -- Length Origin [LINEAR_LENGTH_I]
    LINEAR_UNIT_I,     -- UoM Origin [LINEAR_UNIT_I]
    LRPID_I,           -- LRP Origin [LRPID_I]
    OFFSET1_TYPE_I,    -- Type Offset 1 Orig [OFFSET1_TYPE_I]
    OFFSET1_VALUE_I,   -- Offset 1 Origin [OFFSET1_VALUE_I]
    OFFSET1_UNIT_I,    -- UoM Offset 1 Origin [OFFSET1_UNIT_I]
    OFFSET2_TYPE_I,    -- Type Offset 2 Orig [OFFSET2_TYPE_I]
    OFFSET2_VALUE_I,   -- Offset 2 Origin [OFFSET2_VALUE_I]
    OFFSET2_UNIT_I,    -- UoM Offset 2 Origin [OFFSET2_UNIT_I]
    PRIMARY KEY (MANDT, OBART, TABKEY)
);

Learn More