I_LOCAGGREGATIONROOT

CDS View
8 Fields 4 CDS Views

Location Aggregation Root

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_EHSLocationAggregationDEX view_entity from CONSUMPTION Location Aggregation Data Extraction
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity
I_EHSDataSet view union COMPOSITE Data Sets
I_EnvrmtAmountsForActivity view inner COMPOSITE Amounts for Activities

Fields (8)

KeyField CDS FieldsUsed in Views
KEY LocAggregationUUID EHSClassifiedDataUUID,EHSComplianceScenActivityUUID 2
_EHSDataPeriod _EHSDataPeriod 1
_EHSLocation _EHSLocation 1
DataUsagePeriodicity DataUsagePeriodicity 1
EHSLocationUUID EHSLocationUUID 3
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 (
    LOCAGGREGATIONUUID,
    _EHSDATAPERIOD,
    _EHSLOCATION,
    DATAUSAGEPERIODICITY,
    EHSLOCATIONUUID,
    LOCAGGREGATIONID,
    LOCAGGREGATIONNAME,
    LOCAGGREGATIONTITLE,
    PRIMARY KEY (LOCAGGREGATIONUUID)
);

Learn More