RE: RE: Upload Item Location (F41021Z1)
Anton, Jane,
I would pretty much agree with Jane - copy/paste is a lot easier then
SQL scripts. But, I think I have mentioned it, we had more then 100'000
(hundred thousand) records, and copy paste was not an option.
We were uploading item master and item balances via cycle count, and
were loading the following tables: F4101z1, F4102, F41021, F4105z1,
F4141z1. F4111 will be updated by the cycle count, and F4602 was not
involved (I don't even know what it stands for, if it's pricing, then we
did not need it, otherwise I don't know). If you need to know more, what
and how to load - search for an e-mail by Rafal (rmolas in the List if I
remember correctly), who explained it in detail (it was a couple of
month ago).
A hint - if you are uploading a huge number of records (as we did) - try
loading items and everything from Z-files in several batches, in
parallel. All of UBE's, which are used, support parallel processing, and
they are not very resource hungry (5 Item Master Z-file postings running
in parallel took only 65% of processor time on 3way HP box (Oracle)
(compared to less then 10% for one UBE, which is a waste of computer
power, IMHO)). Decrease in run time is quite significant (from 3 records
per second to up to 12 per sec in our case). Unfortunately, it is quite
dangerous to run a different type of Z-posting UBE in parallel (you cant
post item costs while you are still posting item master records - messes
things up). But you can load F41021 independently from F4101 (just make
sure you don't have any orphans in the end), because it's just SQL.
Good luck,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
PS: Process was run in B7332, SP13.3 on HP UX (3way, 2Gig RAM), Oracle
8.1.5i, UBE's were run on enterprise server, SQL was run in Access via
native (not MS) ODBC drivers, your mileage may be different.
PPS: Hi there, Rafal.