topic Re: Abap in Application Development and Automation Discussions

Abap

Former Member — Wed, 24 Jan 2007 04:39:02 GMT

Abap Interview Questions this is very urgent for me

4. What is Primary key, foreign key ? what is primary index?

secondary index?

5. how many indexes can be created for a table?

7. what are the components of a table?

9. if you write a write statement after end-of-selection, will that be triggered?

5. How can we use tables in sap scripts?

23. How to convert a sapscript to smart form?

Re: Abap

Former Member — Wed, 24 Jan 2007 04:45:09 GMT

4. What is Primary key, foreign key ? what is primary index?

secondary index?

Primary key is the key which is unique in the table

Primary index is the default index created for the table on primary keys

Secondary index is created on requirement based on some fields

5. how many indexes can be created for a table?

9 indexes.

9. if you write a write statement after end-of-selection, will that be triggered?

yes

Re: Abap

seshatalpasai_madala — Wed, 24 Jan 2007 04:45:30 GMT

Hi,

4) Primary key is the set of fields of a table that uniqely identify a record of a table. Foriegn key is to make srure data consistancy that is reference from a table to another tables primary key or key field. Primary index is automatically crated in ABAP and is nothing but an index over the primary key. Secondary key is somthing that we can create on a table and is a set of keys which we think are mostly used in the WHERE clause.

5)We can create as many as 9 secondary indexes as we want but it is better not to have more than 2. There can be only one primary index. Indexs can be database specific.

Regards,

Sesh

Message was edited by:

Seshatalpasai Madala

Re: Abap

Former Member — Wed, 24 Jan 2007 04:56:33 GMT

hi reddy here are a few answers..

23. transaction code: SMARTFORMS,menu Utilities - Migrate Scripts to Smartforms.

5.We can access structures and the tables that are updated during runtime.

Else you have to pass the structure values to the table in the print program

5.max 9 indexes for a db table .however u can create additional indexes

9.yes it wud be triggered

however for better performance in the intw have a look at these links,

http://www.sap-img.com/abap/important-abap-faq.htm

http://www.sap-img.com/sapscripts/faq-for-sap-scripts.htm

with regards,

all the best,

sampath

*award points if helpful

Message was edited by:

sampath pilla

Re: Abap

Former Member — Wed, 24 Jan 2007 06:51:55 GMT

hi vijay,

Primary Key : it is set for a field to avoid duplicate enteries(or re-entry of a particular data)

Foreign Key: Foreign Key relationship is set between the parent table and the foreign key table. depend on the cardinality the foreign key table accepts the entry as it is in the parent table, generally if u set a foreignkey relationship in the table for a field the value u enter will be checked with the parent table and it will be saved only if the value of that field is in the parent table.

primary index: The primary index is always created automatically in the R/3 System. It consists of the primary key fields of the database table. This means that for each combination of fields in the index, there is a maximum of one line in the table. This kind of index is also known as UNIQUE.

Secondary index:secondary indexes, which can restrict the number of table entries searched to form the result set.

You specify the fields of secondary indexes using the ABAP Dictionary. You can also determine whether the index is unique or not. However, you should not create secondary indexes to cover all possible combinations of fields.

5. ans: 9 indexes.

7.components of a table : data element, domain, etc.

9. it will get triggered

23 . u can convert SAPSCRIPT to SMARTFORMS from the transaction SMARTFORMS itself from menu Utilities - Migrate Scripts to Smartforms.

or u can use program SF_MIGRATE.

note: only the layout will be migrated