Azure Data Factory - pass parameter to SAP HANA CDS view

227 Views Asked by At

Does anyone know, how to pass parameter from Azure Data Factory data flow to SAP HANA view?

The task is to filter BSIK to GJAHR through DataFlow activity and SAP CDC scenario with full load at every time.

  1. Based on GJAHR, I created view ZBSIKTST, based on BSIK:
    define view ZBSIKTSTv
    with parameters p_gjahr:gjahr
    as select from bsik
    {
     key bukrs,
     key lifnr,
     key umsks,
     key umskz,
     key augdt,
     key augbl,
     key zuonr,
     key gjahr,
     key belnr,
     key buzei
    }
    where gjahr = :p_gjahr
    
  2. Tried to put the parameter in SAP CDC Dataset with many ways, no positive results.

Thanks!

0

There are 0 best solutions below