Dear Suresh,
Generic Data Source is created whenever the SAP Content Data source doesnu2019t support our requirement And then we can create a data source with respect to our requirement.
There are two ways you can enter into the creation screen of generic data source:
1) By entering SBIW as the T-code.
Expand the Generic Data sources icon and press on the clock symbol (IMG activity)
Or Instead of all the above steps you can simply use T-code: RSO2
Now you have the option to create, change or display a Data source for transaction Data, Master Data attributes or Texts.
Give a Proper technical name of the Data Source you want to create and press create
Now select the Application Component in which you want to create the datasource
After selecting the application component. Fill the Description fields. And now select the mode of extraction you want to do like
1) Extraction from View/Table
2) Extraction from SAP Query
3) Extraction by function module
And once you give the name of the view/table from where you want to extract. Press Generic delta button at the top.
Here we have three options for delta updation:
Time Stamp: If we want to update change in the records with respect to the time interval then this option is selected.
Calend. Day: If we want to update change in the records with respect to day to day basis then this option is selected.
Numeric Pointer: If we want to update in case of record which is completely new with respect to Field name then we use this option.
And we have got some settings like:
Safety Interval upper limit:
This field is used by Data Sources that determine their delta generically using a repetitively-increasing field in the extract structure.
The field contains the discrepancy between the current maximum when the delta or delta init extraction took place and the data that has actually been read.
Leaving the value blank increases the risk that the system could not extract records arising during extraction.
Example: A time stamp is used to determine the delta. The time stamp that was last read is 12:00:00. The next delta extraction begins at 12:30:00. In this case, the selection interval is 12:00:00 to 12:30:00. At the end of extraction, the pointer is set to 12:30:00.
A record - for example, a document- is created at 12:25 but not saved until 12:35. It is not contained in the extracted data but, because of its time stamp, is not extracted the next time either.
For this reason, the safety margin between read and transferred data must always be larger than the maximum length of time that it takes to create a record for this DataSource (with a time stamp delta), or it must display an interval that is sufficiently large (for determining delta using a serial number).
Safety Interval Lower Limit
This field contains the value taken from the highest value of the previous delta extraction to determine the lowest value of the time stamp for the next delta extraction.
For example: A time stamp is used to determine a delta. The extracted data is master data: The system only transfers after-images that overwrite the status in the BW. Therefore, a record can be extracted into the BW for such data without any problems.
Taking this into account, the current time stamp can always be used as the upper limit when extracting: The lower limit of the next extraction is not seamlessly joined to the upper limit of the last extraction. Instead, its value is the same as this upper limit minus a safety margin. This safety margin needs to be big enough to contain all values in the extraction which already had a time stamp when the last extraction was carried out but which were not read. Not surprisingly, records can be transferred twice. However, for the reasons above, this is unavoidable.
Data Source Is Real-Time Enabled
The 'real time enabled' indicator determines whether a delta-enabled Data Source can be used as a supplier of data for a real-time daemon.
And there are two options provided like
1) New Status for changed records:
If you select this option each record to be loaded delivers the new status for the key figures and characteristics. DataSources with this delta type can write to ODS objects or master data tables.
2) Additive Delta:
The key figures for extracted data are added up in BW. Data Sources with this delta type can supply data to ODS objects and Info Cubes.
After giving the required selections of all the above options save the data source.
Then you will get a screen where you have options like:
1) Selection:
Check it when you want to select the range of the values to be picked from this field. Once we select this field, it will be available in the infopackage under the Data Selection tab for selecting the range.
2) Hide Field:
Check it when you donu2019t want this field to be extracted.
3) Inversion:
This will give the negative value of the field.
4) Field Only:
If a field is required only for certain calculation purpose and not for extraction then we can check this option.
Once we give all the above selections, save it and replicate the Data source in BW.
Also check these links for Views..
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed06446011d189700000e8322d00/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm
Hope this helps u...
Best REgards,
VVEnkat..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.