SADL_SB_AUNIT_SCARR

DDL: SADL_SB_AUNIT_SCARR SQL: VSADLSB_AU_SCARR Type: view

SADL_SB_AUNIT_SCARR is a CDS View in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 4 fields with key field id. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] SADL_SB_AUNIT_SPFLI schedules $projection.id = schedules.carrier_id

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName VSADLSB_AU_SCARR view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY id carrid
name carrname
url url
schedules schedules 
@AbapCatalog.sqlViewName: 'VSADLSB_AU_SCARR'
define view SADL_SB_AUNIT_SCARR as select from scarr
    association [0..*] to SADL_SB_AUNIT_SPFLI as schedules on $projection.id = schedules.carrier_id
{
    key carrid as id,
    
    carrname as name,
    currcode as local_currency,
    url as url,
    
    schedules
}           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"SCARR"
],
"ASSOCIATED":
[
"SADL_SB_AUNIT_SPFLI"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More