SAP Articles

Page 52 of 91

Create database view in SAP ABAP

Ali
Ali
Updated on 25-Feb-2020 1K+ Views

In ABAP, you can make use of Function modules - DDIF_VIEW_PUT and DDIF_VIEW_ACTIVATE for view activation. All table parameters should be defined correctly otherwise it can result in an error in the creation process.DDIF_VIEW_PUT − Interface for writing a view in the ABAP Dictionary.You can refer to below link for more details −http://www.se80.co.uk/sapfms/d/ddif/ddif_view_put.htmCALL FUNCTION 'DDIF_VIEW_PUT' "DD: Interface for writing a view in the ABAP DictionaryEXPORTINGname = " ddname Name of the view to be written * dd25v_wa = ' ' " dd25v View header * dd09l_wa = ' ' " dd09v Technical settings of the view * TABLES * dd26v_tab ...

Read More

Accessing element which is defined SAPUI5 application

Rahul Sharma
Rahul Sharma
Updated on 25-Feb-2020 173 Views

You could try using the below code −var iconTabBar = sap.ui.getCore().byId("vwDetails--itabBar")

Read More

HANA Modeling objects and Content folder in SAP HANA Studio

John SAP
John SAP
Updated on 24-Feb-2020 1K+ Views

In SAP HANA Studio, Content folder contains all the design time repository objects. In this folder, all objects created in HANA system are managed under packages. To create a new object, you have to first select a Package.In a package you have different HANA Modeling Views- Attribute Views, Analytic Views, Calculation Views and Analytic Privileges. Each of the object type is managed in different folder in a package.

Read More

Different objects inside a package in SAP HANA

John SAP
John SAP
Updated on 24-Feb-2020 290 Views

Following objects are available in a Package under Content tab in HANA system −Attribute ViewsAnalytic ViewsCalculation ViewsAnalytic PrivilegeStored ProceduresSub-PackagesDecision Tables

Read More

Difference between _SYS_BIC and _SYS_BI schema in SAP HANA

John SAP
John SAP
Updated on 24-Feb-2020 3K+ Views

_SYS_BIC schema in SAP HANA database is used to store column views of all the activated objects in HANA repository.  When an object is created and activated (HANA Modeling views, Stored Procedures), run time objects are saved under _SYS_BIC/Column views in database.These column views are used by front-end tools like BusinessObjects to get the data in a query._SYS_BI:This schema in HANA system stores table created for variables, time dimension- Gregorian, Fiscal and schema and content mapping tables.

Read More

SAP interfaces throws an error message "Completion Code 2, Reason 2161, MQJMS2002

Monica Mona
Monica Mona
Updated on 24-Feb-2020 263 Views

As per my understanding,  the only way to get the MQ jar files or the MQ C/C++ library files onto a system is by installing any of the below:Using WebSphere MQ product orUsing WebSphere MQ Client SupportPacsYou can find jar file under WebSphere MQ V7.0 Clients SupportPacks. The install files are commonly available under java/lib directory.You can try installing jar files from Fix Central. Go to Fix Central and enter "Java" in the Text search box.https://www-945.ibm.com/support/fixcentral/swg/identifyFixes?query.parent=ibm~WebSphere&query.product=ibm~WebSphere~WebSphere%20MQ&query.release=9.0&query.platform=AllThe name of the file to be downloaded is in this format:-[IBM|WS]-MQ-Install-Java-All.jar.For example, for MQ V9.0:9.0.0.0-IBM-MQ-Install-Java-All.jar.You have the following files that can be moved to ...

Read More

Information required adding a new remote data source in SAP HANA SDA

John SAP
John SAP
Updated on 24-Feb-2020 467 Views

Select the system that you want to access as Remote Data Source and enter the authentication details. You have to enter the Connection Properties and Credentials for remote system.On right hand side, you have option to Test the Connection or you can also run to create the data source.

Read More

Creating a new remote source in SAP HANA using SQL

John SAP
John SAP
Updated on 24-Feb-2020 2K+ Views

You can also create a remote source using SQL statement as below −CREATE REMOTE SOURCE Source_Name ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral_DSN_Name’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In this SQL statement- can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.In above statement, is used to specify the connection information for data source where you need to mention the DSN name for your ODBC remote source system. You have to create a System DSN/User DSN to access the data source using ODBC connection.To open SQL console, right click on Remote ...

Read More

Using configuration file orcl.ini to add Oracle data source in SAP HANA

John SAP
John SAP
Updated on 24-Feb-2020 535 Views

CONFIGURATION FILE ‘property_orcl.ini’ It is only required for Adapter ODBC for Oracle data sources. Below shows SQL query to create an Oracle Remote Source using SQL

Read More

Remote data sources supported under SAP HANA SPS06 SDA

John SAP
John SAP
Updated on 24-Feb-2020 201 Views

Following remote data sources are supported under SAP HANA SPS06 Smart Data Access −Sybase ASESAP Sybase IQ 15.4 ESD 3 and Version 16.0Apache Hadoop Version 2.3Teradata Database Version 13.0 or higher

Read More
Showing 511–520 of 902 articles
« Prev 1 50 51 52 53 54 91 Next »
Advertisements