Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Mergin Purchase Order Items and Material Movements / Stocks

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.

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question