Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hello,
When you have a character field that is searchable always fill the field with zeros in front, eg 0021, 0031. My client has the same issue for some classification data that they have maintained too.
I guess it seems that maybe on your SAP projects there never any template used for number ranges, organizational data. You may have two legacy systems that were never done with an ETL process.
Regards
Waza
| | | ---------------Original Message---------------
From: Mat
Sent: Wednesday, March 16, 2011 5:24 PM
Subject: Company codes with 2 characters and 4 characters - sorting issue
Hi
We have some company codes in our system with 2 characters and some with 4 characters. For example,
01
20
2000
31
4000
4001
When the users run the reports (for instance, FBL1N) and include a range for company codes such as 2000 to 4001, they expect only three company codes 2000, 4000 and 4001 to be picked up. But the system is selecting 2000, 31, 4000 and 4001.
We have asked the users to not use a range, but just list the company codes in the multiple selection. But did anyone have a similar issue and were able to get the company codes (ones with numeric values) sorted correctly? |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  wnash7658
SAP Accounting Enthusiast
Contributed 500 posts in a group to earn a Silver Achievement Most Popular White Papers
In the Spotlight  _.____.__ |
