Test_Cds_Astcheck_24

@AbapCatalog.sqlViewName: 'testcdsac24'

define view Test_Cds_Astcheck_24  as select 
 from snwd_so
association [*]    to qlast_sddl_bpa      as buyer         on buyer_guid =  buyer.node_key
association [2]    to qlast_sddl_texts    as note          on note_guid =  note.parent_key
association [0..*] to qlast_sddl_bpa      as created_by_partner on snwd_so.created_by =  created_by_partner.node_key and created_by_bp = 'X'
association [0..2] to qlast_sddl_bpa      as changed_by_partner on snwd_so.changed_by =  changed_by_partner.node_key and changed_by_bp = 'X'
association [0..1] to qlast_sddl_employee as created       on snwd_so.created_by =  created.node_key and created_by_bp = ' '
association [0..1] to qlast_sddl_employee as changed       on snwd_so.changed_by =  changed.node_key and changed_by_bp = ' '
association [2]    to tcurc               as currency   on currency_code =  waers

{
 
 key node_key, 
 key so_id, created_by, created_at, changed_by, changed_at, created_by_bp, changed_by_bp, note_guid, buyer_guid, currency_code, gross_amount, 
  net_amount, tax_amount, lifecycle_status,  billing_status,  delivery_status,  op_id,  _dataaging,  dummy,  overall_status,  buy_contact_guid, 
  ship_to_adr_guid, bill_to_adr_guid,payment_method, payment_terms, 
  /* Associations */
  buyer, created_by_partner, changed_by_partner, created, changed, note, currency }           
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[
"QLAST_SDDL_BPA",
"QLAST_SDDL_EMPLOYEE",
"QLAST_SDDL_TEXTS",
"TCURC"
],
"BASE":
[],
"VERSION":0
}
}*/