Skip to Content
1
Nov 29, 2011 at 04:38 PM

How it works for Item Master active or inactive?

1506 Views

Hi,

Recently I need to get the list of all active products(item master) from SAP DB in my external application, I just realized that it is not just a field to indicate this item is active or inactive. It seems there several fields related for active status, they are validFor, validFrom, validTo, frozenFor, frozenFrom, frozenTo. Different comnination have differnt status which is quite confused to me. Is there a way or anyone has a existing SQL query which I can refer in my application? I did some tests in SAP, seems quite difficult to understand the logic and I can't find any usefull document in the SDK help file.

Any piece of help will be highly appreciated !

Lan