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 51 of 91
Managing cross database container access in SAP HANA
The cross database container access is managed in Global.ini file in Configuration under System Administration.To access global.ini file you need to navigate to Administration tab in HANA Studio → Configuration and there you can find Global.ini file.
Read MoreViewing table definition in SAP HANA
To check table definition, you need to right click on table name → Open Definition and this will open table structure under HANA database.
Read MoreSQL statement to create a Restricted user in SAP HANA
It is very simple. You can create a Restricted user with below query −CREATE [RESTRICTED] USER [] [ ] [ ] [ ] [ ] [ ] []In above SQL query, you have to pass following parameters −Specifies a database user in another tenant database as the remote identity of the database user being created.Specifies the user password of the user being created.Defines an external identification mechanism.Defines an external identity that is used to authenticate the user.
Read MoreChecking create time for all users in SAP HANA
This can be found using following SQL command −SELECT * from USERS;
Read MoreUnderstanding a database view in SAP HANA database
Consider the following example −Example Id Empl. NameEmpl.userEmpl.passwordJoining Date1 Employee 1 Emp1Emp1Pwd 9/11/20162 Employee 2Emp2Emp2Pwd16/08/20153Employee 3 Emp3Emp3Pwd 15/09/20164Employee 4Emp4 Emp4Pwd3/07/20145Employee 5 Emp5 Emp5Pwd 10/09/20126 Employee 6Emp6 Emp6Pwd 1/10/2013 Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.
Read MoreHow to extract data from SAP using .NET provider.
To extract using SSIS, you need to have access to backend system. You can use .NET connector and write a Windows application that extracts data from SAP system using Function Module.For more details on how to connect SAP using .NET connector, you can refer this blog- https://blogs.sap.com/2013/02/14/connecting-to-sap-with-nco-3/With use of BAPI’s you can allow external applications to access business processes and data in R/3 system. Below code is used to make call to BAPI. First is to create a class that implements IDestinationConfiguration −Imports SAP.Middleware.Connector Public Class ECCDestinationConfig Implements IDestinationConfiguration Public Event ConfigurationChanged(ByVal destinationName As String, ByVal args As ...
Read MorePassing multiple parameters in SAP BO Webi report
An open document URL is constructed as follow −http://:/OpenDocument/opendoc/?&&...&With use of SAP Business Objects API, you can query each prompt- single value or multiple value. When you build URL, you may have to include parameter types.You can join parameters with the ampersand (&) and you shouldn’t use space with & ampersand. Example − sType=wid&sDocName=Sales2003https://URL_path/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sType=wid&sRefresh=Y&iDocID=AUcrjvCCPOVHtSvXJV9Qs0k&lsMYBO_BU=B;B&lsSYBO_CALYEAR=201710&lsSYBO_CRNCY=USDIn this URL, you can see single value variable YBO_CALYEAR and value is passed in YYYYMM format&lsSYBO_CRNCY=USD, you can see single value variable and I am passing value “USD”When you run the report, you can define a report level variable or use report-level function to capture multiple ...
Read MoreUser rights required to make a call to SAP RFC Function Module RFC_SYSTEM_INFO from JAVA application
When you use Java connector you need basic authorization to read metadata of Function Module. S_RFC is an authorization object for the RFC call.This object contains the following fieldsRFC_TYPE Type of the RFC object you want to protect. You can pass the value 'FUGR'- function group) or 'FUNC'- function module.RFC_NAME Name of RFC to be protected. This file contains a value of the function group or of function modules.CTVT ActivityThis field may take the value 16.In case you want a user to be able to call function modules in-group 'ABCD' remotely, following user authorization is required ...
Read MoreIn SAP system, how can I find details of Change Request with modification?
You can view Transport request that contains detail about your changes by going to T-Code SE37. You have to enter the name of Function Module and click on Utilities → Versions → Version ManagementAlso note that when you don’t put the changes in $TMP package, the system will ask you to provide a Transport Request to save or activate your changes.You can also check the package by navigating to Goto → Object Directory Entry in Transaction code: SE37 as below:
Read MoreHow to use constant in ABAP program which has trailing space?
This is because you are declaring constant as type c. The type c variable always trims the trailing space. I would suggest you define it as string as followsCONSTANTS: co_abc type string value ' b '.This will keep the trailing spaces.
Read More