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

Inventory Mangement steps - questions

Dear Experts,

I have a task in hand to implement Inventory Management in SAP BW 3.5. Now, this is the first time that we will be implementing anything related to Logistics and I havenu2019t done so earlier in my support projects. I have got 10 hrs of down

I have gone through some threads (as below) and the How to document for the same.

Setting up material movement/inventory with limit locking time

Treatment of historical full loads with Inventory cube

how to run setup tables for two clients with in one system

I have below ques:

1) The How to document says, u201CMany customers also use program RSM13005 (schedule job periodically) to import data from an application from the central update table to the delta queue or RMBWV303 to write data from the extraction queue to the delta queue. In this case, also make sure that the program is not to be started before the initialization has been carried out successfully as this results in the loss of data records in the extraction queue or central update table.u201D

Q u2013 How to make sure that the program is not started before the initialization has been carried out.

2) As answered by Surendra Reddy in one of the thread - Treatment of historical full loads with Inventory cube

Step 2.First clear Setuptables, RSA7, SMQ1 in ECC and Cube data in BW.

Q2.1 u2013 Do I have to clear setuptables from LBWG- MC03BX0SETUP, MC03BF0SETUP?

Q2.2 - SMQ1 u2013 Do I need to delete all the entries in there or any specific?

Q2.3 - RSA7 u2013 Do I need to delete entries for 2LIS_03_BX (I guess it wonu2019t be there as this is delta Q?) , 2LIS_03_BF and 2LIS_03_UM?

3) The How to document says u2013 u201CActivate the extract structure MC03BF0 for the corresponding DataSources 2LIS_03_BX/2LIS_03_BF in the LO cockpit (transaction code in R/3: LBWE) before initializing the opening balanceu201D

Q u2013 Should I activate 2LIS_03_BF after successful initialization run of 2LIS_03_BX OR even if both are activated before 2LIS_03_BX run, that is fine?

4) The thread says in step 6 i.e. after initialization run of 2LIS_03_BX.--> Delete the setup tables once the BW load completes.

Q - Which Setup tables ???

5) The thread says in step 12 i.e. after "Initializing the delta process" run of 2LIS_03_BF  Delete the setup tables once the BW load completes.

Q - Which Setup tables ???

6) The thread says in step 15 i.e. after "Initializing the delta process" run of 2LIS_03_UM  Delete the setup tables once the BW load completes.

Q - Which Setup tables ???

7) Step 19 says "STOP V3 JOBu201D don't run till all Historical data is finished.

Q u2013 Do I need to check in LBWE u2013 job control (against Inventory Controlling) that it is not scheduled?

8) In the same thread Shirley Tremblay stated that when she was running Historical loads of BF to fill the setup table when divided into multiple jobs spread historically it wasnu2019t giving the right data while when she ran a full setup table for BF resulting in many hours of runtime, she got correct results.

Q u2013 What is the right process?

9) For running historical loads of UM to fill the setup table -

Q - Do I need to run these loads after successful historical run of BF or can this be started alongwith BF?

10) Do I need to run the FULL Load IP (for historical runs) with same date ranges as I gave for filling the respective setup tables?

replied

Hi,

Q1.How to make sure that the program is not started before the initialization has been carried out.

A- All the users needs to be out and check BG jobs for this Prog TCODE- (MCNB)

Q2.1 u2013 Do I have to clear setuptables from LBWG- MC03BX0SETUP, MC03BF0SETUP?

A - Yes

Q2.2 - SMQ1 u2013 Do I need to delete all the entries in there or any specific?

A- All.

Q2.3 - RSA7 u2013 Do I need to delete entries for 2LIS_03_BX ?

A- Dont delete the init,Empty the Queue and pull data to BW and Delete the Data.

Q Should I activate 2LIS_03_BF after successful initialization run of 2LIS_03_BX OR even if both are activated before 2LIS_03_BX run, that is fine?

A- Activate the str before running the DS BF.

Q- The thread says in step 6 i.e. after initialization run of 2LIS_03_BX.--> Delete the setup tables once the BW load completes. - Which Setup tables ???

A- Setup tables for Application Comp 03 to avoid data missmatch casue you will be filling setup tables again for BF and then UM.

Rest you have How to Document for IM implementation and follow SAP Notes.Abt full Load data load depends Volume of your data that will be heavy any way.Try splitting on Data range.

You are asking deleting which setup tables every time you have to delete 03 only.Try this Blog for Retail management they have given, how to handle these data source as per 7.0.

http://wiki.sdn.sap.com/wiki/display/Retail/AnalyticsforSAPforRetail

Read Confugration guide for RMA.This tells you steps for these data sources in Detail.

~AK

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