ACMTEST_ASPECT_FOR_FILTERING

DDL: ACMTEST_ASPECT_FOR_FILTERING Type: view_entity

A DCL to test aspect filters

ACMTEST_ASPECT_FOR_FILTERING is a CDS View that provides data about "A DCL to test aspect filters" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 10 fields with key fields sales_id, buyer_guid. It has 3 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
snwd_so snwd_so from

Associations (3)

CardinalityTargetAliasCondition
[1] sacm_cds_snwd_bpa tocustomer $projection.buyer_guid = tocustomer.bpa_id
[1] sacm_cds_snwd_employees toemployee $projection.created_by = toemployee.employee_id
[1..*] sacm_cds_snwd_so_i toitems $projection.sales_id = toitems.parent_key

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label A DCL to test aspect filters view
Metadata.ignorePropagatedAnnotations true view
AccessControl.auditing.type #CUSTOM view
AccessControl.auditing.specification audited view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY sales_id node_key
KEY buyer_guid buyer_guid
created_by created_by
created_at created_at
employee toemployee last_name
customer tocustomer company_name
country
tocustomer tocustomer
Associationtoemployee
AssociationtoitemsAssociation 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'A DCL to test aspect filters'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.auditing.type: #CUSTOM
@AccessControl.auditing.specification: 'audited'
define view entity ACMTEST_ASPECT_FOR_FILTERING as select from snwd_so
association [1]     to sacm_cds_snwd_bpa        as tocustomer   on $projection.buyer_guid = tocustomer.bpa_id
association [1]     to sacm_cds_snwd_employees  as toemployee   on $projection.created_by = toemployee.employee_id
association [1..*]  to sacm_cds_snwd_so_i       as toitems      on $projection.sales_id = toitems.parent_key
{
key node_key as sales_id,
key buyer_guid as buyer_guid,
created_by,
created_at,
currency_code,
delivery_status,
toemployee.last_name as employee,
tocustomer.company_name as customer,
tocustomer.toaddress.country as country,
tocustomer,       --Association
toemployee,       --Association
toitems           --Association
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SACM_CDS_SNWD_AD",
"SACM_CDS_SNWD_BPA",
"SACM_CDS_SNWD_EMPLOYEES",
"SNWD_SO"
],
"ASSOCIATED":
[
"SACM_CDS_SNWD_BPA",
"SACM_CDS_SNWD_EMPLOYEES",
"SACM_CDS_SNWD_SO_I"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More