Extractor for purchasing of external services

[Alex5]

Hi forum,

I need to extract the following key figures for purchasing of External Services:

- PO value / quantity

- Accepted value / quantity

- Invoiced value / quantity

These KFs should be reported by Service Nr., Purchasing Group and Purchasing document

The standard BI Datasource for External Services 2LIS_02_S174 does not cover my requirement, because it does not include Purchasing Group, Purchasing document.

Now I am trying to build my own extractor and would like to know from which tables I can extract the data and how. The Infostructure S174 is not what I need, because it does not contain all characteristics I need.

I am thinking of using tables ESLL (Service line items), EKPO (Purchase order line items) and EKBE (Purchase order history). But I don't how to connect all the needed information.

Can anybody help?

Thanks in advance,

Alex

[Former Member]

I am thinking of using tables ESLL (Service line items), EKPO (Purchase order line items) and EKBE (Purchase order history). But I don't how to connect all the needed information.

I got your question please find the steps

A/ Go to SE11 . Create a view on the tables

ESLL (Service line items),

EKPO (Purchase order line items)

EKBE (Purchase order history)

Add the primary key fields and then use the fields you require in the data source .

B/ Replicate the same on the BI side .

C/ Create necessary infoobject and key figures .

D/ Connect the datasource with the target .

E/ The required fields are there in the target .

Assign marks is the best way to appreciate help

[former_member181964]

Hi,

If 2LIS_02_S174 this will cover at least 60 to 70% of your requirements, tehn it is betterto enhance the DS and use it.

Thanks

Reddy