Skip to Content
0

APO leading zero in table /SAPAPO/MATMAP

Apr 13, 2017 at 01:57 PM

51

avatar image
Former Member

Hello,

I have a question concerning material master management in APO system where we would kindly require your help and support.

BACKGROUD

We are moving all systems to a new landscape, meaning:

SAP ECC we will migrate into another system already used by another company

SAP APO we will copy it (together with master data) to have a new system which will be connected to the above ECC.

There is an important difference between the two SAPO ECC system (as-is and future target) about material master number management in SPRO -> Logistics general -> Material master -> Basic settings -> Define Output Format of Material Numbers [OMSL transaction]:

As-is system has Material No. Length = 18 & Lexicographical = null & Leading Zeros = null

Target system has Material No. Length = 12 & Lexicographical = X & Leading Zeros = X

This means that in as-is system the material will be displayed as 12345678 but will be technically stored with unconverted values in tables as 000000000012345678.

In target system, the two values are the same (no zeros additionally recorded in the tables).

ISSUE IN NEW APO

We did the CIF configuration in target DEV ECC and created integration models. While activating the integration models, we are getting an error for material in Queue monitor (see attachment).

Basically, it is saying that material cannot be created because already existing.

When we check the /SAPAPO/MATMAP table in APO system, already existing materials (we copied the system with all master data) are stored with zeros in the field EXT_MATNR. New materials are getting saved without zeros, because in new target ECC the zeros are not added in the tables.

Is there a way to use any report to “clean” the APO tables in order to remove the zeros, in order to be able to use the system without any huge impact?

Or, did anyone had similar issue and how solved without changing manually all data? DId you prepare a Z* report to remove the zeros from the mentioned table (and are there many more tables referred to that, which we will need to change anyway)?

Thanks a lot for your help!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers