Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Querying Sys tables - Calculation Views

Soooo....

I've been playing around in the system views and found quite a bit of useful stuff for querying meta-data around base objects.

For Tables, column definitions, constraints etc ...

For Attribute views,  column names, dependencies, joins & join conditions....

Yet for Calculation Views; I'm drawing a blank.

Ok, so I can list them (name, type) from sys.objects, but I've not been able to gain any further info.

Does anyone know (a) why this is (they they are not detailed in sys views ?)  and (b) does the data I'm looking for exist in tables elsewhere ?

Just for illustration, a small example of the views I've been hitting so far ..

M_TABLES
CS_VIEW_COLUMNS
CS_BO_VIEWS
CONSTRAINTS
CS_JOIN_TABLES
CS_JOIN_PATHS
CS_JOIN_CONDITIONS
CS_KEY_FIGURES
OBJECTS
OBJECT_DEPENDENCIES
Tags:
Not what you were looking for? View more on this topic or Ask a question