Sunday, May 31, 2015

TIP: Deactivating the SAP menu or user menus

ISSUE: There may be a need to switch off the ability to see the standard SAP menu or the user menu. How can we accomplish that?

Saturday, May 30, 2015

Testing or executing a function module without having access to SE37

ISSUE: In certain environments you may be restricted from using SE37 to execute or test a function module. There is a way around it if you have access to SE38 or SA38.
SOLUTION: Simply use SE38 or SA38 to execute program RSFUNCTIONBUILDER. This brings up a very similar screen to SE37 as shown below, where you can then proceed to test out your function module

Friday, May 29, 2015

TIP: Debugging a popup window

Debugging a report is pretty simple but there is a trick to stopping a debug session when a popup window happens. If the popup window is a result of a message and you know the message number you can search and potentially put a break-point in the code but sometimes you can't do that. In order to stop the code at the popup window do the following:
  • Create and save a TXT file with the following text:
[Function] Command=/H Type=SystemCommand
  • Execute the program and when the popup happens you can drag and drop the TXT file on to the popup window in SAP. Continuing will launch you in to the debugger

Thursday, May 28, 2015

TIP: ABAP System Fields – Structure SYST

Name Type Length Use Description
ABCDE CHAR 26 Constants Alphabet (A,B,C,…)

APPLI RAW 2 Obsolete

BATCH CHAR 1 Background processing Program runs in the background

BATZD CHAR 1 Obsolete

BATZM CHAR 1 Obsolete

BATZO CHAR 1 Obsolete

BATZS CHAR 1 Obsolete

BATZW CHAR 1 Obsolete

BINPT CHAR 1 Batch input Program runs under batch input

Placing an Image or HTML page on your start screen

When you log in to SAP you can change the image on the right hand side but you can also make it an HTML page which provides for the opportunity to link to help files, SOPs, training documents, etc... Very useful... An example of displaying an HTML is shown in the screen-capture of our system below

To accomplish it follow the following steps.

5 Reasons to Consider BI360 over Management Reporter for Microsoft Dynamics GP

5 Reasons to Consider BI360 over Management Reporter for Microsoft Dynamics GP
"When it comes to reporting out of Dynamics GP, there is a veritable smorgasbord of options available to you, the end user. Although it may be tempting to opt to use Microsoft’s Management Reporter 2012 as it comes bundled with your GP license, Management Reporter may not be the best option depending on your or your organization’s individual needs."
Read the full blog here

Wednesday, May 27, 2015

TIP: Seeing what views are missing from your material master

When you create a material master you may not have all the information available to generate all the required views. The nice thing is that there is a table in SAP that stores an entry for each view that has not been created. It would be a simply thing to write a report or better still, create a workflow to ensure that all the required views for you materials have been created before they are made available for use. To review this tables details let's run through an example.

Q Data USA SAP Event Management Video Cast #1 - A SAP EM Overview and OTC Demo

Tuesday, May 26, 2015

TIP: Finding a transport related to an IMG activity

If you need to find a transport that was associated to a specific IMG activity then follow this procedure:
  • Transaction SE03 - Transport Organizer Tools
  • Select "Search for Objects in Requests/Tasks" as shown below

Vendor Managed Inventory Under the DSCSA -

Dirk Rodgers of writes another interesting article around Vendor Managed Inventory and the impact of DSCSA on it.

Monday, May 25, 2015

Scan ABAP code for a specified string

Use report RPR_ABAP_SOURCE_SCAN to find all programs that contain a specified string. See the selection screen below.

Report to check if finance or sales view missing for a customer master record


You find that your master data process leads to customer records that occasionally have missing sales or finance views. How can we easily find these records and address them.


  1. I like to use Workflow to manage the creation of master data to ensure proactive maintenance of master data views - i.e. When a customer is created and it's missing the sales or finance view then send a work item to the sales or finance team in order to have them create it. The workflow is only terminated once the view has been created. Businesses that need to follow a compliance process often use this technique and have the QA team be the last in the process to release the master data object for general use.

Sunday, May 24, 2015

Uprotecting a program variant

Program variants can be protected in order to avoid unauthorized users from changing them. E.g. Variants are protected if they are part of a batch scheduling process that needs for them to remain consistent in order to maintain the integrity of the executing batch job. 
Protecting a Variant

Saturday, May 23, 2015

Changing master data in mass

Use transaction MASSD to change attributes of your various master data elements. The following master data objects can be changed using this transaction:
  1. BUS0015    Profit center
  2. BUS1001    Materials (industry)
  3. BUS1001001    Materials (retail)
  4. BUS1006    Business Partner
  5. BUS1133    Rental units
  6. BUS1178001    Mass Maintenance Mat
  7. BUS2012    Purchase orders
  8. BUS2013    Purch. Sched. Agrmt
  9. BUS2014    Purchase Contract
  10. BUS2031    Customer Quotation
  11. BUS2032    Sales orders
  12. BUS2034    Customer Contract
  13. BUS2104    Appropriation Req.
  14. BUS2105    Purchase Requisition
  15. BUS3003    Purchasing Info Rec.
  16. BUS3006    G/L Account
  17. CA_CONTACC    Contract Account
  18. FORCE_LS    ForceEl (Log. Syst.)
  19. KNA1    Customers
  20. LFA1    Vendors

Friday, May 22, 2015

Subscribing to changes in business transactions e.g. Sales Order changes

You may have a need to be proactively notified whenever a particular business object is changed. E.g. If I own a particular Sales Order and I want to ensure that I am immediately made aware of any changes to it then I can do the following to "subscribe" to the sales order changes:

FDA Warns of Bogus Botox - Case for SAP ATTP?

Counterfeit Botox may have been distributed to doctors' offices and medical clinics across the United States, the U.S. Food and Drug Administration warns.

The bogus Botox -- which is considered unsafe and should not be used -- was sold by an unlicensed supplier not authorized to ship or distribute drug products in the United States, the FDA said in a news release.

Packaging similarities between the fakes and the FDA-approved Botox, which is made by Allergan (100 units/vial), could cause health care professionals to mistake one for the other.

Approved Botox displays the active ingredient as "OnabotulinumtoxinA" on the outer carton and vial, the FDA said.

The outer carton of the counterfeit version says the active ingredient is "Botulinum Toxin Type A" instead of "OnabotulinumtoxinA," according to the agency.

The FDA said the counterfeit product also can be identified in other ways. For instance, the vial is missing the lot number.

Read full article here :

NFI Chooses MacroPoint for Load Tracking

MacroPoint, creators of patented freight tracking software designed to give 3rd party visibility into load status, today announced that NFI, a fully integrated supply chain solutions provider, has implemented its solution to enhance load tracking capabilities within its brokerage service offering.

“We chose MacroPoint to fill a gap in the track and trace function of our business,” said David Broering, SVP, Integrated Solutions at NFI. “MacroPoint gives us another tool to use to provide our carrier partners with options for updating us with the location of the loads they’re hauling. With MacroPoint we will also be able to track more loads with the same number of people, allowing us to scale our business faster without having to incur additional overhead costs.”

NFI, headquartered in Cherry Hill, New Jersey, is a privately held company that provides dedicated transportation, warehousing, intermodal, brokerage, transportation management, global, real estate, and trailer storage services. The more than $1.1 billion operation has 25 million square feet of warehouse and distribution space and a company-owned fleet of over 2,000 tractors and 8,200 trailers, operated by more than 2,600 company drivers and 250 owner operators.

Activated on the mobile phones of drivers hired by NFI’s carrier partners, MacroPoint’s location tracking software provides load status and location visibility. With MacroPoint, the company now has real-time location tracking, on-time delivery monitoring, and arrival/departure notifications, eliminating the need for third parties to check in to receive load status reports.

Read full press release here:

Thursday, May 21, 2015

TIP: Command line OK codes

Here is a list of the available command line OK codes:

Direct call of transactions, session handling:

  • /nxxxx -Terminates the current transaction, and call transaction “xxxx” - E.g. /nVA02 calls transaction VA02 in the current session This terminates the transaction. This generally corresponds to going back with F15.
  • /n -Terminates the current transaction and returns to the SAP menu
  • /nend - Terminates all separate sessions and logs off (corresponds to “System -> Log off”)

TIP: Editing SAP table contents

Here is an old tip but a good one.
ISSUE: We have the need to change a value in a table that is not open for maintenance. PS: You should only use this technique in a dev / test environment. Also, if it does not work in your system then the functionality has been deactivated (refer to OSS note 1420281)

TIP: Report to view condition record changes

Use report RV16ACHD to check changes made to condition records for a condition type, promotion, sales deal or agreement. The selection options for the report look as follows:

The result of executing the report looks like this:

Wednesday, May 20, 2015

Creating a pricing report without using ABAP

You may have a need to generate an ad-hoc pricing report showing condition records, values and validity dates - Check out this technique as it does not involve ABAP in any way - It's all done through the magic of configuration.

SOLUTION: SAP provides a standard solution that allows you to create a pricing report. The following took me literally 2 minutes to configure and run.

TIP: Adding an authorization to a user using a function module

Note: Only recommended for Dev environments to test your authorizations and how they work for your programs...
Call function PRGN_INTERFACE_USER with the following parameters:
  •  Profile: Authorization profile you need to add
  • User: User to add the profile to
  • Action: I = Insert, D = Delete
  • Perform checks = <blank>

Poll - What position do you hold at your company?

What level are you?

Poll - What is your relationship to SAP?

Relationship to SAP?

Poll - Where do you live?

Which region do you live in?

Tuesday, May 19, 2015

TIP: SAP SD Frequently Asked Question OSS notes

Check out these OSS notes relating to SAP SD that contain various FAQs:

SD-SLS-SO - Sales Order

  • 549438 FAQ: Search help for the sales order
  • 548488 FAQ: Checking the sales document for open quotations
  • 549413 FAQ: Quantity rounding in the sales order

TIP: System trace for authorization checks

Use transaction STAUTHTRACE to trace a specific users interaction with authorization objects. The resulting display is a very useful ALV grid containing the authorization objects as well as the sub-objects and related activities checked.

TIP: Correcting an inconsistency between LIPS and VBEUP

On occasion the delivery item somehow loses it's status entry in VBUP as well as the vice versa scenario where there is a VBUP entry without a corresponding LIPS entry. To correct the issue refer to OSS Note  79210 or refer to  2006809 – Composite SAP note: How to fix delivery-related inconsistencies.
In short do the following:
  • Using SE38 execute program WS_CORR_LIPS_VBUP_01 to delete the delivery line items or status accordingly
  • Using SE38 execute program RVDELSTA to redetermine and update the Delivery Status accordingly


Monday, May 18, 2015

Mapping a Customers EDI field in to and then out of SAP

Customers that transact Orders to you via an EDI X12 850 often need you to send certain, customer specific, fields back to them on subsequent documents. This is often a requirement at both the header and item levels of the order. A common example of a header field would be the department number. It makes sense for the customer to have the department number returned on subsequent documents but we don't have any use for that number in our SAP system other than to store the details and pass it to subsequent documents.

ERPGenie Youtube channel

We have tagged our favorite SAP related videos on our ERPGenie YouTube Channel. Check it out - Leave comments to suggest new videos to feature.

Why Does ANVISA Embrace GS1 Standards, Except The Serial Number? - By Dirk Rodgers

Dirk Rodgers of has written another great article on ANVISA... Read below for an excerpt  or read the full article here. Serialization is a challenge and with this interpretation from the Brazilian authorities it certainly complicates matters for manufacturers if their goods land up in Brazil...
"In Brazil, the National Agency of Sanitary Surveillance (ANVISA) has built their pharma serialization regulation around GS1 standards. They embrace the GS1 Datamatrix and GS1-128, both encoded with GS1 Application Identifiers (AI) and using GS1 Human Readable Interpretation (HRI) (see my previous essay, “The ANVISA Unique Medicine Identifier (IUM) on Drug Packages”, for my thoughts on HRI), the GS1 Global Trade Item Number (GTIN) and the GS1 Serial Shipping Container Code (SSCC) to be specific. But there is one GS1 standard they steer clear of: the GS1 serial number. Why is that?

Sunday, May 17, 2015

Lumira Edge Install by James Mason

Article by James Mason for Decision First Technologies 
"As a moderately experienced user of SAP Lumira Desktop, I am knowledgeable in the utility and functionality that it provides. It is ideal for manipulating, editing, and formatting data to create visualizations and share them throughout an organization. Its user-friendly interface enables users to easily compose engaging documents from multiple data sources that don’t need to be 100% clean.

Saturday, May 16, 2015

EDI - IDoc mapping to X12 and EDIFACT

This is an oldie but a goodie!!! A list of the Message Types (an example of the IDoc type) linked to the corresponding EDIFACT and ANSI X12 standard message.

Friday, May 15, 2015

TIP: VBFA table uncovered

The document flow table VBFA is a key table when looking for related documents. Let's take a look at it.

TIP: Order status tables uncovered

We often need to look at the VBUP (Item) and VBUK (Header) tables to see what the status of our order or delivery is. PS: Using SAP EM to track your order status has far more functions and features available to you (see blog on Q Data USA).
In this blog posting I highlight the key fields in VBUP and VBUK that I commonly use in the OTC process.

Tuesday, May 12, 2015

SAP EM - Direct Search via URL

Daniel Haerder from SAP just released the news that there is a new feature available for SAP EM 9.0 (SP07 or note 2005297) which allows for the using of URL parameters when starting the EM web UI. The parameters will allow you to select a web interface transaction and trigger the search directly. Launching the SAP EM Web UI URL with the parameters will send you straight to the result list on the 'Search Result' tab corresponding to the search parameters that have been provided in the URL. The provided search parameters are still available then on the 'Search' tab so that you can further manipulate them accordingly.

SAP Fiori - An Overview

The following is the marketing blurb from SAP: "SAP Fiori is the new user experience (UX) for SAP software. It applies modern design principles for a completely re-imagined user experience. SAP Fiori UX represents a personalized, responsive and simple user experience across devices and deployment options.

SAP and Google planning on integrating more...

"SAP (Systems Applications and Products) is one of the biggest and most known inter-enterprise software company that focuses on managing business operations and customer relations. The company has offices in 130 countries around the globe and over 282,000 customers. SAP CEO, Bill McDermott, announced a new partnership during this year’s SAPPHIRE NOW keynote; Google will be collaborating closely with SAP with a goal of making work simpler, further improve productivity, and extend collaboration for both companies’ employees. Google and SAP will focus on enterprise mobility, which will make use of Android for Work and SAP Mobile Secure 2.7; business analytics with Google Apps and SAP Lumira, and business applications; this last will make it possible to move data from Google to SAP applications without any major hassle, creating a simpler workflow for both companies. Both Google and SAP will take advantage of each other’s services and applications, meaning that this partnership will benefit the two companies equally.

Monday, May 11, 2015

SAP Track and Trace solution – Part 1 – Outbound Logistics

Most organizations deal with the shipment of goods in to and out of their premises. With the increasing demand for a better customer experience it is a challenge to provide a high level of customer service when parts of your supply chain fall somewhat out of your “sphere of influence”. Sure, through contractual obligations, you can try and force your suppliers and carriers to behave in a certain way but as the old saying goes “stuff happens!”. If the supply chain breaks down outside of your 4 walls, are you aware of it? Do you have enough time between when you find out about the issue and the time needed to correct it? Do these issues in the supply chain cause disruption and potentially lead to lost customers and sales?
The key to remedying this issue was discussed back in the 1990’s and was termed Supply Chain Event Management – Give me the ability to monitor the events occurring THROUGHOUT my supply chain as and when they occur – Let me measure these events against what I had expected to occur and if it differs in any way let me know so that I can take proactive measures to correct it.SAP was a part of the “think tank” that came up with the term “Supply Chain Event Management” and created the product SAP Event Management to provide us with this functionality. It went in to General Availability in 2004 so has been around rather a long time…
In this article I want to describe how SAP Event Management forms the back-bone of your Track and Trace requirements and specifically focus on the outbound logistics scenario.
TnT outbound

Firstly let me describe what Track and Trace is and how it relates to my issue described above.

SAP Event Management Use Cases - Part 3

In my 1st blog on use cases for SAP EM we took you through some of the use case for SAP TM, GTS and SNC as well as the highly popular Track and Trace where folks simply want to know, from their carriers or freight forwarders, that their goods are on time… In my 2nd blog on use case we described the ever popular OTC and PTP processes, being the most asked for processes to monitor...

With that been said below is a list of more processes that are making use of SAP EM to fill certain holes:
  1. PO Prompt Payments -
  2. Production Order Visibility -
  3. Delivery (Outbound and Inbound)
Just ping me if you want more details on these scenarios 

The ANVISA Unique Medicine Identifier (IUM) on Drug Packages - Dirk Rodgers

Last week Dirk wrote about the DSCSA Product Identifier on Drug Packages in the United States.  Last month he wrote about shipping container/transport package identification under the Brazil National Medicine Control System (SNCM) (see “ANVISA And The SSCC Controversy”).  In this article Dirk takes a look at drug package identifiers under the SNCM as regulated by the National Agency of Sanitary Surveillance (ANVISA).  Dirk is a member of the GS1 Healthcare group - Contact GS1 Healthcare for more information.

An excerpt from Dirk's article:
"Under the SNCM, manufacturers must apply a Unique Medicine Identifier (IUM) to all drug packages imported or sold into the Brazilian supply chain and trace them through the supply chain by December 11, 2016.  By December 11 of 2015, manufacturers must apply the IUM to the packages of at least three lots of drugs and trace them to the dispensing points.  And you thought compliance with the DSCSA was going to be hard to achieve!

Friday, May 8, 2015

Consumption-based planning and MRP

MRP and Consumption-based planning are two fundamental SAP planning types that can be used to determine a product’s requirements. To avoid any confusion we not referring to the MRP run that is executed through MD01 and MD02. We are referring to planning types that are set in the Material Master’s MRP1 tab. The MRP type is used in the MRP run to determine HOW procurement and/or production quantities are calculated.

Thursday, May 7, 2015

Microsoft Dynamics Safepay - Managing electronic payments

Check out how to manage electronic payments with Microsoft Dynamics Safepay at

ERPGenie.COM Subscription FREE giveaway!!!

We have a few extra SAP related books just waiting to be given away. We have decided to offer every 10th subscriber to the new and improved ERPGenie.COM website a FREE book - We will even pay the shipping just because we are nice folks ;)

What Wikipedia Won't Tell You About EDI

I found this interesting blog post written by Kristen Kearns, Manager of EDI Services for Aurora Technologies. She quite correctly describes some of the nuances in EDI that is overlooked by folks that aren't too engaged in the implementation of EDI. The theory of EDI with it's communication protocols, standards, elements, segments, separators is all good and fine but at some stage it runs in to the brick wall called REALITY!!!

See how the Amazon warehouse operates

Check out the robots in action....

Wednesday, May 6, 2015

Mapping the SAP IDoc to / from Partner Profile

I have spent many years coming to grips with the relationship between a SAP IDoc, the partner profile and how it relates to EDI. You can see sample mapping templates here and Sample EDI Specs here but this spreadsheet will hopefully make clear how the SAP Partner Profile (WE20) impacts the IDoc control record (EDIDC) and ultimately how it plays a role in selecting the appropriate map to use for translating in to an EDI message (for outbound). 2 Files are also attached to this post to show:
  1. See the 7 key fields used to determine which partner profile to select - See Image and relate to "Partner Profile Key" section 1-7 below
  2. Relating the EDI fields in the Partner profile to the EDI translation tool - See Image and relate to "EDI standard" section 1-3 below
Read the full article on EDIGenie.COM

EDI and the IoT (Internet of Things)

I read this great post by Faith Lamprey on how EDI is very suited to connecting to the Internet Of Things...
With devices and gadgets being Internet, RFID and GPS enabled you can imagine there would be enough information to control every aspect of that device.

Monday, May 4, 2015

Real use case: Supply Chain Maturity Whitepaper

Last year I conducted an analysis of a particular business who’s main focus is procuring, storing and supplying general products to large facilities. The focus of my investigation was primarily around the integration of SAP EDI in to the supply chain and in particular the Procure to Pay (PTP) process with a heavy emphasis on the Advanced Ship Notification and the automation thereof.

The DSCSA Product Identifier On Drug Packages - Dirk Rodgers

According to the Drug Supply Chain Security Act (DSCSA), manufacturers must apply a new “Product Identifier” on all of their prescription drug products by November 27, 2017 (Repackagers by that date in 2018).  The DSCSA Product Identifier is defined this way:
The term ‘product identifier’ means a standardized graphic that includes, in both human-readable form and on a machine-readable data carrier that conforms to the standards developed by a widely recognized international standards development organization, the standardized numerical identifier, lot number, and expiration date of the product.”  (Section 581[14])

Sunday, May 3, 2015

SAP EDI Subsystem Certification

Cross Application - Electronic Data Interchange Interface (CA-EDI)

Built into SAP’s applications are interfaces to EDI messages.SAP provides an open, common interface to EDI translators / subsystems (XA-EDI). EDI subsystems assume responsibility for all EDI-oriented tasks:
  • Converting data
  • Message or interchange handling
  • Communication
  • Partner profile administration
  • Process monitoring
Read the full article on EDIGenie.COM

Saturday, May 2, 2015

TIP: ABAP code to add an IDoc to your application object

Sometimes you need to write ABAP code to generate an IDoc. With this new custom IDoc generation you would like to have it link to your SAP application object (E.g. Sales Order, Delivery, …) You would like to see your IDoc linked to the Generic Object Services (GOS) display relationships service. Well here is the code needed to do just that…

SAP Web IDE 1.10 Documentation

The latest Web IDE documentation has been released. View at

The who's who of SAP HANA cloud

Matthias Steiner has created a list of all the relevant folks in the SAP HANA Cloud world. Check it out on SCN at

Friday, May 1, 2015

SAP Best Practice way of handling inbound posting IDoc errors

I often get asked how IDocs and workflow are connected.... The diagram below should clear up the confusion.
Use transaction WE42 to ensure that the relevant IDoc object is linked to the needed events that workflow uses.
INPUTERROROCCURRED is triggered when the IDoc fails to post. It will then search for linked workflows (configured using transaction SWETYPV) to see what workflow to trigger.
There is a standard single step workflow that is provided but most people want a little more functionality than what is provided SAP standard. Read the full article on EDIGenie.COM

TIP: How to modify the text in an Alert

SAP provides the ability to create alerts (emails) through the Alert Framework. Other modules, like SAP Event Management, integrate with the Alert Framework in order to send notifications on exceptions uncovered in the process.

The text that is maintained in the Alert Category definition (tx: ALRTCATDEF) is either static or mapped in from the called system (e.g. SAP EM).

SD Foreign Trade vs. SAP Global Trade Services (GTS)

SAP Global Trade Services (SAP GTS) automates global trade processes and enables you to manage large numbers of business partners, and high volumes of documents while also helping you to comply with changing legal regulations.
It facilitates gloabl trade by providing you with the tools you require to respond to governments modernizing their systems and to customs authorities communicating electronically with businesses. - To read the full article Click Here