cancel
Showing results for 
Search instead for 
Did you mean: 

DS Enhancement Question !

Former Member
0 Kudos

Hello experts,

I wanted to understand some basic concepts of DataSource Enhancements., I am sorry to put such kind of wide and often asked thread again. But unfortunately i couldnt find clear understanding form the existing Posts and from SAP help site.

Here are my first Phase questions !

1) Can we do Enhancement to All the DS? ?Means those form SAP given and ZDS ?

2) 0DS ( SAP Given ) are build on multiple SAP Tables..Correct ? so if i have to enhance that, where do i specify those Joins of Tables ? The same way when we create ZDS ( View based ) and for view we define conditions and Joins.

3) Which DS are not Enhanceable ? If any ?

4) Can we do enhancement to 2LIS ...DS?

i guess let me first clear these basic questions..and then i have some more for each..

Thanks. for your time..

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Honar ,

Can we do Enhancement to All the DS

1.standard datasources are usually based on FM and SAP not allow us to change them .So we enhance them by adding some fields in there append structure and then populating them via cmod code .

2.Sometime for Z data sources also we do the same thing if changes in there basic struture are not feasable .

ex: A datasource is based on a view and we just need one more field from some other table then instead of changing view itself we just enhance data source for 1 field .

0DS ( SAP Given ) are build on multiple SAP Tables

Usually they are FM based .

We can't change them .So to enhance them we create an append structure and then add our fields in that .After extraction from FM or Tables CMOD code will get excuted and will populate fields from Append structure .

Which DS are not Enhanceable

All datasurces with a structure can be enhanced .

Can we do enhancement to 2LIS ...DS

yes .You can check lots of threads in SDN for the same .

Hope this will be helpful .

Regards,

Shreya

Former Member
0 Kudos

Thank you guys..

So, lets say, if i have a DS created on a VIEW, and that View also has some fields which are not in the DS, then in that case i just need to append strecture and add those additional fields..correct ? since those fields are mapped correctly in VIEW itself, then I dont need to write anything in to CMOD..i guess ..

former_member199691
Active Contributor
0 Kudos

If data source is cretaed on a view, all the fields from the view should be present in DS.

- check that fields are not hidden in DS. If yes, remove the check so that such fields can be used in BI.

- another possibility may be that view has been changed after DS was created, in that case you should just need to save the DS again (and also check the tick mark for hidden fields).

Regards,

Gaurav

Former Member
0 Kudos

Hi Honar ,

1. All fields that are in view will be available for data source .May be they are just hidden but they are actually present in your view and extract structure .Check in RSA2 .

2. If you have some field in table on top of which your view is created and you want them in your data source then you can just change your view and and unhide those fields so that they can be pulled in datasource at BW side .

3. For append structure lets we have a scenario :

ex: We have table COBRA and COBRB on which we have a view . Now I need some fields from ANLA table of asset master data .

My logic is i want to get all records by joining COBRA and COBRB and then by checking some specific value i want to populate ANLN1 field in my datasource .

Here i will not change my view instead of that i will create one append structure and will addone field in that .

Now i will write CMOD code to populate that field from table ANLA.

Hope this will clear your doubts .

Regards,

Jaya Tiwari

former_member199691
Active Contributor
0 Kudos

1) Can we do Enhancement to All the DS? ?Means those form SAP given and ZDS ?

Yes, using CMOD we can enhance all the data sources.

*2) 0DS ( SAP Given ) are build on multiple SAP Tables..Correct ? so if i have to enhance that, where do i specify those Joins of Tables ? The same way when we create ZDS ( View based ) and for view we define conditions and Joins. *

CMOD is the place where you have different exits for different type of data sources (transaction data, master data and hierarchy).

*3) Which DS are not Enhanceable ? If any ? *

I am not sure, we can enhance LO cockpit data sources, 0FI data sources. We can enhance master data data source as well. I guess we can enhance all sort of data sources.

4) Can we do enhancement to 2LIS ...DS?

Yes, we can.

Regards,

Gaurav