test_cds_versioning_01

DDL: TEST_CDS_VERSIONING_01 SQL: TESTCDVERS01 Type: view

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
snwd_so snwd_so from

Associations (6)

CardinalityTargetAliasCondition
[1] snwd_so _sibling1 $projection.node_key = _sibling1.node_key
[*] snwd_so _sibling2 $projection.node_key <> _sibling2.node_key
[*] t100 _t1001 $projection.so_id = _t1001.arbgb
[1] t100 _t1002 $projection.so_id = _t1002.arbgb and _t1002.sprsl = 'E' and _t1002.msgnr = '001'
[*] sflight _vclnt1 $projection.so_id = _vclnt1.carrid
[1] sflight _vclnt2 $projection.so_id = _vclnt2.carrid and $projection.so_id = _vclnt2.connid and _vclnt2.fldate = '20000101'

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName TESTCDVERS01 view

Fields (10)

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
_t1001 _t1001
_vclnt1 _vclnt1
_vclnt2 _vclnt2 
@AbapCatalog.sqlViewName: 'TESTCDVERS01'

define view test_cds_versioning_01  as select
 from snwd_so

association [1]    to snwd_so      as _sibling1          on $projection.node_key =  _sibling1.node_key association [*]    to snwd_so      as _sibling2         on $projection.node_key <>  _sibling2.node_key association [*]    to t100         as _t1001             on $projection.so_id  =  _t1001.arbgb
association [1]    to t100         as _t1002             on $projection.so_id  =  _t1002.arbgb and _t1002.sprsl = 'E' and _t1002.msgnr = '001'
association [*]    to sflight      as _vclnt1            on $projection.so_id  =  _vclnt1.carrid
association [1]    to sflight      as _vclnt2             on $projection.so_id  =  _vclnt2.carrid and $projection.so_id  =  _vclnt2.connid and _vclnt2.fldate = '20000101' {  key node_key,  key so_id,  created_by,   created_at,
  changed_by,
  _sibling1,
  _sibling2,
  _t1001,
  // ppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp

  _t1002                                                                                                                                                                                                                                                    as blablablabla,
  _vclnt1,
  _vclnt2
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[
"SFLIGHT",
"SNWD_SO",
"T100"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More