Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Following is the error and it occurs when you implement ZEROFILL incorrectly−mysql> create table DemoTable -> ( -> StudentCode int(10) NOT NULL ZEROFILL AUTO_INCREMENT PRIMARY KEY -> ); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ZEROFILL AUTO_INCREMENT PRIMARY KEY )' at line 3For correct implementation, use the below syntax −SyntaxyourColumnName int(10) ZEROFILL NOT NULL AUTO_INCREMENT PRIMARY KEYLet us first create a table −mysql> create table DemoTable -> ( -> StudentCode int(10) ZEROFILL NOT NULL ... Read More
Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> DoubleValue varchar(20) -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(DoubleValue) values('80.2, 90.5, 88.90'); Query OK, 1 row affected (0.44 sec) mysql> insert into DemoTable(DoubleValue) values('78.56, 45.80, 88, 45.6'); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable(DoubleValue) values('12.34, 90.06, 89.90'); Query OK, 1 row affected (0.11 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will ... Read More
You can create a custom function to sum a comma-separated string in MySQL. Let us first create a table. Here, we have a varchar column, wherein we will add numbers in the form of strings −mysql> create table DemoTable -> ( -> ListOfValues varchar(50) -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('20, 10, 40, 50, 60'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+----------------+ | ListOfValues ... Read More
Note that both production and development system should point to same directory. SAP never transfer files from one transport directory to another. Below is the process:You release a request from dev system. This create files in /usr/sap/trans/(data & cofiles).When STMS Transport Management System is configured correctly, you immediately see the request on the production system import queue and can import it.Incase route in Transport Management System is not configured it is possible to add a request to queue and then import to production.STMS is complex process in SAP system. I would suggest you refer this link:SAP Help linkRead More
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.