topic Re: COMBINING COMMON COLUMNS IN SELECT QUERY in Application Development and Automation Discussions

COMBINING COMMON COLUMNS IN SELECT QUERY

Former Member — Wed, 20 Dec 2006 10:39:08 GMT

hi all,

While make inner join between two tables how to link more than one

common colums , which operator i want to use, shall anybody give me one ex.

Thanks in advance.

R.Vijai

Re: COMBINING COMMON COLUMNS IN SELECT QUERY

Former Member — Wed, 20 Dec 2006 10:41:31 GMT

Select single Vbrk_{Bukrs Vbrk}Kunrg Vbrk~Vbeln

Vbrk_{Fkdat Vbrk}Bstnk_Vf Vbrk~Zterm

Tvzbt~Vtext

Vbak_{Vbeln Vbak}Bstdk

Likp_{Vbeln Likp}lfdat Likp~Lfuhr

into w_vbrk

from vbrk

inner join Tvzbt on Tvzbt_{Zterm = Vbrk}Zterm and

Tvzbt~Spras = sy-langu

Inner join Vbfa as SalesLnk

on SalesLnk~vbeln = pu_vbeln and

SalesLnk~vbtyp_v = c_order

inner join Vbak on Vbak_{Vbeln = SalesLnk}Vbelv

Inner join Vbfa as DeliveryLnk

on DeliveryLnk~vbeln = pu_vbeln and

DeliveryLnk~vbtyp_v = c_Delivery

inner join Likp on Likp_{Vbeln = DeliveryLnk}Vbelv

where vbrk~vbeln = pu_Vbeln.

santhosh

Re: COMBINING COMMON COLUMNS IN SELECT QUERY

Former Member — Wed, 20 Dec 2006 10:49:29 GMT

Hi Vijaya ,

Just keep on adding 'AND' , beofre all the other conditions.

Regards

Arun

Re: COMBINING COMMON COLUMNS IN SELECT QUERY

Former Member — Wed, 20 Dec 2006 10:50:38 GMT

good

try like this

SELECT c~matnr "Material no.

c~werks "Plant

c~lvorm "Flag Mat.-Del. at Plant level

c~bwtty "Valuation category

c~kzkri "Indicator: Gritical part

c~dispr "Material: MRP profile

ADD Mike Krepcik TD 3363 02/01/05 D10K913640

c~dismm "MRP type

END TD 3363 02/01/05 D10K913640

c~plifz "Planned delivery time in days

c~perkz "Period indicator

c~minbe "Reorder point

c~mabst "Maximum stock level

c~umlmc "Stock in Tran. (plant to plant)

a~mtart "Material type

a~meins "Base unit of measure

k~spras "Language key

k~maktx "Material description

w~bwkey "Valuation area

w~bwtar "Valuation type

w~lbkum "Total value stock

w~salk3 "Value of total valuated stock

w~verpr "Moving ave. price/periodic unit

w~peinh "Price unit ADD D10K913194

FROM marc AS c LEFT OUTER JOIN mara AS a

ON c_{matnr = a}matnr

LEFT OUTER JOIN makt AS k

ON c_{matnr = k}matnr

LEFT OUTER JOIN mbew AS w

ON c_{matnr = w}matnr AND

c_{werks = w}bwkey

INTO TABLE i_splus

WHERE c~matnr IN s_matnr "Material no.

AND c~werks IN s_werks. "Plant

thanks

mrutyun^