Anil SAP Gupta has Published 115 Answers

Adding millisecond to date in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 20:53:10

Try using ADD_SECONDS function as below:SELECT ADD_SECONDS (TO_TIMESTAMP('2017-07-15 02:17:15'), 0.1) FROM TESTThis will add seconds as fraction value as requested. Below is syntax and example:ADD_SECONDS SyntaxADD_SECONDS (t, n)DescriptionComputes the time t plus n seconds.Example:SELECT ADD_SECONDS (TO_TIMESTAMP ('2012-01-01 23:30:45'), 60*30) "add seconds" FROM DUMMY; add seconds2012-01-02 00:00:45.0To know more about ADD_SECONDS ... Read More

Using HP UFT GetCellData function on SAP Web Dynpro crash Internet Explorer

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 20:48:55

Note that column number is used to locate table cell data and column name is unique identifier.object.GetCellData( row, column)- takes argument as long integers row and cell numbers to locate cell data.Try using GetCellData like this:Browser("Browser").Page("Page").Frame ("searchDialog").SAPTable("ResultsTable").GetCellData(1, 1) Browser("Browser").Page("Page").Frame ("searchDialog").SAPTable("ResultsTable").GetCellData(1, 2)Read More

Inbuilt data provisioning tools in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:28:05

SAP HANA also provides few of built-in tools which can be used for data provisioning in HANA database −Flat File Load (Import../Export.. option)Smart Data Streaming (This is available with HANA SPS09)Smart Data Access

Different connection types in SAP Remote Function call

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:26:38

Following RFC connection types are available in SAP system −Connection Type 3 (ABAP Connection) This connection type is used to specify connection between ABAP systems. You need to mention the host name and IP address of source system and also the logon information. This is applicable for both type of RFCs, ... Read More

Trusted RFC connection in SAP system

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:24:56

A trusted RFC connection is used to define Remote Function Call (RFC Connection) between two systems. By creating a trusted RFC connection between two systems, it allows you to create a trusted-trusting relationship between systems wherein, you can communicate and exchange information and data.To create a new trusted RFC connection, ... Read More

Embedded BW parameters for SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:24:09

To setup the following Parameters in BW Using Program SAP_RSADMIN_MAINTAIN  or you can also use T-code SE38 or SA38PSA_TO_HDB_DESTINATION − This parameter defines that where we need to move the Incoming dataPSA_TO_HDB_SCHEMA − This parameter is used to define which schema the replicated data will be assigned to.PSA_TO_HDB − GLOBAL ... Read More

Enabling Web dispatcher in SAP HANA Studio

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:22:49

To enable SAP Web dispatcher, you have to change Instance Value 0 to 1 in sapwebdisp in SAP HANA Studio → Configuration tab. This will enable ICM Web dispatcher and it uses ICM Method to load or read the data from SAP HANA system. Note that this method of data ... Read More

Data Replication techniques in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:22:02

SAP HANA is an in-memory database that supports real-time data replication from SAP and non SAP data sources. Following data replications are supported using SAP HANA −SAP Landscape Transformation (SLT) This is trigger based approach used to transfer data from source system to target systemSAP Data Services (BODS) This is commonly used ... Read More

Using Delivery unit in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:19:15

In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit

Using Delivery unit in SAP HANA

Anil SAP Gupta

Anil SAP Gupta

Updated on 25-Jun-2020 08:18:31

In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit

1 2 3 4 5 6 7 ... 12 Next
Advertisements