Python Forum
SAP Business Objects Query SQL
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SAP Business Objects Query SQL
#1
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!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Appropriate data-structure / design for business-day relations (week/month-wise) sx999 2 2,754 Apr-23-2021, 08:09 AM
Last Post: sx999
  Generating random business cards Inkanus 2 2,152 Dec-08-2020, 09:41 PM
Last Post: buran
  Business formulas more help needed!! jy0013 4 3,376 Aug-29-2017, 12:21 AM
Last Post: jy0013

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020