I_LOCAGGREGATIONROOT

CDS View
10 Fields 5 CDS Views

Location Aggregation Root

I_LOCAGGREGATIONROOT is a CDS View in S/4HANA. Location Aggregation Root. It contains 10 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_EHSLocationAggregationDEX view_entity from CONSUMPTION EHS Location Aggregation
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity
I_EHSDataSet view union COMPOSITE Data Sets
I_EHSEnvRptPRTRSubstScenAggrgn view_entity inner COMPOSITE Compl Scenario PRTR data aggregation
I_EnvrmtAmountsForActivity view inner COMPOSITE Amounts for Activities

Fields (10)

KeyField CDS FieldsUsed in Views
KEY EHSSubjectUUID EHSSubjectUUID 1
KEY LocAggregationUUID EHSClassifiedDataUUID,EHSComplianceScenActivityUUID 3
_EHSDataPeriod _EHSDataPeriod 1
_EHSLocation _EHSLocation 1
DataUsagePeriodicity DataUsagePeriodicity 1
EHSLocationUUID EHSLocationUUID 3
EHSSubjectType EHSSubjectType 1
LocAggregationID EHSComplianceScenActivityID 1
LocAggregationName EHSClassifiedDataName,EHSComplianceScenActivityName 2
LocAggregationTitle EHSClassifiedDataTitle,EHSComplianceScenActivityTitle 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.

-- Location Aggregation Root
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LOCAGGREGATIONROOT (
    EHSSUBJECTUUID,
    LOCAGGREGATIONUUID,
    _EHSDATAPERIOD,
    _EHSLOCATION,
    DATAUSAGEPERIODICITY,
    EHSLOCATIONUUID,
    EHSSUBJECTTYPE,
    LOCAGGREGATIONID,
    LOCAGGREGATIONNAME,
    LOCAGGREGATIONTITLE,
    PRIMARY KEY (EHSSUBJECTUUID, LOCAGGREGATIONUUID)
);

Learn More