on 09-17-2008 12:15 PM
- What are the uses of 'record key' and 'line number' in the DTW template?
So It is like indexing the records? okie..
Let me tell you a scenario. Please tell me what would be the result.
scenario 1:
Items to be uploaded: 200
number of templates: 2 ( 100 items per template)
I define the record key 1- 100 for the 100 items in the first template
I also define the record key 1-100 (not 101 -200) in the second template
In this attempt, what will be the result? will the second template items update the first template items?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If 100 items are import twice using same record key, the result is entry exist in the table error message. It will not success to import the data. you won;t be able to import but only update.
if 200 items are different but you also still use the same record key, the error message will still as same as above.
Rgds,
Hi
'Record key' is a unique one. U have to use the same 'record key' to update the existing records. for Ex. U uploading a new BP record with customer name XYZ. U missed out the pincodes.. u can use same record to update otherwise it will give error or it will create a new record.
Line number is a Normal one which is more than one record.
By
Kalai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
record key is an Entry key that uniquely identifies the record. For example you have more than one data, so using the record key it will be helpful to identity by system in the documents, master data and other transactions.
line number is Line number in the record lines. So, if one record have more than one number, you must use line number.
Both are not exposed to SBO UI. you could only see them in the table directly or using query.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.