on 08-21-2009 9:45 PM
Hello all,
I am currently trying to update existing ship-to and bill-to addresses under the BP master with new Address Names. I am doing the update via DTW and make sure that the new Names match the old names' Line Number under CRD1. But for some reason the old name isnt updated and a new ship-to/bill-to address is created. Any thoughts as why this isnt working?
Thanks in advance,
-Max 2.0
To locate the exact line number of the Ship-to or Bill-To addresses would not be easy. Better uncheck the Importing New Objects so that no new addresses could be added at least.
You may post a sample of your DTW data for others to check.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the quick response Gordon,
I actually only checked Update existing records but for some reason it is actually adding the additional record. Even thought it was just supposed to be an update. Since I am only testing the data right now my header under the oBusinessPartner template looks something like:
RecordKey CardCode
1 C1000
And the oBusinessPartner - BPAddresses lines look something like:
RecordKey LineNum AddressName
1 0 NewName
Thanks again,
-Max 2.0
In my template I do have all the fields populated.....the above was just an example showing what template I am using. I have entered what I thought was the correct linenum but when it is imported SAP has assigned the imported update as a new address with a different linenum then the one in the template.
-Max 2.0
BP file contains
Recordkey,Cardcode
Recordkey,Cardcode
1,C20000
Address file contains
Recordkey,Linenum,Addresstype,Addressname,Block
Recordkey,Linenum,Addresstype,Addressname,Block
1,0,bo_BillTo ,UsedToBe Bill To,NowBlockIsNewBlocker
LineNum is the existing address number stored in the column LineNum of crd1. This example just happens to be changing the first address associated with this customer, so I have zero for LineNum.
After running DTW, the bill to address for C20000 that used to have address name = 'Bill To' now has address name = 'UsedToBe Bill To'. Block was 'Suite 500' and is now 'NowBlockIsNewBlock'.
When you run DTW, during 'Step 3: Check the inport data', look at the Target Data Tab. Make sure that 'Update Schema' is ticked.
That Target Data Tab gave me fits in the past.
Edited by: Cindy Lange on Aug 26, 2009 2:18 PM
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.