Test_Cds_Astcheck_01

DDL: TEST_CDS_ASTCHECK_01 SQL: testcdsac1 Type: view

test 1

Test_Cds_Astcheck_01 is a CDS View that provides data about "test 1" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 12 fields with key fields node_key, so_id. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
snwd_so snwd_so from

Associations (4)

CardinalityTargetAliasCondition
[1] qlast_sddl_bpa _buyer buyer_guid = _buyer.node_key
[1] qlast_sddl_texts _note note_guid = _note.parent_key
[0..*] qlast_sddl_so_item _items snwd_so.node_key = _items.parent_key
[1] tcurc _currency currency_code = waers

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName testcdsac1 view
AbapCatalog.compiler.compareFilter true view
EndUserText.label test 1 view

Fields (12)

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
changed_at changed_at
buyer_guid buyer_guid
note_guid note_guid
_buyer _buyer
_note _note
_items _items
_currency _currency 
@AbapCatalog.sqlViewName: 'testcdsac1'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'test 1'
define view Test_Cds_Astcheck_01
  as select

  from snwd_so
  association [1]    to qlast_sddl_bpa     as _buyer    on buyer_guid = _buyer.node_key
  association [1]    to qlast_sddl_texts   as _note     on note_guid = _note.parent_key
  association [0..*] to qlast_sddl_so_item as _items    on snwd_so.node_key = _items.parent_key
  association [1]    to tcurc              as _currency on currency_code = waers
{
  key node_key,
  key so_id,
      created_by,
      created_at,
      changed_by,
      changed_at,
      buyer_guid,
      note_guid,
      currency_code,
      _buyer,
      _note,
      _items,
      _currency
}         
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[
"QLAST_SDDL_BPA",
"QLAST_SDDL_SO_ITEM",
"QLAST_SDDL_TEXTS",
"TCURC"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More