Skip to Content


Introduction:

This document has 2 parts. First part explains about the activation of the data source 2lis_02_SRV & second part explains about enhancing it for adding the services line items to be made available for extraction.


Data Source 2LIS_02_SRV used for extraction of (Services Procurement) service line data to BW is made available with ECC 6.0 EHP 3. Though its name seems similar to the LO Cockpit extractors, it will not be visible in the transaction LBWE. Hence there has to be some special configurations maintained to be made available for data extraction. Next we will see when there’re multiple line items or records for one service entry sheet, in T-Code RSA3 result, they would have the same purchase order (EBELN) and the same item number (EBELP) and except these there’s no unique key to distinguish them. So we will have to enhance it to include a unique key so that if there are many line items in a service they can be displayed along with their quantities & values.

Activating 2LIS_02_SRV:


Create relevant entries in table TMCEXACT

Check if any entry exists in the table TMCEXACT for MC02M_0SRV.  MC02M_0SRV is the extract structure for the data source 2LIS_02_SRV. If not maintain the data as below. Also note TMCEXACT can be maintained by using the transaction SE16N.


ESTRUC

ISOURCE

ISGEN

UPDACT

ADDHEADER

MCAPPUPDA

MC02M_0SRV

2LIS_02_SRV

X

X

X

2

TMCEXACT.png

Maintain transaction key for SAP BW

In transaction SBIW -> Settings for Application-Specific Data Sources (PI) -> Logistics -> Settings: Purchasing -> Transaction Key Maintenance for SAP BW as:

Appl. comp.

Application

Operation

Description

MM

2

30

Service Entry Sheet

Tran Key.png

Activate EHP3 switch:

Search for business function in ENTERPRISE_BUSINESS_FUNCTIONS

->LOG_MM_CI_2  in T Code SFW5. If it’s off, please switch on LOG_MM_CI_2. 

While doing so make sure dependencies were off.

/wp-content/uploads/2014/11/switch_591323.png

Go to T code SFW2 & give the business function LOG_MM_CI_2 & click display.  Check if these switches MM_SFWS_SC2 and MM_SFWS_UI_1P2P are off. If so please turn on both Switches as well as the Business Function.

BF.png

BF2.png

This will activate the code that fills the structure.

Activate data source of Appl. Comp. 02 in LBWE

Make sure at least one of the below data sources belonging to purchasing application is activated in transaction LBWE, 2lis_02_acc / 2lis_02_hdr / 2lis_02_itm / 2lis_02_scl. But still the data source 2LIS_02_SRV will not be visible in LBWE, but is activated & will be visible in RSA3.


Enhancing the data source 2LIS_02_SRV:

Thus activated data source doesn’t have unique key to distinguish the multiple line items in a service entry sheet. So if this is updated into the DSO then, the values will be overwritten. In the below figure a purchase order has a single service entry sheet against a single line item. But the service entry sheet 1000283729 has 6 different records with the different quantity.

/wp-content/uploads/2014/11/entrysheet1_591325.png

/wp-content/uploads/2014/11/rsa3_591326.png

So to identify them we will need some unique keys. The values come from the table ESLL. So PACKNO and INTROW from the ESLL table can be used as unique keys to identify the values. As they don’t exist in standard extraction structure MC02M_0SRV, we will have to add fields PACKNO & INTROW to our own data structure, such as ZMC02M_3SRV, and append this structure to the standard extraction structure MC02M_3SRV. 

Create an append structure for MC02M_3SRV.

MC02M_3SRV.png


Add the below mentioned fields as shown below:

Component

Typing Method

Component Type

Data Type

Length

Decimal

Short Description

PACKNO

Types

PACKNO

NUMC

10

0

Package number

INTROW

Types

NUMZEILE

NUMC

10

0

Line Number

MC02M_3SRV2.png

Filling/ Deletion of setup table

After this we need to re-fill setup table for 2LIS_02_SRV by T-Code OLI3BW, then we’ll see fields PACKNO (package number) & INTROW (line number) in T-Code RSA3 result as below.

RSA3_2.png

Note:

For all other data sources of LO Cockpit you can delete the setup table data in the T Code LBWG. But for the data source 2LIS_02_SRV this doesn’t hold true as this data source in not in LBWE.

To clear data from setup table MC02M_0SRVSETUP of 2LIS_02_SRV we have to manually in SE14 as below.

SE14.png

Conclusion :

In any Industry Procurement of services is also an important part just as procurement of materials. This is the only data source which deals with the services part. This is made available from ECC 6.0 EHP3 only. And also care has to be taken to activate it in a different way than other LO Data sources.

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. G. Bot

    Hi Shreesh,

    According to note 1606666 the field ADDHEADER in table TMCEXACT should not contain any value. In your table above you have populated this field. You might want to correct this.

    Best regards,

    Gerard

    (0) 
  2. joseph reddy

    Hi Shreesh,


    I did all the above steps and all are ok in the system to extract service entry sheets data. However i am not getting any data in RSA3.I am on EHP7 for SAP ERP 6.0 on HANA DB? Any inputs on this?


    Regards,

    Joseph

    (0) 

Leave a Reply