TABLE

Former Member — Tue, 12 Jun 2007 12:54:19 GMT

HAI,

In SE11 we created two database tables say some 1000 fields each.Now f we want both the tables combined into one table, how do we do that?

THANK YOU

ASHOK KUMAR

Re: TABLE

Former Member — Tue, 12 Jun 2007 12:56:32 GMT

You can create a Database VIEW in SE11

like how you create a table

join the both tables and display the fields

- Database View (SE11)

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

<b>Reward points for useful Answers</b>

Regards

Anji

topic Re: TABLE in Application Development and Automation Discussions

TABLE

Re: TABLE