Contact person

[Former Member]

Can Sombody tel me link between

ADRC/ADR6 table WITH kna1/knb1/knvv table

Cos we want to display fax Number of contact person along with billing number

Edited by: rohith modi on Feb 14, 2008 10:20 AM

[Former Member]

hi,

The ADRNR_KNA1= ADDRNUMBER_ADRC

Example: Go to KNA1 table pick up value in ADRNR value & fed in ADDNUMBER in ADRC table to get details

The same with ADR6 table

Hope this helps u

regards,

Arun prasad

Edited by: arun prasad on Feb 14, 2008 10:30 AM

[Former Member]

THNX FOR REPLYIN

i tried this but i'm unable to pick up

Contact persons Fax Number

[Former Member]

hi,

The Fax number u can get directly from KNA1 table itself with the field TELFX

else

u can get from ADRC tables with dialling code+number from field FAX NUMBER

hope this helps u

regards,

Arun prasad

[Former Member]

Thx arun,

But we are trying to display Fax number of Contact person - we have maintained it in customer master contact person tab

Home address -fax number.

we want to display this Fax number

[Former Member]

hi,

try with table ADR3

where ADDRNUMBER_ADR3= ADRNR_KNA1

hope this helps u

regards,

Arun prasad

[Former Member]

HI Arun,

THANKS For helping Keep up the good job