Data sources

[Former Member]

Hi all,

Can anybody tell me about 2lis_o3_bx, 2lis_03_bf and 2lis_03_um data sources and when these data sources are uses in business scnerio ???

Today i saw a business scnerio on my client system that scnerio taking data from these three data sources and update one cube i want to create that type of scnerio but i have no idea related to this so please help me out .

thanks and regards

Ankit

[former_member345199]

Hi,

These are the standard data sources used for Inventory extraction.

2LIS_03_BX- Initial Stock/Material stock

2LIS_03_BF - Material movements

2LIS_03_UM - Revaluations/Find the price of the stock

The first DataSource (2LIS_03_BX) is used to extract an opening stock balance on a

detailed level (material, plant, storage location and so on). At this moment, the opening

stock is the operative stock in the source system. "At this moment" is the point in time at

which the statistical setup ran for DataSource 2LIS_03_BX. (This is because no

documents are to be posted during this run and so the stock does not change during this

run, as we will see below). It is not possible to choose a key date freely.

The second DataSource (2LIS_03_BF) is used to extract the material movements into

the BW system. This DataSource provides the data as material documents (MCMSEG

structure).

The third of the above DataSources (2LIS_03_UM) contains data from valuated

revaluations in Financial Accounting (document BSEG). This data is required to update

valuated stock changes for the calculated stock balance in the BW. This information is

not required in many situations as it is often only the quantities that are of importance.

This DataSource only describes financial accounting processes, not logistical ones. In

other words, only the stock value is changed here, no changes are made to the

quantities. Everything that is subsequently mentioned here about the upload sequence

and compression regarding DataSource 2LIS_03_BF also applies to this DataSource.

This means a detailed description is not required for the revaluation DataSource.

http://help.sap.com/saphelp_bw32/helpdata/en/05/c69480c357354a8846cc61f7b6e085/content.htm

http://help.sap.com/saphelp_bw33/helpdata/en/ed/16c29a27db6e4d81a015be8673eb80/content.htm

How to Handle Inventory Management Scenarios in BW (NW2004)

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98bd7c01...

https://websmp205.sap-ag.de/~sapdownload/011000358700002121282004E/HowToInventory10.pdf

Thanks,

JituK

[Former Member]

Hi,

Business Scenario

2.1 Inventory management with non-cumulative key figures

The reporting requirement is to report the historical stock balances on a daily level and

90 percent of all materials were moved 1 time in the month.

The query-runtime is excellent. To reduce the data volume in the fact table, it is better to

use the non-cumulative key figures.

2.2 Inventory management with SnapShots

The reporting requirement is to report the historical stock balance on a monthly level of

all materials. 90 percent of all materials were moved 1 time in the month.

Due to the high amount of movements the query-runtime is bad. To reduce the query

runtime of the non-cumulative InfoCube, the SnapShot Scenario should be implemented

in parallel. (see 2.3)

2.3 How to choose the right scenario

The SnapShot loads data for every key figure and granularity of the InfoCube. This can

end in a very high data volume and batch process time. The movements are not stored

in the InfoProviders. An retrace of one special stock is not possible.

The non-cumulative key figures calculate stock during query runtime. The source of the

calculation is the loaded movements and a special reference point. In general this means

that the report can display stock on a date where no movement is loaded. This feature

can end in a bad runtime of the query.

regards

Harikrishna N

[Former Member]

Hi Ankit,

the 2lis_o3_bx, 2lis_03_bf and 2lis_03_um data sources are used for inventory /material management data.

simple senario: if we are working for past 5 to 7years of data and also for loading changes of current data in MM thn we use these data sources.

2LIS_03_BX: for initial load of data.

2LIS_03_BF: for material movements ( how much data is loaded from past 2months ...for this marker is set in BW side based on that past and future movements of that material is given..like these senarios its used).

2LIS_03_UM: for revaluation of the materials. ( if you brought the materail in past days and now the price has changed. caluclating the change price or revaluating tat materail.)

hope it will gives clear info abt your doubt on MM data sources.

[Former Member]

Hi

here inventory means stock of that material ?????

Beacause in MM there is no table for storing material stock on month basic .

one more question after using and implement these data sources in BW is it work as like R3 standard report MC.1 or MC.9 ?????

thanks

[varma_narayana]

Hi

2lis_o3_bx, 2lis_03_bf and 2lis_03_um data sources are used to extract Inventory (Material Movements) data from SAP.

You can go thru the "How to Paper on Inventory Management Scenarios" for more details.

cheers.