Skip to Content
-2

How to extract data from Structure MDEZ in ABAP CDS views

Dec 13, 2017 at 03:09 PM

152

avatar image
Former Member

Hello All,

I have to create CDS views in Eclipse by using structure MDEZ from SAP ERP system. Transaction code : Co09 is showing the data for this structure.

Can you please tell me how to create CDS views by using Structure instead of table?

It is giving me error in define view statement if I read structure in it.

Thanks in advance.

Regards,

Sheetal

10 |10000 characters needed characters left characters exceeded

You really don't know the difference between ABAP Dictionary structures and database tables?

Please learn these basics first.

https://help.sap.com/http.svc/rc/abapdocu_752_index_htm/7.52/en-US/index.htm?file=abenddic_classical_objects.htm

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Dec 13, 2017 at 03:56 PM
0

Hi Sheetal,

You can't create a CDS view from a structure. CDS view, is in essence a view. A view of the database. Why do you want to do this? Or what is the business scenario you are looking for?

Best regards,

Alex

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Alexander,

Thanks for your answer.

Client wants to see the data in BEx report from transaction code: CO09. They want to see the ATP quantity (MDEZ-

MNG04) in BEx and do the analysis of the Materials. we are using Composite providers to create any BEx reports.

Is there any alternative to solve my issue?

Regards,

Sheetal

0
Former Member

Hi Sheetal,

I am not a BW or BEx expert so i cannot offer you help regarding this part. To solve your problem you should find the correct database tables where this information is stored. Based on your questions i assume you are not a programmer or either you are new to SAP.

First and foremost, go and get some basic database knowledge, then some Open SQL, and then dig into CDS views.

For your problem you have two ways:

1) Debug the transaction CO09 and see how the fileds are mapped and where your value is coming from

2) Check this BAPI: BAPI_MATERIAL_MRP_LIST . Inside there is a function module where your structure is filled. FM: MD_MRP_LIST_API. I am sure you might find your answer there.

Good luck,

Alex

0
Former Member

Thanks for your help. I will try to do it.

0