select staments??

105 Views

Hi,

For one of my requirement i need some quires.Please help me.

Queires : To retrive the name1,name2

logic : pick customer No from MHND-KUNNR and use table kna1-name1.

logic : pick customer No from MHND-KUNNR and use the table kna1-name2.

for Address Line 1 to retrive the ADRC(HOUSE_NUM1),ADRC(STREET).

logic: Pick the address number from the table KNA1 and then go to the table ADRC to pull the relevant field.

for Address Line 2 to retrive the ADRC(STR_SUPPL1 ),ADRC(STR_SUPPL2 ),ADRC(STR_SUPPL2 ).

logic: Pick the address number from the table KNA1 and then go to the table ADRC to pull the relevant field.

for contact tel number ADR2(TEL_NUMBER)

logic: Pls extract the Address number from Table T001 and then extract telephone sequence no.2 from table ADR2

Please help me how to write the select quires?

Regards,

srihitha