Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Cluster tables in SAP QUERY not defined

Former Member

‎2009 Jul 14 7:16 AM

0 Kudos
817

Hi,

I am working on the SAP QUERY in which i am able to create all types of queries from the transparent tables also. But i am facing the problem that when i try to use Clusters or Pooled Tables it does not allow to do this as it is not possible.

How can i create the queries to reterive the data through Clusters or Pooled Tables .

Please provide me guidelines for solving this problem.

2 REPLIES 2

Former Member

‎2009 Jul 14 7:21 AM

0 Kudos
143

Hi Rich,

SAP never allows JOIN to any cluster or POOLED table.

So instead of using these in SQVI, use T.CODE SQ01, SQ02, SQ03, to develop a query, Fn.Area, user group.

In SQ02 you have the option to write a code.

So define fields as per requirement for data required from Cluster tables and Pooled table and write simple queries to fetch data in these fields.

Regds,

Anil

Former Member
In response to Former Member

‎2009 Jul 14 7:39 AM

0 Kudos
143

Hi,

Should i use the concept of internal tables in the code section of Infoset. Is there any small example for it? I tried to search in the forum but it is not there.

Currently, i am writing the code in code section of infoset but the problem is to retrive the data from the cluster tables i.e. CDPOS and it is header table CDHDR(Transparent table) there is no link present between them. If i write the code for it,then there will be no use of creating the infoset.

Please rectify me if i am wrong.

Edited by: ricx .s on Jul 14, 2009 8:52 AM