SAP DATA view with Blank fields

[Former Member]

hi all,

I have view with the following information and want to change field blank value.

View Fields: Invoice No, Date, Amount, Salesman Code, Salesman name, Customer Code, Customer Name.

some of the transaction in View Direct Transaction so Salesman Code & Name is blank.

is it possible in view to display blank field value with Following information?

Salesman Code = 00

Salesman Name ="Direct Sale"

Best Regards,

Mazahir

[Former Member]

Hello Amit,

Thank for your reply as this command to add in my view build statement right?

We are using SAP HANA and view information coming from 5 tables.FYI

Best Regards,

Mazahir

[jyothirmayee_s]

Hi,

Amit suggested this formula in WebI.

If you want in HANA view, can use the similar concept.

Thanks,

Jothi

[amitrathi239]

use if-else condition to display these values.

V Sales Name=If([Salesman Name]="") then "Direct Sale" else [Salesman Name]

similar for other