#sapb1 — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sapb1, aggregated by home.social.
-
Affordable ERP Software for Small Business: No More Excel Chaos! 🚀
🛑 STUCK IN SPREADSHEET CHAOS?
Stop drowning in messy Excel files and take control of your business with a powerful ERP solution.
📺 Watch Overview: https://youtu.be/Ca7GjdZBsPo?si=XP89-BlXCuatj1tK -
Affordable ERP Software for Small Business: No More Excel Chaos! 🚀
🛑 STUCK IN SPREADSHEET CHAOS?
Stop drowning in messy Excel files and take control of your business with a powerful ERP solution.
📺 Watch Overview: https://youtu.be/Ca7GjdZBsPo?si=XP89-BlXCuatj1tK -
Affordable ERP Software for Small Business: No More Excel Chaos! 🚀
🛑 STUCK IN SPREADSHEET CHAOS?
Stop drowning in messy Excel files and take control of your business with a powerful ERP solution.
📺 Watch Overview: https://youtu.be/Ca7GjdZBsPo?si=XP89-BlXCuatj1tK -
Affordable ERP Software for Small Business: No More Excel Chaos! 🚀
🛑 STUCK IN SPREADSHEET CHAOS?
Stop drowning in messy Excel files and take control of your business with a powerful ERP solution.
📺 Watch Overview: https://youtu.be/Ca7GjdZBsPo?si=XP89-BlXCuatj1tK -
Proud to share the successful Kick Off of SAP Business One for a leading Wire and Cables Manufacturing Company 🏭🔌
A critical milestone that sets the direction for a structured, efficient, and scalable ERP journey ahead! 🚀
Excited for what's coming next! 💼✨
#SAPBusinessOne #SAPB1 #KickOff #KabeerConsultingGroup #WireAndCableIndustry #CableManufacturing #ERPImplementation #ManufacturingExcellence #SAPConsulting #DigitalTransformation
-
⛽ Struggling with asset tracking, compliance and operations in oil & gas?
SAP B1 ERP solution, tailored for the oil & gas industry, helping companies gain real-time visibility, automate operations and stay compliant.🔗 https://www.kabeerconsulting.com/industries/sap-b1-oil-gas/
📺 https://youtu.be/AhBWcpY7keY?si=fb50pWEJ3x3YsH4z -
Vendor Self-Service Portal streamlines procurement workflows, reduces manual communication, and improves supplier engagement — all while staying integrated with your SAP B1 system.
🔗 https://www.kabeerconsulting.com/vendor-self-service-portal/
📺 https://youtu.be/QN5_DN1xuW8?si=lmut-Rz1pCWfUvor -
Dealer Management System for SAP B1 is a centralized solution designed to manage dealer operations efficiently across sales, inventory, finance, and after-sales processes.
🔗 https://www.kabeerconsulting.com/sap-b1-dealer-management-system-dms/
📺 https://youtu.be/myVNBG6VFs4?si=4WAYl4vddKolimII -
Biometric Integration Addon for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking & workforce management
🔗Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
📺 Watch Overview: https://youtu.be/gD4a9aLrokM?si=UtCkMUJk3FKhmNQ8 -
Biometric Integration Addon for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking & workforce management
🔗Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
📺 Watch Overview: https://youtu.be/gD4a9aLrokM?si=UtCkMUJk3FKhmNQ8 -
Biometric Integration Addon for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking & workforce management
🔗Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
📺 Watch Overview: https://youtu.be/gD4a9aLrokM?si=UtCkMUJk3FKhmNQ8 -
SAP B1 ERP for Dairy Industry | End-to-End Milk Processing Management
Kabeer Consulting brings you a customized ERP solution for the dairy industry, built on the world’s #1 ERP platform – SAP B1
🌐 https://www.kabeerconsulting.com/industries/sap-b1-dairy-milk/
🔗 https://youtu.be/fh20GbqFTbo?si=k0Hy1WPpPHh6-m6m -
Automate your GST reconciliation with our SAP B1 Addon. Effortlessly match purchase and sales data with registered returns to ensure total accuracy and seamless tax compliance.
🌐https://www.kabeerconsulting.com/gst-reconciliation-addon-for-sap-b1/
🔗https://youtu.be/41MEzXVSXnA?si=zWdHa1LcuhwDNgHk -
Automate your GST reconciliation with our SAP B1 Addon. Effortlessly match purchase and sales data with registered returns to ensure total accuracy and seamless tax compliance.
🌐https://www.kabeerconsulting.com/gst-reconciliation-addon-for-sap-b1/
🔗https://youtu.be/41MEzXVSXnA?si=zWdHa1LcuhwDNgHk -
Automate your GST reconciliation with our SAP B1 Addon. Effortlessly match purchase and sales data with registered returns to ensure total accuracy and seamless tax compliance.
🌐https://www.kabeerconsulting.com/gst-reconciliation-addon-for-sap-b1/
🔗https://youtu.be/41MEzXVSXnA?si=zWdHa1LcuhwDNgHk -
Automate your GST reconciliation with our SAP B1 Addon. Effortlessly match purchase and sales data with registered returns to ensure total accuracy and seamless tax compliance.
🌐https://www.kabeerconsulting.com/gst-reconciliation-addon-for-sap-b1/
🔗https://youtu.be/41MEzXVSXnA?si=zWdHa1LcuhwDNgHk -
Great Day Everyone! 🚀
We are Extremely Happy to share a proud milestone with you all — the successful Go-Live of our Barcode / QR Code Add-on integrated with SAP Business One for a leading Fastener Manufacturing Company in India!
A huge appreciation to our incredible Sales Team, Support Team, and Functional Experts who worked tirelessly to make this project a grand success 👏👏
#SAPB1 #GoLive #Barcode #QRCode #Manufacturing #DigitalTransformation #ERPforSME #KabeerConsultingGroup
-
Bank Integration & Vendor Payment Add-on for SAP B1 | Automated Payments Solution
Managing vendor payments manually in SAP B1 can be time-consuming and error-prone.
🔗 https://www.kabeerconsulting.com/bank-and-vendor-payment-addon-for-sap-b1/
📺 https://youtu.be/b2So9tEmZ0k?si=7NvCSn4ueAAnuM9Q -
WhatsApp Add-on for SAP B1 enables seamless communication between your ERP system and customers through WhatsApp, automating notifications and improving customer engagement.
🌐 https://www.kabeerconsulting.com/whatsapp-addon-for-sap-business-one/
📺 https://youtu.be/b4xC_Minp1w?si=Fq7KG-pWz2i_jzE_ -
Dealer Management System for SAP B1 is a centralized solution designed to manage dealer operations efficiently across sales, inventory, finance and after-sales processes
🌐 https://www.kabeerconsulting.com/sap-b1-dealer-management-system-dms/
🔗 https://youtu.be/myVNBG6VFs4?si=9HEI0qPhjVXK75oU -
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility
🌐 https://www.kabeerconsulting.com/transport-management-system/
🔗 https://youtu.be/eFi7T9crD6o?si=57qZfgQvv1QfcLeQ -
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility
🌐 https://www.kabeerconsulting.com/transport-management-system/
🔗 https://youtu.be/eFi7T9crD6o?si=57qZfgQvv1QfcLeQ -
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility
🌐 https://www.kabeerconsulting.com/transport-management-system/
🔗 https://youtu.be/eFi7T9crD6o?si=57qZfgQvv1QfcLeQ -
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility
🌐 https://www.kabeerconsulting.com/transport-management-system/
🔗 https://youtu.be/eFi7T9crD6o?si=57qZfgQvv1QfcLeQ -
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility
🌐 https://www.kabeerconsulting.com/transport-management-system/
🔗 https://youtu.be/eFi7T9crD6o?si=57qZfgQvv1QfcLeQ -
Biometric Integration Add-on for SAP B1 enables seamless integration of biometric attendance devices with SAP B1, automating employee attendance tracking and workforce management
🔗 Learn more: https://www.kabeerconsulting.com/biometric-integration-addon-for-sap-b1/
-
SAP B1 ERP for Metal Industry | ERP for Inventory, Scrap, and Production Tracking , built to handle everything from procurement to production, quality & dispatch all in one system
▶ Watch the Course Preview: https://youtu.be/cNMcMZYFVhQ?si=uRgpdgZ9Jfiep2Pu
https://www.kabeerconsulting.com/industries/sap-b1-metal-industry/ -
SAP B1 ERP for the Food Industry, streamline your entire process — from sourcing to production to delivery — while staying fully compliant and traceable.
🔗 Learn More: https://www.kabeerconsulting.com/industries/sap-b1-food-industry/
https://youtu.be/b-wBBOXiKSE?si=DztSBZqoJFtFxbqN -
Best ERP for Oil & Gas Industry | ERP for Operations, Inventory & Compliance | SAP B1
🏭 Designed for refineries, EPC contractors, service providers, oilfield equipment companies, and petrochemical units.
https://www.kabeerconsulting.com/industries/sap-b1-oil-gas/ -
Transport Management System for SAP B1 automates logistics planning, shipment tracking, and freight cost control. SAP TMS Solution improves transportation efficiency and supply chain visibility.
Request a demo: https://www.kabeerconsulting.com/transport-management-system/ -
May Lord Hanuman bless you with strength, courage, and success. Wishing you growth, prosperity, and positivity in all your endeavors.
Happy Hanuman Jayanti by Kabeer Consulting Group#HanumanJayanti #HappyHanumanJayanti #BusinessGrowth #Success #Strength #Prosperity #SAPB1
-
SAP B1 ERP for Medical Devices Industry | Kabeer Consulting Group
Looking for a reliable ERP to manage compliance, inventory, and quality in the medical devices sector? SAP Business One has it all
Get a Free Demo: https://www.kabeerconsulting.com/industries/sap-b1-medical-devices/ -
Ecommerce Integration Add-on for SAP B1 enables seamless connectivity between your online store and SAP ERP, ensuring real-time data synchronization across platforms.
https://www.kabeerconsulting.com/ecommerce-integration-with-sap-b1/ -
SAP B1 ERP for Food Industry | ERP for Batch Control, Shelf Life & Quality
🍞 Running a food business and tired of juggling spreadsheets, quality logs, and manual tracking?
-
Top SAP B1 Partner in Noida | Expert ERP Solutions by Kabeer Consulting
Kabeer Consulting delivers ERP solutions that streamline operations, boost productivity, and support growth for businesses in Noida and beyond. -
🚀Kabeer – A Global SAP Partner needs your attention for a quick announcement!
We are delighted to inform you all that we have officially kicked off the SAP Business One implementation for a large company in the Poly-Chem Industry based in Delhi.
This is a great achievement and a reflection of the hard work, dedication, and teamwork shown by everyone involved.
Very well done, Team! 👏
#SAPBusinessOne #SAPB1 #SAPImplementation #GlobalSAPPartner #ERPForChemical #PolichemIndustry
-
Best Maintenance Management Application for SAP B1
-
Best Maintenance Management Application for SAP B1
-
Best Maintenance Management Application for SAP B1
-
Best Maintenance Management Application for SAP B1
-
Zoho CRM Integration with SAP Business one | Automated Lead Sync Solution
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Great Day Everyone!
We are extremely Happy and proud to announce you all that we have successfully did the Go-Live of SAP Business One with a leading company in the Healthcare industry! 🚀
Great Work done by Sales Team & by our Support & Functional Team in making this project successful 👏👏
#SAPBusinessOne #GoLive #HealthCare #SAPB1 #AffordableERP #ERPforSME #KabeerConsultingGroup #SAPPartner
-
Introducing HANA
While I had planned something about the General Ledger for this newsletter, circumstances changed, so I’ll do something entirely different.
As many of you know, I’m no longer with Scientific Device Laboratory. If you’d like to know more about that situation, I have described it in detail here, but the very short version is that I lost the ability to access SAP B1 for this newsletter for the last nine months.
Fortunately, I found someone to help. Richard Duffy and SMB Solutions are graciously providing me with a new Demo instance of SAP Business One, but with one Wrinkle: It is HANA.
Before I go into anything other topics, I’m writing a series of newsletters about how HANA affects SAP B1. We’ll cover the basics of how to write queries in HANA for those curious or needing to translate SQL to HANA and back. Once we have all that, I’ll share with you what I plan to do about writing this newsletter on a HANA system. I’ll assume you know SQL or have taken my course SAP Business One Reporting and Customization.
First, let’s give a little background on HANA. SAP decided several years ago to make a database system they could use across their product line. It has its pluses and minuses. The marketing for HANA was often around its speed due to the in-memory column-based database.
Data in a computer system is stored in dimensional sequence, not the two dimensions we associate with a table. It is as if you had a spreadsheet of only one row.
The best we can do to represent a table is to take the rows or the columns as groups, add them in sequence, then add the next row or column.
Let’s suppose you had this table:
The data would be stored in row order like this in a row-based database.
This is fast for performance in adding and deleting data but presents performance problems in calculations. To get a sum for balances, for example, you have to load each row, get the balance, add it to the total, and then get the next row, which is lots of work.
On the other hand, a column-based database would do this:
All the data for the columns are grouped. To get a sum, it loads the column and sums it. Unlike the Row-based arrangement, there is no jumping around in the data, making it much faster. However, this usually requires in-memory access to the data instead of on-disk access. Such an arrangement requires a substantial amount of memory to run efficiently. Also, insertions and deletions of rows are more complicated as you add data in several places, not as one group.
HANA is not the only column-based database. Data analysis tools like Pandas and even Microsoft SQL Server 2012 have in-memory processing in columns.
Because the HANA implementation of the SAPB1 started from scratch, you will notice a different User interface when running HANA compared to a SQL Server version of Sap Business One. My disparaging quip about SAP B1 UI being as fashional as Windows 95 is no longer accurate.
I’ll discuss this UI in a later column, but from now on, you’ll see screenshots like this in my newsletters.
The real fun begins when you start making queries. HANA has its variant of SQL. Creating a query in the SAP B1 Query Generator of the names and quantities of inventory items produces this query.
SELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited",T0."OnOrder" FROM OITM T0
You’ll notice the double quotes on the column names. Double quotes are required on column names. Some, like the table name, have optional quotes, but putting quotes around all tables, columns, and aliases like TO is legitimate and often good style.
SELECT "T0"."ItemCode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "OITM" "T0"
What’s in the Quotes is case-sensitive. Can you spot the two errors here?
SELECT "T0"."Itemcode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "oitm" "T0"
“T0″.”Itemcode” and “oitm” do not have the proper case. Interestingly, it will work if I do oitm without quotes.
Comments are still two dashes. Like many other programming languages, HANA adopts the
/*and*/for block comments.-- This is a comment/*This is a block comment. You can add several lines until you use the termination character on the next line.*/
Basic selection, literal strings with single quotes, and sorting also work the same as SQL: this query works with a parameter and sorting:
-- A comment is two dashesSELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM OITM T0 WHERE -- Compound data filter T0."SellItem" = [%0] -- Parameter AND T0."PrchseItem" = 'Y' -- String Literal AND T0."OnHand" > 0 -- ComparisonORDER BY T0."IsCommited" -- Sorting
If you look at only the basics, HANA looks a lot like SQL. However, once you get past the syntax, HANA starts getting different from SQL. In the next newsletter, I’ll look at some commonly-used functions in HANA.
-
Introducing HANA
While I had planned something about the General Ledger for this newsletter, circumstances changed, so I’ll do something entirely different.
As many of you know, I’m no longer with Scientific Device Laboratory. If you’d like to know more about that situation, I have described it in detail here, but the very short version is that I lost the ability to access SAP B1 for this newsletter for the last nine months.
Fortunately, I found someone to help. Richard Duffy and SMB Solutions are graciously providing me with a new Demo instance of SAP Business One, but with one Wrinkle: It is HANA.
Before I go into anything other topics, I’m writing a series of newsletters about how HANA affects SAP B1. We’ll cover the basics of how to write queries in HANA for those curious or needing to translate SQL to HANA and back. Once we have all that, I’ll share with you what I plan to do about writing this newsletter on a HANA system. I’ll assume you know SQL or have taken my course SAP Business One Reporting and Customization.
First, let’s give a little background on HANA. SAP decided several years ago to make a database system they could use across their product line. It has its pluses and minuses. The marketing for HANA was often around its speed due to the in-memory column-based database.
Data in a computer system is stored in dimensional sequence, not the two dimensions we associate with a table. It is as if you had a spreadsheet of only one row.
The best we can do to represent a table is to take the rows or the columns as groups, add them in sequence, then add the next row or column.
Let’s suppose you had this table:
The data would be stored in row order like this in a row-based database.
This is fast for performance in adding and deleting data but presents performance problems in calculations. To get a sum for balances, for example, you have to load each row, get the balance, add it to the total, and then get the next row, which is lots of work.
On the other hand, a column-based database would do this:
All the data for the columns are grouped. To get a sum, it loads the column and sums it. Unlike the Row-based arrangement, there is no jumping around in the data, making it much faster. However, this usually requires in-memory access to the data instead of on-disk access. Such an arrangement requires a substantial amount of memory to run efficiently. Also, insertions and deletions of rows are more complicated as you add data in several places, not as one group.
HANA is not the only column-based database. Data analysis tools like Pandas and even Microsoft SQL Server 2012 have in-memory processing in columns.
Because the HANA implementation of the SAPB1 started from scratch, you will notice a different User interface when running HANA compared to a SQL Server version of Sap Business One. My disparaging quip about SAP B1 UI being as fashional as Windows 95 is no longer accurate.
I’ll discuss this UI in a later column, but from now on, you’ll see screenshots like this in my newsletters.
The real fun begins when you start making queries. HANA has its variant of SQL. Creating a query in the SAP B1 Query Generator of the names and quantities of inventory items produces this query.
SELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited",T0."OnOrder" FROM OITM T0
You’ll notice the double quotes on the column names. Double quotes are required on column names. Some, like the table name, have optional quotes, but putting quotes around all tables, columns, and aliases like TO is legitimate and often good style.
SELECT "T0"."ItemCode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "OITM" "T0"
What’s in the Quotes is case-sensitive. Can you spot the two errors here?
SELECT "T0"."Itemcode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "oitm" "T0"
“T0″.”Itemcode” and “oitm” do not have the proper case. Interestingly, it will work if I do oitm without quotes.
Comments are still two dashes. Like many other programming languages, HANA adopts the
/*and*/for block comments.-- This is a comment/*This is a block comment. You can add several lines until you use the termination character on the next line.*/
Basic selection, literal strings with single quotes, and sorting also work the same as SQL: this query works with a parameter and sorting:
-- A comment is two dashesSELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM OITM T0 WHERE -- Compound data filter T0."SellItem" = [%0] -- Parameter AND T0."PrchseItem" = 'Y' -- String Literal AND T0."OnHand" > 0 -- ComparisonORDER BY T0."IsCommited" -- Sorting
If you look at only the basics, HANA looks a lot like SQL. However, once you get past the syntax, HANA starts getting different from SQL. In the next newsletter, I’ll look at some commonly-used functions in HANA.
-
Introducing HANA
While I had planned something about the General Ledger for this newsletter, circumstances changed, so I’ll do something entirely different.
As many of you know, I’m no longer with Scientific Device Laboratory. If you’d like to know more about that situation, I have described it in detail here, but the very short version is that I lost the ability to access SAP B1 for this newsletter for the last nine months.
Fortunately, I found someone to help. Richard Duffy and SMB Solutions are graciously providing me with a new Demo instance of SAP Business One, but with one Wrinkle: It is HANA.
Before I go into anything other topics, I’m writing a series of newsletters about how HANA affects SAP B1. We’ll cover the basics of how to write queries in HANA for those curious or needing to translate SQL to HANA and back. Once we have all that, I’ll share with you what I plan to do about writing this newsletter on a HANA system. I’ll assume you know SQL or have taken my course SAP Business One Reporting and Customization.
First, let’s give a little background on HANA. SAP decided several years ago to make a database system they could use across their product line. It has its pluses and minuses. The marketing for HANA was often around its speed due to the in-memory column-based database.
Data in a computer system is stored in dimensional sequence, not the two dimensions we associate with a table. It is as if you had a spreadsheet of only one row.
The best we can do to represent a table is to take the rows or the columns as groups, add them in sequence, then add the next row or column.
Let’s suppose you had this table:
The data would be stored in row order like this in a row-based database.
This is fast for performance in adding and deleting data but presents performance problems in calculations. To get a sum for balances, for example, you have to load each row, get the balance, add it to the total, and then get the next row, which is lots of work.
On the other hand, a column-based database would do this:
All the data for the columns are grouped. To get a sum, it loads the column and sums it. Unlike the Row-based arrangement, there is no jumping around in the data, making it much faster. However, this usually requires in-memory access to the data instead of on-disk access. Such an arrangement requires a substantial amount of memory to run efficiently. Also, insertions and deletions of rows are more complicated as you add data in several places, not as one group.
HANA is not the only column-based database. Data analysis tools like Pandas and even Microsoft SQL Server 2012 have in-memory processing in columns.
Because the HANA implementation of the SAPB1 started from scratch, you will notice a different User interface when running HANA compared to a SQL Server version of Sap Business One. My disparaging quip about SAP B1 UI being as fashional as Windows 95 is no longer accurate.
I’ll discuss this UI in a later column, but from now on, you’ll see screenshots like this in my newsletters.
The real fun begins when you start making queries. HANA has its variant of SQL. Creating a query in the SAP B1 Query Generator of the names and quantities of inventory items produces this query.
SELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited",T0."OnOrder" FROM OITM T0
You’ll notice the double quotes on the column names. Double quotes are required on column names. Some, like the table name, have optional quotes, but putting quotes around all tables, columns, and aliases like TO is legitimate and often good style.
SELECT "T0"."ItemCode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "OITM" "T0"
What’s in the Quotes is case-sensitive. Can you spot the two errors here?
SELECT "T0"."Itemcode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "oitm" "T0"
“T0″.”Itemcode” and “oitm” do not have the proper case. Interestingly, it will work if I do oitm without quotes.
Comments are still two dashes. Like many other programming languages, HANA adopts the
/*and*/for block comments.-- This is a comment/*This is a block comment. You can add several lines until you use the termination character on the next line.*/
Basic selection, literal strings with single quotes, and sorting also work the same as SQL: this query works with a parameter and sorting:
-- A comment is two dashesSELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM OITM T0 WHERE -- Compound data filter T0."SellItem" = [%0] -- Parameter AND T0."PrchseItem" = 'Y' -- String Literal AND T0."OnHand" > 0 -- ComparisonORDER BY T0."IsCommited" -- Sorting
If you look at only the basics, HANA looks a lot like SQL. However, once you get past the syntax, HANA starts getting different from SQL. In the next newsletter, I’ll look at some commonly-used functions in HANA.
-
Introducing HANA
While I had planned something about the General Ledger for this newsletter, circumstances changed, so I’ll do something entirely different.
As many of you know, I’m no longer with Scientific Device Laboratory. If you’d like to know more about that situation, I have described it in detail here, but the very short version is that I lost the ability to access SAP B1 for this newsletter for the last nine months.
Fortunately, I found someone to help. Richard Duffy and SMB Solutions are graciously providing me with a new Demo instance of SAP Business One, but with one Wrinkle: It is HANA.
Before I go into anything other topics, I’m writing a series of newsletters about how HANA affects SAP B1. We’ll cover the basics of how to write queries in HANA for those curious or needing to translate SQL to HANA and back. Once we have all that, I’ll share with you what I plan to do about writing this newsletter on a HANA system. I’ll assume you know SQL or have taken my course SAP Business One Reporting and Customization.
First, let’s give a little background on HANA. SAP decided several years ago to make a database system they could use across their product line. It has its pluses and minuses. The marketing for HANA was often around its speed due to the in-memory column-based database.
Data in a computer system is stored in dimensional sequence, not the two dimensions we associate with a table. It is as if you had a spreadsheet of only one row.
The best we can do to represent a table is to take the rows or the columns as groups, add them in sequence, then add the next row or column.
Let’s suppose you had this table:
The data would be stored in row order like this in a row-based database.
This is fast for performance in adding and deleting data but presents performance problems in calculations. To get a sum for balances, for example, you have to load each row, get the balance, add it to the total, and then get the next row, which is lots of work.
On the other hand, a column-based database would do this:
All the data for the columns are grouped. To get a sum, it loads the column and sums it. Unlike the Row-based arrangement, there is no jumping around in the data, making it much faster. However, this usually requires in-memory access to the data instead of on-disk access. Such an arrangement requires a substantial amount of memory to run efficiently. Also, insertions and deletions of rows are more complicated as you add data in several places, not as one group.
HANA is not the only column-based database. Data analysis tools like Pandas and even Microsoft SQL Server 2012 have in-memory processing in columns.
Because the HANA implementation of the SAPB1 started from scratch, you will notice a different User interface when running HANA compared to a SQL Server version of Sap Business One. My disparaging quip about SAP B1 UI being as fashional as Windows 95 is no longer accurate.
I’ll discuss this UI in a later column, but from now on, you’ll see screenshots like this in my newsletters.
The real fun begins when you start making queries. HANA has its variant of SQL. Creating a query in the SAP B1 Query Generator of the names and quantities of inventory items produces this query.
SELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited",T0."OnOrder" FROM OITM T0
You’ll notice the double quotes on the column names. Double quotes are required on column names. Some, like the table name, have optional quotes, but putting quotes around all tables, columns, and aliases like TO is legitimate and often good style.
SELECT "T0"."ItemCode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "OITM" "T0"
What’s in the Quotes is case-sensitive. Can you spot the two errors here?
SELECT "T0"."Itemcode", "T0"."ItemName", "T0"."PrchseItem", "T0"."SellItem", "T0"."InvntItem", "T0"."OnHand", T0."IsCommited",T0."OnOrder" FROM "oitm" "T0"
“T0″.”Itemcode” and “oitm” do not have the proper case. Interestingly, it will work if I do oitm without quotes.
Comments are still two dashes. Like many other programming languages, HANA adopts the
/*and*/for block comments.-- This is a comment/*This is a block comment. You can add several lines until you use the termination character on the next line.*/
Basic selection, literal strings with single quotes, and sorting also work the same as SQL: this query works with a parameter and sorting:
-- A comment is two dashesSELECT T0."ItemCode", T0."ItemName", T0."PrchseItem", T0."SellItem", T0."InvntItem", T0."OnHand", T0."IsCommited", T0."OnOrder" FROM OITM T0 WHERE -- Compound data filter T0."SellItem" = [%0] -- Parameter AND T0."PrchseItem" = 'Y' -- String Literal AND T0."OnHand" > 0 -- ComparisonORDER BY T0."IsCommited" -- Sorting
If you look at only the basics, HANA looks a lot like SQL. However, once you get past the syntax, HANA starts getting different from SQL. In the next newsletter, I’ll look at some commonly-used functions in HANA.
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness
-
https://www.linkedin.com/pulse/product-labels-barcodes-sap-business-one-steven-lipton Learn where to obtain data for Product barcodes in SAP Business One. We'll look at UPC/EAN product codes, Batch Numbers, and Expiration dates. Along the way, we'll decide how you want to print a label, Application Identifiers for product labels, and the best barcode and formatting for your label. #sapbusinessone #sapb1 #barcodes #Bizoneness