Skip to Content
avatar image
Former Member

SAP DATA view with Blank fields

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 07, 2017 at 11:48 AM

    use if-else condition to display these values.

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

    similar for other

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2017 at 01:04 PM

    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

    Add comment
    10|10000 characters needed characters exceeded