topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Wed, 27 Nov 2013 07:28:03 GMT

not working ?

TABLES : vbak ,vbap.

DATA : BEGIN OF itab OCCURS 0,

vbeln TYPE vbak-vbeln,

erdat TYPE vbak-erdat,

erzet TYPE vbak-erzet,

posnr TYPE vbap-posnr,

matwa TYPE vbap-matwa,

posar TYPE vbap-posar,

END OF itab.

DATA gt_orn LIKE STANDARD TABLE OF itab.

SELECT

vb~vbeln

vb~erdat

vb~erzet

vp~posnr

vp~matwa

vp~posar

INTO CORRESPONDING FIELDS OF TABLE itab

FROM

vbak AS vb

INNER JOIN

vbap AS vp

vb~vbeln = vp~vbeln

WHERE

vb~erdat = '14.11.2013'.

LOOP AT gt_orn INTO itab.

WRITE: / vbap-vbeln , vbak-erdat, vbak-erzet.

ENDLOOP.

Re: inner join

nabheetscn — Wed, 27 Nov 2013 07:33:27 GMT

Change like this

TABLES : vbak ,vbap.

DATA : BEGIN OF itab OCCURS 0,

vbeln TYPE vbak-vbeln,

erdat TYPE vbak-erdat,

erzet TYPE vbak-erzet,

posnr TYPE vbap-posnr,

matwa TYPE vbap-matwa,

posar TYPE vbap-posar,

END OF itab.

DATA gt_orn LIKE STANDARD TABLE OF itab.

data:lv_datum type erdat.

lv_datum = '20131114'.

SELECT

vb~vbeln

vb~erdat

vb~erzet

vp~posnr

vp~matwa

vp~posar

INTO CORRESPONDING FIELDS OF TABLE itab

FROM

vbak AS vb

INNER JOIN

vbap AS vp

vb~vbeln = vp~vbeln

WHERE

vb~erdat = lv_datum.

LOOP AT gt_orn INTO itab.

WRITE: / vbap-vbeln , vbak-erdat, vbak-erzet.

ENDLOOP.

Re: inner join

arivazhagan_sivasamy — Wed, 27 Nov 2013 07:34:19 GMT

Hi Semih,

Please pass the date like below

vb~erdat = '20131114'.

Arivazhagan S

Re: inner join

Former Member — Wed, 27 Nov 2013 07:45:52 GMT

And also change "INTO CORRESPONDING FIELDS OF TABLE itab" statement to gt_orn

Re: inner join

Former Member — Wed, 27 Nov 2013 08:01:46 GMT

tables : vbak , vbap.

data : begin of gt_itab occurs 0,

vbeln like vbap-vbeln,

posnr like vbap-posnr,

matnr like vbap-matnr,

arktx like vbap-arktx,

kunnr like vbak-kunnr,

erdat like vbak-erdat,

end of gt_itab.

data gt_tab like standard table of gt_itab.

select

vb~vbeln vb~posnr

vb~matnr vb~arktx

vk~kunnr vk~erdat

into corresponding fields of table gt_tab

from

vbap as vb

inner join

vbak as vk

vb~vbeln = vk~vbeln

where

vb~posnr = 20.

LOOP AT gt_tab INTO gt_itab.

WRITE: / vbap-vbeln , vbap-posnr , vbap-matnr , vbap-arktx,

vbak-kunnr, vbak-erdat.

ENDLOOP.

Re: inner join

nabheetscn — Wed, 27 Nov 2013 08:06:16 GMT

tables : vbak , vbap.

data : begin of gt_itab occurs 0,

vbeln like vbap-vbeln,

posnr like vbap-posnr,

matnr like vbap-matnr,

arktx like vbap-arktx,

kunnr like vbak-kunnr,

erdat like vbak-erdat,

end of gt_itab.

data gt_tab like standard table of gt_itab.

select

vb~vbeln vb~posnr

vb~matnr vb~arktx

vk~kunnr vk~erdat

into corresponding fields of table gt_tab

from

vbap as vb

inner join

vbak as vk

vb~vbeln = vk~vbeln

where

vb~posnr = 20.

LOOP AT gt_tab

WRITE: / gt_tab -vbeln , gt_tab -posnr , gt_tab -matnr , gt_tab -arktx,

gt_tab -kunnr, gt_tab -erdat.

ENDLOOP.

Re: inner join

Former Member — Wed, 27 Nov 2013 08:13:01 GMT

thank you

Re: inner join

Former Member — Wed, 27 Nov 2013 08:27:08 GMT

Change your erdat field's date in query like below. Because no data found about 20131411

SELECT k~vbeln k~erdat k~erzet p~posnr p~matwa p~posar

INTO CORRESPONDING FIELDS OF TABLE gt_itab

FROM vbap AS p

INNER JOIN vbak AS k ON p~vbeln = k~vbeln

WHERE k~erdat like '%1998%'.

Best Regards

Omer Faruk