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: 1706
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

Re: Query Functionnal Location & Contact Person

Postby Frank Lai » Fri Nov 24, 2017 1:43 pm

Hi

Sorry for the delay in replying. Don't come to this site much anymore. Anyway, run tcode OIPP and display the details of the functional lcoation category you want. Inside you will see a partner determination procedure. Standard is PM. Then run tcode VOP2 and display the partner functions configured for the procedure. For PM you will see that there is only vendor side set up. That may be why you don't get customer. Try adding customer partner functions into the procedure and see if that makes are difference. You may need a PM or SD functional person to help.

Frank
Frank Lai
 
Posts: 1706
Joined: Mon Oct 21, 2002 8:03 am
Location: Canada


Return to ABAP

Who is online

Users browsing this forum: Google Adsense [Bot] and 7 guests





loading...


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