Problem on Generic Extraction from table MBEW

[former_member746094]

I create the view for MBEW (ZMBEW) for extraction from DB view.

However, i found current period getting wrong.

MBEW selection:

Results:

ZMBEW Article = 0464148 results:

I don't understand why my view table getting wrong value from MBEW.

Here is my join conditions on ZMBEW.

I try to find another way to get MBEW data from bw,

I found that

0CO_PC_ACT_02 can get LBKUM,SALK 3

from MBEW and MBEWH. But i found some issues on there.

The MBEWH results seems miss match the results from data source 0CO_PC_ACT_02.

0CO_PC_ACT_02:

MBEW:

MBEWH

Is anyone have solution/faced this problem before? Thank you.

[sdebaerd]

If you're on S4/HANA, MBEW should not be used directly.
There is a replacement view:

MBV_MBEW

If you use this view, you'll get the correct results.
When you would use eclipse to see what is inside the CDS, you'll understand why certain columns remain blank, due to the way the data is now stored in the database.

Replacement views can be found, by opening the "old" table in SE11, go in Display -> More -> Extras -> Replacement Object