cancel
Showing results for 
Search instead for 
Did you mean: 

extracting crm opportunity notes to bw

Former Member
0 Kudos

Hello

How can I pull opportunity notes into BW to be used in reports ?

Thanks

Rita

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

The table STXL holds only a TDNAME which is not the text of the note

RITA

Former Member
0 Kudos

Rita, did you ever solve this problem? Thanks, Doug

Former Member
0 Kudos

Doug,

Did you solve the problem. I have similar issue.

Thanks for the reply

Naveen

Former Member
0 Kudos

Hi Des

I also dont believe such standard extractor exists.

I dont know the source table that holds the notes and actually I dont think the notes are holds in a table.

any idea ?

Rita

Former Member
0 Kudos

Hi,

All Long Text data is stored in table STXL. You need to use TDOBJECT and TDSPRAS to select your required data. Create a GDS on top of this table.

desgallagher
Contributor
0 Kudos

Hello Rita,

I don't believe that there is a standard delivered extractor that wll load this information to BW, do you know the source table

that you want to load the data from? If yes you could create you own extractor in RSO2 to extract the information.

Best Regards,

Des