Test_Cds_Astcheck_27

DDL: TEST_CDS_ASTCHECK_27 SQL: testcdsac27 Type: view

Test_Cds_Astcheck_27 is a CDS View in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 11 fields with key fields node_key, so_id. It has 6 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
snwd_so snwd_so from

Associations (6)

CardinalityTargetAliasCondition
[1] Test_Cds_Astcheck_24 _sibling1 $projection.node_key = _sibling1.node_key
[1] Test_Cds_Astcheck_24 _sibling2 $projection.node_key = _sibling2.node_key and _sibling2.so_id = '0000000001'
[1] Test_Cds_Astcheck_24 _sibling3 $projection.node_key = _sibling3.node_key and _sibling3.so_id > '0000000001'
[1..2] Test_Cds_Astcheck_24 _sibling4 $projection.node_key = _sibling4.node_key and _sibling4.so_id = '0000000001'
[1..*] Test_Cds_Astcheck_24 _sibling5 $projection.node_key = _sibling5.node_key and _sibling5.so_id = '0000000001'
[4] Test_Cds_Astcheck_24 _sibling6 $projection.node_key = _sibling6.node_key and _sibling6.so_id = '0000000001'

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName testcdsac27 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY node_key node_key
KEY so_id so_id
created_by created_by
created_at created_at
changed_by changed_by
_sibling1 _sibling1
_sibling2 _sibling2
_sibling3 _sibling3
_sibling4 _sibling4
_sibling5 _sibling5
_sibling6 _sibling6 
@AbapCatalog.sqlViewName: 'testcdsac27'

define view Test_Cds_Astcheck_27  as select 
 from snwd_so
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [1]    to Test_Cds_Astcheck_24      as _sibling1         on $projection.node_key =  _sibling1.node_key
association [1]    to Test_Cds_Astcheck_24      as _sibling2         on $projection.node_key =  _sibling2.node_key      
                                                                       and _sibling2.so_id = '0000000001'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [1]    to Test_Cds_Astcheck_24      as _sibling3         on $projection.node_key =  _sibling3.node_key
                                                                      and _sibling3.so_id > '0000000001'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [1..2]    to Test_Cds_Astcheck_24      as _sibling4         on $projection.node_key =  _sibling4.node_key
                                                                       and _sibling4.so_id = '0000000001'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [1..*]    to Test_Cds_Astcheck_24      as _sibling5         on $projection.node_key =  _sibling5.node_key
                                                                       and _sibling5.so_id = '0000000001'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [4]    to Test_Cds_Astcheck_24      as _sibling6         on $projection.node_key =  _sibling6.node_key
                                                                       and _sibling6.so_id = '0000000001'
                                                                                                                                                 
{
 
 key node_key, 
 key so_id, 
  created_by, 
  created_at, 
  changed_by,
  _sibling1,
  _sibling2,
  _sibling3,
  _sibling4,
  _sibling5,
  _sibling6
}                      
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[
"TEST_CDS_ASTCHECK_24"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More