Standard Cost Marking and Release Status — Reading It Straight from KEKO, MBEW and MBEWH
If you run a standard cost estimate every month, sooner or later someone asks a question no single SAP screen answers well: which materials were only marked, which were actually released, and when? Opening CK11N or CK24 material by material is not an answer when there are hundreds of them. Three tables carry the whole story — KEKO , MBEW and MBEWH . Below are the queries I use to read status, monthly trend and missed releases straight out of them, in ABAP SQL and in native HANA SQL for the DB02 SQL editor. The three states of a cost estimate Estimating, marking and releasing are three separate acts, and each leaves its trace in a different field. Getting that mapping right is most of the job: Status How it is recognised What it means ESTIMATED_ONLY FREIG ≠ 'X', VORMDAT = 00000000 The estimate was run (CK11N/CK40N) and nothing else happened. The material master still carries the old price. MARKED_NOT_RELEASED FREIG ≠ 'X', VORMDAT > 00000000 Marked (CK24 marking...