Extracting the Quota data

[Former Member]

HI Experts,

I'm doing an extraction for quota arrangement data by using EQUK ,EQUP and MARC tables for an idoc.

I have done well , got output too.

Now the problem is I'm cross chekcing the file data with Table data . Where i have not found any data based QUNUM- Field from both the tables EQUK, EQUP.

Actually table the field pre defined as CHAR .

While entering as inout field for tables it is not taking .

Ex: Qunum values :

                         622985

                         622986

SE11  Table EQUK /EQUP : field is not taking as same.

if we can give as  622985*  as input in the table , then only im getting my record.

please suggest me how to over come this.

Thanks in Advance.

[nabheetscn]

Simply you can do as follow

In QMEL you have 12 char field and EQUK/EQUP has a 10 char field. So simple use conversion exit CONVERSION_EXIT_ALPHA_INPUT for your field and use the output then it will work

Just make sure the field type should have same type as the table on which you are going to make a select.

Nabheet

[Former Member]

HI ,

Thanks for your reply.

Please find the below screen shots and let me know.

I think this will help you more clear about my query.

Regards

[nabheetscn]

Hi

Please give like 0000622987. Add leading zeros it will work..

Nabheet

[Former Member]

Hi,

We have done all the testing.

And we find that dev to quality sys it is diferent. Where quality it is working simple number diaplying the records. and for dev it is not.

Thanks.

[nabheetscn]

My question is simple in output does it display you leading zero's if yes that means you have to always add leading zero before fetching data

[Former Member]

absolutely true.

But for us in Dev system , o\p with out zeros , and for Qua with zeros it is coming.

How do i send this for testing.

[nabheetscn]

If you double click and check do you see any leading zeroo..?

[Former Member]

No leading zeros in dev system. where as in our quality we will get with zeros.

both are quiet opposite results.

[nabheetscn]

Hi Sumalatha

This should not happen..Is their any enhancement that is basically inserting data in this tbale?

Nabheet

[Former Member]

Hi Nabheet,

She is right, I was faced the same situation in earlier.  It works in Quality and not working in DEV.

Finally we found that some support packs issue

It is very difficult to trace the error. finally, I have placed the leading zeros of the field, it worked in all systems.

Rg, Kiran

[nabheetscn]

Hi Kiran

Yes if both quality and development are at different patch level it may be an issue. But still i feel if we add leading zeros it shall work

Nabheet

[Former Member]

Yes, I greed!

Rg, Kiran

[Former Member]

Hi ,

Check "QUNUM"  Field,  Domain "Convers. Routine" is Assign with this Domain (i.e. QUNUM) so use "CONVERSION_EXIT_ALPHA_INPUT" in your case  which is Suggest by .

Regard's

Smruti

[atul_mohanty]

Hi

Use conversion exit 'CONVERSION_EXIT_ALPHA_INPUT' for the field QUNUM as already suggested by some members.

Regards,

Atul Mohanty

[Former Member]

Many Thanks