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