I_DFS_MaintFlightOrderBasic

DDL: I_DFS_MAINTFLIGHTORDERBASIC SQL: IDFSFLGHTORD Type: view BASIC

Basic view of flight order

I_DFS_MaintFlightOrderBasic is a Basic CDS View that provides data about "Basic view of flight order" in SAP S/4HANA. It reads from 1 data source (/isdfps/lm_fli) and exposes 16 fields with key field MaintenanceOrder.

Data Sources (1)

SourceAliasJoin Type
/isdfps/lm_fli /isdfps/lm_fli from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDFSFLGHTORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Basic view of flight order view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder /isdfps/lm_fli aufnr
DfsMaintFlightOrderStartTime /isdfps/lm_fli start_tnzone
DfsMaintFlightOrderStartDate /isdfps/lm_fli start_date
DfsMaintFlightOrderEndTime /isdfps/lm_fli landing_tnzone
DfsMaintFlightOrderEndDate /isdfps/lm_fli landing_date
DfsMaintFlghtOrdObjectNumber /isdfps/lm_fli f_objnr
DfsMaintFlightConfiguration /isdfps/lm_fli arm_setup
DfsMaintFlightLtstTakeOffTime /isdfps/lm_fli latest_take_off
DfsMaintPlndFlightDuration /isdfps/lm_fli flight_duration
DfsMaintPlndFlightDurationUnit /isdfps/lm_fli unit_fl_duration
DfsMaintFlightDeviation /isdfps/lm_fli variance
DfsMaintFlightDeviationReason /isdfps/lm_fli reason_variance
DfsMaintFlightDestinationDesc /isdfps/lm_fli landing_loc
DfsMaintFlightMissionID /isdfps/lm_fli mission
ForceElementOrgUUID /isdfps/lm_fli operation_id
DfsObjectSequenceNumber /isdfps/lm_fli operation_cnt
@AbapCatalog.sqlViewName: 'IDFSFLGHTORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType:#BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Basic view of flight order'
define view I_DFS_MaintFlightOrderBasic
  as select from /isdfps/lm_fli
{
  key /isdfps/lm_fli.aufnr            as MaintenanceOrder,
      /isdfps/lm_fli.start_tnzone     as DfsMaintFlightOrderStartTime,
      /isdfps/lm_fli.start_date       as DfsMaintFlightOrderStartDate,
      /isdfps/lm_fli.landing_tnzone   as DfsMaintFlightOrderEndTime,
      /isdfps/lm_fli.landing_date     as DfsMaintFlightOrderEndDate,
      /isdfps/lm_fli.f_objnr          as DfsMaintFlghtOrdObjectNumber,
      /isdfps/lm_fli.arm_setup        as DfsMaintFlightConfiguration,
      /isdfps/lm_fli.latest_take_off  as DfsMaintFlightLtstTakeOffTime,
      /isdfps/lm_fli.flight_duration  as DfsMaintPlndFlightDuration,
      /isdfps/lm_fli.unit_fl_duration as DfsMaintPlndFlightDurationUnit,
      /isdfps/lm_fli.variance         as DfsMaintFlightDeviation,
      /isdfps/lm_fli.reason_variance  as DfsMaintFlightDeviationReason,
      /isdfps/lm_fli.landing_loc      as DfsMaintFlightDestinationDesc,
      /isdfps/lm_fli.mission          as DfsMaintFlightMissionID,
      /isdfps/lm_fli.operation_id     as ForceElementOrgUUID,
      /isdfps/lm_fli.operation_cnt    as DfsObjectSequenceNumber







}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ISDFPS/LM_FLI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/