Data Loading

Lo related datasources.

• New Datasource
• Checking : Check the existing setup table to see if data is present in the setup tables. Go to SE16 and give the setup table name
• MC<Application Number>M_0<datasource>SETUP
• MC02M_0ITMSETUP
• Deleting : If data is present in the setup tables, delete them and re-load them again. Remember  that set up tables are filled for the whole application and not for each datasource.
• Set up table data will be deleted for whole 'Purchasing' if deleting for '02' even though you want data reload for only Purchasing Item datasource 2lis_02_itm.
• T-Code : LBWG 
• Or SBIW -> Settings for Application-Specific Datasources(PI) -> Logistics  -> Managing Extract Structures -> Initialization -> Delete the contents of the setup tables  
• Filling : Go to corresponding t-code for each application (unlike deleting, filling setup table t-code is different for each application or Goto SBIW ->  SBIW -> Settings for Application-Specific Datasources(PI) -> Logistics  -> Managing Extract Structures -> Initialization -> Filling in setup tables -> Application Specific setup of statistical data -> (choose your application)
• Depending on the screen you get over there, selections can be given and data can be filled to the setup tables or you can run it wide open.
• Remember to run in background, so that its easy to monitor and know the status. The job will be scheduled under job name 'RMCENEUA'.
• Once the job is completed, the data is available to load to BW Via 'Full Update'
• Existing datasource
• Once the new field is added to the datasource, there are two ways to go.
• Historic data is not required for the new field
• So we need not do anything. Just add the field and the code if needed any in the exit and  let the regular process chains get the delta and fill the data
• Historic data needed
• For this we need to do a full load. So we need to follow all the steps as for a new datasource and fill the history.
• Looks for downtime ( when the delta's are not running) Fill the setup tables and do a full load to BW and to the infoprovider. It will take care of the existing data and also writing data to the new fields.
• Delta need/will NOT be disturbed. No Initialization is required.