Skip to Content
0

ODP Extractor issue - Missing fields when importing into Data services

Sep 26, 2017 at 10:41 AM

142

avatar image
Former Member

Hi guys,

I'm importing some extractors into data services but I'm facing a big issue, which is only certain fields are imported. For example, using 0ASSET_TEXT.

This is the extract structure in ECC:

The datasource has been enabled in table ROOSATTR, and table ROOSFIELD looks like this:

When I import it from data services designer, this is what I get:

So, key1, key2 and key3, which in this case are chart to accounts, asset number, etc, are simply missing.

Any ideas?

Thanks

img1.png (14.9 kB)
img2.png (12.4 kB)
img3.png (59.2 kB)
img4.png (32.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Sep 26, 2017 at 02:03 PM
0

I'm coming to the conclusion that text extractors that have this "dynamic" structure (with generic "key1" "key2" "key3" type-fields) will simply not work. I'm saying this because none of these text extractors are ODP enabled by SAP, you need to manually add them to table ROOSATTR so it does not sound like a casual coincidence.

Anyway, if any of you have any ideas, please let me know.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 26, 2017 at 02:30 PM
0

https://launchpad.support.sap.com/#/notes/2321909

Seems to me generic text extractors using structures ROTEXT* should work unless you have added custom fields, which I haven't.

So still no solution.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 26, 2017 at 03:06 PM
0

I created a custom copy of the datsource, enabled it as ODP using program RODPS_OS_EXPOSE, and it works:

So what am I missing that causes the standard ones not to work?


capture1.png (351.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 27, 2017 at 02:56 PM
0

Hi Former Member,

What is the original data type of the missing fields?

I suspect the source contains the data types that are not supported in Data Services.

https://apps.support.sap.com/sap/support/knowledge/preview/en/1598268

Share
10 |10000 characters needed characters left characters exceeded