topic Re: Customized Table in Application Development and Automation Discussions

Customized Table

Former Member — Tue, 03 Mar 2009 08:08:36 GMT

Hi Guru,

Here am using one customized table like z_mkpf_mseg

It having fields both from mkpf, mseg and also some other tables..

My issue is when i try to execute my customized table the data s not coming..

Pl tel me how to link my customized table to tht standard table..

Pl guide me..

Regards:

Manoj

Re: Customized Table

former_member242255 — Tue, 03 Mar 2009 08:10:22 GMT

you cannot link your Ztable to standard tables..

you have to incorporate the logic in some of the program for the Ztable to be filled.

Re: Customized Table

Former Member — Tue, 03 Mar 2009 08:11:30 GMT

Hi Manoj

Please be clear, if it is an internal table or database table and how you are getting the data you can also post your code.

Regards

Rajnesh Dharmat

Re: Customized Table

Former Member — Tue, 03 Mar 2009 08:12:14 GMT

Hi,

Make use of common fields, if possible common key fields.

Thanks,

Asit Purbey.

Re: Customized Table

naveen_inuganti2 — Tue, 03 Mar 2009 08:16:54 GMT

Sarvan Kumar wrote:

> you cannot link your Ztable to standard tables..

But we can link,

Make sure that there is a link, I think here it would be MBLNR,

If there are common contents in both table for your key field, it will deffenately fetches data.

if not,

Check entries at table level.

Declare your internal table in proper way...i mean field order...of your output internal table..if you are using INTO TABLE...syntax.

Check SY_SUBRC for that select statement...trace the error.

All the best.

Naveen Inuganti.

Re: Customized Table

Former Member — Tue, 03 Mar 2009 08:46:24 GMT

Hi all,

Am using customized table only not an internal table..

I write corresponding select queries also..

eg:

select * from zmm_mkpf_mseg

into corresponding fields of table itab

where bukrs in s_bukrs and werks in s_werks

and lifnr in s_lifnr

and budat in s_budat

and bwart = '122'.

select * from zmm_mkpf_mseg into corresponding fields of table itref

for all entries in itab

where mblnr = itab-LFBNR

and zeile = itab-lfpos

and mjahr = itab-LFBJA.

Note: in tht above code zmm_mkpf_mseg is my customized table..

Table level mseg,mkpf having data but i cant get the data in my customized table..

Pl guide me..

Re: Customized Table

Former Member — Tue, 03 Mar 2009 08:46:26 GMT

Hi all,

Am using customized table only not an internal table..

I write corresponding select queries also..

eg:

select * from zmm_mkpf_mseg

into corresponding fields of table itab

where bukrs in s_bukrs and werks in s_werks

and lifnr in s_lifnr

and budat in s_budat

and bwart = '122'.

select * from zmm_mkpf_mseg into corresponding fields of table itref

for all entries in itab

where mblnr = itab-LFBNR

and zeile = itab-lfpos

and mjahr = itab-LFBJA.

Note: in tht above code zmm_mkpf_mseg is my customized table..

Table level mseg,mkpf having data but i cant get the data in my customized table..

Pl guide me..

Re: Customized Table

Former Member — Tue, 03 Mar 2009 08:52:08 GMT

Do you have data in zmm_mkpf_mseg table

and how u r maintaining the data in zmm_mkpf_mseg.

first check whether you have data there or not

Rajnesh

Re: Customized Table

former_member242255 — Tue, 03 Mar 2009 09:02:03 GMT

hi ,

my intention was to tell that simply if we have some link field in out custom table we will not get the data.

we should have the data filled in our custome table..

that is wat i wanted to say..i think i have said the same in the second line.

Edited by: Sravan Kumar on Mar 3, 2009 10:03 AM