cancel
Showing results for 
Search instead for 
Did you mean: 

How ADRNR will be generated when create masterdata(comp.code/vendor/custom)

Former Member
0 Kudos

Dear All,

I would like to know how t001-ADRNR will be generated when we create company code/vendor/customer.

where we can assign the number range to ADRNR?

thanks in advance...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

These are master data objects. These objects are linked to the address management function of SAP. When a new master is created, the system checks the relevancy of the master for address management and if found relevant assigns an ADRNR number to it. The function module that checks relevancy and assigns the number range to it is usually ADDR_NUMBER_GET. The address data for the master is then stored with this number as the key in table ADRC.

The number range for ADRNR is "01" which is maintained through SA01. There is another number range "10", which is used for manual sales documents.

For all practical purposes the number "01" is relevant.

cheers.

Former Member
0 Kudos

Thanks Mr.Neeraj for your quick reply, can we assign diffrent numer range(ADRNR) for master data like company code adrnr , custmer Adrnr , etc...

is it possible? if so how i can do?

Former Member
0 Kudos

Hi,

First, the answer to your question, no, you cannot change it.

The number range is hard coded as "01" in all the programs.

Second, Why do you want to do this, it has no practical use.

Cheers.

Former Member
0 Kudos

Hi Mr.Neeraj,

The problem i am facing is:

when i change the address of comp.code//business place and transport to production. so it is taking exising adrnr number in the production. that is that number is allready given to customer/vendor/com.code/business place in production.

I gues the root cause is: is this may be directly updating ADRC (standard tables) ? some one before directly updated . at the time of upgrading from 4.6c to 4.7 what they did is they directly updated ADRC tables.. i guess . this is root cause of the problem.

thanks advance.

Former Member
0 Kudos

Hi,

The transport for a company code does take the address table, however it does not return an error because of ADRNR. There is a high probability that the ADRNR in your PRD system will not match with the ADRNR in DEV for the same company code. Even in our systems the same scenario exists but there is no error in transport.

Can you send the details of the error you receive in the transport.

Cheers.

Former Member
0 Kudos

HI Neeraj, Thanks for you time.

when upgrading from 4.6c to 4.7: some consultants are downloaded tables data from ADRC(SAP 4.6c-production)and uploaded into ADRC table(SAP 4.7-production) diretly. because of this the generated number in the production is some time allready present in the respective tables. So this is causing conflict.

So how to solve this case.. pl let me know if you need any clarification.

thanks in advance..

Former Member
0 Kudos

Hi,

Can you check this:

1. Open T001 table in SE11. Pick a company code you are facing a problem with. In the table, check the ADRNR.

2. Go into table ADRC, enter this ADRNR and see the output. Does it show the address of the company code?

If it does then your transport will not have a problem. But if it doesn't then, I assume then you would have a problem. But even then , a tranport should change the earlier address in ADRC and bring it to the same for the company code.

But the real problem will only arise, when the number range status (in SA01) is less that what is actually present in the ADRC table. To set this right, here is what you should do:

From table ADRC, check the highest number of the ADRNR table. In SA01 look at the status of number range "01", if it is less than the highest number in ADRC, then, increase the number under the column current number to the one already present in table ADRC.

This should solve your problem.

Cheers.

Former Member
0 Kudos

Hi,

i checked J_1BBRANCH-adrnr with the same adrnr i checked in adrc-adrnr but it dont have same address(not address of Business place,but it is address of customer).

when i created test company and it generated address number, again i checked in SA01, but this number is not in that range.

this is before creation of company code

for ex: in SA01 i find for 01 number range is :0000000001 to 0049999999 , current no is :112027

after creating company code

in SA01 i find for 01 number range is :0000000001 to 0049999999 , current no is :112027

t001-adrnr is 112012.

it means that adrnr is not generating from that address range ...

please comment on this...

i agree with your suggestion of replacing current number with max adrnr number in adrc table. but in which tcode i have to change the current number?

thanks in advance

Former Member
0 Kudos

Hi,

SE11, table ADRC, Enter ADRNR range as 112027 to 199999 or you can use the multiple select option for >112027. The first option will ensure you do not get number range 10 in the output. Find out the highest number for ADRNR fornumber range 01.

Open transaction SA01, in the screen there is a button for status, click on that. The number range screen will open with the current status column open for input. Change the number to the highest number available in ADRC table; save and you should be ok.

Cheers.

Former Member
0 Kudos

HI Mr.Neerj, thanks for your time.

when i created test company and it generated address number, again i checked in SA01, but this number is not in that range.

this is before creation of company code

: in SA01 i find for 01 number range is :0000000001 to 0049999999 , current no is :112027

after creating company code

in SA01 i find for 01 number range is :0000000001 to 0049999999 , current no is :112027

t001-adrnr is 112012.

it means that adrnr is not generating from that address range ...

when i create customer also

it is not taking the number from this range

for ex:

before creation of customer status in sa01

in SA01 i find for 01 number range is :0000000001 to 0049999999 , current no is :112027

after creation of customer status in sa01

in SA01 i find for 01 number range is :0000000001 to 0049999999 , current no is :112027

customer kna1-adrnr is 112015

it means that it is taking the number range not from sa01..

please comment on this...

number range for 10 is :

10 9000000000 9999999999 9000100539

Former Member
0 Kudos

Hi,

The number range object for address is usually buffered by 20, i.e. whenever you do a transaction which results in the creation of an address number, 20 numbers are buffered.

In your specific case what this means is that there is buffering up to 112027. This number in SA01 will not change till the time you reach it. The moment you do, another 20 will be buffered during the next create transaction.

If your new customer was assigned a number of 112015, create 12 more and the number in SA01 will not change, the moment you create the 13th , the number should get buffered by another twenty and should show 112047.

Can you tell me the highest ADRNR in _ADRC_ table in the '01' number range?

Cheers.

PS: If you want to check buffering, go to Tcode SNRO, enter ADRNR in the object field and click on display. You should see the value 20 against No. of numbers in buffer

Former Member
0 Kudos

Hi,

highest ADRNR in ADRC table in the '01' number range is 112028.

then i have to enter the current address status = 112028+ 20 = 112048 or even more than that

safe side 112060..is better?

Answers (0)