fetching data

[former_member820770]

Hi Frnds,

i have one requirement

i need to fetch FERT Meterial from DDL CDS SQL View and need to pass the FERT meterial to MARA and need to get the meterial group (mara-matkl)..could you please anyone help me in this.

Thanks

[harishankar714]

you can write a CDS query that combines data from both views.

@AbapCatalog.sqlViewName: 'Z_FERT_MATERIAL_GROUP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Z_FERT_MATERIAL_GROUP as 
select from mara
inner join (
    select matnr as FERT_MATERIAL 
    from "YOUR_DDL_CDS_SQL_VIEW_NAME"
) as ddl_cds on mara.matnr = ddl_cds.FERT_MATERIAL
{
    matnr,
    matkl as MATERIAL_GROUP
};