CDS View with delta Extraction for PR and PO

[bappy_shahariar]

Hello guys,

I need your expert help with CDS View with delta Extraction for PR and PO as there was no standard source for Purchase Requisition. I have created a cds view its works fine for full load on BW but the delta load give error like "Invalid Entry : No entry in ODQSSN found for subscription SAP_BW in development ". Please help.

@AbapCatalog.sqlViewName: 'ZCDS_EBAN_EBKN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Purchase Requsition'
@Analytics:{dataCategory:#FACT ,
            dataExtraction.enabled:true}
@Analytics.dataExtraction.delta.byElement.name:'erdat'
@Analytics.dataExtraction.delta.byElement.maxDelayInSeconds: 1800

define view ZCDS_EBAN_EBKN_R as 
    select from eban left outer join ekpo on    
                                                eban.banfn = ekpo.banfn
                                            and eban.bnfpo = ekpo.bnfpo
                     left outer join ekko on ekpo.ebeln = ekko.ebeln
                     left outer join eket on  ekpo.ebeln = eket.ebeln
                                            and ekpo.ebelp = eket.ebelp
                     left outer join ebkn
                                          on eban.banfn = ebkn.banfn
                                          and eban.bnfpo = ebkn.bnfpo 
                                          and eban.mandt = ebkn.mandt
                     left outer join zcds_eban_rel as H on 
                                                 eban.banfn = H.banfn
                                            and eban.bnfpo = H.bnfpo   
    
{
eban.banfn,    --Purchase Requisition Number
eban.bnfpo,    --Item Number of Purchase Requisition
eban.bsart,    --Purchase Requisition Document Type
eban.loekz,    --Deletion Indicator in Purchasing Document
eban.statu,    --Processing status of purchase requisition
eban.frgzu,    --Release status
eban.ekgrp,    --Purchasing Group
eban.ebeln,    -- Purchase order
eban.ebelp,    -- Purchase order item
eban.bedat,    -- Purchase Order Date
ekko.frgke ,    --Relase Indicator in PO
eket.wemng ,   -- Delivery Qty
eban.bsmng,    -- Quantity ordered
eban.afnam,    -- Requisitioner
eban.packno,   -- Package number
eban.frgkz,    --release status
eban.erdat,    --Changed On
eban.txz01,    --Short Text
eban.matnr,    --Material Number
eban.werks,    --Plant
eban.bednr,    --Requirement Tracking Number
eban.menge,    --Purchase Requisition Quantity
eban.meins,    --Purchase Requisition Unit of Measure
eban.badat,    --Requisition (Request) Date
eban.lfdat,    --Item Delivery Date
eban.ekorg,    --Purchasing Organization
eban.ebakz,    --Purchase Requisition Closed
eban.bstyp,    -- Document cat.
eban.estkz,    -- Creation ind.
eban.matkl,    -- Material Group
eban.frgdt,    -- Release Date
eban.pstyp,    -- Item category
eban.knttp,    -- Acct Assignment Cat.
eban.banpr,    --Proc. State
ebkn.zebkn,    -- Serial no.acct.assgt
ebkn.vproz,    -- Distribution (%)
ebkn.sakto,    -- G/L Account
ebkn.kostl,    -- Cost Center
ebkn.anln1,    -- Asset
ebkn.anln2,    -- Sub-number
ebkn.aufnr,    -- Order
ebkn.ps_psp_pnr,    -- WBS Element
ebkn.nplnr,    -- Network
ebkn.netwr,    -- Net Order Value 
H.udate as udate
}
group by
eban.bstyp,    -- Document cat.
eban.estkz,    -- Creation ind.
eban.afnam,    -- Requisitioner
eban.matkl,    -- Material Group
eban.frgdt,    -- Release Date
eban.pstyp,    -- Item category
eban.knttp,    -- Acct Assignment Cat.
eban.ebeln,    -- Purchase order
eban.ebelp,    -- Purchase order item
eban.bedat,    -- Purchase Order Date
eban.bsmng,    -- Quantity ordered
eban.packno,   -- Package number
eban.banfn,    --Purchase Requisition Number
eban.bnfpo,    --Item Number of Purchase Requisition
eban.bsart,    --Purchase Requisition Document Type
eban.loekz,    --Deletion Indicator in Purchasing Document
eban.statu,    --Processing status of purchase requisition
eban.frgzu,    --Release status
eban.ekgrp,    --Purchasing Group
eban.frgkz,    --   --release status
eban.erdat,    --   --Changed On
eban.txz01,    --   --Short Text
eban.matnr,    --   --Material Number
eban.werks,    --   --Plant
eban.bednr,    --   --Requirement Tracking Number
eban.menge,    --   --Purchase Requisition Quantity
eban.meins,    --   --Purchase Requisition Unit of Measure
eban.badat,    --   --Requisition (Request) Date
eban.lfdat,    --   --Item Delivery Date
eban.ekorg,    --   --Purchasing Organization
eban.ebakz,    --   --Purchase Requisition Closed
eban.banpr,    --   --Proc. State
ebkn.zebkn,    -- Serial no.acct.assgt
ebkn.vproz,    -- Distribution (%)
ebkn.sakto,    -- G/L Account
ebkn.kostl,    -- Cost Center
ebkn.anln1,    -- Asset
ebkn.anln2,    -- Sub-number
ebkn.aufnr,    -- Order
ebkn.ps_psp_pnr,    -- WBS Element
ebkn.nplnr,    -- Network
ebkn.netwr ,   -- Net Order Value
H.udate,
ekko.frgke,
eket.wemng,
eban.erdat  --Changed On