Stack Overflow
Stack Overflow

Questions tagged [sap-query]

Questions related to "SAP Query" which consists of subareas such as "Queries", "InfoSets", "InfoSet Queries", "User Groups", "Translation/Query", and "QuickViewer".

31 questions
1
vote
2 answers

SAP JCo 3 RFC RSAQ_REMOTE_QUERY_CALL - unexpected results

We’re using JCo 3.0 to connect to RFCs and read data from SAP R/3. We use one RFC RFC_READ_TABLE often and use a second custom RFC to read employee information. My questions revolve around a third RFC RSAQ_REMOTE_QUERY_CALL. I'm calling an ad-hoc…
niccolo
  • 29
  • 1
  • 3
0
votes
1 answer

Providing TCode to SAP SQ01 query-generated program

There is a client-specific query (SQ01) in all three clients, DEVELOPMENT, QUALITY and PRODUCTION. The query is exactly same in QUALITY and PRODUCTION clients. But there are some changes in DEVELOPMENT client. I have to create a new transaction code…
Nitesh Bakshi
  • 1
  • 3
0
votes
2 answers

Existing column considered non-existent during Select

I need to select a field from knb1 where kunnr from knb1 is equal to kunnr in likp and assign it to field KART_KLIENT1. For a reason I can't warp my head around, it says that neither table knb1 nor likp have a column kunnr... Which both of them…
Bartosz_76
  • 77
  • 1
  • 12
0
votes
3 answers

ABAP SQ01 Error in generated report (Selection screen is too large) Message No. AQ366

I am getting below error while run the query with SQ01 I don't know where the problem came from. I just have 3 fields in selection And just two fields in output Below my SELECTION-SCREEN code in the infoset SELECTION-SCREEN: BEGIN OF BLOCK…
hammerman
  • 23
  • 1
  • 5
0
votes
1 answer

Selecting the lowest value of a character string in a grouped data

I'm trying to create a SAP Query (SQ02). My dataset is grouped based on a value of a field (example below). I need to select and output the lowest value of another field, but its a mixed character - Letter + a number, I need the lowest number. I…
DDoze
  • 53
  • 2
  • 9
0
votes
1 answer

Retreiving ship-to-party country SAP QuickViewer

I've created a QuickView, where I enter Sales Document data as search criteria. Selection fields are VBAP-VBELN, VBAP-POSNR, VBAP-MATNR and VBAP-KWMENG As the Sales Document Item data. Furthermore I retrieve the Schedule line date…
Havard Kleven
  • 422
  • 6
  • 19
0
votes
0 answers

How to output duplicate row count into a custom field in SAP query

Our company runs on SAP ERP 6.0, SAP_BASIS 702, SAP_ABA 702 (2005), just something to keep in mind in regards to the code syntax. I have a table LTAP, I want to create a query based on this table, which would produce "N" as number of picks that…
DDoze
  • 53
  • 2
  • 9
0
votes
1 answer

How to count duplicate rows in a query in efficient way?

I am creating a report in SAP SQ01/SQ02 whose purpose is to show the number of times a product was picked in the specified time frame. The data is mainly sourced from table LTAP. I just need to be able to count the number of rows Material XYZ is…
DDoze
  • 53
  • 2
  • 9
0
votes
0 answers

SAP infoset query modify table after selection

Is it possibly to modify certain rows of the output table in a SAP infoset query? If yes, how? I already tried writing some code for that in the coding tab in the infoset (at the end of selection - after the list) but I was not able to reference the…
Suimon
  • 271
  • 1
  • 6
  • 15
0
votes
2 answers

Concatenating strings in SAP Query

I'm creating a BAPI for SAP R/3. The equivalent in MSSQL of what I'm trying to write is this: select bkpf.BELNR, bkpf.BUKRS, bkpf.GJAHR, bkpf.AWKEY into #tab from bkpf where exists ( select 1 from #n_tab n where…
manoftheyear
  • 374
  • 1
  • 6
  • 18
0
votes
0 answers

SAP infoset table connection

I'm new in SAP and I have a question. I have an infoset that has 3 tables that contain customer information and shopping made. Currently I get a report that contains the details about the customer and there is a column that indicates whether the…
user1595351
  • 31
  • 4
0
votes
1 answer

Fetch rows on joined ESLL, EKPO, EKKO from selection screen input

What I would like to achieve is a join between tables ESLL, EKPO, EKKO via SAP Query. Specifically these are the steps I would like to achieve: in the selection parameter every time I will enter the query I will give a different value for…
hammerman
  • 23
  • 1
  • 5
0
votes
3 answers

How can I get a list of SQVI queries by User ID?

Just as some background, I intend to write an Excel add-in with .NET that can execute queries from an SAP system. Thus, I'm looking for a list of function modules for SAP's SQVI transaction. I can't seem to find much information about them; the few…
Peder Rice
  • 1,764
  • 3
  • 28
  • 51
0
votes
1 answer

Allow an end user to populate a field along with the selection fields

I would like to add 1 input filed into the Infoset/Query in SAP. Basically I'd like to have 1 field (integer) end user can populate alongside the selection fields. How to do so?
SimonFreeman
  • 205
  • 1
  • 7
  • 17
-1
votes
1 answer

In SAP SQ01, how can I avoid an ABAP runtime error due to a returned null value in a local calculated field?

I've created an SQ01 query with the intention of returning order schedule lines that have an open quantity based off of the Delivered Quantity (MENGE - GLMNG), this has been configured in a local calculated field. SAP ERP calculates this field in…
M.White
  • 5
  • 6
1
2
3