Hi experts,
I have been googeling this issue now, not finding a satisfying solution. Maybe you have suggestions on how to proceed this issue.
My client use SAP-transaction MCBE to extract data to excel and then analyze data together with other sources. He wants to user SAP BI to do this and I am now doing my best to help him. MCBE seem to get data from S039-table. This table is transparent and not possible to build an extraction from to BI. S039 contains data from S031 and S032. I tried to join the two tables but I'm at the wrong track since S032 does not contain any time-object, which means that the values from S032 is always the latest one?
The two most important key figures according to my client is ValStockValue and Tot. usage val. (in MCBE). These are in S032, but it is not possible to choose "calmonth interval" for that table, and therefore not join it with S031 either...
Maybe I am making it more difficult than it in fact is, but I can't proceed without help. Please help!
I need a step by step understanding of how to extract MCBE-data to BI easily.
Regards,
Sofie