Command: Blank

Previous  Next |  Direct link to this topic

Go to list of all Commands

Syntax: Blank($[$<item>.<col>.0]);

 

Blanks the field indicated (Blank = a text field receives an empty value).

 

Command variants

Description

Blank($[$<item>.<col>.0]);

Sample: Blank($[$14.0.0]) blank the Customer ref. field on a Sales Order.

Tip: instead of specifying the column you can use keyword “RowHeader” to do a click/select the row-header (The gray block in front of the row)

 

Blank($[$<item>.<col>.0.<row>]);

As above but with a 4th .row argument that allow you to specify a specific row to work with.

 

In addition to a numbered row you can use the following keywords to refer to special rows:

 

Keyword

Description

.FIRST

Refer to the First row in the Matrix (does essentially the same a ".1")

.LAST

Refer to the Last row in the Matrix

LAST-1

Refer to the Second to Last row in the matrix (this is in many cases handy as SAP normally have an new empty line for new row entries)

.SELECTED

Refer to the Row that have a Selection (aka highlighted in Yellow). If no selection this will fall back to working with the first row

.FOCUSED

Refer to the Tow that have cell focus (the row where the "yellow" cell is). If no cell focus this will fall back to working with the first row

 

Sample: Blank($[$38.163.0.LAST]); Would blank the Free text of the item matrix on a sales order on the last row

Video: Working with rows and keywords

NB: You cannot blank a field if it is not allowed by the sap business logic (example: it is not possible to blank the quantity on a document line since it is not allowed to have no value). It is not possible to blank a combo box or checkbox since these are considered always to have a value (use the set command instead)

 


Similar/Related Commands:
- BlankUdfSideBar
- MultiSetFromSQL
- Set
- SetCaption
- SetUdfSidebar
- Transfer
- TransferBack
- TransferBackUdfSidebar
- TransferUdfSidebar