cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding supress zeerows in reporting

Former Member
0 Kudos

Hi experts,

This is my 0material number(000000000009400001) ,it's length is 18 and the same as in data target,but when execute the query i want display the no like this 9400001,i don't want before all zeeroos,pls let me know how to do

Thanks

chandra.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Reddy,

goto query designer-->change the settings in Material >right click on the materail>properties>Display of results> give suppress result rows-->allways & change and see the normalization settings.

Hope this helps you.

Regards

Pcrao.

former_member205352
Active Contributor
0 Kudos

Have you used MATN1 conversion for your material info object.Use this conversion

Hope this helps.

Former Member
0 Kudos

Hi Praveen,

already alpha convertion is MATN1

CHANDRA

Former Member
0 Kudos

I think leading zero can be suppress if the characteristics has conversion ALPHA, in infoobject maintenance

Former Member
0 Kudos

hi,

try the Suppress Zeros under the Rows/columns tab in the Query properties.