on 09-25-2014 6:44 AM
Hi All,
I am creating new data model, I am confused what entity type goes with what relationships.
Can someone pleased explain while creating relationships below points:
1)What does From entity stands for and To entity type stands for?
2) Entity type 3 relationship with Type 1 Entity?
3)Cardinality - 0:N ,1:N and 1:1 stands for?
Please ,i ts a request don't provide help.sap links .
Kindly explain.
Regards,
Swati
Hi Swati,
Let me try to explain you in simple terms.
1. What does From entity stands for and To entity type stands for?:-
To Entity means the (referencing entity type) and the from-entity (referenced entity type), like suppose Material(MARA) and Plant(MARC),
so the relationship is from Material to Marc, as a single material can be extended to many plant hence we have relationship as:-
From To Cardinality
Material MARC 1:N
2. Entity type 3 relationship with Type 1 Entity?
From To Cardinality Type:
Type3 Type1 1:N/0:N Referencing
3. Cardinality - 0:N ,1:N and 1:1 stands for?
0:N means optional-to- many relationship date of death--->person
1:N means 1 to many relationship like person-->books
1:1 means 1 to 1 relationship like person-->weight
Hope it helps.
Regards
Prateek Agarwal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prateek,
I am assigning Type 3 entity in From entity type and Type 1 in To entity type with relationship Referencing and Cardinality 1:N.
But it shows :
The following error is
For entity types with storage and use type 3 for which the check table is predefined by the data element or domain, the other key fields in the check table must be mapped using relationships with Leading as the relationship type. The check table for entity type ZPTCR contains 2 additional key fields. However, &V4 leading entity types are defined using relationships.
Regards,
Swati
Hi Swati,
As per the above screenshot above you need to maintain one additional leading entity type, like in your scenario you are havig a type 3 entity ZPTCR contains some check table which is more then 1 key field so if you can go to entry/help cjheck tab in your table you ca find that check table name.
so you need to assign the relationship between that check table ad your's type3 entity check table as leading with cardinality 1:N.
Hope it helps.
Regards
Prateek
Hi Swati
Please refer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.