REPORT zbb_teh_occds6.
SELECT * FROM zbb_teh_occds6
INTO TABLE @DATA(IT_RES).
CL_DEMO_OUTPUT=>DISPLAY( IT_RES ).

CDS View with Input Parameters
A CDS (Core Data Services) view with input parameters is a type of view in SAP HANA that allows users to define a reusable query that can accept input parameters at runtime. Input parameters can be used to filter data or restrict the output of a query to a specific subset of data that meets certain conditions.
Syntax:
Define View
With parameters : ,
:
Note: The data type must be either a data element or dictionary predefined type (abap.char, abap.cuky, etc.)
Note: In WHERE conditions, reference parameters with : or $parameters. prefix (e.g., :parameter1 or $parameters.parameter1)
Object:
Develop an ABAP CDS to display customer numbers, customer names, cities and countries based on given country
@AbapCatalog.sqlViewName: ‘ZTEC_BBS_OSQL7’
@EndUserText.label: ‘Working with CDS View with parameters’
define view ZBB_TEC_OCDS7
with parameters I_LAND1 : land1_gp
as select from kna1
{
kunnr,
name1,
ort01,
land1
}
where land1 = :I_LAND1

ABAP Program to Consume:
REPORT zBBS_TEC_occds7.
PARAMETERS P_LAND1 TYPE KNA1-LAND1.
SELECT * FROM ZBB_TEC_OCDS7( i_land1 = @P_LAND1 )
INTO TABLE @DATA(IT_KNA1).
CL_DEMO_OUTPUT=>DISPLAY( IT_KNA1 ).

Advanced CDS View with Multiple Parameters
@AbapCatalog.sqlViewName: ‘ZBB_TEC_OSQL8’
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: ‘Working with CDS View with parameters’
define view ZBBS_TEC_OCDS8
with parameters
I_TCUKY : abap.cuky(5),
@Environment.systemField: #SYSTEM_DATE
I_ERDATE : abap.dats
as select from bsik
{
bukrs,
belnr,
gjahr,
bldat,
budat,
dmbtr,
waers,
:I_TCUKY as TARGET_CURRENCY,
currency_conversion(
amount => dmbtr,
source_currency => waers,
target_currency => :I_TCUKY,
exchange_rate_date => $parameters.I_ERDATE
) as TARGET_AMOUNT
}

ABAP Program to Consume:
REPORT zBBS_8pm_occds8.
PARAMETERS: P_TCUKY TYPE BSIK-WAERS,
P_ERDATE TYPE SYDATUM.
SELECT * FROM ZBBS_8pm_ocds8(
i_tcuky = @P_TCUKY,
i_erdate = @P_ERDATE
) INTO TABLE @DATA(IT_BSIK).
CL_DEMO_OUTPUT=>DISPLAY( IT_BSIK ).

Key Features:
• Demonstrates multiple input parameters (currency key and date)
• Shows both parameter reference methods (: and $parameters.)
• Includes currency conversion using input parameters
• Uses system field annotation for default date value
• Corrected “TARGET_CURRECY” to “TARGET_CURRENCY”
• Proper parameter passing in ABAP program

Working with Associations in CDS Views
There are 3 types of associations:
1. Ad-hoc associations
2. Exposed associations
3. Filtered associations

1- Ad-hoc Associations
The data definition that defines the association uses an individual field of the associated table or CDS view, are immediately translated into JOIN clause in the SQL create statement that is sent to the database.
Example:
@AbapCatalog.sqlViewName: ‘ZSP_8PM_OSQL10’
@EndUserText.label: ‘Working with Ad-hoc associations’
define view ZBBS_TEC_OCDS10 as select
from kna1 as a association to vbak as _b
on a.kunnr = _b.kunnr
{
a.kunnr,
a.name1,
a.ort01,
_b.vbeln, //ad-hoc association
_b.audat //ad-hoc association
}

ABAP Program to Consume:
REPORT zbbs_8pm_occds01.
SELECT * FROM ZBBS_TEC_OCDS10
INTO TABLE @DATA(IT_RES).
CL_DEMO_OUTPUT=>DISPLAY( IT_RES ).

2- Exposed Associations
Instead of addressing individual fields of the associated table or CDS View, it is also possible to add the entire association as a single element into the field list. This is called an exposed association.
Example:
@AbapCatalog.sqlViewName: ‘Zbbs_8PM_OSQL11’
@EndUserText.label: ‘Working with Exposed association’
define view Zbbs_8PM_OSQL11 as select
from kna1 as a association to vbak as _b
on a.kunnr = _b.kunnr
{
a.kunnr,
a.name1,
a.ort01,
_b //Exposed association
}
ABAP Program to Consume:
REPORT Zbbs_8PM_OSQL11.
SELECT KUNNR,
NAME1,
ORT01,
\_b-vbeln,
\_b-audat,
\_b-auart,
\_b-bukrs_vf
FROM ZSP_8PM_OCDS11
INTO TABLE @DATA(IT_RES).
CL_DEMO_OUTPUT=>DISPLAY( IT_RES ).
Consuming from Another CDS View:
@AbapCatalog.sqlViewName: ‘ZBBS_8PM_OSQL12’
@EndUserText.label: ‘Consume from exposed association CDS view’
define view ZSP_8PM_OCDS12 as select from Zbbs_8PM_OSQL11 as c
{
c.kunnr,
c.name1,
c.ort01,
c._b.vbeln, //path expression
c._b.audat //path expression
}

3- Filtered Associations
A filtered association in CDS View is an association between two entities that includes a filter condition to restrict the related records that are included in the association. This allows you to define a relationship between two entities that only includes a subset of the related records, based on specific criteria.
Example:
@AbapCatalog.sqlViewName: ‘Zbbs_8PM_OSQL13’
@EndUserText.label: ‘Working with filtered associations’
define view Zbbs_8PM_OSQL13 as select
from kna1 as a association to vbak as _b
on a.kunnr = _b.kunnr
{
a.kunnr,
a.name1,
a.ort01,
_b[auart = ‘TA’].vbeln, //Filtered association
_b.audat,
_b.auart
}
ABAP Program to Consume:
REPORT Zbbs_8PM_OSQL13.
SELECT * FROM Zbbs_8PM_OSQL13
INTO TABLE @DATA(IT_RES).
CL_DEMO_OUTPUT=>DISPLAY( IT_RES ).

Working with Extension of CDS View
Simple CDS View:
@AbapCatalog.sqlViewName: ‘Zbbs_8PM_OCDS14’
@EndUserText.label: ‘Simple cds’
define view Zbbs_8PM_OCDS14 as select from kna1
{
kunnr,
name1,
name2,
ort01,
land1
}
Extension of CDS View:
@AbapCatalog.sqlViewAppendName: ‘Zbbs_8PM_OSQL15’
@EndUserText.label: ‘Extension of cds view’
extend view Zbbs_8PM_OCDS14 with Zbbs_8PM_OSQL15
association to vbak as _B on kna1.kunnr = _B.kunnr
{
CONCAT(name1, name2) as FULL_NAME,
UPPER(name1) as UPPER_NAME,
_B.vbeln,
_B.audat,
_B.bukrs_vf
}
ABAP Program to Consume:
REPORT Zbbs_8PM_OCDS14.
TABLES KNA1.
SELECT-OPTIONS S_LAND1 FOR KNA1-LAND1.
SELECT * FROM Zbbs_8PM_OCDS14
INTO TABLE @DATA(IT_RES)
WHERE LAND1 IN @S_LAND1.
CL_DEMO_OUTPUT=>DISPLAY( IT_RES ).
To learn SAP ABAP please click here
To learn SAP Data sphere please click here
To learn SQL for native HANA please click here
To learn SAP SAC from SAP please click here