on 06-04-2008 7:17 AM
Hi BW experts,
can anybody explain about datasource enhancement with real time senarios. best answer could be rewarded with points.
Regards
Ravi prakash
Hi Prakash,
Enhancing DataSources
Use
The SAP enhancement RSAP0001 is available if you want to fill fields that you have added to the extraction structure of a DataSource as an append structure. This enhancement is made up of the following enhancement components:
Data Type
Enhancement Component
Transaction data
exit_saplrsap_001
Attributes, texts
exit_saplrsap_002
Hierarchies
exit_saplrsap_004
See also:
Changing the SAP Standard ® Customer Exits
Prerequisites
You have enhanced the extraction structure of the DataSource with additional fields.
Procedure
Note:
As soon as an SAP enhancement is assigned to one project, it can no longer be copied to another project.
1. In Customizing, choose the extractors (transaction SBIW in source system) Postprocessing DataSources ® Edit DataSources and Application Component Hierarchy.
2. Highlight the DataSource that you want to enhance and choose DataSource Function Enhancement.
The project management for SAP enhancements screen appears.-+
3. Specify a name for your enhancement project in the Project field.
4. Choose Project ® Create.
The Attribute Enhancement Project Display Documentation.
9. Save your entries.
If a project already exists for the SAP enhancement, you cannot save your entries. Go back to the initial screen and enter the existing project. Continue with step i).
10. Return to the start screen.
11. Select the Component subobject.
12. Choose Change.
The system displays the SAP enhancements you have entered with the corresponding components (in this case, function exit).
To display the documentation for a component, select the component and choose Goto ® Display Documentation.
13. Select the component (for example, EXIT_SAPLRSAP_001) that you want to edit and choose Edit ® Select.
The system displays the function module prepared by the SAP application developer. Use the include program contained in this module to transfer your functionality to the module.
14. Call the include program by double-clicking on it.
¡ The ABAP editor appears.
a. Enter the source text for your function in the editor and save your include program.
¡ The system asks whether you want to create an include program.
...
a. Confirm that you want to create an include program.
b. Specify the program attributes and save them.
c. Choose Goto ® Source Code.
The ABAP editor appears.
d. Enter the source text for your function in the editor and save your include program.
15. Return to the start screen.
16. Activate your enhancement project by choosing Project ® Activate Project.
See also:
Creating Additional Projects
Creating Customer-Specific Function Modules
Result
The enhancement is activated and at the runtime of the extractor, the fields that have been added to the DataSource using the append structure are filled with data.
Editing DataSources & Application Component Hierarchies
Use
To adapt DataSources to your requirements, you can edit them in this section before transporting them from a test system into a productive system.
In this section, you can also post-process the application component hierarchy.
Procedure
DataSource
Transporting DataSources
Select the DataSources you want to transport from the test system into the productive system. Next, choose Transport. Enter a development class and a transport request. Otherwise the DataSources cannot be transported.
Maintaining DataSources
To maintain a DataSource, select it and choose Maintain DataSource. The following editing options are available:
· Selection
When scheduling a data request in the BW Scheduler, you can enter the selection criteria for the data transfer. For example, you may want to determine that data requests are only to apply to data from the previous month.
If you set the Selection indicator for a field within the extract structure, the data for this field is transferred in accordance with the selection criteria in the scheduler.
· Hide field
You should set this indicator to exclude an extract structure field from the data transfer. As a result of your action, the field is no longer made available in BW when setting the transfer rules and generating the transfer structure.
· Inversion
Reverse postings are possible for customer-defined key figures. For this reason, inversion is only possible for certain transaction data DataSources. These include DataSources that have a field that is indicated as an inversion field, for example, the field update mode in the DataSource 0FI_AP_3. If this field has a value, then the data records are interpreted as reverse records in BW.
Set the Inversion indicator if you want to carry out a reverse posting for a customer-defined field (key figure). The value of the key figure is then transferred in inverted form (multiplied by u20131) into BW.
· Field only known in exit
You can enhance data by extending the extract structure for a DataSource using fields in append structures.
The indicator Field only known in exit is set for fields of an append structure. In other words, by default these fields are not passed onto the extractor from the field list and selection table.
Deselect the indicator Field only known in Exit to enable the BW Service API to pass on the field of the append structure to the extractor together with the fields of the delivered extract structures in the field list and selection table.
Enhancing the Extract Structure
If you want to transfer additional information for an existing DataSource from a source system into BW, you first need to give the DataSource extract structure additional fields. To do this, create an append structure for the extract structure (see Adding Append Structures).
...
1. Choose the button Enhance Extr. Str., to access field maintenance for the append structure. The name of the append structure is taken from the extract structure name in the customer namespace.
2. Enter the fields you want to add together with their subordinate data elements into the field list. You can use all functions for field maintenance for tables and structures here.
3. Save and activate your append.
4. Go back to the DataSource display and make sure that the Hide Field indicator is not selected for the newly added fields..
Function Enhancement
To fill the append structure fields with data, you need to create a customer-specific function module. For information about enhancing the SAP standard with customer-specific function modules, see Enhancing the SAP Standard in SAP Library.
The SAP enhancement RSAP0001 is available to enhance DataSources for the SAP Business Information Warehouse. This enhancement is made up of the following enhancement components:
Transaction data
exit_saplrsap_001
Attributes, texts
exit_saplrsap_002
Hierarchies
exit_saplrsap_004
From Release 6.0, the Business Add-In (BAdi) RSU5_SAPI_BADI is available. You can display the BAdI documentation in the BAdI definition or BAdI implementation.
Application Component Hierarchy
· To create a same-level or subordinate node for a particular node, place the cursor over this node and click on Object ® Create Node. You can create subordinate nodes by choosing Object ® Create Children.
· To rename/expand or compress a node, place your cursor over the node and click on the appropriate button.
· Hereu2019s what you need to do to reposition a node or subtree: Select the node you want to reposition (by positioning the cursor over it and choosing Select Subtree), position the cursor on the node onto which the selected node is to be positioned. Then, choose the button Reposition.
· If you select a node with the cursor and choose Set Segment, this node is displayed with its subnodes. You can goto the super-ordinate nodes for this subtree via the appropriate links in the row above the subtree.
· If you select a node with the cursor and choose Position, the node is displayed in the first row of the view.
· All DataSources for which a valid (assigned) application component could not be found are placed under the node NODESNOTCONNECTED. The node and its sub-nodes are only built at transaction runtime and refreshed when the display is saved.
NODESNOTCONNECTED is not persistently saved to the database. For this reason, it is not transferred in a particular status into other systems due to the transport of the application component hierarchy .
Note: Hierarchy nodes created under NODESNOTCONNECTED are lost when a save is carried out. After saving, the system only displays nodes under NODESNOTCONNECTED that were moved under this node with DataSources.
A DataSource hangs under an application component X. You transfer a new application component hierarchy from Business Content that does not contain application component X. The result is that thus application component is automatically placed under the node NODESNOTCONNECTED.
Note: Changes to the application component hierarchy are only valid until the next transfer from Business Content.
thanks
abdul
reward me points if usefull
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just a thought - but why not try the BW forum?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.