on 02-15-2008 9:34 PM
Hi SDN members
I'm building an iView on our Supplier Portal, and part of our "Welcome iView", we want to show supplier (vendor) relevant information contained in the Vendor Master. One of them is to show their Quality Partners in Read mode, including their phone # and email address. However, I cannot find the tables linking a Vendor to all the "partners" listed in the Display Vendor : Partner Functions Screen. Do you happen to know where this data is? Also, all the details for a given partner is contained somewhere else, which table(s) would that be?
Thanks in advance for your collaboration!
Eric L.
Hi,
WYT3 as written above will contain the link.
1/From the link you get the partner and the partner function.
2/ With the partner function, you can determine accurately the partner type (table TPAR)
3/Now where are the accurate phone and address !!
3.1/ customers KNA1 => which provide a short info. More accurate is the address attached to it (table ADRC, ... )
3.2/ vendor LFA1=> which provide a short info. More accurate is the address attached to it (table ADRC, ... )
3.3/ contact person: KNVK. => which also provide a short info. More accurate is the address attached to it (table ADRC,ADRP, ... )
Take into account that Function modules do exist to read easily these data.
Hope this helped a bit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
WYT3
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric,
Chk in LFM2 table for the details which u want.
BR,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.