Query

[Former Member]

hi,

could u plase send me the details query

goto <b>[vbpa]</b> for the for the delivery note number.for partner function <b>sp[/b(sold-to), goto table [kna1] for the following:

table name [kna1]

name:[name1]

street:[street]

city:[ort01]

state:[regio]

zip:[pstlz]

dea#;[search term 1]

regards

srinu

[Former Member]

select kunnr from vbpa where vbeln = (order/delivery)

select nmae1 street... from kna1 where kunnr = vbpa-kunnr

-Kiran

[Former Member]

Hi Srinu,

Try with the following code.

DATA V_KUNNR TYPE VBPA-KUNNR.

DATA:

BEGIN OF WA_KNA1,

NAME1 TYPE KNA1-NAME1,

STRAS TYPE KNA1-STRAS,

ORT01 TYPE KNA1-ORT01,

REGIO TYPE KNA1-REGIO,

PSTLZ TYPE KNA1-PSTLZ,

MCOD1 TYPE KNA1-MCOD1,

END OF WA_KNA1.

<b>SELECT KUNNR FROM VBPA INTO V_KUNNR

WHERE VBELN = <VBELN> AND PARVW = 'SO'.

SELECT NAME1 STRAS ORT01 REGIO PSTLZ MCOD1

INTO WA_KNA1

WHERE KUNNR = V_KUNNR.</b>

Thanks,

Vinay

[Former Member]

Srinu,

<b>SELECT KA_{NAME1 KA}STREET KA_{ORT01 KA}REGIO KA~PSTLZ.... INTO WA_ADDRESS

FROM KNA1 AS KA INNER JOIN VBPA AS VB ON KA_{KUNNR = VB}KUNNR WHERE AND VB~VBELN = DELIVERY_NUMBER

AND VB~PARVW = 'SP'.</b>

rgds,

TM.

Please mark points if helpful.

[sridharreddy_kondam]

Hi Srinu,

Try this, select u r required fields and also metion the condition. first declare one internal table which has req. fields from both tables

select k_{PARVW k}kunnr p_{NAME1 p}ORT01 p_{REGIO p}PSTLZ into table itab

from

vbpa as k inner join kna1 as p on k_{kunnr = p}kunnr where k_{vbeln = 'values u pass' and k}parvw = 'u r value' .

Regards,

Sridhar