I_EHSAMOUNTROOT

CDS View
24 Fields 9 CDS Views

EHS Amount Root

I_EHSAMOUNTROOT is a CDS View in S/4HANA. EHS Amount Root. It contains 24 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_Amount view from CONSUMPTION Amount Data
C_EHSMyDataCollectionAmounts view from CONSUMPTION My Data Collection Amounts
I_EHSAmountRootVH view from BASIC Search for Amounts
I_EHSAmountsForActivity view from COMPOSITE Amounts for Activity
I_EHSAmountsForActivity view union COMPOSITE Amounts for Activity
I_EHSEnvRptPRTRSubstAirCalc view_entity inner COMPOSITE Air part of PRTR subs from Scenario Calc
I_EnvrmtAmountsForActivity view from COMPOSITE Amounts for Activities
I_EnvrmtAmountsForActivity view union COMPOSITE Amounts for Activities
P_EHSMYDATACOLPENDINGAMOUNTS view from COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY EHSAmountUUID EHSAmountUUID 4
_EHSAmountSourceType _EHSAmountSourceType 2
_EHSAmountStatus _EHSAmountStatus 2
_UnitText _UnitText 3
EHSAmountDeviationID EHSAmountDeviationID 1
EHSAmountExternalSource EHSAmountExternalSource 1
EHSAmountHasWarning EHSAmountHasWarning 1
EHSAmountIsFaulty EHSAmountIsFaulty 1
EHSAmountIsMissing EHSAmountIsMissing 2
EHSAmountIsNotAvailable EHSAmountIsNotAvailable 2
EHSAmountIsPreliminary EHSAmountIsPreliminary 1
EHSAmountIsReplaced EHSAmountIsReplaced 1
EHSAmountSourceType EHSAmountSourceType 1
EHSAmountSourceUUID EHSAmountSourceUUID 2
EHSAmountStatus EHSAmountStatus 2
EHSAmountUTCDateTime EHSAmountUTCDateTime 4
EHSAmountValue EHSAmountValue 2
EHSAmountValueAsText EHSAmountValueAsText 1
EHSSubjectType EHSSubjectType 2
EHSSubjectUUID EHSSubjectUUID 3
Note EHSAmountRemarkText,Note 2
UnitOfMeasure UnitOfMeasure 1
UnitOfMeasureDimension UnitOfMeasureDimension 1
UnitOfMeasureName UnitOfMeasureName 2

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.

-- EHS Amount Root
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSAMOUNTROOT (
    EHSAMOUNTUUID,
    _EHSAMOUNTSOURCETYPE,
    _EHSAMOUNTSTATUS,
    _UNITTEXT,
    EHSAMOUNTDEVIATIONID,
    EHSAMOUNTEXTERNALSOURCE,
    EHSAMOUNTHASWARNING,
    EHSAMOUNTISFAULTY,
    EHSAMOUNTISMISSING,
    EHSAMOUNTISNOTAVAILABLE,
    EHSAMOUNTISPRELIMINARY,
    EHSAMOUNTISREPLACED,
    EHSAMOUNTSOURCETYPE,
    EHSAMOUNTSOURCEUUID,
    EHSAMOUNTSTATUS,
    EHSAMOUNTUTCDATETIME,
    EHSAMOUNTVALUE,
    EHSAMOUNTVALUEASTEXT,
    EHSSUBJECTTYPE,
    EHSSUBJECTUUID,
    NOTE,
    UNITOFMEASURE,
    UNITOFMEASUREDIMENSION,
    UNITOFMEASURENAME,
    PRIMARY KEY (EHSAMOUNTUUID)
);

Learn More