topic Re: VIEWS in Application Development and Automation Discussions

VIEWS

Former Member — Tue, 01 May 2007 06:53:39 GMT

IN VIEWS :

WHILE CREATING MAINTAINENCE VIEWS AFTER SPECIFIED TABLE 1 : EG : MARA AND CLICK ON RELATIONSHIPS........WE GET A LIST OF TABLES.....IN THAT WE SOME 3 SUB CATEGIRIES LIKE : REFERERCED TABLES, DEPENDENT TABLES, RELATIONSHIPS WITH UNSUITABLE CARDINALITY.........WHAT IS THESE ? CAN ANY1 TELL ME.

Re: VIEWS

h_senden2 — Tue, 01 May 2007 07:12:56 GMT

Please : don't shout !

Do not use CAPITALS only !

Hans

Re: VIEWS

Former Member — Tue, 01 May 2007 07:21:03 GMT

Hi Ravindra,

When u enter a table name say mara, then by clicking on relationships you would get to see <b>which all tables can be linked with mara ,as in which all have fields in common for establishing joins ..</b>

in maintainence views, we cannot define join conditions of our own choice . When we select a table from relationships , all the joins are <i>automatically made</i> for us.

first know wat cardinality means:

1:1 - one record in the other corresponding to one in the former.

1:n - like header table with details one : vbrk with vbrp.

so unsuitable cardinality should mean tht it doesnot fall under these definitions of cardinality.

Regards,

Shweta

unsuitable cardinality mean

Message was edited by:

shweta soni

Re: VIEWS

Former Member — Tue, 01 May 2007 10:39:13 GMT

I dint get u ........I understand that candinality deals with relasionships.....but wat is the diff between REFERERNCED TABLES and DEPENDENT Tables

Re: VIEWS

Former Member — Tue, 01 May 2007 10:42:50 GMT

check below wiki...

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap+dictionary&;

u will get all the answers for ur questions.

Reward if useful.

Re: VIEWS

Former Member — Tue, 01 May 2007 16:31:40 GMT

Nope that dint ans my Q.

Top contributors plz do look into this specially to

1. Anji Reddy Vangala

2. Ferry Lianto

3. Ravi Thothadri

plz tell me wat is the diff .....n.....which circumstances do we use them

Re: VIEWS

Former Member — Tue, 01 May 2007 17:10:03 GMT

1. referenced table means, list of those tables, which fields from mara have as check table (foreign key table ) . for eg, field MTART has check table T134.

2. tables where MARA is used as a check table. for eg, makt-matnr has check table MARA.

Re: VIEWS

Former Member — Thu, 03 May 2007 15:22:40 GMT

Can any one add on this..............I am half way through