🎦 Video Description
Do you want to update your price lists quickly without the use of the DTW? This video shows you how to export your price list information to Excel and then format it and upload it through the SAP Business One client directly from your workstation even without server access.
💾 Price List Queries
-- SQL
SELECT
T0.[PriceList] AS 'Price List No.'
,T0.[ItemCode] AS 'Item No.'
,T1.[BASE_NUM] AS 'Item No, Base Price List No.'
,T1.[Factor] AS 'Item No, Factor'
,CASE T0.[Price] WHEN 0 THEN '' ELSE CAST(T0.[Price] AS VARCHAR) END AS 'Item No, List Price'
,T0.[Currency] AS 'Item No, Currency for List Price'
,CASE T0.[AddPrice1] WHEN 0 THEN '' ELSE CAST(T0.[AddPrice1] AS VARCHAR) END AS 'Item No, Additional Price (1)'
,T0.[Currency1] AS 'Item No, Currency for Add. Price 1'
,CASE T0.[AddPrice2] WHEN 0 THEN '' ELSE CAST(T0.[AddPrice2] AS VARCHAR) END AS 'Item No, Additional Price (2)'
,T0.[Currency2] AS 'Item No, Currency for Add. Price 2'
FROM
ITM1 T0
INNER JOIN OPLN T1 ON T0.[PriceList] = T1.[ListNum]
WHERE
T1.[ListName] = '[%0]'
ORDER BY T1.[ListName], T0.[ItemCode]
-- HANA
SELECT
T0."PriceList" AS "Price List No."
,T0."ItemCode" AS "Item No."
,T1."BASE_NUM" AS "Item No, Base Price List No."
,T1."Factor" AS "Item No, Factor"
,CASE T0."Price" WHEN 0 THEN '' ELSE CAST(T0."Price" AS VARCHAR) END AS "Item No, List Price"
,T0."Currency" AS "Item No, Currency for List Price"
,CASE T0."AddPrice1" WHEN 0 THEN '' ELSE CAST(T0."AddPrice1" AS VARCHAR) END AS "Item No, Additional Price (1)"
,T0."Currency1" AS "Item No, Currency for Add. Price 1"
,CASE T0."AddPrice2" WHEN 0 THEN '' ELSE CAST(T0."AddPrice2" AS VARCHAR) END AS "Item No, Additional Price (2)"
,T0."Currency2" AS "Item No, Currency for Add. Price 2"
FROM
ITM1 T0
INNER JOIN OPLN T1 ON T0."PriceList" = T1."ListNum"
WHERE
T1."ListName" = '[%0]'
ORDER BY T1."ListName", T0."ItemCode"
📚 Chapters
00:00 - Pilot Introduction
00:45 - Scenario Description
02:00 - Price List Import Overview
03:55 - Extract to Excel
04:29 - Editing Prices
07:50 - Creating Import File
08:49 - Import from File
10:20 - Pilot Outro
💼 Working Remotely: Efficiently and Effectively Free Course ☕
remote.battleshipcobra.com (Free)
🧮 SQL FOR SAP BUSINESS ONE COURSE NOW AVAILABLE 📈
sql.battleshipcobra.com (50% off)
📊 CRYSTAL REPORTS FOR SAP BUSINESS ONE COURSE 💎
crystal.battleshipcobra.com (50% off)
🎉ADVERTISE IN MY VIDEOS 🎊
advertise.battleshipcobra.com
😎 More About BattleshipCobra
battleshipcobra.com/
💸 Support These Videos
donate.battleshipcobra.com/