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 68 of 91
Getting memory error while doing UNION in SAP HANA
The SQL UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows.To use this UNION clause, each SELECT statement must haveThe same number of columns selectedThe same number of column expressionsThe same data type andHave them in the same orderWhile performing UNION you need to note that what data it will bring. To perform UNION ALL you need to ensure that views should be fully materialized.To know more about SAP HANA Modeling, you can refer SAP Guide:SAP HANA Guide
Read MoreDifference between Open SQL, Native SQL in SAP HANA
As you know SAP was not providing any db for ECC and it had to be purchased separately. When you call your database in ABAP program, you need to write a SQL. As R/3 from SAP works with most relational databases, a common set of features had to be used, with some SAP specific extensions which are translated by the ABAP kernel to be understood by the actual DB. This language is known as Open SQL language.When you develop only for one database, it uses native instructions. IT is developed in Native SQL. Now when you use SAP HANA as ...
Read MoreCalculate TVA amount in SAP T-Code: FB01
Note that T-Code: FB01 (Post Document) is known as Financial Accounting module under application component Financial Accounting and runs Documentation FI posting program SAPMF05A upon execution.SAP TCODE : FB01Transaction Description: Post DocumentSAP Module ID : FISAP Module Description: Financial AccountingYou can refer SAP FI POST Document guide for more details.
Read MoreUsing SAP NetWeaver Recording and Playback features
Note that while using SAP Recording and playback, you get an export option however exporting to spreadsheet has a number of limitations, like the number of rows and columns (note 700206), file size (note 1854956) and many other limitations.700206 - XXL: MAX Size Limit for Excel Export for Table and PivotSAP Note 700206Solution as per SAP Note:Increased the Max Size Limit to 65536 rows and 256 columns for Table and Pivot Table option of Excel Export. This change is available for officeintegration technology only and no adaption is possible to old SAP Macros. To get the correction import the relevant ...
Read MoreGetting error while extracting data from SAP
Note that your findById method should return an object. Also try the below code as fix to your code:session.findById("wnd[0]/tbar[1]/btn[8]").press On Error Resume next myText = "x" err.clear myText = session.findById("wnd[1]/tbar[0]").Text if err.number 0 then myText = "" on error goto 0 If myText = "No data exists for chosen selection" Then GoTo TroubleShootInterCompany End If
Read MoreIn SAP system, outbound IDOC is not getting triggered in T-Code: VA01
I am not sure what has gone wrong however you can open order in edit mode in T-code: VA02 and take a look at the message determination protocol. There you can check why message wasn’t processed in SAP system.
Read MoreCan I change the text of options for SELECT via code in ABAP?
Yes, it can be done but I would request you to go through documentation available on SAP help before asking such questions as such things are well explained in documentation and help you to know the system better. You just need to set the text property to text of your choice.INITIALIZATION %_name_%_app_%-text = Hope it helps.
Read MoreCan I export CSV by using REST API in SAP Business Objects?
Yes, it is feasible and I have done something similar in one of my previous projects. But you need to be little clear on what you need to export. There are two options regarding the content of export:Raw Data ( it is basically the query)Formatted Data ( it is your report)I will provide you help for both. In case, if you are looking for just exporting the raw data then you can the following call and you should be able to fetch the raw data.http://:6405/biprws/raylight/v1/documents//dataproviders//flows/Also as will require the response in CSV, set the ACCEPT to ‘text/plain’ so that the ...
Read MoreExecuting SAP RFC creates an error: "The current application triggered a termination with a short dump
This is very generic error and it could be due to any reason: code error, inconsistency in data, or some other issue. You can use T-Code: ST22 to check short dump message in SAP system.This is used to check ABAP Runtime errors- All Client. You need to pass the filter condition, and click on Start
Read MoreHow to create a list in SAPUI5?
I have gone through your code and it looks your list binding is incorrect. When you bind your data, your data should be in a JSON array format. Please find below the updated working code.Examplevar oModelData = [ {Animal: "Kangaroo", Zoo: "Sydney"}, {Animal: "Tiger", Zoo: "Melbourne"}, {Animal: "Lion", Zoo: "Alaska"} ]; var oItem = new sap.m.StandardListItem({ title : "{ Animal }", description : "{ Zoo }" }); var oList = new sap.m.List({ headerText:" Items", items: { path: "/", template: oItem } });Hope it helps!
Read More