ERPfixers Blog Series

Role of Table Index in Data Loading of Info-objects

Role of Table Index in Data Loading of Info-objects

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.

How to Manage UNSPSC® Standard Codes Using SAP Classification System

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.

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 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.