I_AirborneAgentRoot

DDL: I_AIRBORNEAGENTROOT SQL: IABAGTROOT Type: view BASIC

Airborne Agent

I_AirborneAgentRoot is a Basic CDS View (Dimension) that provides data about "Airborne Agent" in SAP S/4HANA. It reads from 1 data source (ehhssd_abagt) and exposes 9 fields. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
ehhssd_abagt ehhssd_abagt from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..*] I_AirborneAgentRevision _AirborneAgentRevision $projection.AirborneAgentUUID = _AirborneAgentRevision.AirborneAgentUUID

Annotations (13)

NameValueLevelField
EndUserText.label Airborne Agent view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
ObjectModel.representativeKey AirborneAgentUUID view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IABAGTROOT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (9)

KeyFieldSource TableSource FieldDescription
_AirborneAgentRevision _AirborneAgentRevision
AirborneAgentID id
AirborneAgentMigrationSource migration_src
CreatedByUser user_id_cr
_CreatedByUser _CreatedByUser
CreationDateTime datetime_cr
LastChangedByUser user_id_ch
_LastChangedByUser _LastChangedByUser
LastChangeDateTime datetime_ch 
@EndUserText.label: 'Airborne Agent'
@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled:true }
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'AirborneAgentUUID'
@Metadata.allowExtensions:true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_CreatedByUser','_LastChangedByUser']

@AbapCatalog.sqlViewName: 'IABAGTROOT'
@AbapCatalog.compiler.compareFilter: true


// Client handling by session 

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec   

                         sizeCategory:  #S,         // < 1000

                         dataClass: #MASTER }  

define view I_AirborneAgentRoot as select from ehhssd_abagt 
    
    association [0..1] to I_User as _CreatedByUser on $projection.CreatedByUser = _CreatedByUser.UserID 
    association [0..1] to I_User as _LastChangedByUser on $projection.LastChangedByUser = _LastChangedByUser.UserID 
    association [0..*] to I_AirborneAgentRevision as _AirborneAgentRevision on $projection.AirborneAgentUUID = _AirborneAgentRevision.AirborneAgentUUID

{
    
    key cast( db_key as ehhss_abagt_key_ref )as AirborneAgentUUID,
    _AirborneAgentRevision,
    
    id as AirborneAgentID,
    
    migration_src as AirborneAgentMigrationSource,
    
    user_id_cr as CreatedByUser,
    _CreatedByUser,
    
    datetime_cr as CreationDateTime,
    
    user_id_ch as LastChangedByUser,
    _LastChangedByUser,  
    
    datetime_ch as LastChangeDateTime      
    
}          
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHHSSD_ABAGT"
],
"ASSOCIATED":
[
"I_AIRBORNEAGENTREVISION",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More