topic Re: ERROR in Application Development and Automation Discussions

ERROR

Former Member — Wed, 19 Jul 2006 07:43:46 GMT

HI,

WHEN I AM EXECUTING THIS CODE IT IS GIVING AN ERROR LIKE

No component exists with the name "MATNR", but there is a component with the similar name "MTSNR".

Tables: mseg,mkpf,lfa1,ekko,ekpo,bseg,bkpf,zmigo_addition.

*selection screen

selection-screen begin of block b1 with frame title text-001.

parameters: p_werks like mseg-werks.

select-options: s_budat for Mkpf-budat.

selection-screen end of block b1.

*TYPES DECLARATION

types:begin of typ_mseg,

p_werks type werks_d, "Plant location

mblnr type mblnr, "Number of Material Document

s_budat type budat, "Posting date in document

mtsnr type mtsnr1, "Number of external material slip

maktx type maktx, "Material description

menge type menge_d, "Quantity

lifnr type lifnr, "Vendor Number

name1 type name1_gp, "Name1

name2 type name2_gp, "Name2

telf1 type telf1, "Telephone number

trnam type ztrnam, "Transporter name

glano type zglano, "GR/LR/AWB No

J_1ICSTNO type J_1ICSTNO, "Central Sales Tax Number

J_1ILSTNO type J_1ILSTNO, "Local Sales Tax Number

J_1IEXRN type J_1IEXRN , "Excise Registration Number

end of typ_mseg.

*INTERNAL TABLES DECLARATION

data: it_mseg type standard table of typ_mseg initial size 0,

it_mseg1 type standard table of typ_mseg initial size 0,

it_mseg2 type standard table of typ_mseg initial size 0,

it_mseg3 type standard table of typ_mseg initial size 0,

wa_mseg like line of it_mseg.

select a_{mblnr a}matnr

a_{menge a}lifnr

b~budat

into table it_mseg

from mseg as a

join mkpf as b

on a_{mblnr = b}mblnr

where werks = p_werks and

budat IN s_budat.

if it_mseg[] is not initial.

select lifnr name1 name2 telf1

into table it_mseg1

from lfa1

for all entries in it_mseg

where lifnr = it_mseg-lifnr.

ENDIF.

if it_mseg1[] is not initial.

select trnam glano lifnr

into table it_mseg2

from zmigo_addition

for all entries in it_mseg1

where lifnr = it_mseg1-lifnr.

endif.

if it_mseg2[] is not initial.

select maktx from makt into

table it_mseg3

for all entries in it_mseg2

where matnr = it_mseg2-matnr

endif.

Re: ERROR

Former Member — Wed, 19 Jul 2006 07:47:47 GMT

Hello Amit,

Declare the MATNR in the structure typ_mseg.

If useful rewrd.

Vasanth

Re: ERROR

dani_mn — Wed, 19 Jul 2006 07:48:03 GMT

*TYPES DECLARATION

types:begin of typ_mseg,

p_werks type werks_d, "Plant location

mblnr type mblnr, "Number of Material Document

s_budat type budat, "Posting date in document

matnr type matnr,

mtsnr type mtsnr1,"Number of external material slip

maktx type maktx, "Material description

menge type menge_d, "Quantity

lifnr type lifnr, "Vendor Number

name1 type name1_gp, "Name1

name2 type name2_gp, "Name2

telf1 type telf1, "Telephone number

trnam type ztrnam, "Transporter name

glano type zglano, "GR/LR/AWB No

J_1ICSTNO type J_1ICSTNO, "Central Sales Tax Number

J_1ILSTNO type J_1ILSTNO, "Local Sales Tax Number

J_1IEXRN type J_1IEXRN , "Excise Registration Number

end of typ_mseg.

You have not declare matnr in your type declaration. now copy this code and check.

Regards,

Wasim Ahmed

Re: ERROR

Former Member — Wed, 19 Jul 2006 07:49:24 GMT

U don't have any field matnr in your types declaration. Then how can u refer it?

Re: ERROR

Former Member — Wed, 19 Jul 2006 07:51:11 GMT

hi amit,

error occured in the following lines

in the it_mseg2 , there is no field called MATNR , declare one field matnr in that type typ_mseg

if it_mseg2[] is not initial.
select maktx from makt into 
table it_mseg3 
for all entries in it_mseg2
where matnr = <b>it_mseg2-matnr</b>
endif.

Re: ERROR

Former Member — Wed, 19 Jul 2006 07:51:47 GMT

Hi,

the problem is in the select...

just check the bold one...

*TYPES DECLARATION

types:begin of typ_mseg,

p_werks type werks_d, "Plant location

mblnr type mblnr, "Number of Material Document

s_budat type budat, "Posting date in document

mtsnr type mtsnr1, "Number of external material slip

maktx type maktx, "Material description

menge type menge_d, "Quantity

lifnr type lifnr, "Vendor Number

name1 type name1_gp, "Name1

name2 type name2_gp, "Name2

telf1 type telf1, "Telephone number

trnam type ztrnam, "Transporter name

glano type zglano, "GR/LR/AWB No

J_1ICSTNO type J_1ICSTNO, "Central Sales Tax Number

J_1ILSTNO type J_1ILSTNO, "Local Sales Tax Number

J_1IEXRN type J_1IEXRN , "Excise Registration Number

end of typ_mseg.

*INTERNAL TABLES DECLARATION

data: it_mseg type standard table of typ_mseg initial size 0,

it_mseg1 type standard table of typ_mseg initial size 0,

it_mseg2 type standard table of typ_mseg initial size 0,

it_mseg3 type standard table of typ_mseg initial size 0,

wa_mseg like line of it_mseg.

select a_{mblnr a}mstnr

a_{menge a}lifnr

b~budat

into table it_mseg

from mseg as a

join mkpf as b

on a_{mblnr = b}mblnr

where werks = p_werks and

budat IN s_budat.

Regards

vijay

Re: ERROR

Former Member — Wed, 19 Jul 2006 07:54:17 GMT

Amit,

Whichever statement is giving that error, the strcuture you are accessing has a field called MTSNR.

If you can give the statement giving the error, then we can point out the error easily.

Regards,

Ravi

Note : Please mark all the helpful answers