MLRUNLIST_LC_V

@AbapCatalog.sqlViewName: 'MLRUNLIST_LC_DDL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'MLRUNLIST extended field length CYCLENR'
define view MLRUNLIST_LC_V
  as select from mlrunlist as rl

{ key        cast (rl.runref          as ml4h_runref          preserving type )     as RUNREF,
  key        cast (rl.kalnr           as ck_kalnr             preserving type )     as KALNR,
  key        cast (rl.jahrper         as jahrper              preserving type )     as JAHRPER,
             cast (rl.from_jahrper    as jahrper              preserving type )     as FROM_JAHRPER,
             cast (rl.run_id          as ckml_run_id          preserving type )     as RUN_ID,
             cast (rl.otype           as ckml_otyp            preserving type )     as OTYPE,
             cast (rl.matnr           as matnr                preserving type )     as MATNR,
             cast (rl.bwkey           as bwkey                preserving type )     as BWKEY,
             cast (rl.bwtar           as bwtar_d              preserving type )     as BWTAR,
             cast (rl.werks           as werks_d              preserving type )     as WERKS,
             cast (rl.kalst           as ck_kalst             preserving type )     as KALST,
             cast ( concat( rl.cyclenr_prefix , rl.cyclenr ) as ml4h_cyclenr_long ) as CYCLENR_LONG,
             cast (rl.xrelevant       as ml4h_xrelevant       preserving type )     as XRELEVANT,
             cast (rl.xsimbadi        as ml4h_xsimbadi        preserving type )     as XSIMBADI,
             cast (rl.xvcr            as ml4h_xvcr            preserving type )     as XVCR,
             cast (rl.xpreproc        as ml4h_xpreproc        preserving type )     as XPREPROC,
             cast (rl.xsettle         as ml4h_xsettle         preserving type )     as XSETTLE,
             cast (rl.xclose          as ml4h_xclose          preserving type )     as XCLOSE,
             cast (rl.xnopll          as ml4h_xnopll          preserving type )     as XNOPLL,
             cast (rl.cnt_settlelines as ml4h_cnt_settlelines preserving type )     as CNT_SETTLELINES,
             cast (rl.kalnr_agg       as ck_kalnr             preserving type )     as KALNR_AGG
};
-- where rl.cyclenr         > '00000' or
--       rl.cyclenr_prefix  > '000';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MLRUNLIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/