cancel
Showing results for 
Search instead for 
Did you mean: 

data source enhancement

Former Member
0 Kudos

i wanted to use data source 0CRM_OPPT_I to load opportunity data into BW, but i can't find all the required fields in the data source.

those fields are available in the corresponding extract structure. CRMT_BW_OPPT_I. can we add the fields from the extract structure into the data source.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

go to the customizing over the Data Source and Unselect the Hide Fields then u can be able to view the required Field in the extracted DATA.

GAK

former_member182516
Active Contributor
0 Kudos

Hi Shiva,

Have you verified weather the fields are hidden in the extract structure ? if they are hidden you can directly make use of those fields by unhiding those fields.

make sure that fields present in extract structure is populated with data in RSA3

and Check the field property for the fields in extract structure

Transaction RSA2 -- enter DS --> display -- > in the fields TAB check for the fields that you are looking for. here check the field property area. if the feild property for the field - is "A" field is hidden by SAP.

You can change the status of the feilds property using a simple program. Where you will declare the ROOSFIELD table and write the simple below select statement.

Below is the code to change the field properties.

{code}

REPORT ZTEST_DS.

Tables: ROOSFIELD.

SELECT SINGLE * FROM ROOSFIELD WHERE OLTPSOURCE ='0CRM_OPPT_I' ANS OBJVERS ='A' AND FIELD ='<FIELD>'.

IF SY-SUBRC =0.

ROOSFIELD-SELECTION ='P'.

MODIFY ROOSFIELD.

ENDIF.{code}

Once you are done you can check the field property is changed. check the data in RSA3 and replicate the Ds to BW and proceed with the rest of the steps.

Please find the field properties.

If this is not working ,its understood that SAP is not supporting those fields present in Extract structure. then you can enhance the fields to the data source.

regards

KP

Former Member
0 Kudos

Hi Mr. Shiva,

If the desires fields is available in extract struture , you can enhance by drag & drop only . Activate the data source . Please go through the URL , how to enhance Data Source.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00c1f726-1dc2-2c10-f891-ddfbffdb1...

If the fields is not available in extract structure , you have to append structure ,it requires coding also.

Hope it will help you.

Regards,

Anand Mehrotra.