Activities without Relationship

[Former Member]

We have around 2000 activities in project. How to identify activities with missing relationship?

[former_member203098 · Accepted solution]

in cj20n select the network header and click on the network graphic there on bottom right side you can see the activities

with out relationships.

regards,

[Former Member · Accepted solution]

But we want to create kind of log. Becasue there are lot of networks.

[former_member203098 · Accepted solution]

you can see cn49n report for relationships.

[Former Member · Accepted solution]

CN49N will display activities with Relationship only.

I work around I see is take the activity list from CN47N & CN49N and using excel find the activities with missing relationship. Do you agree?

[former_member203108 · Accepted solution]

No you dont have to do this exercise with excel. Use filter functionality, pull in the "relationship type" field in the filter, and set it in such a way that the activities without any relationship should be displayed. once you open the filter, you will know how to do it. so try it out.

[Former Member · Accepted solution]

Which report are refering to? Because CN49N will not show activities without relationship? Where is the question of filter?

In CN47N there is no relationship field.

[former_member203108 · Accepted solution]

Oh..I am sorry, I could have executed CN49N thinking that it is CN47N.

I would suggest another way, execute CN41N, you will find all activities but for activities with relationship, you will another row below to that activity showing relationship icon. If the activity is without any relationship then you wont find that row for that particular activity. So you can easily differentiate the activities with relation and without relation easily from this report.

[former_member203098 · Accepted solution]

yes, ahmed is right you can also find the activity relationships as suggested.

regards

[Former Member · Accepted solution]

Thanks Ahmed. Unfortunately we are in SAP4.7 and there is no CN41N transaction.

Thanks for the help