SAP ABAP Problems & Solution

What is a Date Element in SAP ABAP ? Data elements is an object which specified semantic information of a field , like: field label, headings. What is a Domain in SAP ABAP ? Domain is an object which specified technical information of a field in a table, like : data type, value range, length  etc. Why use Data elements and Domains in SAP: When ever we are creating a new table or adding a field to existing table, we need to specify field labels and data types for the field, in SAP we maintain these values in the form of Data elements and Domains. T-Code is : SE11

Data Types Domains Data Elements in SAP: Basically there are three types of data types in sap: Elementary Data types, Complex Data types, Reference Types. Elementary Data types: In elementary data types there are again two types of data category: Fixed length and Variable length. Fixed Length Data Types: F Float  I integer H hexadecimal D Date T Time N Numeric C Text Field P Parked Number Variable Length: STRING Character Sequence X STRING Byte Sequence.  Complex Types includes structure types and table types. Reference Types includes Data References and Object References   

What is data dictionary in sap? SAP data dictionary is central repository for the development of object, SAP data dictionary is used to create & maintain metadata. SQL can be divided by two parts: DML - Data Manipulation language consist of SELECT ,INSERT, UPDATE, MODIFY, DELETE etc. DDL - Data Definition language consist of CREATE TABLE, DROP TABLE, ALTER TABLE, CREATE INDEX etc. Data Dictionaries function : Database tables. views Data Elements Domains Structures Search Helps Lock Objects T-Code is : SE11  

Select Appending: SELECT APPENDING query is used to append SELECT query result directly to some other internal table. Below is the syntax for SELECT APPENDING Syntax: SELECT  FIELD1  FIELD2  from DB_TABLE   APPENDING TABLE ITAB (internal Table)  WHERE  FIELD = COND_VALUE. Where condition is not mandatory for this syntax.

SELECT DISTINCT in SAP ABAP: Select Distinct is a sql query, which is used to get distinct value of a column from database table.Its remove duplicate value of a column of a table. Syntax: SELECT DISTINCT COLUMN_NAME FROM DBTABLE INTO TABLE ITAB(Internal Table)  WHERE <CONDITION>.

Select into corresponding fields in SAP ABAP: Select into corresponding fields is used to get data from database table  into a user define internal table or work area without define list of field. Syntax: Select * from DatabaseTable into corresponding fields of table <internalTable> It has compare each of the database field,Sap doesn't advisable to use this.  

Select statement for all entries: SELECT FOR ALL ENTRIES is the best alternative for SELECT WITH JOINS, this statement is very helpful for reading data from more than 2 tables. The load on database will be very less. Ensure before using SELECT FOR ALL ENTRIES Parent internal table must not be empty ( If it is empty, where condition fails and it will get all records from database). Remove all duplicate entries in parent internal table. Syntax: SELECT Table_FIELDS FROM DBTBL1 INTO TABLE ITAB1  WHERE <CONDITION>.  SELECT TABLE_FIELDS FROM DBTBL2 INTO ITAB2 FOR ALL ENTRIES IN ITAB1  WHERE TABLE_FIELD1 = ITAB1-TABLE_FIELD1.

Select with Joins in SAP ABAP: SELECT WITH JOINS statement is used to read data simultaneously from multiple database tables. For more than 3 tables is not advisable to join using select with join , because its create heavy load on database. Select with joins look like: Select  table_name~field             table_name2~field             table_name3~field into table IT_tablename (Internal table) from table_name inner join table_name on table_name~field = table_name2~field inner join  table_name2 on table_name2~field = table_name3~field.

What is the difference between Select Single and Select up to 1 rows in SAP ABAP ? These statements are the part of reading data from database table. By using SELECT SINGLE and SELECT UPTO 1 ROWS we can able to read single record from a database table . Look at a glance below table: SELECT SINGLE SELECT UP TO 1 ROWS Used to read exact record from database table. Used to read appropriate record from database table. To read exact record from database table we need to provide all key fields. We can read appropriate record from database table, we may not need to provide all key fields. This statement should be used only if all the key fields are available. This statement should be used only if we have some key fields or no key fields. How to Write: SELECT SINGLE * FROM Table_Name INTO WA WHERE ALL KEY FIELDS For performance this is better than select upto sta...

Smartform: Smart form is a GUI Tool which is used to design the business legal documents such as Delivery note,Purchase order,Invoice etc. The transaction code is SMARTFORMS. Smartforms are client independent objects. Smartforms are advanced version of SAP Scripts. It is a GUI tool and it is user friendly.  Smatrtforms and SAP Scripts differences: Smartforms SAP Scripts     Smartforms are client independent. SAP Scripts are client dependent. Main window is not compulsory. Main window is compulsory. Smartforms generates a Function module when activated. No Function Module will be generated. Smartforms texts supports various colors. Scripts allows black and white colors only. There is no transfer of control between program and form, once the control is transfered to Function Module, it will never come back. Scripts has repeated transfer of control. Only single page for...

Enterprise resource planning ( ERP ) is an enterprise-wide information system designed to coordinate all the resources, information, and activities needed to complete business processes such as order fulfillment or billing. An ERP system supports most of the business system that maintains in a single database the data needed for a variety of business functions such as Manufacturing, Supply Chain Management, Financials, Projects, Human Resources and Customer Relationship Management. An ERP system is based on a common database and a modular software design. The common database can allow every department of a business to store and retrieve information in real-time. The information should be reliable, accessible, and easily shared. The modular software design should mean a business can select the modules they need, mix and match modules from different vendors, and add new modules of their own to improve business performance.  Ideally, the data for the various bus...

UPDATE & Delete Statement Update Statement:  UPDATE statement is used to modify the existing records in a table.with We need to use Where Clause with Update statement to update the selected row,otherwise all the rows would be affected. The Update Statement look like : UPDATE table_name SET column1 = value1, column2 = value2...., columnN = valueN WHERE [condition];     If anyone forget to use Where Clause then the total row will be updated. So use Where clause with Update statement.   Delete Statement: The Delete Statement use to delete the existing record in a table.We need to use Where Clause with Delete Statement,Otherwise all the rows would be affected. The Statement look like: DELETE FROM table_name WHERE condition ;