DATACOLLECTIONROOTBASIC

DATACOLLECTIONROOTBASIC is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
DataCollectionID DataCollectionID 2
DataCollectionMigrationSource DataCollectionMigrationSource 2
DataCollectionName DataCollectionName,EHSClassifiedDataName 3
DataCollectionTitle DataCollectionTitle,EHSClassifiedDataTitle 3
DataCollectionUUID DataCollectionUUID 2
DataUsagePeriodicity DataUsagePeriodicity 2
EHSAmountExternalSource EHSAmountExternalSource 2
EHSLocationUUID EHSLocationUUID 3
EHSSubjectType EHSSubjectType 2
EHSSubjectUUID EHSSubjectUUID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DATACOLLECTIONROOTBASIC (
    DATACOLLECTIONID,
    DATACOLLECTIONMIGRATIONSOURCE,
    DATACOLLECTIONNAME,
    DATACOLLECTIONTITLE,
    DATACOLLECTIONUUID,
    DATAUSAGEPERIODICITY,
    EHSAMOUNTEXTERNALSOURCE,
    EHSLOCATIONUUID,
    EHSSUBJECTTYPE,
    EHSSUBJECTUUID
);