Skip to Content
avatar image
Former Member

ODP Extractor issue - Missing fields when importing into Data services

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 26, 2017 at 02:30 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 26, 2017 at 03:06 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 27, 2017 at 02:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded