Number Range for Position Object for LSMW

[Former Member]

I am trying to upload data for Position object through LSMW. I am using Tcode PP02. For testing purpose, I have created the upload file with just two records. While executing step 14, I faced the following error: "The number indicated is not in any valid external interval". While recording I had given the Position id (SEARK) as 50006510. In the upload file the values for Position Id's (SEARK) are 50006511 and 50006512.

In "Maintain Muber ranges" (Tcode OONR), the values for 01S subgroup are as below:

No. from Number To Number Current Number Ext

EX 00000001 49999999 Checked

IN 50000000 99999999 50009599 Unchecked

Please let me know where I am going wrong

-Shambhvi

[Former Member]

Thanks for the help! My issue is resolved.

-Shambhvi

[Former Member]

Hi

The number range for position is defined as external or internal ?

If it is external then the number range provided by you is not in the range of external numbers so it is throwing the error.

R K

[sikindar_a]

while uploading please ensure that you shd have external no range one the upload is done you have to go with internal no range

[Former Member]

Ok. But from the data that has been set up for Number Ranges, the external number range is active. Do you mean to say that while recording, I should use the Position id as Current Number +1 and in the upload file also the numbers have to be greater than Current Number +1? Will that solve my problem? Whatever reocrd we creare during recording, will it also actually get created in the database or is it for only recording purposes?

-Shambhvi

Edited by: shambhvi murthy on May 30, 2011 10:08 AM

[Former Member]

Hi

During upload please make the number range external if you want to provide the numbers for the positions and if you want system to provide the number the make it internal.

R K

[Former Member]

Whatever reocrd we creare during recording, will it also actually get created in the database or is it for only recording purposes?

Yes, recording also create record in database. You can check it in PO13 T-code.

If you want to create position in 5000000 series by manual no. assignment for object than make it external no. range.

Rgds,

Lata

[Former Member]

Since recording also creates a record in the database, if I have to upload, let us say, 50 positions which are in the upload file, then I have to delete the first position record and use it for recording purpose. Am I right? This is assuming I am using an external number range and all the numbers in the upload file have a continuous numbering in the scending order (10002000, 10002001, 10002002... etc.).

-Shambhvi

Edited by: shambhvi murthy on May 30, 2011 12:10 PM

[sikindar_a]

No Need of deletion of the first position , while uploading Assign the number series outside SAP and upload once it is done make it as internal

[Former Member]

Sorry, I did't get you! Let us say in the upload file, my Positions are numbered 20001000, 20001001 .... upto 20001050. So, I will create an external number range from 20001000 to say, 49999999 and then upload the data. after the datga is correctly uploaded, I will change the range to "Internal". Am I right? But for the Position record that I create during recording, what number should I assign?

-Shambhvi

[sikindar_a]

Assign 20001000 there will be no problem and in excel sheet update the no ranges from the next number

[Former Member]

Fine. That means my upload file will have Position numbers from 20001001 to 20001050 (49 rows) and NOT from 20001000 to 20001050 (50 rows). The Position number 20001001 should be used for creating the Position recrod through "Recording".

-Shambhvi

[Former Member]

Since you have maintained external number range for position is 00000001 to 49999999, hence you need to maintain the Position number with in the range specified in your input file.

Edited by: Rajesh Jogiparthi on May 30, 2011 2:50 PM