I_EHSAMOUNTROOT

CDS View
24 Fields 12 CDS Views

EHS Amount Root

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

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_Amount view from CONSUMPTION Amount Data
C_EHSAmountDEX view_entity from CONSUMPTION EHS Data Amount
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_EHSEnvRptPRTRSubstScenAggrgn view_entity inner COMPOSITE Compl Scenario PRTR data aggregation
I_EHSEnvRptPRTRSubstScenCalc view_entity inner COMPOSITE Compl Scenario PRTR calculation data
I_EHSEnvRptPRTRSubstScenColl view_entity inner COMPOSITE Compl Scenario PRTR data collection
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 7
_EHSAmountSourceType _EHSAmountSourceType 3
_EHSAmountStatus _EHSAmountStatus 2
_UnitText _UnitText 4
EHSAmountDeviationID EHSAmountDeviationID 1
EHSAmountExternalSource EHSAmountExternalSource 2
EHSAmountHasWarning EHSAmountHasWarning 2
EHSAmountIsFaulty EHSAmountIsFaulty 2
EHSAmountIsMissing EHSAmountIsMissing 2
EHSAmountIsNotAvailable EHSAmountIsNotAvailable 2
EHSAmountIsPreliminary EHSAmountIsPreliminary 1
EHSAmountIsReplaced EHSAmountIsReplaced 1
EHSAmountSourceType EHSAmountSourceType 1
EHSAmountSourceUUID EHSAmountSourceUUID 3
EHSAmountStatus EHSAmountStatus 2
EHSAmountUTCDateTime EHSAmountUTCDateTime 7
EHSAmountValue EHSAmountValue 2
EHSAmountValueAsText EHSAmountValueAsText 1
EHSSubjectType EHSSubjectType 3
EHSSubjectUUID EHSSubjectUUID 4
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