topic Re: select validation in Application Development and Automation Discussions

select validation

Former Member — Wed, 14 May 2008 13:20:43 GMT

Hi all,

I am writing the select on MCON data base view . I am adding the profit center field in selection screen , I have to add the profitcenter (MARC-PRCTR) in that select , but the MCON doesn't have the prctr field.

I am writing like the code below.

SELECT * FROM mcon INTO TABLE it_mcon

WHERE werks = p_werks

AND matnr IN s_matnr

AND mtart IN mtart

AND abcin NE space

AND lvorm = space.

in above i have to add the PRCTR field also .

regards.

Ajay

Re: select validation

former_member226999 — Wed, 14 May 2008 13:23:35 GMT

Join MARC on matnr and fetch the values

Re: select validation

Former Member — Wed, 14 May 2008 13:26:12 GMT

Hi,

First find the related fields in the both the tables.

Then write the select statement on them.

Re: select validation

Former Member — Wed, 14 May 2008 13:27:35 GMT

Hi Ajay,

for profit center use cepc-prctr.

Re: select validation

Former Member — Wed, 14 May 2008 13:39:00 GMT

Hello Ajay-

Below is a simple example similar to your requirement.

tables:mcon,marc.

types:begin of i_test,

matnr type matnr,

mtart type mtart,

prctr type prctr,

end of i_test.

data:t_test type TABLE OF i_test,

w_test type i_test.

select a~matnr

a~mtart

b~prctr into table t_test from mcon as a inner join

marc as b on a_{matnr eq b}matnr.

loop at t_test into w_test.

write 😕 w_test.

endloop.

Cheers,

~Srini...

Re: select validation

Former Member — Wed, 14 May 2008 13:42:43 GMT

Hi all,

I solved my self.

thansk for your support.

regards,

Ajay