Setup table filling

[Former Member]

Hi Experts,

I have a question with regards to setup tables fill up for 2LIS_03_UM.

-Initially deltas from 2014 have been setup for 2LIS_03_BF's and data has been loaded to a Custom-DSO. Later data from 2004-2013 has also been      loaded to the custom DSO. Now 2004-2013 data should be loaded to 0IC_C03 from DSO for BF data.

-2LIS_03_UM deltas from 2014 have been setup. Now I need to fill setup tables for data from 2004-2013. I'm going to fill the setup tables using Company code, fiscal year fields. This data should be loaded to 0IC_C03. Inorder to do this, as a first step I have deleted the setup tables for app.component 03 using LBWG as I found 20 records in setup tables related to 2LIS_03_BF.

As a second step, I am trying to fill up the setup tables for 2LIS_03_UM. However I am getting them message that "DATASOURCE 2LIS_03_BF HAS STILL DATA TO BE TRANSFERRED". I couldn't proceed further.

So, my questions here are

1. Do I have to request ECC downtime in order to fill the setup tables. (Remember, I only intend to fill up for 2LIS-03-UM.)

2. "DATASOURCE 2LIS_03_BF HAS STILL DATA TO BE TRANSFERRED" is the message I have been receiving while trying to fill up for 2lis_03_um. What does this mean? Is this somehow related to unprocessed requests in SM13. Or is this being encountered as the deltas are running(daily twice) and they are queued up.

Please suggest me what needs to be done here.

Thanks,

Sandeep

[RamanKorrapati]

Hi,

1. You want fill setup tables for past data(2004 -2013). so down time not is not required here.

2. As per the delta set up, 03 application data will be still exist at ecc side queues(SMQ1/SM13/LBWQ). No issue about it. its just warning and ignorable.

Lets try to fill setup tables as per needs.

Later try to use repair full request to load data from set up tables.

While using repair full request, use proper selections to load data 2004 -2013 data only.

Thanks

[former_member186399]

Dear Sandeep,

1) ECC downtime is not required if your intention is load only 2004 to 2014 data.

2) Ignore this warning message. This shows that the data for 03_BF is still available in the queues  to be extracted to BW. You may fill the table for 03 UM and load it in BW without impacting any of your queues.

Regards

Gajesh

[former_member185132]

Hi,

I hope you are doing all these activities in D and Q first, not in P. It is really easy to totally mess up Inventory reporting if you haven't planned your activities carefully. For best results, try to have a copy of ECC P in the ECC Q system so you can simulate the scenario accurately.

Do I have to request ECC downtime in order to fill the setup tables.

To answer that, I need to understand the complete scenario here: are you going to reload 0IC_C03? Is BX going to be reloaded? If not, why not? What is your current plan and requirement?

Is this somehow related to unprocessed requests in SM13

It is a warning, and it is usually because there is some data still left in the delta/extraction queue for BF.

Regards,

Suhas