fetching data

former_member820770 — Tue, 20 Sep 2022 07:16:25 GMT

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

Re: fetching data

harishankar714 — Thu, 09 Feb 2023 13:43:49 GMT

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
};

topic fetching data in Application Development and Automation Discussions

fetching data

Re: fetching data