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
-
Economics & Finance
SAP Articles
Page 84 of 91
How can I transfer data from SAP HANA to virtual table?
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.
Read MoreDoes Process before output and process after input initiate commits in ABAP?
Yes, the PBO-PAI triggers commit so your requirement will fail. You need to make changes to your current implementation to avoid the auto-commit.
Read MoreWhat are the available options for Data integration in SAP?
Yes, there exists an equivalent. You can go for using SAP HANA Smart Data Integration also known as SDI. It is a standard offering of SAP for data integration. You don’t require any additional infrastructure for this, like a separate server or other. There are lots of blogs and online help which can help you to start on SDI.You can also check out for Data services but that is too complex and may be excessive for the mentioned usage.
Read MoreHow to perform repetitive aggregation over a field in a SAP HANA table?
The logic is pretty simple. You can define a local variable which is used for storing the total sum of all the groups. When you are performing iteration for each group, you can add the sum at the group level to the local variable.I am not suggesting code as it is very basic and straightforward.
Read MoreWhat does an InfoStore refer to in SAP BO?
Basically Infostore refers to the metadata about Objects and in BO terms – infoobject. An infoobject is basically an entity in SAP business Object universe. It can be a report or a user or an event as well.For E.g.: if we are speaking about an employee so an employee has a metadata like Name, Department, Designation, Salary and others. Infostore lists out this metadata when the context in Employee. So when you execute a GET request for getting infostore it returned you the metadata for an info object.
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 MoreHow 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 MoreHow to switch between different views in ALV Grid in SAP ABAP?
You can achieve something similar to your requirement. Firstly, you need to fetch the layout key information from the layout object. You can look for disvariant to get the key information if not able to find. Then use the key information to specify different handles for different data types. So basically you are having different layouts for different inputs or data types. As soon as you change the data type, the handle will do its job and display will change accordingly. Hope it helps!
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 MoreWhich all formats are compatible as input by Process Integration SAP
The answer to your question is that a lot of formats are supported by process integration for processing. The basic concept is that you need to define a mapping which will parse the incoming file and then converts it to the output format. Since you are getting a file from service as an input, it will be better if it is in CSV or .xls.
Read More