Enhancing Custom DataSource.

[Former Member]

Hi

Can any body share ur experience in enhancing the datasource .

I know the steps how to enhance the Custom DataSource.I will appreciate if u can tell the real time scenario for which data sources/module u did enhancement and what type fields u added to enhance the datasource.

Thanks for ur time,

Abhi

[Former Member]

Abhi

You can enhance any data source depending upon your requirement.for example 2LIS_02_ITEM can be enhanced by by going to LBWE and transferring fields in ES tab from right to left as per your requirements.

If the required fields are not there in data source / ES then you need to write small ABAP prog to populate that field from other table.

[Former Member]

Hi Krishna,

Can u pls give me an example(not code) in real time scenario to populate a field using ABAP Program.

Thanks,

Abhi

[Former Member]

Abhi,

Lets say you are having FI, CO and CO-PA extraction in your BW environment. You want to enhance all the related data sources to add a field say "Original G/L account". In that case you have to enhance all those tables that were used for FI, CO extraction and for CO-PA you habe to enhance all your CE1XXXX, CE2XXXX etc tables along with the opertaing concern. These tables now will receive data for the new fields added whenevr there is a posting going into the system.

Then you need to add the field into your data source and extract it. You can use ABAP if you are using a custom extractor with FM extraction, but if you are directly using the tables / views no need to write any ABAP code.

Another example could be you are not appending any fileds to the system tables from which you are doing the extraction i.e. the field is not getting data from any posting. The field's information you are interested may be available in some other system table from which you are not doing any extraction. In that case you need to enhance your data source with the field by ABAP.

Hope i am clear.

Thx,

Soumya