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
How do I turn off group message in ios7.0.6Settings > Messages http://support.apple.com/kb/HT5760Read other 2 answers [More]
my son made a really cute movie in iMovie, and saved it as an iTunes file, which put it in the .m4v format. i emailed the .m4v file to all our family and friends ... and the PC users can't open the file. can i do something about this (ie. save it in [More]
HI there xperts! I am having a lot of trouble trying to decipher the multitude of information around for integrating Jdeveloper ADF applications with ebusiness 12.1.3 Essentially, I have created a number of view pages, in my application but now need [More]
My daughters each have their own nicknames for Game Center on their iPod Touches. Each nickname has its own password. My youngest can't remember her password. Since I updated her iOS, I have to log her back into her Game Center account. Is there a wa [More]
The phone is brand new with no data to back up, so i don't know why it's taking so long.  it's been at Step 2 of 6 for over 3 hours.  has anyone else run into this problem?I'm been fighting the same issue for the last 2 days using Windows XP.   It ca [More]
Hello Experts, Document is cleared in vendor line item display without check number for a particular doc. Vendor did not get the payment too. Please give your inputs on this what are the possible scenarios. Thanks in advance. robHi, Please explain yo [More]
Hi I need to clear vendor open invoices using BAPI's for T-code F-44 .I've got through various FM like bapi_acc_document_post and bapi_ar_acc_getbalanceditems but could'nt find solution.Have any boby worked on this tcode to clear vendor accounts usin [More]
Hi, I think it could be very generic question since moving from Flex to HTML5 extension is loosing ability to read write a file in local file system. I'm trying to write a log file within extension space but It throws error as 'TypeError: Illegal con [More]
How do I transfer an album of photos from my macbook air to my iPadiTunes is your friend. iTunes: Syncing photos - Apple SupportRead other 2 answers [More]
I had a few questions and would appreciate any help A.Is there a Document Warehousing feature/module available within the Oracle CRM suite that can link to various documents ( eg word, ppt etc ) for viewing and changing the data? B. Is there a link a [More]