topic Re: Can Data Clusters in DB tables be read using Core Data Services? in Application Development and Automation Discussions

Can Data Clusters in DB tables be read using Core Data Services?

vonglan — Wed, 07 Sep 2022 06:43:51 GMT

Can export/import DB tables (that have RELID and SRTF2 fields) be read using Core Data Services?

former_member303082 — Wed, 14 Sep 2022 10:39:36 GMT

Hi Edo,

Yes, such a transparent table can be used as data source in a CDS View.

Example:

define view ZHM_CDS1_DATA_CLUSTER_TABLE

as select from demo_indx_blob

{
key relid as Relid,
key id as Id,
userid as Userid,
timestamp as Timestamp,
clustd as Clustd
}

Regards, Harish Mehta

vonglan — Thu, 22 Sep 2022 14:11:45 GMT

Hi Harish,

thanks for answering.

Not sure whether you understood what I meant.

For a cluster table like INDX, you read (interpret) the cluster with a statement like

* read the configuration table from DB
    import gendat = lt_gendat from database indx(sd)
                                        id   'GENDAT'.

Is there any equivalent method (e.g. special CDS syntax) for accessing (interpreting) the clustered information via CDS?

Best regards,

Edo

former_member303082 — Thu, 22 Sep 2022 14:29:34 GMT

Hi Edo,

No, there is no corresponding syntax in CDS to execute import/export ABAP statement.

Regards, Harish