.png)
Using SAP QR Codes
SAP has introduced the use of QR Codes in version 10. They have included QR Code data fields on all sales and purchasing documents and on the item master. You can use this information to better run your business. This document illustrates how to utilize QR Codes for Item labels. Understanding how this is done for item labels will enable you to create QR codes on any Crystal Report - for sales and purchasing documents for instance.
.png)
User view of This function
The user needs to include data in the 'Create QR Code from' field in the item master or the marketing documents. For instance, let's assume you want to connect an item label to a set of 'compliance' documents that were used when testing the product. You maintain the informtion by part in a web site: www.mypartdata. The 'page' where you maintain the specific part data for item 15020 is: www.mypartdata/compliance/15020/. When the label QR code is scanned the compliance page is accessed directly - enabling your customer to see the compliance documents.
Likewise from a PO Crystal report document you could print specific part specifications based on the item detailed engineering specifications being stored in a particular location on your web site. The vendor would receive the purchase order with the QR codes for each item on the PO and they could directly access the engineering specifications they need to meet for each part.
Sales documents could have a QR Code specific to the document (not the part) that would point to a URL for an ongoing sale.
QR Code Usage Ideas
Item master QR Codes• Labels with links to compliance information • Labels with links to engineering specific information• Labels with links to pictures of the product• Labels with detailed description of the part – i.e. 500 – 1000 characters rather than just the normal 100.
Sales and Purchasing documents – QR Codes• Include link to tracking information – UPS, FEDX, etc.• Link to logistics paperwork / forms• Links to sales of products• Links to your support web site / contact information• Direct email to support or sales• Purchase order with links to each item’s purchasing specifications• Links to products that if you purchase this – you should look at these products
Using QR Codes Provided by SAP
In SAP Version 10 fields for QR Codes are available. All marketing document forms have a QR Code Content field in the 'Accounting' tab. The item master form has a QR Code Content field in the 'Sales Data' tab. Note: I used the SAP function 'Edit Form UI' to increase the size of the Create QR Code form field - for readability.
Item Label Example
A 'Label Print' button has been added to the item master form. Clicking this button when the 'Create QR Code form' has data will print a label with a QR code. included - link to whatever the contents are in this item's 'Create QR Code form' field. The label below was printed from the item 'B10000' and if you click on it you will see a map of my location in The Villages Florida.
Crystal Report label example
Boyum Crystal Report Access
Item placement tool was used to create a 'Label Print' button on the item master. When the button is clicked it accesses this Crystal Report - using the current item for the 'parameter'.Crystal 'Database Expert'
Reviewing the label print Crystal report, this 'Database Expert' references 2 Command line scripts. The first identifies the item: select itemcode, itemname, docentry, objtype, qrcodesrc from oitm where qrcodesrc is not null The 'is not null' clause eliminates all items without QR Code information. Delete this 'where' clause if you want to print labels for all parts - some with a QR Code and some without. The second identifies the QR Code information: select "FileContnt", Cast("SrcObjType" as varchar(20)) as ObjType , cast("SrcObjAbs" as integer) as ObJAbs from OQRC where FieldName= 'QRCodeSrc' The scripts are linked as shown below.
Label Information
.png)
The label Crystal report consists of 3 fields: The item code (text and as a bar code); the item description; and the QR Code information.Label Page Setup
The label is being printed using a Brother QL 700 printer. The labels are 4 inches long by 2.4 inches wide. The label stock is 2.4 inches wide.QR Code Option - Web Site
The label QR code for this part (15010) shows the main web site for Mascidon. When the user uses their phone camera to scan the QR Code they will be redirected to Masidon's web site.QR Code Option - Web Site Page
The label QR code for this part (15020) shows the BOM Enhancements page for Mascidon's website. When the user uses their phone camera to scan the QR Code they will be redirected to Masidon's web site BOM enhancement page.QR Code Option - GPS Position
The label QR code for this part shows the latitude and longitude for my home address. If the user's camera scans this code on the label they will be shown a map of the subdivision I live in.QR Code Option - email
.png)
The label for the part B-100 has my email address as the QR Code content. When the label is printed and the user uses their camera to scan the label QR Code it will open an email screen with the 'To' email set to this email address.
SAP QR Codes Explained
I am using the sales order 'Create QR Code From' field located in the Accounting tab of a sales order for my explanation. Assume that I have entered 'www.mascidon.com' in this field on a sales order. What happens when this field is entered? The field ORDR.QRCodeSrc (ORDR is the sales order header table) is populated with ‘www.mascidon.com’.
When this sales order is created with this QR code description, a record is created in the table OQRC (QR code table). This table has the following fields of data: Absentry – this is the key field in OQRC – if you had 100 QR codes on file this value would go from 1 to 100.FileContnt – This field is an ‘image’ type field in SQL (or Hana). When the sales order screen is created and the QR codes field has data, SAP calls a routine to create a record in the table OQRC – based on the screen being updated and the fields as described above. This field, FileContnt, is a QR Code ‘image’ of the bar code. It is the 2D bar code image.SrcObjType – 17 is the sales order table internal id assigned by SAP. All documents and master tables in SAP have an assigned code. Production orders have 202 as their assigned code.SrcObjAbs – marketing documents and most master tables have a field ‘Docentry’ (the production order table OWOR has this field as well).Expafter – not sure when this is used but it isused to define when this QR code expires – i.e. after 10 days. This period of time is set up when QR codes are defined in Administration System Initialization General Settings QR Codes tabCreateDate – date the QR code was createdCreateTS – time createdUpdateDate – date the QR code was updated (i.e. you changed www.mascidon.com to your web site).UpdateTS – time updated
When accessing Crystal reports to print the QR Code, the field 'FileContnt' is printed on the form to display the bar code in 2D.
When this sales order is created with this QR code description, a record is created in the table OQRC (QR code table). This table has the following fields of data: Absentry – this is the key field in OQRC – if you had 100 QR codes on file this value would go from 1 to 100.FileContnt – This field is an ‘image’ type field in SQL (or Hana). When the sales order screen is created and the QR codes field has data, SAP calls a routine to create a record in the table OQRC – based on the screen being updated and the fields as described above. This field, FileContnt, is a QR Code ‘image’ of the bar code. It is the 2D bar code image.SrcObjType – 17 is the sales order table internal id assigned by SAP. All documents and master tables in SAP have an assigned code. Production orders have 202 as their assigned code.SrcObjAbs – marketing documents and most master tables have a field ‘Docentry’ (the production order table OWOR has this field as well).Expafter – not sure when this is used but it isused to define when this QR code expires – i.e. after 10 days. This period of time is set up when QR codes are defined in Administration System Initialization General Settings QR Codes tabCreateDate – date the QR code was createdCreateTS – time createdUpdateDate – date the QR code was updated (i.e. you changed www.mascidon.com to your web site).UpdateTS – time updated
When accessing Crystal reports to print the QR Code, the field 'FileContnt' is printed on the form to display the bar code in 2D.
