Skip to Content
0

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

Sep 05, 2017 at 02:02 PM

54

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Samyak Jain Oct 04, 2017 at 07:41 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Dirk Venken
Oct 04, 2017 at 08:19 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded