Skip to Content

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

Filtering out records with unblocked stock in MCHB


Good day,

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.

Thank you.

Best Regards,

Raphael

Tags:
Former Member
replied

yes it looks correct, but more easy would be to use QA07 transaction as it is exactly made for this check and it can even post into blocked stock. Click the blue info button in the selection screen for details

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question