Categories: ECC

PRPS-USR06 decimal notation problem

Posted by Joury Jonkergouw on Posted in ABAP, ECC, SAP BW Tagged

After enhancing the datasource 0WBS_ELEMT_ATTR with the two additional user fields  USR06 (UF value 1 WBS) and USE06 (UF unit value 1 WBS) I encountered some strange behaviour.

This began when I extracted data from the ECC source system and I saw that the notation of the user value (after DSO activation) was different from the value filled in by the end user. SAP note 1646349 summarizes this problem. It states that the USR06 and USR07 fields of the PRPS table are always stored with 3 decimals places.
SAP Knowledge Base Article - 1646349 - Decimal Shift in User Currency Fields
For this problem I have developed some lines of ABAP code. The logic uses the TCURX table to calculate how many places decimal must shift for each user value known in the RESULT_PACKAGE. Use this ABAP code inside a transformation to get the same user value as maintained in ECC.

SAP tables related to transports

Posted by Joury Jonkergouw on Posted in ECC, SAP BW Tagged ,

In some cases it might be interesting to know which SAP BW objects are attached to a specific transport for e.g. release management. Instead of copy and pasting object values mentioned in the SE10 transaction SAP tables can be used.

All information related to SAP transports is stored in E07* tables. An overview of these tables is shown below. Along with this information and this table overview you have the ability to compose an overview of objects (including their functional description) belonging to specific transport.

Table Description
E070 Change & Transport System: Header of Requests/Tasks
E070A Change & Transport System: Attributes of a Request
E070C CTS: Source/Target Client of Requests/Tasks
E070CREATE Change & Transport System: Creation Date of Request
E070CTV Generated Table for View E070CTV
E070DEP Change & Transport System: Dependencies of Requests
E070L CTS: Index for Assigning Numbers to Requests/Tasks
E070M CTS: Target Package/Layer for Requests
E070TC Help Table for E070 for Client-Specific Imports
E070USE Use of Current Requests by Users
E070V Generated Table for View E070V
E071 Change & Transport System: Object Entries of Requests/Tasks
E071C Change & Transport System: Client-Specific Lock Flag
E071E Lang. Transport: Positive List for Generic Object Selection
E071K Change & Transport System: Key Entries of Requests/Tasks
E071KC Change & Transport System: Key Entries of Requests/Tasks
E071KF Change & Transport System: Nametab Info. on (CHAR)Key Fields
E071KFINI Change & Transport System: Nametab Info. on (CHAR)Key Fields
E071K_30 Change & Transport System: Key Entries of Requests/Tasks
E071K_KEY E071K Key Fields
E071S System-Specific Import Status of Objects
E071V Generated Table for View E071V
E07T Change & Transport System: Short Texts for Requests/Tasks
E07T_OLD E07T Before TRKORR Extension

Thanks to http://sapbasisanswers.blogspot.nl/ for supplying this helpful overview.

Determine standard values of a production order via SAP ECC tables

Posted by Joury Jonkergouw on Posted in ECC Tagged ,

Ever heard of norm time per operation? If you did, then you don’t have to read further, for those who didn’t please continue.

Last week a business user asked me if it was possible to calculate the norm time per operation on a production order and to add this Key Performance Indicator to an existing BW report. I actually never heard of this KPI. Nonetheless the formula behind it is pretty easy.

Norm time = Base quantity / Standard value of machine

So with this formula in mind my journey began in the SAP ECC source system. Via transaction CO03 I went to a production order and went to an individual operation. Per operation you are able to consult the standard values and the base quantity. The base quantity is straightforward and can be easily extracted via table AFVV.
Standard values of a operation for a specific production order
Extracting standard values is a little bit more complicated, due to the fact that these are attached to a specific work center via a formula parameter. There are multiple standard values available like labor, setup & machine time. For our norm time KPI we are only interested in the machine time.

CONTINUE READING…

SAP tables and relations

Posted by Joury Jonkergouw on Posted in ECC, SAP BW Tagged

Sometimes it’s useful to know how the different tables of SAP are related to each other, especially when developing new functionality in BW or ECC. Christopher Solomon and some other (yet unknown) people have composed a .pdf file where per functional area the entities and their relations are graphically displayed. Refer to the attached file to see the result.

Attachments

ECC source systems appearing in BI folder

Posted by Joury Jonkergouw on Posted in ABAP, ECC, SAP BW Tagged ,

Today a colleague noticed that our ECC systems appeared not under the SAP folder, but under the BI folder. This is strange, since ECC is not a BI system. In order to fix this SAP has publishes (of course) an SAP note. (1087980).
ECC source systems appearing in BI folder
This note describes the following steps in order to fix this issue:

Step Action
1. Check that an entry with SRCTYPE ‘M’ exists in table RSBASIDOC table of ECC source system.
2. Note the values for SLOGSYS and RLOGSYS. It should be same.
3. Run the function module RSAP_BIW_DISCONNECT in the ECC system. NOTE: Never run that function module in a BI system!
4. Enter the following values: I_BIW_LOGSYS <RLOGSYS> as noted in step 2 I_OLTP_LOGSYS  <SLOGSYS> as noted in step 2 I_FORCE_DELETE <X> DO NOT ENTER ANY VALUE IN THE FIELD  – RFC target sys !!!!!
5. Go to RSA1-> Source systems.
6. Select the ECC source system and select RESTORE in the right click menu.

After step 6 has been performed be sure to reactivate all of your transfer structures. If you do not do this the system will not appear under the SAP folder. After you have done this the ECC system should appear in the SAP folder.
ECC source systems appearing in BI folder

Attachments