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
Articles by Anil SAP Gupta
Page 10 of 10
Can 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 MoreHow to specify the connection string in SAP NetWeaver?
You got it partially correct but had something irrelevant present in the connection string. Try with the below connection string, it should work: /H/122.175.43.76/S/3266
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 MoreIs Partitioning required in SAP HANA tables for one million records?
I think you are over thinking on a potential issue. The size of tables as you said will be rarely over one million records which does not qualify it to be considered a big table. In my application we have tables which are much bigger than that but still work pretty well over time. Also, as you said that data is mainly categorized on a daily basis so, theoretically it makes sense to partition tables on dates. It should improve the performance to some extent. But it can also lead to good number of partitions which can backfire too from ...
Read MoreReading latest measurement point in SAP RFC
There is a Function Module: MEASUREM_DOCUM_RFC_SINGLE_002 that you can use to read documents if keys are known. When there is no RFC module to get a list of $foo according to a set of selection criteria, it is possible to use RFC_READ_TABLE to get the keys from db directly.Function Module MEASUREM_DOCUM_RFC_SINGLE_002: RFC Measurement document: Individual processing, Change/Display or ReadUseWith use of this RFC, following remote calls can be used:Remote dialog (WITH_DIALOG_SCREEN = 'X')Remote dialog in display mode (EDIT_MODE = ' ')Remote dialog in change mode (EDIT_MODE = 'X')Remote reading of measurement document data (WITH_DIALOG_SCREEN = ' ')NotesApart from when an ...
Read MoreFetching data from transparent tables in SAP system
Try checking length of variable if it is meeting minimum variable length required, if not append zeroes in end.
Read More