on 12-01-2008 3:43 AM
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...
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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..
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.
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
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.
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
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
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.