Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
I think you knew the answer beforehand as you already mentioned it in your question. You need to set an SAP user for every user to work the SAP prescribed way otherwise you are violating the service agreement of SAP and hence support will be void.
I think you should try using long properties as it is one of closed way to get to achieve this.
To get the server name of SAP HANA server, you need to check the virtual machine (VM) list.You can find this list under Virtual machine details of your corresponding HANA SPS5 server’s External Address property.Usually, the port number is 30015.For the problem that you are facing regarding the connection set up, you can refer below link for more details.https://blogs.sap.com/2013/06/17/connecting-to-your-hana-database-from-php-using-odbc/
As per my understanding of your question, the better option for you will be to code the selection in ABAP. Then you can wrap this selection in a function module which will be remote function call enabled. Then go ahead and use this module.But let’s say you are not able to use it, then only remaining option for you will be ‘RFC_READ_TABLE’ but it has got its own problems.
If you need a standalone application, you can use maven-assembly-plugin that can handle JAR with renaming in resulting artifacts.Also, this problem is with 3.0.11 and older versions like 3.0.6 don’t have the same problem.You can also refer this SAP blog for more details:https://blogs.sap.com/2013/04/05/using-jco-without-nwds/
As per your requirement, you are utilizing ABAP memory to transfer data to background session from session of the user. It will not work as per the standard documentation. RFC or updates module will run in different user sessions with different ABAP memory and hence it will not be possible.
RFC enabled function modules, you should use a structure as line type for the table. You should declare a dictionary structure Z_MY_PARTS_DATA with a single field DESCRIPTION TYPE CGPL_TEXT2.Declare a data dictionary table type Z_MY_PARTS_TABLE using this structure.Next is to use the table type in Function module.
Either you can use SAP “WAIT UP TO” statement. For e.g. the below statement waits up for 30 seconds WAIT UP TO 30 SECONDS But this statement has an implicit database commit. It might sound weird but there are scenarios where this behavior is expected so you should be aware of whether this fits your use case or not. In addition to this, it performs a rollout and releases the worker processes. But the use cases where you don’t want to have an implicit database commit and worker process are considered important then you can go for an ... Read More
SAP stands for Systems Applications and Products in Data Processing. As the name suggests, it is an application used for data processing like ERP (Enterprise Resource Planning).The SAP is mainly used in business that consists of different independent modules (Financial, Administrative, Sales & Distribution, Production Planning, Customer Relationship Management, Material Management) which are integrated for business management. SAP manage all resources of an organization in a very effective way and make a plan how to get maximum utilization of resources (Materials, Manpower, Money, and Services). SAP ERP system gives a centralized access control to the database/modules that run in any organization ... Read More
You are making a basic mistake over here. A VORA virtual table does not support the traditional INSERT or UPDATE or DELETE statements. If you are planning to make any modification to data from VORA itself, then you need to use the APPEND command to add data or files to the table. But since you are trying from SAP HANA even this will not work for you. For your requirement, you need to have a HDFS file then use it for appending to the virtual table.