This website is not affiliated with, sponsored by, or approved by SAP AG.

Query Functionnal Location & Contact Person

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Query Functionnal Location & Contact Person

Postby BrunoGr » Thu Nov 02, 2017 12:29 pm

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-
BrunoGr
 
Posts: 2
Joined: Tue Oct 31, 2017 11:13 am

Re: Query Functionnal Location & Contact Person

Postby Snowy » Thu Nov 02, 2017 1:02 pm

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.
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28768
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: Query Functionnal Location & Contact Person

Postby Frank Lai » Mon Nov 06, 2017 10:25 am

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
Frank Lai
 
Posts: 1705
Joined: Mon Oct 21, 2002 8:03 am
Location: Canada

Re: Query Functionnal Location & Contact Person

Postby BrunoGr » Mon Nov 13, 2017 2:53 am

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-
BrunoGr
 
Posts: 2
Joined: Tue Oct 31, 2017 11:13 am


Return to ABAP

Who is online

Users browsing this forum: No registered users and 6 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.