topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Tue, 04 Jul 2006 09:39:28 GMT

hi,

could u plase send me the details query

goto [vbpa] for the for the delivery note number.for partner function 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

Re: Query

Former Member — Tue, 04 Jul 2006 09:54:32 GMT

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

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

-Kiran

Re: Query

Former Member — Tue, 04 Jul 2006 10:02:58 GMT

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.

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.

Thanks,

Vinay

Re: Query

Former Member — Tue, 04 Jul 2006 10:04:21 GMT

Srinu,

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'.

rgds,

TM.

Please mark points if helpful.

Re: Query

sridharreddy_kondam — Tue, 04 Jul 2006 10:15:27 GMT

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