VIEWS

[Former Member]

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.

[h_senden2]

Please : don't shout !

Do not use CAPITALS only !

Hans

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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