topic interview qst in Application Development and Automation Discussions

interview qst

Former Member — Tue, 21 Nov 2006 09:18:31 GMT

views - how can we use views in your program?

Idoc- can we sent already sended idoc if status is showing error message

without making any changes?

bdc- what are the views we implemented for your data transfer ?

what exactly we are doing in bdc updates?

Re: interview qst

Former Member — Tue, 21 Nov 2006 12:52:49 GMT

We can make a select query from Data base views.

we can resend idocs which shows thethe error.

the third Q might be asked on mm01 material master views.

BDC updates are two types .

1) synchronous

2)asynchronous

Re: interview qst

Former Member — Tue, 21 Nov 2006 14:27:13 GMT

> views - how can we use views in your program?

You can create view combining multiple tables, which will help us selecting data form the view directly rather than remembering the tables and joining them manually.

> Idoc- can we sent already sended idoc if status is showing error message without making any changes?

Yes you can

> bdc- what are the views we implemented for your data transfer ?

In material master, you can say that we have implemented PURCHASING, SALES etc view. Best is to say that we have used BAPI for material master.

> what exactly we are doing in bdc updates?

While running a BDC, we are simulating a transaction just the way a user would do, if he has to do it online.

Regards,

Ravi

Note Please mark all the helpful answers

Re: interview qst

seshatalpasai_madala — Wed, 22 Nov 2006 03:30:31 GMT

Hi,

There are 4 types of views.

Database views: These views always use INNER JOIN, and they are defined mostly to READ the data from more than one table using INNER JOIN. You can also insert into a Database view if it is on a single table.

Maintanance views: These views always use OUTER JOIN, and they are defined mostly to for data read and inserting data into multiple tables.

Helpviews: These views also use OUTER JOIN and mostly used as SELECTION METHOD of a SEARCH HELP.

Projection Views: These is a view of some of the selected fields of a database table.

BDC: This is a techince used to execute programs in back ground. Data is passed using the structure BDCDATA and messages into BDCMSGCOLL.

Regards,

Sesh

Re: interview qst

Former Member — Wed, 22 Nov 2006 04:46:27 GMT

good

view->

A view describes the layout and behavior of a rectangular area of a user interface.

Use

Every Web Dynpro application has at least one view. The layout of a view is made up of different user interface elements, which can be nested in each other. The positioning of interface elements in one view is supported by the supplied layout variants.

A view table never actually exists physically. Instead, it is formed from the rows of the underlying base table(s) when this view table is specified in an SQL statement.

Syntax

<create_view_statement> ::= CREATE [OR REPLACE] VIEW <table_name> [(<alias_name>,...)] AS <query_expression> [WITH CHECK OPTION]

THANKS

mrutyun^