topic Re: Interview Questions in Application Development and Automation Discussions

Interview Questions

Former Member — Fri, 09 Mar 2007 09:27:01 GMT

Hi,

1. What is the difference between pooled and cluster tables? can i link the pooled table to cluster to retriveve the data?

2. What is the purpose of End of selection will be used?

3. Alv-types (tree structure.....how can we get)?

4. if consider one table is there and after one month i want to know the modifications for that table. how can i know that?

5. if consider one script is there . i want to display the same information twice in that same layout. how can i?

6. what is the main diff bw call transaction and session method? When we use the Session method normally? What is back ground job?

7. What is development cycle in your organization?

Re: Interview Questions

Former Member — Fri, 09 Mar 2007 09:39:44 GMT

1. What are pooled tables?

These are logical tables which must be assigned to a table pool when they

are defined. Pooled tables can be used to store control data (such as

Screen sequences or program parameters).

2. What is a table cluster?

A table cluster combines several logical tables in the ABAP/4 Dictionary.

Several logical rows from different cluster tables are brought together

in a single physical record. The records from the cluster tables

assigned to a cluster are thus stored in a single common table in the

database.

3. The purpose of End of selection would be to tell the user this is where exactly where selection of data end and you are going to display the data.

4. Alv types : Simple ALV, Interactive ALV and Hierarchial sequental ALV

5. You can see the table modifications in table CDHDR table.

6. If you want to display the same data twice , create a different text element in the script with the same fields and call it after the fields are displayed first time.

7. In Call transaction method no messages will be created automatically. You need to explicitly handle the messages. In sesseion the system automatically generates messages. If you have large data then you will go for session method.

8. Back gound job means you can schedule any type of program using the time and date . The system executes it automatically when it encounters the same date and time. Usually very large programs will be put in back ground jobs.

9. Typical development cycle involve.

1. Design

2. Develpement

3. Coding

4. Integration

5. Testing

6. Implementation

Regards,

Jayaram..

Re: Interview Questions

Former Member — Fri, 09 Mar 2007 09:42:19 GMT

pooled table and cluster tables are the many SAPtables are related with the database tables(only one)

and the pooled tables are the lasrge tables with small amount of data.

and the cluster tables are small tables with the large amount of data(key fieldss are mandatory)

i think u cannot link between pooled and cluster tables

end-of-selection,perpose is it closes the all events used in the program

and at last u r printing output of the data.

alv types are list and grid

reuse_alv_list_display

reuse_alv_grid_display

in main table please don't mension the text element in text editor

call transaction is data updation takes place at a time.

and in session method data updation take place unless until session is created

back ground job is done with sm36 and also sm35

and use of session method we create log session (that is error logs are created)

when data is updated where the errors takes place it shows in error log while in call trasaction is not.

i know these answers.

rewards if it helpful

vijay pawar

Re: Interview Questions

Former Member — Fri, 09 Mar 2007 09:42:53 GMT

Hi...

2) Generally End of Selection is meant to END a GET EVENT.... in a program...

Whenever you USE STOP in any of the events then the Control goes to the

End-Of-Selection Event.

3) ALV Types..

a. List Display

b. Grid Display.

Regards,

Vivekananda Varma Dandu.

Re: Interview Questions

Former Member — Fri, 09 Mar 2007 09:56:41 GMT

1.pooled table must need one minimum primary key... whereas cluster table not... cluster table is nothin but the collection of transparent tables...

2.Once if we written end sellection after that we cannot write select query.