Example: If Null/Initial Then First to Last

That means, the system substitutes null and initial values (for Characteristic it is whitespace (' ') and for Key Figure it is zero ('0')) by the next non-null value of the succeeding table having the same field. If this field only has initial/null values, the system just sets an initial value.

The system takes the first non-null and non-initial value and if all values are null or initial, it returns an initialized value, empty or blank for a Character (CHAR) field and “0” for a Key Figure field.

In PROD05 row, we had our first null value (?). Since we only have two tables we won't be able to look further for another initial value. Since all values are null for the Amount field, the system returns an initialized value. For Key Figure, it will be “0”. The same scenario will be encountered for PROD06, PROD09 and PROD10.

In PROD07 row, we had our first initial value (''), as you can see we look at the next table for the same Customer field. Since the next value for Customer is “DE_CUST07”, it will be the value for Customer field at PROD07. The same is true for PROD08 scenario, which will have a value of “DE_CUST08”.