append

NAeda — Wed, 27 Feb 2008 15:21:18 GMT

Hello ALL,

I have 2 internal table....

by using select query i fetched the data from 2 database tables and i added it to one internal table table by using

Select......from append table ....

here the proble is i got one more table the same way i need to add the content to one single table ...

please give me the solution its urgent..!

here is my code and i am getting dump

my tables are

TYPES: BEGIN OF ty_mat_val,

matnr TYPE matnr,

bwkey TYPE bwkey,

bwtar TYPE bwtar_d,

lfgja TYPE lfgja,

lfmon TYPE lfmon,

lbkum TYPE lbkum,

salk3 TYPE salk3,

vprsv TYPE vprsv,

peinh TYPE peinh,

verpr TYPE verpr,

stprs TYPE stprs,

bklas TYPE bklas,

END OF ty_mat_val.

TYPES: BEGIN OF ty_acct,

ktopl TYPE ktopl,

ktosl TYPE ktosl,

bklas TYPE bklas,

konts TYPE saknr,

END OF ty_acct.

TYPES: BEGIN OF ty_final,

matnr TYPE matnr,

bwtar TYPE bwtar_d,

lfgja TYPE lfgja,

lfmon TYPE lfmon,

salk3 TYPE salk3,

lbkum TYPE lbkum,

stprs TYPE stprs,

werks TYPE werks_d,

maktx TYPE maktx,

konts TYPE saknr,

price TYPE p DECIMALS 2,

END OF ty_final.

TYPES: BEGIN OF ty_tab1,

kalnr TYPE ck_kalnr,

lfgja TYPE bdatj,

lfmon TYPE poper,

matnr TYPE matnr,

bwtar TYPE bwtar,

bwkey TYPE bwkey,

lbkum type lbkum,

peinh type peinh,

vprsv type vprsv,

salk3 type salk3,

END OF ty_tab1.

IF NOT i_acct[] IS INITIAL.

SELECT matnr bwkey bwtar lfgja lfmon

lbkum salk3 vprsv peinh verpr

stprs bklas

FROM mbew

INTO TABLE i_mat_val

FOR ALL ENTRIES IN i_acct

WHERE bklas = i_acct-bklas

AND bwtar IN s_bwtar

AND lfgja IN s_lfgja

AND lfmon IN s_lfmon.

SELECT matnr bwkey bwtar lfgja lfmon

lbkum salk3 vprsv peinh verpr

stprs bklas

FROM mbewh

APPENDING TABLE i_mat_val

FOR ALL ENTRIES IN i_acct

WHERE bklas = i_acct-bklas

AND bwtar IN s_bwtar

AND lfgja IN s_lfgja

AND lfmon IN s_lfmon.

SELECT k_{kalnr k}lbkum k_{bdatj k}poper

c_{salk3 c}peinh c~vprsv

d_{matnr d}bwtar d~bwkey

into corresponding fields of table i_tab1

from ckmlpp as k

inner join ckmlcr as c on k_{kalnr = c}kalnr

AND k_{bdatj = c}bdatj

AND k_{poper = c}poper

inner join ckmlhd as d

on k_{kalnr = d}kalnr for all entries in i_mat_val

where d~matnr = i_mat_val-matnr

and d~bwkey = i_mat_val-bwkey

and d~bwtar = i_mat_val-bwtar.

Edited by: Aeda N on Feb 27, 2008 4:23 PM

Re: append

NAeda — Wed, 27 Feb 2008 15:31:25 GMT

please check the join condition ... and let me know

regards

Aeda n

topic Re: append in Application Development and Automation Discussions

append

Re: append