Sitemap

Amicuk Programming Answers

Question regarding SAP query (SQ01& SQ02)

-0001-11-30   Views:1

Advertisement

Hello everyone, I have been assigned a task of creating a SAP query in SQ01. The report requires me to incorporate a drill down functionality. i.e. when I double click on a material I should be able to see the components of that material. My question

Hello everyone,
I have been assigned a task of creating a SAP query in SQ01. The report requires me to incorporate a drill down functionality.
i.e. when I double click on a material I should be able to see the components of that material.
My question is "Is it possible to incorporate a drill down functionality in a Query through SQ01".
If yes then how.
Please provide me with some documentations or example codes for this.
Regards,
Deepti Jain.

The replay answer
Advertisement
Deepti,
There are 2 ways to get the output  From SAP query.
1.Under record processing :
      if you don't write any code in Start of selection event for output
     (WRITE statements)  we can not have any control on that.
2. Under start of selection event :
     If you write any code in START OF SELECTION event like
     get the data in internal table and loop the internal table
     In loop WRITE statement to display with format and try to use
    Interactive report commands Here. I think it will work fine.

Go to See the other 4 answers

Question in SAP QUERY- SQ01,SQ02,SQ03

Category:DefaultRelease time:-0001-11-30Views:130

Hi SAP QUERY Experts, I have a question for the query. Is it possible using a interface parameter for report-to-report interface? I mean when I double click on one the data record of query, I want to transfer the key information of this record to the[More]

Question regarding SAP query (SQ01& SQ02)

Category:DefaultRelease time:-0001-11-30Views:130

Hello everyone, I have been assigned a task of creating a SAP query in SQ01. The report requires me to incorporate a drill down functionality. i.e. when I double click on a material I should be able to see the components of that material. My question[More]

SAP Query (SQ01/SQ02/SQ3)

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts, I have created query (SQ01/SQ02/SQ03) to display below fields: Hazard Code, Device Location Number, Hazard Code Description, Loc. Created by, Loc. Created on Date. Now in the output list I want to display a summary of all the count of rec[More]

Hide columns for ALV list output in SAP Query SQ01/SQ02

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have a requirement to hide the columns which are empty in sap query SQ01 alv list output. Please let me know this functionality available in Query (SQ01) like normal reports Regards, VenkatHi, We just can't make changes in this case as this[More]

Transport request for SAP Query - SQ01, SQ02, SQ03

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts,   I have a doubt, Whether we can have request for SAP Query which have created from Transaction SQ01.If Yes then How to do that....? Thanks in Advance, Chetan JoshiHi, Use the program RSAQR3TR Thanks NarenRead other 4 answers[More]

SAP Query-SQ01,SQ02,SQ03

Category:DefaultRelease time:-0001-11-30Views:130

Hi, One query was created in Development client and a transaction code was created for the same and transported to QA & production. But I am unable to see the same in QA cliet or production client. this was done by SAP implementation team and i do no[More]

Export & import of query (SQ01/SQ02/SQ03)

Category:DefaultRelease time:-0001-11-30Views:130

Hi, How to export/import SAP Query (SQ01/SQ02/SQ03) without any transport request. waiting for ur reply. Thanks in Advance, PranabHi, If you dont want to create any transport request number then you need to download/upload the query instead of import[More]

Creation of SAP Query in SQ02 with Single Table With Condition

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I want to Create SAP Query in SQ02 using single Table MCHA. ii) I dont want all entries of MCHA Table I mean , I have to apply some Condition on this Table. i.e  Suppose I am having actual data in MCHA table is like this for Material M1. Plan[More]

How to Hide Empty Column In SAP Query (SQ01)

Category:DefaultRelease time:2015-10-11Views:130

I was crated a report in sq01 based on business requirements , but there are some fields without any content , in sq01 if you select one of output fields in the right side of the screen in the left side you can see  "List Fields" T in the list f[More]

SAP Query (SQ01) who and when to use the report

Category:DefaultRelease time:-0001-11-30Views:130

HI Experts!!! Is there somewhere recorded information:  who and when to use the report from SAP Query (SQ01)? ThanksHi This topic doesn´t belong to the Service Marketplace Area. regards MartinRead other 2 answers[More]

Default value for SAP Query - SQ01

Category:DefaultRelease time:-0001-11-30Views:130

Hi Expert, I made a query for GL master data, and I have a selection criteria on chart of account, but since the chart of account for all company codes are same; therefore I would like to default the chart of account selection criteria to my COA. I r[More]

Hot
I imported a csv document into Numbers (3.5.2) and then into Pages 5.5.2 on my ancient laptop running 10.10.3. Numbers supports the multiple page printing of the file but I need to add comments to the table that numbers will not accommodate. I copied [More]
Please help, I cannot get my PSE8 Organiser to open at all. I get an error saying that the organiser has unexpectedly quit. The editor will open as normal but I cant access the Organiser via the Editor either. The only two things that occured prior t [More]
Hi all, I am looking for a sql script or method to find the name of a trace file in udump for trace enabled concurrent programs. I know the trace files show 11i logon (user_name from fnd_user) in the name of the trace file but I am looking for a sql [More]
Hello all, I am running IIS 5.0 on Windows 2000 SP 2. I have Oracle 8.1.5 installed on this machine. I am currently only using the sample database that with Oracle. When I run a simple select statement from the ASP page, I see everything correctly, e [More]
My girlfriend works at a small business running about 10 PCs and a Windows server. Also on the network are about 15 VOIP telephones. She's had an emac on the network working fine for a few months. It was connecting to the server and the to the intern [More]
Using my iPad mini can I copy and paste phone numbers on the calendar from different weekdays?I"m not sure exactly what you mean, but if I go into an appointment and open that appointment. I'll then see an 'edit' button. I tap on that to bring up a p [More]
Hi all,    In our Smart forms we have fixed text of 10-12 lines , within which we have 1-2 variable data (dynamic).    Now for this in the smartform,we were thinking to use Standard text SO10 .   Another query is that if we define std texts in SO10 f [More]
Hi i have two structures and i want to print those values using c#..  I have parent structure which has 5 properties on it and inside that having another child structure which refers 5 properties on it. so now i want to print the values for both stru [More]
Dear Friends, I have encountered a very slow macbook pro performance since last one week. I did run the report EtreCheck EtreCheck version: 2.1.5 (108) Report generated 23 December 2014 20:16:22 GMT Hardware Information: ℹ️     MacBook Pro (13-inch, [More]
I just installed Windows 8.1 and now all of my PDF's are blurry when I open them in reader. Is there a solution that I should know?In case one of your extensions is involved, could you test Netflix in Firefox's Safe Mode? That's a standard diagnostic [More]