Problem on Generic Extraction from table MBEW

former_member746094 — Mon, 02 Aug 2021 14:38:27 GMT

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.

Re: Problem on Generic Extraction from table MBEW

sdebaerd — Wed, 31 Aug 2022 12:18:16 GMT

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

Question Re: Problem on Generic Extraction from table MBEW in Technology Q&A

Problem on Generic Extraction from table MBEW

Re: Problem on Generic Extraction from table MBEW