Datasource for Services Procurement

[Former Member]

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

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

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.

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.

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.

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.

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

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.

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.

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.