FAQ Database Discussion Community


How to get the row count via ADBC native SQL?

sql,sap,abap,hana
I can do the following query using Open SQL: select count(*) into lv_count from prcd_elements client specified where waerk = 'USD' How do I do the same thing with ABAP Database Connectivity (ADBC) native SQL? I've tried the following but it gives me an exception... I'm not sure what data...

SAP Script: Set focus on Input Field in order to SendKeys

user-interface,vbscript,scripting,sap,edit
in my SAP VBS Script, I want to paste the Clipboard to an Input Field. I use WshShell.SendKeys "^V", but it does not do anything and I suspect this because the Input Field has no focus. So far my best guess was to "write" empty text into the field and...

Missing sap assembly

c#,sap,.net-assembly,rfc
I am trying to set up connection between sap and .net via rfc. SAP provide dot net library nco3 to make a connection. When I compile the application, it says missing assemblies, even though they are imported. You can see this on the picture and assemblies The code does not...

What is the value of ABAP constants with prefix “%_”?

constants,sap,abap
We are writing a tool in Java to analyze ABAP programs. The code is extracted and given to us as text, so we do not have direct access to the ABAP system. One task is to resolve the value of constants. We now discovered constants whose name starts with %_....

Parsing json into data structures with lower case field names

json,sap,abap
I am parsing JSON into ABAP structures, and it works: DATA cl_oops TYPE REF TO cx_dynamic_check. DATA(text) = `{"TEXT":"Hello ABAP, I'm JSON!","CODE":"123"}`. TYPES: BEGIN OF ty_structure, text TYPE string, code TYPE char3, END OF ty_structure. DATA : wa_structure TYPE ty_structure. TRY. text = |\{"DATA":{ text }\}|. CALL TRANSFORMATION id OPTIONS...

Crystal Reports will not allow me to select database

asp.net,visual-studio-2010,crystal-reports,sap,crystal-reports-2010
Hi I'm trying to create a report and link it to be my database within Visual Studio 2010 but when I try to make the OLE DB (ADO) connection the database does not appear within the Connection Information (Server, UserID, Password and Database) and then when I manually try to...

`BAPI_PO_RELEASE` not returning success in sap

sap,abap
I want to release purchase order according to po number. BAPI_PO_RELEASE standard function module returning success message on release.But on already released po number it shows Already released. code: import parameters IV_EBELN TYPE EKPO-EBELN. IV_FRGCO TYPE BAPIMMPARA-PO_REL_COD export parameter ET_RETURN TYPE /WITS/MI_RETURN_TT' `FUNCTION /WITS/MI_PO_RELEASE. TYPES: BEGIN OF t_ekpo, ebeln TYPE...

Are there significant performance benefits from changing involved queries to stored procedures?

sap,hana
Obvious security benefits aside, are there significant performance boosts yielded from modifying involved queries to stored procedures in a SAP HANA database? If so, are there metrics I can use to gauge perceived benefits?...

BusinessObjects 4.1 Upgrade Migration Content

sap,business-objects,business-objects-sdk
I have a client needing to move from XI R2 to 4.1. I need to pick and choose basically 5 thousand reports, and change what folder they will be in. I will have to actually move the report from one folder to another. Then the content migration will be easy....

ABAP ALV GRID tooltip on cell in several lines

sap,abap
In this post you helped me to fill a tooltip on a cell in a alv. I've realized that this tooltip was limited to about 130 characters. Is there a way to have Tooltip in a long text on multiple lines. Thanks...

Display Column Chart Y Axis Labels in Kilo(K), Million(M) in webi reports

sap,business-intelligence,business-objects
Can we do formatting in Column chart value Axis Labels to show $1000000 as $1M, that is to replace 0's with M for million representation in Webi Reports? Please guide me if this is possible. Thanks Niki...

SQL There is already an object named '#TEMP' in the database after updated to SAP PL-16

sql,sql-server,sql-server-2008,sap
I am working with SQL 2008 R2 and we updated it today with a SAP update PL-16. After that we are getting issue in my previous developed application. We are getting errors in #temp tables. ERROR: [SQL Server Native 10.0][SQL Server]There is already an object named '#TEMP' in the database]...

Number of filled rows in a SapTable

sap,silktest
I'm using Silk4J and I have a table which is reported as SapTable in the Locator Spy. From that table, I'm trying to get all the texts of the second column, but it hangs or terminates with an exception. In the following you find the code for my tries. Finally...

Send a text in message body and not as an attachment

email,outlook,exchange-server,sap,abap
I'm sending the email message from ABAP-report of SAP ECC 6.0 EHP5 to Microsoft Exchange via SMTP. The message reaches user's inbox in Outlook 2013, but it arrives as an attachment instead to be in the body of the message. From the code's point of view, I'm sending the plain...

Difference between getColumnHeaders(), getColumnNames() and getColumnTitles()

java,scripting,documentation,sap,silktest
I am automating tests using Silk4J. For the SapTree [MicroFocus] class, there are the methods getColumnHeaders() [Microfocus], getColumnNames() [MicroFocus] and getColumnTitles() [MicroFocus]. The description of them is very similar and I'm trying to understand the differences. What I found out so far: the methods return different results. In my case,...

crystal report how to display date in boxes of Bank Check Book

crystal-reports,sap,sapb1
I want to print check from SAP Business one. I do all setting except the bank check Date have issue. in bank check the date is in boxes and having spacing. can any one help me to how can i do it? ...

How create sorters and Filters of Row Repeater in xml view of SAP UI5

sap,sapui5
I am trying to create Sorters and Filters of Row Repeater Element in Xml View of SAP UI5. I tried to create by using the Javascript View But no Luck. Please can any one help me to write Sorters and Filters of Row Repeater in XML View. <c:filters> <c:RowRepeaterFilter id="filter1"...

SQL Query - Issues with Multiple ISNULL's and Calculations [closed]

sql,sap
Ive written this query that basically calculates future prices of items, kind of a 'What If' report. Ive got a couple of issue though with the INSULLs last two calculations in the select command and I'm not too sure what I'm doing wrong, below is the full query: SELECT T1.[ItemCode],...

How do we obtain SAP JCo data for tcode DB02

sap,jco
To monitor Performance of SAP CCMS(Rz20), we used XM interface, like : http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/da47d190-0201-0010-ac9a-e236663563e0?QuickLink=index&overridelayout=true&5003637377319 Is there any such interface for Database(DB02)? or what Functional Modules can help me fetch performance data of DB used by SAP Subsystem...

oracle table entry does not exist

oracle,installation,sap,hp-ux
while installing sap on 3 tiered architecture, I need to install database instance (oracle) and central instance(sap) and two different machines. after completing database install and proceeding with central instance installation, the setup is trying to access a table and fails with following error SELECT USERID, PASSWD FROM SAPUSER WHERE...

sapinst giving database connection error

database,installation,oracle10g,database-connection,sap
I am trying to install SAP R-3 ABAP, where databse instance is on one machine and central instance on different machine. Database instance installation is finished but when trying to install central instance when sapinst tries to connect from Central Instance to database instance following error comes up WARNING 2009-05-02...

SAP - RFC Returns Pointer to Data Instead of Data Itself

sap
I am running a RFC to get data from SAP. When I run this RFC, it appears that I get a pointer to the data, rather than the data itself. <ET_RETURN>BAPIRET2_</ET_RETURN> It appears that this BAPIRET2_ is some data set name or pointer. I want the data within this BAPIRET2_...

A bug while displaying permissions in SU56

permissions,sap
Because I could not create some objects in SAP, I was checking my permissions using the SU56 transaction. I realized that 2 permissions had the same text (roughly translated from German) Permission T-EP05077807: 9O,9W,9T create, delete Permission T-EP05077809: 9O,9W,9T create, delete However, when expanding the permission, I can see that...

SAP UI5 Demo Toolkit Source Code

sap,sapui5
I'm new to SAP and SAPUI5 in particular and trying to improve my skills in this domain. I'm looking for some demo apps built using SAPUI5, and found some in the Demo kit (https://sapui5.netweaver.ondemand.com/sdk/#demoapps.html) However I can't find the source code for these apps, neither for other non-trivial demos. Even...

How to start transaction with /dsd/ code in SAP easy access?

sap,jscript
how can I start transaction in SAP easy access using jScript with code which contains /dsd/, like /DSD/DE_ENTRY? In other cases it seems like session.StartTransaction("VT01N"); But it won't work with /dsd/ tCodes....

Converting datetime format without using SAP RFC with C#

c#,datetime,sap
I got a problem when trying to convert a date-time format with SAP RFC. I'm trying this: string tmpDate = argDate.ToString("dd.MM.yyyy"); DateTime date = Convert.ToDateTime(tmpDate); IRfcFunction SAPRateAPI = null; SAPRateAPI = _ecc.Repository.CreateFunction("ZRFC_CUST_CONDITION_RATE"); SAPRateAPI = CreateSAPRateAPI(SAPRateAPI, argPartnerSAPTranCode, argCustSAPTranCode, argMaterialCode, date); SAPRateAPI.Invoke(_ecc); But getting an error 'Specified Cast is not valid'...

Input controls overriding hidden table formula

sap,business-intelligence,business-objects
I have a report I'm working on, where I have a series of tables attached to each other representing 18 months of our business year. Each table is being hidden if an input control of Months does not have the particular months listed, so only the most currently relevant months...

How do SAP and Navision interact with third-party applications?

sap,crm,erp,navision
I am developing a business application and, provided that many companies look for integration, I would like to make it "compatible" with business systems like SAP or Navision. What mechanisms do these systems use for importing/exporting/syncing data with third-party applications?

Does BAPI_TRANSACTION_COMMIT commit changes since the last commit

java,sap,abap,jco
I know When you call BAPIs in your program that change data in the SAP system, you must then call BAPI_TRANSACTION_COMMIT to write the changes to the database. JCoFunctionTemplate functionTemplate = dest.getRepository().getFunctionTemplate("BAPI_FIXEDASSET_CHANGE"); JCoFunction ChangeFunction = functionTemplate.getFunction(); ...//some code ChangeFunction.execute(destination); JCoFunctionTemplate functionTemplate = dest.getRepository().getFunctionTemplate("BAPI_TRANSACTION_COMMIT"); JCoFunction commFunct = functionTemplate.getFunction();...

Unable to access DBCONN after migration to EHP7

sap,abap
I want to access Unix Database from my SAP system. I was using cl_sql_connection class to open the connection. This class was working fine before the upgrade to EHP7. But, now, I am unable to Access table DBCONN in any Stabdard SAP transaction (SE16, SE11...) Following is my code, returning...

Determining whether a button is enabled or disabled (Silk4J)

java,sap,silktest
I am testing a SAP application and I need to find out whether a button is enabled or disabled. I have read the MicroFocus documentation for the SapButton class, but I can't find a method like getEnabled(), isEnabled() or getDisabled() or isDisabled(). How can I find out whether a button...

Abap change pointers send complete material master data idoc

sap,abap,idoc
I have change pointers set-up for material master data and it is already working. Now, I have the requirement always send the whole material information to the external system. When doing manually in BD10, I can select the option to send the full material. However, when using change pointers and...

Error DBIF_RSQL_INVALID_RSQL CX_SY_OPEN_SQL_DB in program

sap,abap
I get the following error: DBIF_RSQL_INVALID_RSQL CX_SY_OPEN_SQL_DB (Open SQL command is too big. Condition WHERE of the Open SQL command contains too many conditions). The error points to the following line: select * from Z3T_MAILS into table t_full_mail UP TO 250 ROWS where ID in r_mid and (p_dat_clause). Other parts...

Text File in ABAP-SAP

sap,abap
How to create a text file or xlsx file using ABAP? Also, what is the difference between, OPEN DATASET filename FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. and OPEN DATASET filename FOR INPUT IN TEXT MODE ENCODING DEFAULT. ?...

SAPUI5 - custom searchfield properties

javascript,xml,sap,sapui5,sap-fiori
I have created a search-field in SAPUI5 using XML. The search field works properly but whenever I enter a search value which is not valid, it returns "No Data", which is correct. I want to edit the "No Data" phrase and customize it to my own phrase like this: "No...

is not an internal table OCCURS n specification is missing

sap,abap
I have this method METHOD get_flights_range. DATA ls_flight TYPE sflight. CALL METHOD check_authority EXPORTING iv_carrid = iv_carrid iv_activity = gc_auth_display. SELECT carrid connid fldate seatsmax seatsocc FROM sflight INTO TABLE et_flights WHERE carrid = iv_carrid AND connid IN it_connid. IF sy-subrc <> 0. RAISE EXCEPTION TYPE zcx_bcuser_no_data. ELSE. SORT et_flights...

Getting error “Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.” for comparing sales accounts

sql-server,tsql,sap
I am getting the following error when trying to compare 2 columns to another 2 columns based on a sales employee. Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. My code is this: select T1.CardCode 'BP Code', T1.CardName 'BP Name',...

How to get function codes for SAP context menus?

automated-tests,sap,silktest
I am automating tests of our SAP application using Silk4J (16.0.1.7470). There is a tree where I selected a node. I can open the context menu programmatically with SapTree.nodeContextMenu(). Now I want to simulate a click onto one of the context menu items. It seems that this can be done...

How obtain a line from a text file based in the id of the line? [closed]

php,file,sap
I have a host name which I read from saplogon.ini file. Now, I load this file into an array say $lines. When I read the host name by $hostname = $lines[10]; I cannot log in but if I hard code value as $line = "host name"; and then assign it...