topic Re: Table? in Application Development and Automation Discussions

Table?

Former Member — Fri, 28 Sep 2007 07:53:14 GMT

Hi all,

I have material number and plant.

Based on these two i need to get MAEX-ALNUM field.

IN MAEX MATNR is a key field and its having different ALNUM value.

How can i know for which plant which is the correct ALNUM.

Please help me regarding this....

gavas.

Re: Table?

Former Member — Fri, 28 Sep 2007 07:56:21 GMT

MAEX table data is not based on plant

This is Material Legal Control data based on the COuntry (ALAND) and GEGRU field

different countries will have different legal control rules for Material

so Plant is not the criteria for this data

Regards

Anji

Re: Table?

Former Member — Fri, 28 Sep 2007 08:01:01 GMT

HI Reddy,

Please clarify this.

I have VKORG 1030....

for that VKORG, one material is there like 55.

there are so many plants for this 1030..like 0001,0002,0003,0004.

now i have to get ALNUM for this material.

55 have so many different ALNUM s are there.

Now how can i come to know

matnr plant ECCN

55 0001

55 0002

55 0003

55 0004

in this how can i find which ECCN for which record please help me...

gavas.

Re: Table?

Former Member — Fri, 28 Sep 2007 08:09:38 GMT

Hi anji reddy,

please solve my problem.

gavas.

Re: Table?

Former Member — Fri, 28 Sep 2007 08:23:15 GMT

selcct matnr werks from marc into table itab where werks = s_werks.

if itab[] is not initial.

select matnr alnum from maex into itab1 for all entries in itab where matnr = itab-matnr

end if.

firstly it will records based on u r plant given in select option............later it will fetch all the records matching u r criteria right???????/

the tale maex is not depens on palnt u must material as key field for this...............based on the material only u have to fetch both alnum and werks

reward points if helpful.......

Re: Table?

Former Member — Fri, 28 Sep 2007 08:25:07 GMT

hi ramya,

if i given material as parameter.

plant as select-option..then///

gavas.

Re: Table?

Former Member — Fri, 28 Sep 2007 08:29:57 GMT

selcct matnr werks from marc into table itab where werks = s_werks and matnr = p_matnr.

if itab[] is not initial.

select matnr alnum from maex into itab1 for all entries in itab where matnr = itab-matnr

end if.

write matnr = p_matnr in select query....................

if u r giving parameter in selection screen mean u r retriving the result only for single material ....belongs to different plants???right................................

in this scenario ...if the proper record is there for u r material definetly it will fetch...if not it wont fetch.......

but it is advisble to give matnr as select option.....

reward points if helpful.................

Re: Table?

Former Member — Fri, 28 Sep 2007 08:41:14 GMT

hi ramya,

thats fine..

but here the problem is for the same material there are different ALNUM values r there in MAEX table.

thats is my problem...

gavas.

Re: Table?

Former Member — Fri, 28 Sep 2007 09:36:24 GMT

yes it will be...............Within each legal regulation, materials are assigned export control classes. Export control classes are used in export licenses to dete

whether the export license covers the export requirements for mater

with this export control class.

The export control class is assigned by the respective authorities.

In the US legal system, the Export Control Classification Number is used

for this purpose (ECCN),

In Germany, the Ausfuhrlistennummer (ALNUM) - export list number- is

used.

different countries will have different alnum values

is there any restriction to retrive to single alnum value to corresponding material.....................u can classify that using embgr right????

jst now i saw for a material number there are two alnum values but embgr is different ...based on this grouping [ by giving 1 or 2 ....] u can overcome

i hope u got the point.............

reward points if helpful

Re: Table?

Former Member — Fri, 28 Sep 2007 09:41:48 GMT

Hi ramya,

can u plz explain it lit bit clearely.

gavas.