Enhancement of DataSource 0VENTURE_ATTR

[Former Member]

Hi all,

I would like to enhance standard DataSource 0VENTURE_ATTR with field CONTRACT from table T8JU Joint Operating Agreement.

I enhanced the ExtractStructure BIW_JV_T8JV with the field, but the extra field is not added to the extractor. Instead I get this warning: Message no R8513. The extraction structure BIW_JV_T8JV of DS 0VENTURE_ATTR is a view. This allows no CustApp.

Is there anything I can do to make the field available in the extractor?

Thanks!

BR,

Linda

[m_verbaan2 · Accepted solution]

Hi Linda,

Steps you can follow are:

1. Create append structure for table T8JV (on which the DB-view is created) and insert your contract field

2. Request an access key to modify DB-view BIW_JV_T8JV (I see no other way)

3. Add the new field op the View fields tab and activate the DB-view

4. Goto RSA6 and unhide the new field + Generate the DS

5. Populate the field via user-exit (CMOD -> component EXIT_SAPLRSAP_002 )

Hope this helps.

Grtx

Marco

[Former Member · Accepted solution]

Thanks Marco,

I will ask our abap-programmer to try what you suggest.

BR,

Linda

[Former Member · Accepted solution]

Hi Marco,

Our abap'er tried what you suggested:

He created an append structure for table T8JV and added the contract number field in the append structure.

He then modified the DB view BIW_JV_T8JV and activated the view.

When we go to RSA6 the added field, Contract no, is still not visible here.

The strange thing is, that if we test the DataSource in transaction RSA3, and then look at the 'ALV Grid'-option the added field is visible here, but if I look at the 'List'-option, the added field is not visible.

We have doublechecked that everything is activated.

I've tried to replicate the datasource to BW, and the field is not visible.

Do you have any ideas what we should do?

Thanks!

BR,

Linda

[Former Member · Accepted solution]

Hi

Unhide the field on RSA6.

Regards,

Chandu.

Edited by: Chandu on Oct 14, 2008 2:22 PM

[m_verbaan2 · Accepted solution]

Try to generate the DataSource in RSA6 from the menu (in change mode).

If still not available pls check table ROOSFIELD....can you find Contract no there?

Grtx

Marco

[Former Member · Accepted solution]

Hi,

The procedure which u have followed is correct till adding the field in the view.

i even faced this problem of the field being not visible. come out of the transaction or go back and come in again, u will find the field.

After selectimng the field in extract structure, for datasource to extract data for the new field u have to write code in CMOD.

after writing the code activate it .

i think this helps you.

Regards,

ranjith

[Former Member · Accepted solution]

Hi Marco,

I checked in table ROOSFIELD, and the field Contract No had a field attribute 'A' - Field in OLTP and BW hidden by SAP. We changed this to ' ' (blank) - No selection possible, Visibility set.

This solved the problem. The added field is now available both in R/3 and BW.

Thanks a lot for your help

Points assigned!

BR,

Linda

[yogesh8984 · Accepted solution]

Hi Linda,

I was also facing the same problem couple of days back which is solved now. But I am wondering whether we could write a user exit for such field. If the extract structure is view, system throws message that CustApp is not possible. Have you written user exit to populate such field which is appended in view via enhancement?

Please reply. Thanks in advance.

Regards,

Yogesh

[Former Member]

.