Problem activating a hidden field in sap standard data source

[Former Member]

Hi There

I'm trying to unhide the field 'created by' in the datasource 0SRM_TD_PO even my dev client.

When I attempt to do this, I get a warning:

Datasource 0SRM_TD_PO is extracted using function module BBP_BI_PO_EXTRACT.

I just want to make the field created by available so that I can map it to a new infoobject in BI.

Any help much appreciated - all relevant se06 objects are modifiable / client is open.

Regards

Conor

[Former Member]

Connor -

I am working on SRM at present.

I tried unhiding the field in my sandbox for that datasource and it did not give me any error.

Try deleting the delta queue, then reinstalling the datasource from RSA5. and then try unhiding the field - it might just work.

Regards

[Former Member]

The Warning is telling you "Datasource 0SRM_TD_PO is extracted using function module BBP_BI_PO_EXTRACT."

Did you take a look at that function module?

I think that even if you "unhide" that field in the Datasource, you still need to modify the function module, which is really making the extraction as the warning says, in order to be able to map it in BW.

Anyway, you always have the option of adding the field to an append structure and capture its value from the original table enhancing the code in CMOD.

Good luck!

Luis

[Former Member]

Hello Conor

This is because you have already loaded data with this data source...first delte the data and any init or selection condition for this DS which you have used in infopackage..then try to unhide...

Thanks

Tripple k

[Former Member]

HI Thanks

Is this done in BI or in the source system ?

Thanks

Conor

[Former Member]

Hi

Do it in BI system..

Thanks

Tripple k

[former_member188975]

Deleting data in the BI system would not have any effect on the datasource ability to be modified...

[Former Member]

Hi Bhanu

Then how is it possible to unhide/select the fields in data source...basically in infopackage you select some condition and run delta...so that initial condition defines the delta data comming in BW...

Clear my doubt if i am wrong somewhere...also the solution of this problem....one solution i can think of is to directly edit system table ...but not sure what are the dependency...

Thanks

Tripple k

[former_member188975]

Hi,

There are 2 things: Adding a field to the datasource, and making the field selectable.

I think Conor is trying to edit the datasource to add a new field through transaction RSO2 (try to edit 0MATERIAL_ATTR in RSO2 as an example and you will see the same message). You can try through RSA6 and take note of the Extract Structure.

Note sure about SRM datasource, but for CRM datasources, the recommended way is through BWA1.

Hope this helps...