Page 1 of 1

Query Functionnal Location & Contact Person

PostPosted: Thu Nov 02, 2017 12:29 pm
by BrunoGr
Hello all SAP Fans,

First of all I am new on this forum, so please excuse me in advance if I posted in the wrong thread... :lol:

I would like to create a query in Quickview, connecting a Functionnal Location to all the Contact Persons it is related to.

Technically speaking, the functionnal location is in the IFLO table, which is directly connected to the partner IHPA table

The contact persons are in the KNVK table, but I can't reach to connect those 2 tables, I miss a connection between the customer number (KUNNR) and the partner number (PARNR) which is the same for us (but probably not for SAP)...

So if anyone can help me...

Thanks in advance!!!!

Regards,

Bruno-

Re: Query Functionnal Location & Contact Person

PostPosted: Thu Nov 02, 2017 1:02 pm
by Snowy
Hi Bruno,

this is not a Basis question, so, I moved it here in the ABAP forum. Maybe someone here has a better idea on the place to move this.

thanks.

Re: Query Functionnal Location & Contact Person

PostPosted: Mon Nov 06, 2017 10:25 am
by Frank Lai
Hi

I have not join these tables for functional locations but I have done it for equipment which also uses IHPA with customers. The value n IHPA does match KUNNR in KNVK. The problem maybe that the partner procedure assigned to the functional location does not have any customer relation partner function configured. The SAP supplied one only have ones like vendor, user responsible etc.

Frank

Re: Query Functionnal Location & Contact Person

PostPosted: Mon Nov 13, 2017 2:53 am
by BrunoGr
Hello Frank,

Thanks for your feedback

could you please explain what you mean by "the partner procedure assigned to the functional location does not have any customer relation partner function configured"...

what is exactly the "partner procedure" and the "customer relation partner function"??

Thanks for your help...

Regards,

Bruno-