Field TARIFTYP as selection field in 0UC_SALES_STATS_01

[Former Member]

Hi,

can any1 letme know hw can i make the field TARIFTYP of datasource 0UC_SALES_STATS_01 as selection field i got the table ROOSFIELD but its not allowing me to change the value to M plz letme know hw it cud be done .

thnx in advance

[Former Member]

Hello,

simply edit the datasource in the is-u system (sbiw -> expand the hierarchy -> search for the datasource -> modify -> mark the the needed fields as selectable (Selection field of a DataSource) and then replicate the datasource in the bw system.

Good luck

[Former Member]

Hi,

create a little abap using the following code:

update roosfield

set selection = 'M

where oltpsource = '0UC_SALES_STATS_01'

and objvers = 'A'

and field = 'TARIFTYP'.

But before that, make sure that the extractor can handle a selection on that field.

regards

Siggi