regarding the inner join

[Former Member]

hi,

SELECT a~audat

a~vbeln

b~posnr

b~werks

c~vbeln

c~erdat

b~matnr

b~kwmeng

b~vrkme

d~bstkd

e~zzarrival_date

e~zzarrival_time

e~zzloading_date

e~zzloading_time

INTO (int_sales_orders-audat ,

int_sales_orders-vbeln ,

int_sales_orders-posnr ,

int_sales_orders-werks,

int_sales_orders-document ,

int_sales_orders-cre_dat ,

int_sales_orders-material ,

int_sales_orders-quantity ,

int_sales_orders-uom ,

int_sales_orders-purchase_order,

int_sales_orders-arrival_date,

int_sales_orders-attival_time,

int_sales_orders-load_date,

int_sales_orders-load_time)

FROM vakpa AS a

INNER JOIN vbap AS b ON a_{vbeln = b}vbeln

INNER JOIN vbfa AS c ON b_{vbeln = c}vbelv

AND b_{posnr = c}posnv

INNER JOIN vbkd AS d ON d_{vbeln = c}vbelv

INNER JOIN vbep AS e ON e_{vbeln = d}vbeln

WHERE

a~kunde = customer_num

AND a~parvw = 'AG'

AND a~vkorg = '1000'

AND a~trvog = '0'

AND audat >= wc_date

AND c~vbtyp_n = 'J'

AND c~vbtyp_v = 'C' .

iam getting error while iam executing this program.

the zzarrival_date,zzarrival_time ,zzloading_date,zzloading_time are appended as structure in the table vbep.

can you tell me what is wrong with this statement.

thanks in advance.

[Former Member]

hi,

SELECT a~audat

a~vbeln

b~posnr

b~werks

c~vbeln

c~erdat

b~matnr

b~kwmeng

b~vrkme

d~bstkd

e~zzarrival_date

e~zzarrival_time

e~zzloading_date

e~zzloading_time

INTO (int_sales_orders-audat ,

int_sales_orders-vbeln ,

int_sales_orders-posnr ,

int_sales_orders-werks,

int_sales_orders-document ,

int_sales_orders-cre_dat ,

int_sales_orders-material ,

int_sales_orders-quantity ,

int_sales_orders-uom ,

int_sales_orders-purchase_order,

int_sales_orders-arrival_date,

int_sales_orders-attival_time,

int_sales_orders-load_date,

int_sales_orders-load_time)

FROM vakpa AS a

INNER JOIN vbap AS b ON a_{vbeln = b}vbeln

INNER JOIN vbfa AS c ON b_{vbeln = c}vbelv

AND b_{posnr = c}posnv

INNER JOIN vbkd AS d ON d_{vbeln = c}vbelv

INNER JOIN vbep AS e ON e_{vbeln = d}vbeln

WHERE

a~kunde = customer_num

AND a~parvw = 'AG'

AND a~vkorg = '1000'

AND a~trvog = '0'

AND audat >= wc_date

AND c~vbtyp_n = 'J'

AND c~vbtyp_v = 'C' .

iam getting error while iam executing this program.

the zzarrival_date,zzarrival_time ,zzloading_date,zzloading_time are appended as structure in the table vbep.

can you tell me what is wrong with this statement.

thanks in advance.

[suredarreddy_pulimamidi]

SAP recommended that use inner join only on 3 tables and must be related.In maximum of the cases avoid joins and use for all entries.

if useful reward.

[messier31]

Hi,

what error you are getting...

try putting ENDSELECT... after select..

Enjoy SAP.

Pankaj Singh.