Skip to Content
0

SAP DATA view with Blank fields

Aug 07, 2017 at 10:40 AM

47

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

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

2 Answers

AMIT KUMAR
Aug 07, 2017 at 11:48 AM
0

use if-else condition to display these values.

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

similar for other

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 07, 2017 at 01:04 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Amit suggested this formula in WebI.

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

Thanks,

Jothi

0