DATA SOURCE ENHANCEMENT STEPS WITH TRANSPORT PROCEDURE

[Former Member]

Please follow this step by step procedure carefully in order to avoid the risk of deltas getting disturbed. Especially if you are in production BW
Step by Step Procedure: -

Go to rsa6 and select data source to be enhanced

Click display, select extract structure and copy in se11

Go to append structure and create new append structure with zz or used already used one

Add fields and activate appended structure

Go back to rsa6 and select data source and click on change so as remove

Hide field and field only option from selections& activate data source.

you have to write ABAP code in User exit under CMOD & in Include ZXRSAU01.
All above changes will ask you for transport request. Assign appropriate development class/Package and assign all these objects into a transport request.
and declare select statement and populate the data for fields and act

1. 1. Carry out changes in LO Cockpit extractor in SAP R/3 Dev system.
   As per the requirement add new fields to Extractor.
   These new fields might be present in standard supporting structures that you get when you execute "Maintain Data source" for extractor in LBWE. If all required fields are present in supporting structure mentioned above then just add these fields using arrow buttons provided and there is no need to write user exit code to populate these new fields.
   However if these fields (or some of the required fields) are not present in supporting structures then you have to go for append structure and user exit code. The coding in user exit is required to populate the newly added fields. You have to write ABAP code in User exit under CMOD & in Include ZXRSAU01.
   All above changes will ask you for transport request. Assign appropriate development class/Package and assign all these objects into a transport request.
   
   2.Carry out changes in BW Dev system for objects related to this change.
   Carry out all necessary changes in BW Dev system for objects related to this change (Info source, transfer rules, ODS, Info cubes, Queries & workbooks). Assign appropriate development class/Package and assign all these objects into a transport request
   
   3.Test the changes in QA system.
   Test the new changes in SAP R/3 and BW QA systems. Make necessary changes (if needed) and include them in follow-up transports.
   
   4. Stop V3 batch jobs for this extractor.
   V3 batch jobs for this extractor are scheduled to run periodically (hourly/daily etc) Ask R/3 System Administrator to put on hold/cancel this job schedule.
   
   5. Lock out users, batch jobs on R/3 side & stop Process chain schedule on BW.
   In order to avoid the changes in database tables for this extractor and hence possible risk of loss of data, ask R/3 System Administrator to lock out the users. Also batch job schedule need to be put on hold /cancel.
   Ask System Administrator to clear pending queues for this extractor (if any) in SMQ1/SMQ2. Also pending /error out v3 updates in SM58 should be processed.
   On BW production system the process chain related to delta Info package for this extractor should be stopped or put on hold.
   
   What is "Zero Down Time" Initialisation in LO?

A downtime is the time in which a resource is not productive...in other words, when you perform some activities, you need to close your system to the users !
During setup tables filling job, you need to have no users that post documents in order to avoid any inconsistency (if you extract data from a table in which someone inserts something, you can loose or extract twice...)

1. 6.Drain the delta queue to Zero for this extractor.
   Execute the delta Info package from BW and load the data into ODS & Info cubes. Keep executing delta Info package till you get 0 records with green light for the request on BW side. Also you should get 0 LUW entries in RSA7 for this extractor on R/3 side.
   
   7. Import R/3 transports into R/3 Production system.
   In this step we import R/3 transport request related to this extractor. This will include user exit code also. Please ensure that there is no syntax error in include ZXRSAU01 and it is active. Also ensure that objects such as append structure is active after transport.
   
   8. Replicate the data source in BW system.
   On BW production system, replicate the extractor (data source).
   
   9. Import BW transport into BW Production system.
   In this step we import BW transport related to this change into BW Production system.
   
   10. Run program to activate transfer rules
   Execute program RS_TRANSTRU_ACTIVATE_ALL. Enter the Info source and source system name and execute. This will make sure that transfer rules for this Info source are active
   
   11.Execute V3 job Manually in R/3 side
   Go to LBWE and click on Job Control for Application area related to this extractor (for 2LIS_12_VCITM it is application 12). Execute the job immediately and it should finish with no errors.
   
   12. Execute delta Info package from BW system
   Run delta Info package from BW system. Since there is no data update, this extraction request should be green with zero records (successful delta extraction)
   
   13.Restore the schedule on R/3 & BW systems
   Ask System Administrator to resume V3 update job schedule, batch job schedule and unlock the users. On BW side, restore the process chains schedule.
   
   From next day onwards (or as per frequency), you should be able to receive the delta for this extractor with data also populated for new fields.