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
BE6K ver 8.6.2 Client has a user who recently got married.  They changed her account information in Active Directtory to reflect her new last name. At that point CUCM shows her as Delete Pending LDAP Sync Status Inactive CUC shows LDAP User has been [More]
How do I get music already on my laptop into my itunes account library? I have just done the icloud match thinking this would pick them all up, but it hasn't, all it has done is match the 40 songs I already have in my itunes library. I wanted to get [More]
hai bro,. i got some error when i try configure eSSO-PG to OIM 9.1.0.2_BP7 Error : Invoking APICommandInvoker. Invoking command add_credential Populating arguments for command add_credential Returning 'operation' for command add_credential No Executi [More]
Dear All, I am new to this blog. I currently working on BSP's.  My requirement is like below. In my company portal, when an employee logins to portal under ESS tab, he can get Employee verification letter ( PDF ) from his manager under whom he is wor [More]
I know that there is a final push to get FP 9 out the door by the end of the month. However, I have to say that the frequency with which my browsers are crashing, predominantly when the content is Flash Video, is giving me some serious cause for alar [More]
how do I change a pdf to a word doc that I can add to and alterYou can use Adobe ExportPDF to do this.Read other 3 answers [More]
Hi, I'm trying to create a web gis in java for my first time and I'v a lot of problems. Can anyone help me? I searched en example for raster viewer or webgis, in java, with rasters opensource, but nothing, I haven't find it. I search this programs fo [More]
When I move my mouse to the left, my screen shifts to the right and vice versa. It seems like some type of option was selected to expand the viewing field - but I want to turn it off and don't know how. Please help/ THanks.Wow. The power of Google is [More]
Hi there, Recently finished a LSO implementation. Question, it appears the most of the LSO_P* transactions doe not use P_ORGIN to restrict for employees by cost centers? I assume this is more Master Data which we use mostly for main payroll transacti [More]
I have had several battery problems with my ipod mini!! I bought 2 of it and lost 90% of the battery duration capacity within the first three weeks. Apple service is not really willing to help and I do not have the time to write and discuss long with [More]