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
Articles on Trending Technologies
Technical articles with clear explanations and examples
Creating xls file in ASP.NET to be imported to SAP
Note that in SAP system, you can import Arrays via a Web Service or using .NET Connector. It shouldn’t be an xls file when you structure the data properly.You can upload an excel file into internal table using an ABAP code:
Read MoreConcatenate columns from different tables in MySQL
You can use CONCAT(). Let us first create a table −mysql> create table DemoTable1 -> ( -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.90 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1 values('Chris'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1 values('David'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select statement −mysql> select *from DemoTable1;This will produce the following output −+-----------+ | FirstName | +-----------+ | Chris | | David | +-----------+ 2 rows in set ...
Read MoreGetting 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 MoreHow to select a field corresponding to the field in which MAX() exists?
For this, you can use sub query along with aggregate function MAX(). Let us first create a table −mysql> create table DemoTable -> ( -> ProductId int, -> ProductAmount int -> ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(1001, 7895); Query OK, 1 row affected (0.32 sec) mysql> insert into DemoTable values(1003, 8903); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(1010, 7690); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(2010, 8450); Query OK, 1 row ...
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 MoreAdd an autoincrement column with a custom start value in MySQL
To add a new column to an already created table, use ALTER TABLE and ADD COLUMN. Use AUTO_INCREMENT to set auto increment custom value.Let us first create a table −mysql> create table DemoTable -> ( -> StudentName varchar(20) -> ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('Adam'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('Mike'); Query OK, 1 row affected (0.12 sec)Display all records from the table using ...
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 More