cancel
Showing results for 
Search instead for 
Did you mean: 

Mergin Purchase Order Items and Material Movements / Stocks

alberto_rosado
Explorer
0 Kudos

Hello,

We have a requierement to add a couple of fields on Stocks infocube which are informed in the Purchase Order Items DSO.

We are considering following options:

  • Create a new dimension with these two fields in Stocks Infocube, and inform the fields by code, selecting the data from Purchase Orders DSO. This is possible as we have purchase order number in the standard material movement extractor.

  • Create a multiprovider with Stocks infocube and Purchase Orders Items, the problem here is that Stocks infocube does not have purchase order number, so we might have to add this new field to the infocube, probably in a line item dimension, so the multiprovider is consistent.

  • Create directly a new DSO, merging data with same purchase order, coming from 2LIS_02_ITM (purchase orders items) and 2LIS_03_BF, material movements. Here we would not need all the movements, only some with specific purchase order type.

Considering that data volume is high, as we are working in Retail enviroment, and performance is really important for us, what do you think will be the best option?

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

former_member181964
Active Contributor
0 Kudos

Hi,

Create a new dimension with these two fields in Stocks Infocube, and inform the fields by code, selecting the data from Purchase Orders DSO. This is possible as we have purchase order number in the standard material movement extractor.

Try to do it in ECC DataSource Enhancement it self for BF and UM DataSources. i.e. 0IC_C03 DataSOurces with PO Data

Create a multiprovider with Stocks infocube and Purchase Orders Items, the problem here is that Stocks infocube does not have purchase order number, so we might have to add this new field to the infocube, probably in a line item dimension, so the multiprovider is consistent.

You need to Enhance Cube and DataSources with required fields, other wise you can't get correct data in rpeorts, Becasue PO and PO ITem, Plant, batch, Day/Month, etc fieds must be common in both CUbes/DSOs to create Multiproviders.

Create directly a new DSO, merging data with same purchase order, coming from 2LIS_02_ITM (purchase orders items) and 2LIS_03_BF, material movements. Here we would not need all the movements, only some with specific purchase order type.

If common Fields are there you can do it. But checl whether DSO will support 2LIS_03_BF DataSource read the following OSS

Note 581778 - ODS capability of extractors from inventory management.pdf

Considering that data volume is high, as we are working in Retail enviroment, and performance is really important for us, what do you think will be the best option?

Minimize the Enhancement fields at DataSource level, in Code use

In ECC

Indexs to on tables where the data is getting in CMOD

User Sort, For All Entries in Code in CMOD

Load at night times.

In BW

Delete Indexes on Cube before loading data

Load data and create Indexes

If posible use DataSelections in InfoPackage (don't use it for LO DataSources)

Increase the hardware sizing.

etc..

Thanks

Reddy

alberto_rosado
Explorer
0 Kudos

Thank you Raymond and Surendra.

We chose the option of a multiprovider, adding purchase doc to stocks infocube to have a common key between Stocks and purchase orders.

Hopefully performance will not decrease a lot.

Kind regards.

Answers (1)

Answers (1)

Former Member
0 Kudos

>

> Hello,

>

> We have a requierement to add a couple of fields on Stocks infocube which are informed in the Purchase Order Items DSO.

>

> We are considering following options:

>

> * Create a new dimension with these two fields in Stocks Infocube, and inform the fields by code, selecting the data from Purchase Orders DSO. This is possible as we have purchase order number in the standard material movement extractor.

>

> * Create a multiprovider with Stocks infocube and Purchase Orders Items, the problem here is that Stocks infocube does not have purchase order number, so we might have to add this new field to the infocube, probably in a line item dimension, so the multiprovider is consistent.

>

> * Create directly a new DSO, merging data with same purchase order, coming from 2LIS_02_ITM (purchase orders items) and 2LIS_03_BF, material movements. Here we would not need all the movements, only some with specific purchase order type.

>

> Considering that data volume is high, as we are working in Retail enviroment, and performance is really important for us, what do you think will be the best option?

>

> Thanks in advance.

I'm also in the Retail environment with the exact same requirement. IMHO, Creating Multiprovider is the better option as data volume is high in retail env (Any lookups in ETL will surely slow down loading performance). You can enable EBELN into DS 2lis_03_bf to get PO doc which will be used in MP to link stocks cube and purchasing cube (or DSO).

For my scenario, my multiprovider is taking Inventory Cube and Purchasing Cube with Article, PO doc as the main keys to link both. I've also created aggregates on both cubes and the Query runtime is quite fast.