Skip to Content
0
Former Member
Aug 28, 2006 at 09:23 AM

Help required on Joins

853 Views

Hi,

Require some help on joining the below tables. I have the requirement as i pass Customer Number(KUNNR) and i need to get the below fields.Pls help me out in writing the code through joins for this.

Field Name Table Name

===========================

KUNNR KNA1

NAME1 ADRC

COUNTRY ADRC

REGION ADRC

CITY1 ADRC

TIME_ZONE ADRC

PERNR KNVP

NAME2 ADRC

STREET ADRC

POST_CODE1 ADRC

PO_BOX ADRC

POST_CODE2 ADRC

TEL_NUMBER ADRC

SMTP_ADDR ADR6

FAX_NUMBER ADRC

NAME1 KNVK

NAMEV KNVK

ANRED KNVK

LANGU ADRC

STCEG KNA1

TPLMA IFLOT

PLTXT IFLOT

BRSCH KNA1

BRAN1 KNA1

Below are the table joins.

KNA1-ADRNR = ADRC-ADRNR

KNA1-ADRNR = ADR6-ADDRNUMBER

KNA1-KUNNR = KNVK-KUNNR

KNA1-KUNNR = KNVV-KUNNR

KNA1-KUNNR = IFLOT-TPLMA

Regards,

Ramesh