Found 1044 Articles for SAP

Table type while importing data from flat file in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

152 Views

While importing data using flat file, you can use any existing table or can also create a new table in any of schema in database.You can create a new table in any of existing schema and also define table type in next window.Under target table, you can mention if you want to use an existing table or  create a new table. Select Schema name from drop down list and enter the table name. Once you click on Next button, in next window you can select table type.

Trigger based SAP HANA data replication

Anil SAP Gupta
Updated on 25-Jun-2020 08:16:41

327 Views

In SAP HANA data replication, following replication methods can be used −SAP Landscape Transformation (SLT)SAP Data ServicesDXCFrom the above method, SAP Landscape Transformation (SLT) Replication is a trigger based data replication method in HANA system. It is used for replicating real-time data or schedule-based replication from SAP and non-SAP sources. It has SAP LT Replication server, which takes care of all trigger requests. The replication server can be installed as a standalone server or can run on any SAP system with SAP NW 7.02 or above.To use this method, you have to navigate to Data Provisioning under SAP HANA Modeler ... Read More

Table mapping while data replication from flat file in SAP HANA database

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

131 Views

Table mapping is last step while uploading data using an Import option in HANA Studio. This shows the data that already exist in the table and also shows the information about the schema and table to which we are going to load the data.Click on Finish to load the data.

Using flat file load in SAP HANA database

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

324 Views

You can use Import.. option in SAP HANA Studio to import data from a CSV file. Go to file and click on Import option.Next is to define Import properties. You can create a new table or you can also use an existing table in HANA database. You can also define if a Header rows exists.

Inbuilt data provisioning tools in SAP HANA

Anil SAP Gupta
Updated on 25-Jun-2020 08:28:05

156 Views

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
Updated on 25-Jun-2020 08:26:38

1K+ Views

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, between ABAP systems and external calls to ABAP systems.Connection Type I (Internal Connections)This connection Type I indicates ABAP systems connected to the same database as current system. Type I entries are predefined and you can’t edit these entries.Connection Type L (Logical Destinations)The logical destination connection type indicates a physical destination. ... Read More

Trusted RFC connection in SAP system

Anil SAP Gupta
Updated on 25-Jun-2020 08:24:56

2K+ Views

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, you can use T-Code − SM59. There are different RFC connections supported as per requirement.Click on the 3rd icon to open a new connection wizard → click on Create button and a new window will open.

Embedded BW parameters for SAP HANA

Anil SAP Gupta
Updated on 25-Jun-2020 08:24:09

169 Views

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 − This parameter is used to replicate all data source to SAP HANASYSTEM − This parameter is used to specify clients to use DXC replicationDATASOURCE − This is used to specify the Data Source usedPSA_TO_HDB_DATASOURCETABLE − This parameter is used to provide the table name which are having list of ... Read More

Enabling Web dispatcher in SAP HANA Studio

Anil SAP Gupta
Updated on 25-Jun-2020 08:22:49

1K+ Views

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 load supports large volume of data.

Checking XS Engine service in SAP HANA system

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

517 Views

You can try accessing XS Engine using below address in IE.http://:80 and you will get below screen to show that XS Engine is working fine.

Advertisements