topic Re: Modify table in Application Development and Automation Discussions

Modify table

Former Member — Wed, 07 Sep 2005 11:50:33 GMT

Hi,

I have a internal table that I want to clean up a little bit.

Inside i_purchase I have a field name MATNR.

i_purchase-MATNR now is 100727

I want it to be '00000000000100727' (orginal form).

Is this possible without using a loop ?

//MA

Message was edited by: Martin Andersson

Re: Modify table

Vinod_Chandran — Wed, 07 Sep 2005 11:54:35 GMT

Hi Martin,

Use the function module CONVERSION_EXIT_ALPHA_INPUT.

Give i_purchase-MATNR in the parameter INPUT and

give another variable of length 17 in the parameter OUTPUT.

Kindly reward points if this is helpful.

Thanks

Vinod

Re: Modify table

Former Member — Wed, 07 Sep 2005 12:01:20 GMT

Hi,

Hmmm... there are 100000 items in the table... I want to update them all at the same time wihtout using a loop..

Re: Modify table

Former Member — Wed, 07 Sep 2005 12:04:17 GMT

Hi,

Try this:

i_purchase-MATNR = '00000000000100727'.

MODIFY i_purchase TRANSPORTING MATNR WHERE MATNR = '100727'.

Svetlin

Re: Modify table

athavanraja — Wed, 07 Sep 2005 12:08:14 GMT

just convert this(i_purchase-MATNR) field type to NUMC with 18 characters long.

if you move 100727 to i_purchase-MATNR it will be automatically padded with 12 0s in the front.

Regards

Raja

Re: Modify table

Former Member — Wed, 07 Sep 2005 12:12:08 GMT

Hi,

Let me explan a little more...

If u use standard SQL the statement would be something like this:

Update MYTABLE set MATNR = '00000000000' + MATNR

How would this look like when having a internal table ?

//MA

Re: Modify table

Vinod_Chandran — Wed, 07 Sep 2005 12:14:35 GMT

You can use the command UNPACK

Re: Modify table

athavanraja — Wed, 07 Sep 2005 12:16:14 GMT

hmmm not clear.

the leading zeros are padded by the conversion routine at the domain level.

to have it in you internal table if the field is define like mara-matnr then you have to use the function module mentioned earlier. the same can be achieved as i said. (changing the data type to NUMC with lenth 18(as this is the length of matnr in mara))

the only problem with my approach would be that if you matnr is a alpha numberic one , you cannot use the approach i have explained.

Regards

Raja

Re: Modify table

Former Member — Wed, 07 Sep 2005 12:24:36 GMT

Hi,

Hmm...I got the i_purhcase from another FM.

This anothern FM has deleted all the leading '0'.

And now I want It back

//MA

Re: Modify table

athavanraja — Wed, 07 Sep 2005 12:28:30 GMT

copy it to your internal table where the matnr field has to be of typ n with lenth 18. thats all you need. it will automatically be padded with leading zeros.

Regards

Raja

Re: Modify table

athavanraja — Wed, 07 Sep 2005 12:43:05 GMT

if you find the answers helpful, reward them and if the question is answered, please mark it as answered and close the thread.

Regards

Raja

Re: Modify table

Former Member — Wed, 07 Sep 2005 12:47:55 GMT

Did you check this "another FM" to see if there is a setting not to convert the material number to output format? MATNR in your i_purchase should be defined as NUMC(18).

Srinivas