How can we get details like Created By and Created On for CDS Views, Tables - in Public Cloud

[100361466722]

Hi All,

I am looking for information like Created By or Last Modify By  & Created On or Last modified On for CDS Views and Tables on S/4HANA Public Cloud. Please let me know if we have any APIs to get those details.

Thanks,

Sreedhar R

[Jerry_Lowery]

Hi Sreedhar

Is your question about Custom CDS Views?

If you are talking about standard views, if the field is not already there I don't believe you can add it.

If it is a Custom Business Object, there are administrative fields you can add.

With a Custom CDS View, you might be able to find the associated object (sales order for example) you want to know when changed and add that object cds view as a secondary data source to your custom view.

I thought about calculated field, but it might be updated on every run/access so that may not be what you want.

Thank you

Jerry

[100361466722]

Thank you Jerry for the response. I am asking in the context of ERNAM and ERDAT in on-prem for any specific objects. For example, a particular CDS View is created by whom and when was that created.

[Jerry_Lowery]

Thank you, you can check the View Browser for the various views (for example I_SalesOrder has ERDAT and ERNAM) to see if the fields are already included. If they are not there, I don't think you have the option in public cloud to modify the SAP provided views. If you are a 3SL customer, you can explore Developer Extensibility to see you can create/extend your own views. The extensibility tags in the community may be useful in this case (https://community.sap.com/t5/b-erp-questions/SAP+S%25252F4HANA+Cloud+Extensibility/pd-p/270c4f37-c33...) Thank you Jerry

[100361466722]

Thank you Jerry for the response. I am asking in the context of ERNAM and ERDAT in on-prem for any specific objects. For example, a particular CDS View is created by whom and when was that created.

[100361466722]

Hi Jerry, I am not talking about the fields in side the CDS Views. I am looking for the information Created By and Date of that particular CDS itself. Its like in DD02L we have metadata information right for any Table or View (Tabname, View type etc.,). Similar to that I wanted to find the name of the user and date of any CDS View or Table. Please let me know if I am not clear.

[Jerry_Lowery]

Hi Sreedhar - sorry for the confusion - I understand you are asking about OnPrem - your question was tagged with S/4HANA Cloud so I answered from that regard. Generally, I don't expect SAP exposes the last change/by whom info for standard CDS Views publicly - I believe it would violate employee privacy for one. We maintain that information inside our private code repositories obviously. For important changes such as deprecation of a standard view we would announce that as part of the What's New in the Help. For Custom CDS views, you can find out the last changed date/by whom in the Custom CDS Views app. I hope this helps! Thank you, Jerry

[100361466722]

Thank you Jerry for the clarification. Do you know, how to get those details of custom CDS Views programmatically (any API ?) On another post I was looking for some information, how to get the TADIR entry for any object in public cloud. I saw one CDS View, which seems to be not addressing all objects. Basically we get one object name, we are not able to determine whether that is CDS View or Table. So we want to find the type of that object. Any suggestions on this ? Thank you very much.

[Jerry_Lowery]

Please provide the link to your other question - have you tried the $metadata tag like "and.com/sap/opu/odata/sap/YY1_SALES_REVENUE_CDS/$metadata" this will at least give the field types (string, etc)

[Jerry_Lowery]

In public cloud we don't provide direct access to tables - but you can also check the view browser and it will show some table field names (this would not be programmatic)... should work even for custom cds views i believe

[100361466722]

Here is the link for my other question : https://community.sap.com/t5/enterprise-resource-planning-q-a/how-can-we-get-a-tadir-entry-for-any-g...

[100361466722]

My requirement is to find out that type programmatically. SAP must be exposing any API alternatively if we are not able to access tables directly. I was looking for that. Thanks.

[Jerry_Lowery]

We don't expose the author or last change date for example. However if you expose the CDS View as an API you can get the field properties programmatically using the $metadata OData method as I mentioned above. Have a look also at 35D (https://me.sap.com/processnavigator/SolS/EARL_SolS-013/2402/SolP/35D?region=DE). You can also look into extended the data model with Developer Extensibility (https://help.sap.com/docs/SAP_S4HANA_CLOUD/53b14a3c9f7d4837a9c1f271ee3b24a4/e86da62802f54212b2a255ef...). But I think this will not help you with the Author or Last Changed info for the CDS View itself. If you describe your end goal/business requirement that you are trying to achieve, we may be able to provide some other guidance.

[100361466722]

Thank you for the references. Our business requirement is to show the Created By/Modified By and Creation Time as ATTRIBUTES of CDS Views and Tables which we are loading in our catalog(application), which will also useful for the user to search the objects(CDS or Table) based on Created By or Creation Time.