Archive for the ‘ABAP’ Category

About internal tables

This item was filled under [ ABAP, SAP ]

About internal tables

An internal table is a run time instance. It get created when program starts execution. It get destroyed when program terminates. It has two different parts: HeaderLine(optional) and Body(Compulsory). Any value that comes to or goes from interanal table, that travels through headerline. Read More

Continue reading...

Explain row type and line type concept

This item was filled under [ ABAP, SAP ]

Explain row type and line type concept

Line type refers to the structure of an internal table,whereas row type is the actual part that contains the data and it refers to the table body.creating internal table using line type and row type concept is for reusability purpose.Line type and Row type are defined at DDIC LEVEL. Read More

Continue reading...

Update command is used without where clause

This item was filled under [ ABAP, SAP ]

What happens “Update” command is used without where clause ?

It will update all the records with same name in the particular field of the table.

If we dont mention “WHERE” clause in the UPDATE statement, it will update all records satisfying the given condition (if given any ) in the table !

Based on query condition. i Read More

Continue reading...

SAP Oracle Commit and Roll back explained

This item was filled under [ ABAP, SAP, SAP Basis ]

Explain “Commit” and “Roll back”


The Oracle RDBMS provides a transaction model based on a unit of work. The PL/SQL language supports most, but not all, of the database model for transactions (you cannot, for example, ROLLBACK FORCE). Transactions begin with the first change to data and end with either a COMMIT or ROLLBACK.

Read More

Continue reading...

Tagged with: [ ]

ABAP4 Query?

This item was filled under [ ABAP, SAP ]

What is an ABAP/4 Query?
ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports. Statistics: Reports with statistical functions like Average, Percentages. Ranked Lists: For analytical reports. – For creating a ABAP/4 Query, programmer has to create us Read More

Continue reading...

Tagged with: [ ]

What are indexes?

This item was filled under [ ABAP, SAP ]

What are indexes?
Indexes are described as a copy of a database table reduced to specific fields. This data exists in sorted form. This sorting form ease fast access to the field of the tables. In order that other fields are also read, a pointer to the associated record of the actual table are included in the index. The indexes are activated along with the table and are cre Read More

Continue reading...

Tagged with: [ ]

What are domains and data element?

This item was filled under [ ABAP, SAP ]

What are domains and data element?
Domains:Domain is the central object for describing the technical characteristics of an attribute of an business objects. It describes the value range of the field. Data Element: It is used to describe the semantic definition of the table fields like description the field. Data element describes how a field can be displayed to end-user.

Read More

Continue reading...

Tagged with: [ ]

What is foreign key relationship?

This item was filled under [ ABAP, SAP ]

What is foreign key relationship?
A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered should be checked against existing data to ensure that there are now contradiction. While defining foreign key relationship cardinality has to be specified. Cardinality menti Read More

Continue reading...

Tagged with: [ ]