Skip to Content

Data Services System tables

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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';

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 11, 2017 at 02:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded