cancel
Showing results for 
Search instead for 
Did you mean: 

regarding datasource enhancement?

Former Member
0 Kudos

Hi BW experts,

can anybody explain about datasource enhancement with real time senarios. best answer could be rewarded with points.

Regards

Ravi prakash

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks for your valuable explanation on datasource enhance now i got idea.

Regards

Ravi prakash reddy

Answers (1)

Answers (1)

matt
Active Contributor
0 Kudos

Just a thought - but why not try the BW forum?

Former Member
0 Kudos

Thanks for your valuable suggision.

Regards

Ravi prakash