2009 Jul 14 7:16 AM
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.
2009 Jul 14 7:21 AM
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
2009 Jul 14 7:39 AM
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