SAP Table question

[Former Member]

Hello, has anyone worked on the following tables like bringing them in BW into inventory module?

MCHB

MSLB

MSPR,MSSQ

MSKA,MSSA

if so can you tell me the relationship between these tables? i tried to find online but was not able to get anything.

Thanks

[sander_vanwilligen · Accepted solution]

Hi Venkat,

First of all, it's convenient to use the ABAP Dictionary for drawing up an ERD (Entity Relationship Diagram). You can do it using t/code SE11 for all tables which you mentioned.

E.g. for table MCHB (Batch Stocks).

Within t/code SE11 you have the option to graphically show the data model with different views (Ctrl+Shift+F11 or the Graphic icon in the task bar). The default view in my system is Foreign Key Relationships.

Here you can see all entities (tables) with their foreign key relationships. This is important to get an overview.

For the extraction I am pretty sure that the standard 2LIS extractors will do the job:

2LIS_03_BF - Material Movements

2LIS_03_BX - Stock Initialization

2LIS_03_UM - Revaluations

Fields like WBS Element, Batch Number, Sales Order Number, etc. are available. Please refer to e.g. SAP Help.
2LIS_03_BF and 2LIS_03_UM support delta extraction.

Best regards,

Sander

[Former Member]

Hi Venkat,

If you are trying to replicate a Z-report from source in BW, why don't you explore the option below

1. Tweak the Z-report code to dump processed data in a new Z-table in source.

2. Run the report in backgound in a scheduled manner.

3. Create infoproviders DSO/Cube in BW and Generic datasource with suitable structure

4. Load the infoprovider in a scheduled manner using generic datasource.

5. Build your report on the infoprovider.

Warm Regards,

ajay

[RamanKorrapati]

Hi,

if you take source team help, they can suggest you about the relations between those tables.

Even at SE11, by using view also you can see the primary and foreign key relations between tables.

About relations you can take abap expert help also.

In general inventory extraction may be you know which use LO Data sources(03 - application) which already shared by Sander. if you need same data sources then from Google you may get step by step extraction procedures.

Thanks

[Former Member]

Thank you for your feed back. I am planning to bring these tables in to BW by creating DSOs for each. I see there is a creation date in each of these tables. if i use this date as my delta pointer. would it be ok? would my delta be triggered when some quantity changes? That would be really helpful. Please let me know.

Thanks.

[sander_vanwilligen]

Hi Venkat,

My recommendation remains the same: explore if the standard 2LIS inventory extractors (2LIS_03_BF - Material Movements; 2LIS_03_BX - Stock Initialization; 2LIS_03_UM - Revaluations) cover your requirements. This is an out-of-the-box solution which is a very powerful and proven way of extracting inventory.

Extracting the various tables will not make your life easier. A delta mechanism based on Creation Date does not work for changes considering the key of the tables.

Best regards,

Sander

[Former Member]

Sander, thanks for your help in this matter. Standard LIS extractors will not work for me as I am trying to duplicate a Z report built in ECC. so for example: the way LIS extractors are calculating Total stock is quite different than this Z report. This Z report is using the tables I mentioned in my posts and have to bring those in to BW.

Thanks.

[RamanKorrapati]

Hi,

if you need those tables data into bw side then think about generic extraction by using view or function module.

For delta pointer - you need to choose the right field which have change document property at domain level. if you tables have changed date, then we can use that field as delta pointer related.

You can load this data to separate target and build a multi provider to combine with you standard info cube 0IC_C03(inventory cube).

Thanks

[Former Member]

Thank you for your feedback. i need to know what fields i should use for delta pointer.

[Former Member]

Hello Venkat,

Basically in LO extraction field ROCANCEL is used for delta mechanisam. There are different values of ROCANCEL which represent status of record. Along with this you need to know the delta mechanism of LO extraction ex. ABR, ADD, etc.

Also for inventory please read to Inventory data loading.

Please revert if there are any doubts.

Thanks
Amit

[Former Member]

Hi,

my recommendation: if you need the results of the Z-Report, make a copy of it and let report write results to a new Z-table. On this Z-table you build a view extractor. It can be delta enabled if you're Z-report writes a date, so that you can identify the changed records per day or timestamp. In Bw build a transactional source on that view and extract data to BW. By the way do you have a BW 7.3?

In BW 7.3 you could easily use data flow diagrams to generate your data flow from data source to cube automatically.

In BW 7.0 you have to do the steps manually. Of course you can use delta loads from DSO to cube.

Do you need history?  Do the users report just the daily snapshot of total stocks? That's the point to decide whether to keep history or you can use full loads.

As it looks you don't need to bring all the tables to BW,this would create too much overhead.

Regards

Juergen

[Former Member]

If i bring them in to BW, how would i be able to do delta. can some throw some light on it? Thanks.