I_DATACOLLECTIONROOTBASIC

CDS View
9 Fields 6 CDS Views

Data Collection Root

I_DATACOLLECTIONROOTBASIC is a CDS View in S/4HANA. Data Collection Root. It contains 9 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_EHSDataCollectionDEX view_entity from CONSUMPTION EHS Data Collection
I_DataCollectionRoot view from COMPOSITE Data Collection Root
I_EHSAmountExternalSource view from BASIC External Source
I_EHSAmountsForActivity view inner COMPOSITE Amounts for Activity
I_EHSDataSet view from COMPOSITE Data Sets
I_EHSEnvRptPRTRSubstScenColl view_entity inner COMPOSITE Compl Scenario PRTR data collection

Fields (9)

KeyField CDS FieldsUsed in Views
KEY DataCollectionUUID EHSComplianceScenActivityUUID 3
KEY EHSSubjectUUID EHSSubjectUUID 1
_EHSDataPeriod _EHSDataPeriod 1
_EHSLocation _EHSLocation 1
DataCollectionID EHSComplianceScenActivityID 1
DataCollectionName EHSClassifiedDataName,EHSComplianceScenActivityName 2
DataCollectionTitle EHSClassifiedDataTitle,EHSComplianceScenActivityTitle 2
EHSLocationUUID EHSLocationUUID 2
EHSSubjectType EHSSubjectType 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.

-- Data Collection Root
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DATACOLLECTIONROOTBASIC (
    DATACOLLECTIONUUID,
    EHSSUBJECTUUID,
    _EHSDATAPERIOD,
    _EHSLOCATION,
    DATACOLLECTIONID,
    DATACOLLECTIONNAME,
    DATACOLLECTIONTITLE,
    EHSLOCATIONUUID,
    EHSSUBJECTTYPE,
    PRIMARY KEY (DATACOLLECTIONUUID, EHSSUBJECTUUID)
);

Learn More