How to find name of partner based on partner number

[Former Member]

Hello All,

Can any one help me how to find name of partner based on partner number.

Regards,

Lisa

[Former Member]

check this table TPART.

[Former Member]

Do you mean KNA1 when you say partner ? If yes, use the function VIEW_VBADR.

regards,

Advait

[former_member188685]

it depends on the partner whom you are talking about. this you can get it from partner function.(parnter can be customer, vendor, etc.)

[Former Member]

I want technician name

[Former Member]

SELECT kunnr name1 erdat

FROM kna1

INTO TABLE i_kna1

WHERE erdat IN s_date.

SELECT kunnr kunn2 knref vkorg vtweg spart

FROM knvp

INTO TABLE i_knvp

FOR ALL ENTRIES IN i_kna1

WHERE kunnr = i_kna1-kunnr AND

vkorg IN s_vkorg AND

vtweg IN s_vtweg AND

spart IN s_spart AND

parvw = 'ZR'.

LOOP AT i_kna1.

READ TABLE i_knvp WITH KEY kunnr = i_kna1-kunnr.

IF sy-subrc = 0.

MOVE-CORRESPONDING i_kna1 TO i_cust2.

MOVE-CORRESPONDING i_knvp TO i_cust2.

APPENd i_cust2.

endif.

ENDLOOP.

*SELECT kunnr name1

FROM kna1

INTO TABLE i_kna1.

loop at i_cust2.

read table i_kna1 with key kunnr = i_cust2-kunn2.

IF sy-subrc = 0.

i_cust2-name2 = i_kna1-name1.

modify i_cust2.

endif.

endloop.*

icust2 will have partner number ,....partner name is in KNA1,..

so look in tat ..by above code.._ if this is wat u r luking for

[Former Member]

Hi,

May be you are looking for this table KNVK. Pass the partner number in PARNR and get the name from field NAME1.

[Former Member]

Tcode: BP