Ansicht
Dokumentation
ABENCDS_F1_DATA_SOURCE - CDS F1 DATA SOURCE
ABAP Short Reference ROGBILLS - Synchronize billing plansThis documentation is copyright by SAP AG.
- SELECT, data_source
... entity$[
parameters$]$|
path_expr $[$[AS$] alias$] $[join$] ...
Effect
Defines a data source of a CDS view. A data source can be a DDIC database table defined in ABAP Dictionary , a DDIC database view, an DDIC external view, or a non-abstract CDS entity (a CDS view, a CDS table function, or a CDS hierarchy.
- The data source is specified either directly using its name entity or using a path expression path_expr in which CDS associations are evaluated. The CDS associations of the path expression cannot have any abstract association targets.
- If the data source is a CDS entity with a list of input parameters, actual parameters must be passed to these using parameters.
- An alternative name alias for a directly specified data source can be defined after AS. In fact, AS can be left out. An alternative name must be defined if a path expression is used. The name must comply with the naming rules for names.
Example
Defines the CDS view business_partner for the DDIC database table snwd_bpa, for which an alternative name partner is specified. This name is used in the SELECT list.
-
@AbapCatalog.sqlViewName: 'BPA_VW'
define view business_partner as
select from snwd_bpa as partner
{ key partner.bp_id,
partner.company_name,
partner.bp_role }
as can also be omitted in front of the alternative name partner. The following example demonstrates another valid spelling that is potentially confusing:
-
@AbapCatalog.sqlViewName: 'BPA_VW'
define view business_partner as
select from snwd_bpa
partner{ key partner.bp_id,
partner.company_name,
partner.bp_role }
TXBHW - Original Tax Base Amount in Local Currency BAL Application Log Documentation
This documentation is copyright by SAP AG.
Length: 5115 Date: 20240420 Time: 013459 sap01-206 ( 41 ms )