select validation

[Former Member]

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

[former_member226999]

Join MARC on matnr and fetch the values

[Former Member]

Hi,

First find the related fields in the both the tables.

Then write the select statement on them.

[Former Member]

Hi Ajay,

for profit center use cepc-prctr.

[Former Member]

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...

[Former Member]

Hi all,

I solved my self.

thansk for your support.

regards,

Ajay