Skip to Content
avatar image
Former Member

SAP Data services config to read ECC table with specific view like ALV grid / ALV List?

Hi All,

Currently I am trying to understand if there is any configuration where we can address BODS to read ECC table either by ALV grid view or ALV list.

Reason:

For a NUMC type field in ECC table, the value is blank in ALV grid view but in ALV list it is '0'.

Due to this, my where clause in query ' <field> is null ' not working while reading table. And no records are extracted.

Thank you,

Best Regards,

Sandeep Dadi.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 04, 2017 at 07:41 AM

    Hello Sandeep,

    Can you try the below option?

    In designer Go to Tools - > Options - > SAP -> Environment

    and check the Convert SAP null to null check box

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 04, 2017 at 08:19 AM

    How are you reading the ECC table? In a regular or in an ABAP data flow?

    When in a regular data flow, DS accesses the data at database level, it reads straight from the table. Ignore all values you see in SAP GUI screens. What you see there may be the result of a conversion. It's only the database content that matters.

    Add comment
    10|10000 characters needed characters exceeded