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

[Former Member]

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.

[former_member187605]

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.

[former_member451932]

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