Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Control Null values in a table with Previous values

Hi Team ,


We are into a tricky situation and hoping some inputs.


We have two tables say A and B

They have a Common filed A.controlId and B.control ID on which that are Joined through a Outer Join


A is snapshot table and have only a Particular time range data current .


Fields in Table A will have Only one record say for an account number

Control ID

Created Date

Status

Account Number


Fields In Table B SCD will contain multiple records for an account with there status and previous status

Control ID

Created Date

Previous Status

Account Number


In table B the data is not pushed out on regular basis and we can have Null value for Previous status.

Issue is because Of data not available at times in table B , an account number can show null values for Previous status, we are looking for a Solution through which it should automatically take previous status values if there is null value's


Can this be done at Universe level ?

Former Member
Not what you were looking for? View more on this topic or Ask a question