In this article, an example of supplier data in BW is considered. Supplier data from several SAP systems (from table LFA1) or from non-systems are extracted. Standard data cleansing methods are utilized. Some of these could be de-duplication, standardization and enhancement. Enhancement could be an addition of a standard number, eg. DUNS. At the end of this activity there could be tens of thousands of records to be loaded. Since the result of this activity is a flat file, the data is loaded into BW as a flat file. If the info-object does not have a secondary index, the loading time runs into hours.
SAP Queries
SAP Queries are a tool provided to SAP implementers and super-users. There is some maneuvering room for ABAPers, but this is not considered a programming tool. This doesn’t mean that there aren't programming problems with the tool, but they are mostly ignored until it's too late.
How to Manage UNSPSC® Standard Codes Using SAP Classification System
The United Nations Standard Products and Services Code® (UNSPSC®), is an open, global, multi-sector standard for efficient, accurate classification of products and services. This code is generally assigned to materials and is used for company-wide visibility of spend analysis, cost-optimization and more.
Face it! Or Get Disrupted - Change is Coming Fast
SAP S/4 HANA helps the world run better & improve people’s lives and to help customers run at their best. Read more about SAP S/4 HANA here.
Tips For Keeping GR/IR Under Control
MR11 – Maintaining the GR/IR Clearing Account
Right after a new implementation, everybody is concentrating on getting the invoicing right, and paying suppliers etc. and they tend to assume that the GR/IR is taking care of itself. Generally, if everything matches, it does, the problem is that not everybody understands that the quantity must match exactly to clear the GR/IR account. A typical problem where the invoices are posted manually, could be users struggling to post fractions correctly, for example where using the standard goods receipt process for a service. Another problem, where invoices and credit notes are posted via an interface, is not being able to distinguish between a price and quantity difference and using e.g. a credit memo to post all corrections.
Using ABAP Coding In SAP Standard Query
It is hard to find an easy explanation about ABAP coding in standard queries . In some casesyou can’t easily attach additional information to a field in a Query or you need to call and ABAP function module to do an specific calculation, then adding coding to a local field may be a suitable solution. To demonstrate this we are going to make a standard query with one table using ABAP Coding on it, instead of creating an infoset with three tables inner join) as usual.
How to Enter Text In ABAP Via Editor With FM TERM_CONTROL_EDIT
Sometimes, users needs to enter some text directly (decisions, explanations, comments), for example, during the running of a module pool program. There is an easy way where the user can perform this action. Via MF TERM_CONTROL_EDIT. This MF shows a POP-UP with a text editor screen that is very simple and where the user can enter texts or perform the action of importing/exporting files.
External Debugging from EP (Enterprise Portal) and SRM Portal in SRM System
When we encounter errors/issues in an SRM document (like POs, shopping cart and SRM/EP related SAP objects), then we usually login to the SRM or EP portal to access these corresponding document. In order to analyze further - we also have to check the SRM system to crosscheck if the issue is with any custom code put into the BADI’s (Business AddIns).
To debug this scenario we would have to perform certain set of activity that is causing the error like ordering the PO etc. in the portal login which then calls the SRM system where the actual processing is done. To achieve this we will be using the external debugging option that SAP has provided. (In other words, we can say that to find the RCA we have to debug the SRM/EP objects in their corresponding landscape and that require few settings as explained below).
XBP - External Interface For Background Processing
XBP - stands for External Interface for Background Processing. It is used to enable external entity/system to schedule, start and monitor jobs inside SAP. In XBP, we have many RFC enabled function modules (provided by SAP) which can help external systems to control various background activities in job (like create, modify, delete, start, terminate, monitor etc. inside SAP).
How To Implement a Web Service Call From Excel
In this article, we will explaining how to implement a web service call from Microsoft Excel. The prerequisite to for this? We must have web service toolkit installed.
Calculating Results Analysis POC Using a Percentage Gross Margin
The user requires the ability to calculate percentage of completion without planned costs, using total revenue minus planned margin as the cost basis.
How To Show a Standard Cost Component on a Single Level
We use report S_P99_41000111 for displaying cost components for multiple materials. However we are looking for the cost component costs incurred on the material itself, and not from the lower level materials. For example, we have a finished product with a cost component called Freight. The value in this cost component is $20. However, $15 of this freight came from the source material in a different plant. We therefore only want $5 to show in this report.
How To Migrate Report Painter Reports to the SAP General Ledger
Transaction FAGL_RMIGR
Step 1 Create your own library from New GL TABLE
Go to transaction GR21 and create your library like that
5 Easy Steps to Call an External Command from SAP
Step 1:
Create a batch file with command C:\Temp>copy X(filename) \\19x.16y.20z.k\HPLJetPxxxx. (network path for printer is needed, not port)
Step 2:
Put this batch file on application server.
Script to Start SAProuter on Unix
Here is a script to start the SAProuter in an easy way on Unix. Just put the content below in a sh file, and pay attention to the variables.
Top 15 COPA User Transactions User Manual
Read the Top 15 COPA User Transactions User Manual here. Stay up to date with the latest in the SAP industry as well as tips and tricks by visiting our blog.
SAP ByDesign Functional Tip
Creating an incident at the help center takes the screenshot of your page and attaches to the incident you are creating and registers it for the ByD system.
Simplest Way to Show Custom Data in F4 Help
If you want to display data for a select option in F4 help corresponding to only the data given in pre-select option in selection screen read how here.
Live from SAPinsider Studio: Paul Ovigele of ERPfixers on S/4HANA and Universal Journal
Paul Ovigele, joins SAPinsider Studio at the SAPinsider FIN-GRC event to discuss the impact the Universal Journal in SAP S/4HANA Finance. Watch the video here.