FAQ Database Discussion Community
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]...
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...
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? ...
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...
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],...
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 %_....
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,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...
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...
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...
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....
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...
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...
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,...
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...
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...
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...
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...
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();...
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,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...
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...
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...
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?
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...
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...
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....
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...
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...
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...
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"...
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...
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'...
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',...
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. ?...
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_...
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...
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...
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?...