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
SAP HANA Articles
Page 29 of 58
\\nQuery in Analytic view creating unexpected results in SAP HANA\\n
You haven’t provided complete details what you are trying to achieve. Refer SAP OSS note 1993033 Wrong result for query on analytic viewDuring activation of an analytic view, column view is generated. However, there are some artifacts that cannot be calculated in this column view. In this case, one additional calculation view is generated on top of it. The generation of the calculation view has to be performed if the following elements are defined in the analytic view:Input parametersCalculated attributesUnit or currency conversionsIf at least one of these elements is defined in the analytic view, the activation creates one OLAP ...
Read MoreGenerating result of SAP transaction automatically
There are different approaches that you can follow −First approach would be that you schedule a job and send the result to a mailbox instead of printing it. Then you can use any programming code to read that email and export in desired format.Other approach would be to check available BAPI’s. These BAPI’s can be called from an external program but for this you need to use SAP ABAP.Checkout this SAP blog that tells how to generate a report in background and send result to user email id −SAP blogYou can define distribution list in T-Code − SO23
Read MoreSAP doesn’t accept extension tags generated from wsdl for Web Services
Note that when you map XML schema to C#, it is recommended to map this to class inheritance. As per my understanding, you want to copy extended properties to generated classes however I don’t think you can find any tool to achieve this.I think this should be handled by transforming XML schema to a structure that you want and then use the schema to C# tool. One of the most common way to perform this is via XSLT.XSL (eXtensible Stylesheet Language) is a styling language for XML and it stands for XSL Transformations. XSLT provides the ability to transform XML ...
Read MoreGetting information in MS SharePoint workflow from SAP
There are many tools which offer this function for SharePoint. Try using BCS Business Connectivity Service and LINQ to get data from SAP to SharePoint list and then use that data in workflow.To write your own custom workflow, you can check this link:Custom Activity Workflow for implementing Item Level Security in SharePoint Designer 2007Workflow LinkTo create a Visual Studio 2008 Workflow Activity Library project, you need to follow below steps:First is to open Visual Studio 2008.Navigate to File menu, point to New, and then click Project.Next step is to navigate under the Workflow Project Type and select the Workflow Activity ...
Read MoreAlign items to center not working in SAPUI5
If you want a quick solution then you can use basic CSS properties like padding for left or right to align the content. Use relative percentages so that it works in both the views.Other way which looks ideal is that define a custom CSS. Then you need to add this custom CSS to manifest."resources": { "css": [ { "uri": "css/style.css" } ] }Set the concerned property like Margin: 0 auto; which will help you to set the contents to center.
Read MoreCan we create multiple database in SAP HANA system?
In SAP HANA, you don’t have a concept of creating multiple databases in one container. To create a separate container for your database objects, you can create the schema in HANA db.To create a schema, you can use below SQL query −CREATE SCHEMA schema nameYou can also define as owner name while defining a schema.CREATE SCHEMA [OWNED BY ]If it is not defined, the system takes the current user as the owner of the schema.
Read MoreUse of SPATIAL function in SAP HANA
In SAP HANA, geospatial data types are not defined as such and you need to use scalar values like a.ST_X().You can create a table like this −CREATE COLUMN TABLE MYSCHEMA.SpatialShapes_GEOMETRIES ( ShapeID integer, SHAPE1 ST_Point, SHAPE2 ST_GEOMETRY );SAP provides a complete guide to handle Geospatial data in applications. You can refer this link for more details:https://help.sap.com/doc/PRODUCTION/9db42d044f8e415180d4a4475873b50a/2.0.00/en-US/SAP_HANA_Spatial_Reference_en.pdf
Read MoreFetch fields from table or structure in ABAP SAP
If you need to identify the fields and number of fields in a structure, then you should use runtime type services. Using runtime type services makes more sense in this case as if we have some data in our environment, then it’s not ideal to call database for fetching the same.DATA(structure) = VALUE ( ) DATA(Descriptor) = CAST cl_abap_structdescr( cl_abap_datadescr=>describe_by_data (structure) ) DATA(Fields = LINES(Descriptor ->components ) This will give you the count of the components of the table or structure.You can also try another option if you do not want to ...
Read MoreDifferent ways to interact with SAP system from a web application
Using any of above method depends on what you are connecting, and version of your SAP system. You can use Standard BAPI’s to read or update a service order. BAPI is a Remote Function Call RFC with a standard API.In latest releases of SAP ERP, many of Function Modules are exposed as Web Services.In SAP system, you need to follow some administration task to allow access to SAP system. Following T-Codes can be used: SICF or SOAMANAGER.When you install ABAP Application Server, all the services are available in an inactive state. When a call is made to a URL, multiple ...
Read MoreTaking schema wise backup in SAP HANA
Data backup in any RDBMS system comes under Data Persistence layer. SAP HANA holds the bulk of its data in memory for maximum performance, but it still uses persistent storage to provide a fallback in case of failure.When you refer a schema in database, it refers to a namespace in the database. It is not possible to take backup schema wise as you do for complete database.However it is possible to export a schema using below command −EXPORT "MY_SCHEMA".* AS BINARY INTO '/tmp/my_schema' WITH REPLACE;SyntaxEXPORT AS INTO [WITH ] [ ]Note that you shouldn’t take schema ...
Read More