Skip to Content
0
Former Member
Oct 17, 2014 at 01:12 PM

Blanks from SAP ECC not populated as blank/null at Oracle Tgt

504 Views

Hi,

I am dumping data from ECC to Oracle 11g via SAP BODS 4.1

Columns with blanks are neither populated as blanks nor as null at oracle target table.

However, BODS recognizes the blanks. This is because, when I give a decode function in query transform i.e decode(column=' ', '$',column) , this populates the target with '$'.

When I try to populate directly, Both the below queries return no results.

Select * from ORacle_TGt where column is null

Select * from ORacle_TGt where column=' '


Even on the webi reports, this column is neither seen as NULL nor as Blanks.

Datatype of the column is Varchar(1). Pls help on populating the blank values directly from ECC.

Thanks.