Maintain SAP BOBJ  security settings, Disable Edit and design for public folder reports

Maintain SAP BOBJ security settings, Disable Edit and design for public folder reports

SAP
Learn how you could add Security settings to SAP BOBJ server 4.2 or higher. This article talks about some of the common security settings that can be applied for BOBJ implementation project. Learn how you could Maintain SAP BOBJ security settings, Disable Edit and design for public folder reports. These settings may not already exist by default in the system but is strongly recommended as these are some of the best practices we followed by working with clients and helps to meet the business requirement. Security Settings like To hide folders To restrict Save on Public folder Not allow design button to be enabled Export issue where report default file format comes as .pdf instead of XLS or XLSX : This is not really a security setting but system limitation and…
Read More
SAP BOBJ Troubleshooting tips & fixes applied

SAP BOBJ Troubleshooting tips & fixes applied

SAP
Introduction This article talks about some of the fixes and SAP BOBJ Troubleshooting tips and steps applied for common issues. It covers some common issues and bugs faced by the client and how these can be fixed. Please refer to a section further to find about details of the issue and the fixes we applied for the below issues: Opening a report gives an error “Following Database error occurred: The driver returned invalid SQL_DRIVER_ODBC_VER Error in exporting the file “Sorry Promotion Management application is unable to process your request” & HTTP STATUS 500 error Connection Error: [Microsoft][ODBC Driver Manager] The specified DSN Contains an architecture mismatch between the driver and the application ERROR PublishingService: HandlerPool-Q Failed: The document's serialization version is too recent. Publication not being able to schedule. Web application not…
Read More
SAP Custom Search help creation & understand Elementary and collective search help

SAP Custom Search help creation & understand Elementary and collective search help

SAP
Add custom search help by modifying the standard search help Fix the issue for user being able to select multiple options but after selecting it does not populate the window Find technical information to add SAP custom search help Find the technical information for the specific search help by clicking F1 and find the table name as V_PRSMP Using where used find the specific search help that uses the table Below is the search help which uses that view. Check PRSMP search help and find that it is an elementary search help. So, check if there is any other search help linked to it. Found the search help PRSM from the where used The search help PRSM is a collective search help You can find the corresponding user exit in…
Read More
Learn how to export and import files from BOBJ server

Learn how to export and import files from BOBJ server

SAP
In this blog, we will be cover export and import files from BOBJ server and how it can be used to meet the reporting requirement. This blog covers below topic areas: Overview to help understand what BOBJ does. Steps to export a file Steps to import a file Overview Before we start, on a very high-level SAP BOBJ is a comparable product to what Power BI/SSRS does in the Microsoft world. It has some basic feature and functionalities like: Create daily reporting and dashboarding needs Schedule as a job and send email to stakeholders Manage user security to a very minute and detailed level to give only as much access as needed Ensuring users can only changes specific report attributes and allow them to save reports only locally and not override…
Read More
What you need to know for effective change Management process in ERP systems?

What you need to know for effective change Management process in ERP systems?

SAP
If you are working on any ERP management and consulting projects you know it is of great importance you understand client’s business processes and improve time to implement changes in the system. To ensure you have enough information and knowledge to start a new process or request for change below are some parameters you need to keep in mind Although this content is geared more towards SAP as a tool but equally applicable to doing change management using any other ERP implementation tool. Create a process flow map identifying the main processes, prioritising the processes and creating branches for sub processes Assign a SME or business owner or multiple super users who are closely working on the process and can validate the process Develop a process framework so all your…
Read More
Ariba Master data extraction program

Ariba Master data extraction program

SAP
Introduction: This blog talks about how to use the master data extraction program to read data from ECC to Ariba system. This blog talks about below topic areas: Master Data extraction program Sequence for Initial load consideration Customization of the master program Incremental load consideration Lessons Learnt Test cases for Master data integration Master Data extraction program: The standard program /ARBA/MASTER_DATA_EXPORT needs to be customized or you will keep wasting your time to find the implicit enhancement points which are too less and not in the right places. So I just did what was the easier thing to do copied the entire program as a Z and then did the changes. When you run the program you see radio buttons like Procure to Order and Procure to Pay, Sourcing, and contracts.…
Read More
SAP FI reports  for financial reconciliation and analytics

SAP FI reports for financial reconciliation and analytics

SAP
SAP FI reports for financial reconciliation and analytics The article talks about the different FI reports in the SAP system. I am creating this blog for those who are  looking to use SAP systems for  ways on how  the standard system can help for the FI specific  reports Some of these reports either needs to be tweaked or are not as well know as others and I have mostly seen clients asking for a custom report which they can use to map their transactions or do reconciliation effectively but standard system also offers a lot of options from what I understand. I may keep updating it or organizing it better as I develop further understanding in this area. I am also including some custom logic which I had used to help the…
Read More
SAP Ariba certification exam

SAP Ariba certification exam

SAP
I have been in SAP consulting since last 8+ years and from SRM now to Ariba seemed like a natural progression. I have worked on Ariba projects back in time when it was not an SAP company and now again when it an SAP company and is greatly pitched by SAP to its clients so may be of an interest to all those working in the P2P area. I would like to share my experience of preparation for the Ariba certification so others who are looking to do the same can benefit. In all, the content which was provided gives you a fair idea of what the Ariba software does and how you can leverage and use it for your customers. I have alongside worked on Integration and implementation of…
Read More
SAP SRM Transaction complete a PO

SAP SRM Transaction complete a PO

SAP
  This blog talks about handling old / Pos which may no longer be needed and have to be transaction completed.This is a step before actually archiving the POs and contracts. So basically the business should first be transaction completing them if there is no more GR and Invoice expected and letter archiving them as needed. The details mentioned here are related to mass transaction complete and change the status of the PO/ Contracts from backend via an ABAP report. This, however, is possible to do via front-end by just clicking on the complete button. [caption id="" align="aligncenter" width="621"] Click on Complete to transaction complete a PO[/caption]   The reason for doing transaction completed  can be many from an operational perspective You need to ensure no one is using those POs as…
Read More
What I know and what I learnt USING SAP.COM

What I know and what I learnt USING SAP.COM

SAP
I have been trying to find ways on how to use the community better  but could not be more inclined to share some notes which I thought would be useful for the community.These are some of my Go-To Blogs to help navigate the community in a better way If you see some issues in trying to navigate the community check the reported bugs and see if yours is listed and what’s the status hopefully it should be fixed soon https://blogs.sap.com/2016/10/17/community-known-issues/ If not then try to create a new Q& A and start with Bug: as the prefix  in the heading. This will help to identify your issue as the new bug being reported  and would be picked up by one of the SAP moderators or the Forum team (and yes…
Read More