Relation between table BUT000 & CRMD_Partner HANA Modelling

[former_member558420]

Hi ,

Am Creating an Calculation view Model including BUT000 & CRMD_Partner tables to view the prospect data in opportunity

I need a relation between the two tables as field BUT000/Partner_GUID not as same data type of field CRMD_Partner/ Partner no

And when i join field BUT000/Person number = CRMD_ADDR_NP The Customer Name does not appear i

[developerone]

Hello Ahmed,

Have you tried using the BUT051 table passing the relationship type BUR011 ( Has the Employee Responsible) ?

Thank You,

Sai

[former_member558420]

Hello Sai ,

Sorry i didnt get this ,,, you mean making relation between BUT051 and CRMD_PARTNER ?

[former_member558420]

Hi , Thanks for your comment

I need the Prospect customer and the employee responsible to be viewed together .

As clarification for above i tried to make a Relation between Between BUT000 & CRMD_Partner by relation CRMD_Partner.ADDR_NP to BUT000.Person number but unfortunately did not get the customer too so i was asking if their any other solution to view prospect customer and employee responsible together

[developerone]

Place a filter on BU_GROUP as prospects and create an inner join between BUT000 and CRMD_PARTNER using partner_guid.I was unable to find table CRMD_ADDR_NP. Please provide details of your requirements and screenshots of your views.