topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Thu, 28 Jun 2007 09:22:15 GMT

Hi experts,

i am developing one report.....

i am selecting customer-name from vbak table and delivery order data of customer from lips table.

but i am confused how do i take data of customer and related delivery data of that customer from lips table, since my customer data is in vbak and delivery data in lips?

Regards

Saurabh

Re: Report

former_member378318 — Thu, 28 Jun 2007 09:26:22 GMT

Hi,

Use the SELECT statement with the addition JOIN on tables VBAK and LIPS.

Re: Report

Former Member — Thu, 28 Jun 2007 09:27:42 GMT

i think you can vblen is the primary key

use that for selecttion

Re: Report

Former Member — Thu, 28 Jun 2007 09:27:44 GMT

hi,

which field should be used in innerjoin condition?

Re: Report

Former Member — Thu, 28 Jun 2007 09:31:35 GMT

Hi,

u can link vbak and lips thru vbap table .

lips-vgbel = vbap-vbeln and lips-vgpos = vbap-posnr and

vbap-vbeln = vbak-vbeln

Regards,

Ashok...

Re: Report

former_member378318 — Thu, 28 Jun 2007 09:32:24 GMT

SELECT ....

INTO ...

FROM VBAK AS VBAK

JOIN LIPS AS LIPS

ON LIPS_{VBELN EQ VBAK}VBELN

WHERE ...

Hope it helps.

Re: Report

Former Member — Thu, 28 Jun 2007 09:56:52 GMT

Hi,

try this

SELECT ....

INTO TABLE.....

FROM VBAK

INNER JOIN LIPS

ON vbak_{vbeln = lips}vbeln

WHERE ...

If helpful reard points.

Re: Report

Former Member — Thu, 28 Jun 2007 10:02:07 GMT

Hi,

<b>vbeln </b> is the primary key for vbak and lips. if u want to join then,do this

select vbeln from lips

into itab

for all entries in itab-vbak

where vbeln = itab-vbak-vbeln

this is much faster than joining the two tables.

reward if usefull..

Re: Report

former_member378318 — Thu, 28 Jun 2007 10:15:56 GMT

Mackoy,

Your example makes little sense, if you can get it to work please post the exact syntax again.

Re: Report

SantoshKallem — Thu, 28 Jun 2007 10:44:48 GMT

VBAK-KUNNR = KNA1-KUNNR, WITH THIS RELATION U CAN RETRIVE THE DATA FROM KNA1 ( I THINK U NEED NAME HERE)

VBAP-VBELN = LIPS-VGBEL AND

VBAP-POSNR = LIPS-VGPOS.

SELECT VBAK~VBELN

VBAK~KUNNR

VBAK~VKORG

VBAK~ERDAT

VBAK~NETWR

VBAP~POSNR

LIPS~MATNR

VBAP~KWMENG

LIKP~VBELN

LIKP~LFDAT

LIPS~LFIMG

LIKP~NETWR

KNA1~NAME1

FROM VBAK INNER JOIN VBAP ON VBAK_{VBELN = VBAP}VBELN

INNER JOIN LIPS ON LIPS_{VGBEL = VBAP}VBELN AND

LIPS_{VGPOS = VBAP}POSNR

INNER JOIN LIKP ON LIKP_{VBELN = LIPS}VBELN

INNER JOIN KNA1 ON VBAK_{KUNNR = KNA1}KUNNR

INTO TABLE ITAB

WHERE VBAK~VBELN IN S_ORDER AND

VBAK~VKORG IN ORG AND

VBAK~KUNNR IN CUST.

REGARDS..

SANTHOSH REDDY

Re: Report

Former Member — Thu, 28 Jun 2007 10:45:37 GMT

Hi,

ooppsss... sori for that! this will clear you up.

select vbeln from lips into itab-lips

for all entries in vbak

where vbeln = vbak-vbeln.

regards,

Mackoy.