Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
For this, you can use INFORMATION_SCHEMA.TABLES and find the table you want to search. Let us first create a table −mysql> create table DemoTable -> ( -> Id int, -> Name varchar(20) -> ); Query OK, 0 rows affected (1.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(101, 'Chris'); Query OK, 1 row affected (0.71 sec) mysql> insert into DemoTable values(102, 'David'); Query OK, 1 row affected (0.20 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+------+-------+ | Id ... Read More
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:
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 More
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
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 More
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.
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 More
To consume HANA view, you need to start by creating an ODBC connection to SAP HANA system through odbcad32.exe.Next step is open SAP Design Studio and add a data source by connecting to HANA system and open view as below:This way you can view your SAP HANA view in Design Studio, now to analyze code coverage results, you can refer this SAP blog for step by step process:SAP blog
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 More
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