cancel
Showing results for 
Search instead for 
Did you mean: 

API'S TO GET ABAP DATA ELEMENTS FOR INPUT / OUTPUT ATTRIBUTES OF ANY HANA VIEWS EX: SQL VIEWS, ATTRIBUTE VIEWs,CALCULATION VIEWS

Former Member
0 Kudos

Hi Colleagues,

Use case:

ABAP tables related to MDG are replicated to HANA DB through SLT with out changing any table and their fieldnames. 

For Example : A view any view SQL view or  Attribute View or Calculation View is formed based on  four tables which are replicated through the above process.

Lets Say the total fields in the four tables are around 400.

But while creating the view we have selected only 20 attributes as input or output attributes of the view  among these 400 fields.

We renamed the INPUT or OUTPUT attributes of the view generated so that they are user understandable.

Question:

Is there any way where we could read the information through code ,

1) The input or output attributes  are from which table? which field?(among the four tables and 400 fields)

2) Can we get the ABAP dataelement corresponding to this Input or output attribute in any way?

3) Can we get the time stamp information like when the view is created and changed?

4) Is this information stored in any Hana System views  or Tables or any where in Hana Catalog.

5) Are there any  ABaP APi's or SQL Procedures already available which would return us the above information.

Thanks,

Vasavi.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

May be  "SYS"."COLUMNS" help you

Former Member
0 Kudos

Hi,

SYS.COLUMNS couldnt give us the required information as it stores the table and its meta data info.

But not View Metadata info.

Former Member
0 Kudos

Hi,

View metada too, but required full name, like this:

package/view_name

select ,for example, one field from existing view and take this view name for another select

and try

select * from "PUBLIC".view_columns

SYS.COLUMNS  is a view -

SELECT * FROM SYS.TABLE_COLUMNS

UNION ALL

SELECT * FROM SYS.VIEW_COLUMNS