DTW (Data Transfer Workbench) Price List Update Tutorial - SAP Business One

Подписаться 8 тыс.

Просмотров 9 тыс.

50% 1

📊 WORKING REMOTELY: EFFICIENTLY AND EFFECTIVELY COURSE
remote.battlesh... (FREE!)
🚨 SQL FOR SAP BUSINESS ONE COURSE 🚨
sql.battleshipc... (50% off)
💎 CRYSTAL REPORTS FOR SAP BUSINESS ONE COURSE
crystal.battles... (50% off)
😎 More About BattleshipCobra
battleshipcobra...
🎦 Video Description
This video will show you my process for taking price lists from Excel and uploading them to you SAP Buisness One system using the DTW (Data Transfer Workbench).
💾 Price List LineNum Query
//SQL
SELECT ROW_NUMBER() OVER (ORDER BY T0.[ListNum]) - 1 'LineNum',T0.[ListNum] 'PriceList' , T0.[ListName] FROM OPLN T0 ORDER BY T0.[ListNum]
//HANA
SELECT ROW_NUMBER() OVER (ORDER BY T0."ListNum") - 1 "LineNum",T0."ListNum" "PriceList" , T0."ListName" FROM OPLN T0 ORDER BY T0."ListNum"
📑 Download for Example Spreadsheet
download.battle...
💸 Support These Videos💸
donate.battlesh...

Опубликовано:

4 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@a75820 5 лет назад

I feel it's easier with the import excel option, even though, DTW is faster and give you the error files in case something wrong happens. You should make a tutorial with the import option as well.

@MichaelJTaylor 2 года назад

Hi Greivin, I agree, the DTW seems like a slightly different template for every version. I have been using the SAP Client side import and I have a video already here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9a_etz9wPgQ.html Thanks!

@ThKlein-jv9tr 9 месяцев назад

DTW is faster??? - Not in my experience: importing 12,000 lines took hours, because throughput is around 2 records per second (!). And to be clear: neither is our hardware that bad, nor are small imports handled faster :-(((

@tarmihall3930 4 года назад

Thank you. I've not used SAP in 2 years but withing 14 mins of your tutorial...I'm all good....haha. Although, I cant remember where to get the templates from??

@sidneipsw 3 года назад

Hellow Mike, I hope you be fine! Thank you so much by the help, I got the expected result! Question... Could you explain why the "-1" in the query ? (Basically I know that it decrease the number of the list, but why...?)

@sidneipsw 3 года назад

@@BattleshipCobraSAP Uhuu, thank you so much Mike! Anyway it works well, this litle information could guide me to advance. Great job Mike! See you in the next video! ;)

@RaduCodreanu-i6x 11 месяцев назад

Thx, all clear now.

@BattleshipCobraSAP 5 месяцев назад

Awesome, thanks for watching!

@ricardobovieira Год назад

Thanks a lot! It's working now.

@BattleshipCobraSAP Год назад

Awesome, thanks for watching!

@benjamintrench3561 3 года назад

Excelente, muchas gracias

@RichardGrein 3 года назад

Consegui importar com ajuda do seu vídeo. Obrigado.

@BattleshipCobraSAP 2 года назад

Fantástico, ainda bem que funcionou para você!

@sabiw 4 года назад

For me, this worked differently. I had to use the LineNum you specified, but along with it, I also had to include the PriceList and BasePriceList columns (the real IDs). The other thing, it did not work for me if I used both the OITM and ITM1 txt. I used a single ITM1 txt and I specified the ItemCode with a ParentKey column, as documented here: help.sap.com/viewer/25bde9551224405e84e69c760e272e89/9.3/en-US/aa2d42f312a5479f8b9be4e43bbff58d.html If I used both txt, DTW ran without errors, yet the price lists were not updated (or only a single one, not all of them). If I only specified the LineNum, it throw all kinds of pricelist not defined errors. I used 9.3PL03