Controls whether empty column values are displayed as NULL or an initial (non-NULL) value.

Syntax

Connect-SAPERP -InitialValueMode string

Possible Values

Data Type

cstr

Default Value

"Null"

Remarks

Some fields in SAP tables are configured to have an initial value.

This means that, when a record is inserted into the SAP table without including a value for those fields, instead of being considered NULL, the fields are initialized with a set generic value that represents an empty value without technically being NULL.

For example, a field may be set to initialize with the value 0, or "" (empty string) instead of being NULL.

When this connection property is set to Null, records in fields with the InitialValue indicator enabled in SAP, and whose value matches the initial value for their data type (0, "", etc.), are returned as NULL in query results.

When this connection property is set to InitialValue, records in fields with the InitialValue indicator enabled in SAP, and whose value matches the initial value for their data type (0, "", etc.), are returned as-is in query results.