+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: SAP Business Objects Query SQL (/thread-23599.html)
SAP Business Objects Query SQL - AsaithambiThiyagarajan - Jan-08-2020
How to get the SQL query information which is generated by SAP Business Object Report, using Python?
Number of Columns used in SELECT statement.
Number of Columns used in WHERE Condition
Number of Columns used in JOINS condition.
Table name of the column
Input Query:
Select s.sid,s.sname,d.deptname from student s, department d where s.did=d.did ;
Output:
Column name : SELECT WHERE JOIN Table
s.sid yes yes NO Student
s.name yes No No Student
d.deptname yes No No Department
s.did No yes No Student
d.did No yes No Department
Any suggestions/help on this much appreciated. Thank you!