Skip to Content
0

Data Services System tables

Aug 22, 2017 at 01:37 PM

60

avatar image
Former Member

What Data Services system tables would show the details for the Datastores in a repository?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 24, 2017 at 08:50 AM
0

You Can use the following query to get the list of datastores in your local repository.

select L.NAME as "DATASTORE" from AL_LANG L where OBJECT_TYPE='5';

Share
10 |10000 characters needed characters left characters exceeded
Daya Jha Sep 11, 2017 at 02:19 PM
0

Please refer below query to get BODS metadata details

Following are the List of Query to Fetch the Jobs CountS.NoDetailsQuery1All Project InformationSelect * From ALVW_PROJECTINFO2All Jobs InformationSelect * From ALVW_JOBINFO3All WorkFlow InformtionSelect * From ALVW_WORKFLOWINFO4All DataFlow InformationSelect * From ALVW_DATAFLOWINFO5All DataStore InformationSelect * From ALVW_DATASTOREINFO6All Function InformationSelect * From ALVW_FUNCINFO7All File Format InformationSelect * From ALVW_FILEFORMINFO8All Source Target InformationSelect * From ALVW_MAPPING9All Jobs Execution HistorySelect * From ALVW_HISTORY

Also refer below SCN link

https://archive.sap.com/discussions/thread/3618865

Regards,

Daya Jha

Share
10 |10000 characters needed characters left characters exceeded