I_SADL_Complex_Core

@AbapCatalog.sqlViewName: 'ISADLCOCO'
@EndUserText.label: 'Core view with joins/unions/where-clause'

define view I_SADL_Complex_Core as 

select from snwd_so_i as item 
 inner join snwd_so as header on item.parent_key = header.node_key
 
 association to i_sadl_complex_core as _Something on _Something.SalesOrder = '1000000000' and _Something.ItemPosition = $projection.ItemPosition
{
 key header.so_id as SalesOrder,
 key item.so_item_pos as ItemPosition, 
 
 item.currency_code as CurrencyCode, 
 item.gross_amount as GrossAmount, 
 item.net_amount as NetAmount, 
 item.tax_amount as TaxAmount,
 
 cast('X' as boole_d preserving type ) as AnyFlag,
 _Something
}
where header.delivery_status = 'D'

union all

select from snwd_so_i as item
 association to i_sadl_complex_core as _Something on _Something.SalesOrder = '1000000000' and _Something.ItemPosition = $projection.ItemPosition 
{
 key '0000000000' as SalesOrder,
 key item.so_item_pos as ItemPosition, 
 
 item.currency_code as CurrencyCode, 
 item.gross_amount as GrossAmount, 
 item.net_amount as NetAmount, 
 item.tax_amount as TaxAmount,
 
 cast(' ' as boole_d preserving type) as AnyFlag,
 _Something
}
where item.op_item_pos = '0000000000'