I_Route

DDL: I_ROUTE SQL: ILEROUTE Type: view BASIC

Route

I_Route is a Basic CDS View that provides data about "Route" in SAP S/4HANA. It reads from 1 data source (tvro) and exposes 6 fields with key field Route. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
tvro tvro from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_RouteText _Text $projection.Route = _Text.Route

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey Route view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Route view
Search.searchable true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ILEROUTE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Route route
TransitDurationInCalendarDays
TranspLeadTimeInCalDays
TranspLeadTimeInHrsMin
RouteFactoryCalendar spfbk
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'Route'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE]
@EndUserText.label: 'Route'
@Search.searchable: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ILEROUTE'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@Metadata.ignorePropagatedAnnotations:true

define view I_Route
as select from
tvro 
association [0..*] to I_RouteText as _Text on $projection.Route = _Text.Route
{ 
   @Search.defaultSearchElement:true
   @ObjectModel.text.association: '_Text'
   key route as Route,
   cast(traztd as vdm_letra_duration preserving type ) as TransitDurationInCalendarDays,
   cast(tdvztd as vdm_letra_duration preserving type ) as TranspLeadTimeInCalDays,
   cast(tdvznd as vdm_letra_leadtime preserving type ) as TranspLeadTimeInHrsMin, 
   spfbk  as RouteFactoryCalendar,
   
    _Text
};        
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVRO"
],
"ASSOCIATED":
[
"I_ROUTETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More