Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 57 of 58
How much size does the VARCHAR takes- the defined size or the size of the content in SAP HANA?
I am not sure whether someone can get you exact answer, SAP is not open source and implementation details and bits are not known to many except the creators and few others. If I go with the standard definition, for storage you will require the size of length of the data plus number of bytes for header information. So as per your example it will require 9 + 2 (for header) = 11 overall for storage.
Read MoreCan I define a column as a table type in SAP HANA?
I don’t think there exists any way where you can define the column type of a column within a table type as an array. Table type refers to a row structure with predefined number of columns. So you might need to rethink on how to change the incoming data from .NET application to be a usable one for your SAP HANA project.
Read MoreCan I filter a column in PN in SAP HANA with REGEX?
Projection Node is basically a graphical Calculation view. SAP HANA does not allow usage of regular expression in a graphical calculation view for filtering out data.So if you still need to use graphical calculation view (Projection Node), then you need to filter out the data either by using a table function or equivalent.
Read MoreIntegrating HANA and R using RJDBC
I think there is a typo error. Try correcting your code like classPath="Z:/SAP/hdbclient/ngdbc.jar
Read MoreNeed to update MySQL and SAP database at the same time from a Form
Yes, you can do that but if you are thinking of making the changes in the existing PHP script so that it takes care of both the tasks. Then it will be quite tough.But if you want to have two operations in parallel then you can have it.You can go for writing a web service which can do the DB update activity. You can also try using the SAP API to do the updates. SAP API has the most common and used methods to do the updates.So you might be able to find the ones for your requirement.You can also ...
Read MoreMoving to SAP BOXI 4.0 from BO XIR2
This could be cause of usage of different versions of cryptocme2.dllThis is location of CA's file: C:\Program Files\CA\SC\ETPKI\lib\cryptocme2.dll [Additional Info: File Version: Not Available, Timestamp: 2/29/2012 9:43 PM, size 3, 188 KB] Location of SAP's file : D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\cryptocme2.dll [ Additional Info: File Version 3.0.0.0 , TimeStamp: 2/25/2011 6:55 PM, size: 1704 KB]To fix this issue: you need to rename dll C:\Program Files\CA\SC\ETPKI\lib\cryptocme2.dll to cryptocme2_ca.dllNext is to copy D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\cryptocme2.dll to C:\Program Files\CA\SC\ETPKI\lib\Next is to uninstall BO XI 4.0 SDK via Control Panel.You have to restart the Box and stop ...
Read MoreChecking implementation of interface IF_EX_IDOC_CREATION_CHECK in SAP ABAP
IDOC_DATA_CHECK – This method is used to check IDoc Data to see If an IDoc is Generated.You can check documentation of this interface IF_EX_IDOC_CREATION_CHECK by using T-Code: SE24 or SE80You can refer this Method by using this syntax: CALL METHOD IF_EX_IDOC_CREATION_CHECK=>methodname EXPORTING/IMPORTING...Now come to you issue, an Exit statement takes program out of the loop. Incase you have loop as only processing block, it will also exit the method. You need to call BADI/method for each Idoc.
Read MoreWhat should I prefer to connect to SAP HANA database- extended services or other ODBC technique?
As you had already mentioned that extended services are natively integrated with HANA, so it’s going to be easier to use against HANA but as it is native to HANA only it can’t be used elsewhere. It will be faster when you compare it against ODBC because the extra step will be avoided here as it is native to HANA. Also, as it is integrated other factors like latency and other would be out of question which can be considerable factors with ODBC.Extended Services follow the MVC architecture so you need not worry about the implementation style as it will ...
Read MoreHow to upload a big CSV file in SAP Hybrid mobile app quickly?
As you said you are using the hot folder concept, you need to ensure that the proper threads are being used at every moment for any operation.By default, the number of threads used for import is one. To be more technical, impex.import.workers thread is one if not set explicitly. Since in your case the file is big, make sure that you exploit all the available cores to the fullest. It is highly recommended that maximum threads at any point of time should not be more than twice the number of cores. For optimal working, you may need to work out ...
Read MoreHow to get some customization done in SAP HR system?
I am not sure that there exists something in SAP HR in pure form which supports your use case. But you can handle the scenario as mentioned by you by making some changes here and there.There exists an infotype ‘Contracts’ with SAP HR which stores the type of employment of the employee like permanent or contract. You can take care of this type by flipping the status of the employee type by some third party service. Once the employee resigns then rehire him as a contractor but create a dummy pay roll so that it does not gets picked up ...
Read More