cancel
Showing results for 
Search instead for 
Did you mean: 

data source

Former Member
0 Kudos

hi gurus,

where will we do modifications to a data source?

can any explain me ? if any documetns please forward to following id: sap_remo@yahoo.com

thanks

ram

points are rewarded.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ram,

Can you pls let us know which datasource you want to modify?

However, you can go to T.Code RSA6-> Select your datasource->Function Enhancement.

Regards,

Amit

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

Datasource have to be modified in R/3. if its a logistics datasource, u need to change/enhance the extract structures in lbwe.

in case of master data sources they can be enhanced in rsa6. etc.

Depends on your exact requirement. you need to replicate the datasources in Bw after the changes and then the futher mapping of the additional/new fields to be done with related infoobjects in transfer structures in BW.

hope it helps...

thanks,

(please dont forget to assign points if it helps..)

Former Member
0 Kudos

Hi:

Depending on the requirements,most of the time you may have ask to add some additional fields into the cube .

1. Find out what field do you need from R/3 and what table it's sitting.

2. Add this new field into your data source.( for eg: Logistics (T-code-LBWE), click on the relevant datasource. look into the extract structure.some times,the field you want may be hided in the extract structure.

3. Go to CMOD and choose a project. choose for which u want to enhance (Master data or transaction data)

4. Check in RSA3 if you get the correct record or not.

5. Replicate this into bw.

6. Map this new field with appropriate Info Object in Transfer rules.

7. Add this new infoObject into your comm structure.

8. Also add this new Object into your cube and maintain the dimision in the cube as well.

9. activate the cube and update rule as well.

10 test your result.

Kavi

please assign points if this is helpful!!

Former Member
0 Kudos

Hi kavi,

how u get data filled into that new added filed?. i mean can that be filled with previous history data or only from now only data is filled

thanks

ram

Former Member
0 Kudos

Hello Ram,

You can fill these fields by a specific userexit (for transactional or master data) in CMOD (through the enhancement RSAP0001. You can access the function module EXIT_SAPLRSAP_00n and put your own code in the Z include.

say for eg: if u have added an extra field in any document like billing document, you can right the logic for filling the same from the table for record with doc. no same as the doc no in the communication structure.

hope this helps...

thanks