Question Re: How to check Data Source extraction Logic in Technology Q&A

How to check Data Source extraction Logic

Former Member — Wed, 11 Nov 2009 20:40:13 GMT

Hi Experts

Please explain me in details steps how/where can i check the logic of data sources

We have data sources based on

1) Custom data source based on Function Module (Where can i check the code/logic....)

2) Standard Business Content Data source (Where can i check Logic)

3) Standard Business Content Data source which is enhanced to inculde ZZ fields (Where can i check Logic)

Re: How to check Data Source extraction Logic

dennis_scoville4 — Wed, 11 Nov 2009 21:15:30 GMT


1) Custom data source based on Function Module (Where can i check the code/logic....)

Go to tcode RSO2, enter the generic DataSource name and click Display. In the next screen, it will show you the Function Module that that's used for the extraction of data. Copy that FM name, go to tcode SE37, past the FM name that you previously copied and then click on Display. This is where you can view the extraction logic for the generic DataSource based on a Function Module.


2) Standard Business Content Data source (Where can i check Logic)

Follow the same for display of generic DataSource source. On the initial screen, if you get an I-type message after clicking on Display, that message displays the name of the Function Module being used, otherwise hit Enter to get to the next screen.


3) Standard Business Content Data source which is enhanced to inculde ZZ fields (Where can i check Logic)

Transaction CMOD is used for the creation/maintenance of User Exits. In CMOD, use the dropdown to select the custom Project that's been defined on your source SAP application for BW extraction User Exits, and select the Components radio button. Click on Display. A list of INCLUDE programs will be shown. These INCLUDE programs each represent the four types of DataSources.

EXIT_SAPLRSAP_001 - Transaction Data DataSources User Exit

EXIT_SAPLRSAP_002 - Master Data Attribute DataSources User Exit

EXIT_SAPLRSAP_003 - Master Data Text DataSources User Exit

EXIT_SAPLRSAP_004 - Master Data Hierarchy DataSources User Exit

You will have to know the type of data (e.g. Transaction, Master Data Attribute, etc) to know which INCLUDE to go into. Once you know which one to go into, double-click on it and this will bring into display mode on that INCLUDE. Another INCLUDE will be present that begins wth Z*. Double-click on that, and you should then be in the area where the logic is for determining where to go if the DataSource has a certain value and you should be able to get to the code to read through it from there.

You can also get to these EXIT_SAPLRSAP_NNN programs via tcode SE38.

Re: How to check Data Source extraction Logic

ravishanker_cheedepudi — Wed, 11 Nov 2009 21:22:13 GMT

1) Custom data source based on Function Module (Where can i check the code/logic....)

Check the Datasource it will have Function module , Goto SE37 and give the FM name and check the source code ..

2) Standard Business Content Data source (Where can i check Logic)

RSA2 --> Give the data source name --> extraction tab there is extractor field will have FM name , double click on it and see the logic for that extractor ..

3) Standard Business Content Data source which is enhanced to inculde ZZ fields (Where can i check Logic)

depends upon the data source type (transaction data and master data) go to include program ZXRSAU01 or 02 etc ..

under the specific datasource check logic ..

Ravi

Re: How to check Data Source extraction Logic

Former Member — Wed, 11 Nov 2009 21:55:56 GMT

Thanks for all the update

Could you please update me on

2) Standard Business Content Data source (Where can i check Logic)

Follow the same for display of generic DataSource source. On the initial screen, if you get an I-type message after clicking on Display, that message displays the name of the Function Module being used, otherwise hit Enter to get to the next screen.

I didn't follow I-type message

Re: How to check Data Source extraction Logic

former_member181964 — Thu, 12 Nov 2009 03:40:46 GMT

Hi,

It is diffecult to check "Standard Business Content Data source (Where can i check Logic)" becasues internally it is having thousends of line of code and Include programs etc.. if you want to then goto RSA3 and check Debug and execute it it will go to all code. Else goto RSA2 and find teh FM and then debug it.

Thanks

Reddy

Re: How to check Data Source extraction Logic

Former Member — Thu, 12 Nov 2009 04:36:37 GMT

Hi,

For check the code you need to follow the bellow steps:

1) Custom data source based on Function Module :

a).Check the Datasource in RSO2(custom datasource/Generice datasource).

b).Find the Function module in RSO2.

c).Goto SE37 and give the FM name and check the source code ..

2) Standard Business Content Data source

i).Goto RS02.

ii).Give the data source name --> On the initial screen, if you get an I-type message after clicking on Display, that message displays the name of the Function Module .

iii).Goto SE37, check the souce code.

3).Standard Business Content Data source which is enhanced to inculde ZZ fields

a). GOTO CMOD.

b).Give the project name and click on display.

c). double click on ZXRSAUO1.

d). it displays

EXIT_SAPLRSAP_001 - Transaction Data DataSources User Exit

EXIT_SAPLRSAP_002 - Master Data Attribute DataSources User Exit

EXIT_SAPLRSAP_003 - Master Data Text DataSources User Exit

EXIT_SAPLRSAP_004 - Master Data Hierarchy DataSources User Exit

e). select relevent Exits.

f). Find your datasouce name from WHEN'DATASOUCENAME'.

g). check the code and find the functional module (if it exists).

you can follow above 3 types. those are halp full to check the code if requires.

Regards,

Suman