I_EHSAMOUNTSFORACTIVITY

CDS View
20 Fields 2 CDS Views

Amounts for Activity

I_EHSAMOUNTSFORACTIVITY is a CDS View in S/4HANA. Amounts for Activity. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EHSAmountsCube view from COMPOSITE Environmental Data - Cube
I_EHSAmountSimpleCube view_entity from COMPOSITE Environmental Data Simple - Cube

Fields (20)

KeyField CDS FieldsUsed in Views
KEY EHSAmountUUID EHSAmountUUID 2
DataUsagePeriodicity DataUsagePeriodicity 1
EHSAmountDeviationID EHSAmountDeviationID 1
EHSAmountExternalSource EHSAmountExternalSource 1
EHSAmountIsPreliminary EHSAmountIsPreliminary 1
EHSAmountIsReplaced EHSAmountIsReplaced 1
EHSAmountIssueType EHSAmountIssueType 2
EHSAmountSourceType EHSAmountSourceType 2
EHSAmountStatus EHSAmountStatus 2
EHSAmountUTCDateTime EHSAmountUTCDateTime 2
EHSAmountValue EHSAmountDataMaxQuantity,EHSAmountDataMinQuantity,EHSAmountValue 1
EHSComplianceScenActivityID EHSComplianceScenActivityID 1
EHSComplianceScenActivityName EHSComplianceScenActivityName 1
EHSComplianceScenActivityTitle EHSComplianceScenActivityTitle 1
EHSComplianceScenActivityUUID EHSComplianceScenActivityUUID 1
EHSLocationUUID EHSLocationUUID 2
EHSSubjectType EHSSubjectType 1
EHSSubjectUUID EHSSubjectUUID 1
UnitOfMeasure UnitOfMeasure 1
UnitOfMeasureDimension UnitOfMeasureDimension 1

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.

-- Amounts for Activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSAMOUNTSFORACTIVITY (
    EHSAMOUNTUUID,
    DATAUSAGEPERIODICITY,
    EHSAMOUNTDEVIATIONID,
    EHSAMOUNTEXTERNALSOURCE,
    EHSAMOUNTISPRELIMINARY,
    EHSAMOUNTISREPLACED,
    EHSAMOUNTISSUETYPE,
    EHSAMOUNTSOURCETYPE,
    EHSAMOUNTSTATUS,
    EHSAMOUNTUTCDATETIME,
    EHSAMOUNTVALUE,
    EHSCOMPLIANCESCENACTIVITYID,
    EHSCOMPLIANCESCENACTIVITYNAME,
    EHSCOMPLIANCESCENACTIVITYTITLE,
    EHSCOMPLIANCESCENACTIVITYUUID,
    EHSLOCATIONUUID,
    EHSSUBJECTTYPE,
    EHSSUBJECTUUID,
    UNITOFMEASURE,
    UNITOFMEASUREDIMENSION,
    PRIMARY KEY (EHSAMOUNTUUID)
);

Learn More