Filtering out records with unblocked stock in MCHB
I'm currently trying to find records within MCHB which have expired and which still have unblocked stock. I would like to verify if my understanding of this is correct.
There are multiple stock categories:
- Unrestricted valuated stock --> CLABS
- Restricted Use Stock --> CEINM
- Blocked stock --> CSPEM
- Stock in Quality Inspection -->CINSM
I'm getting SLED by connecting MCH1 and MCHB. I need to find records within MCHB where not all of the stock has been placed in Blocked Stock.
So in this case my logic would be:
(CLABS > 0 or CEINM > 0 or CINSM > 0 )& VFDAT <= current date .
This is because blocked stock is not equal to restricted stock.
I would like to ask if my understanding of this is correct or if there are any details that I may have missed.