How to extract data from Structure MDEZ in ABAP CDS views

[former_member230174]

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

[horst_keller]

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...

[afediuc]

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

[former_member230174]

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

[afediuc]

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

[former_member230174]

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