I_SrvcQtanLifeCycleStatusText

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'ISRVQTANLFCSTTXT',
  compiler.compareFilter: true
}
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ServiceQuotationStatus'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Srvc Quotation Life Cycle Status - Txt'
@AccessControl.authorizationCheck:#NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true

/*+[hideWarning] { "IDS" : [ "KEY_CHECK", "CALCULATED_FIELD_CHECK" ] }*/

define view I_SrvcQtanLifeCycleStatusText
  as select from I_CustMgmtLifecycleUserStsText


  association [1] to I_SrvcQtanLifeCycleStatus as _ServiceQuotationStatus on $projection.ServiceQuotationStatus = _ServiceQuotationStatus.ServiceQuotationStatus

{

      @ObjectModel.foreignKey.association: '_ServiceQuotationStatus'
  key cast(CustMgmtLifecycleUserStatus as crms4_stat_lifecycle preserving type ) as ServiceQuotationStatus,
      @Semantics.language: true
  key Language,

      @Semantics.text: true
      CustMgmtLifecycleUserStsName                                               as ServiceQuotationStatusName,

      _ServiceQuotationStatus

}
where
      CustMgmtLifecycleUserStatus <> 'A'
  and CustMgmtLifecycleUserStatus <> 'B'
  and CustMgmtLifecycleUserStatus <> 'C'
  and CustMgmtLifecycleUserStatus <> 'D'
  and CustMgmtLifecycleUserStatus <> 'E'

union select from I_ServiceQuotationStatusText


association [1] to I_SrvcQtanLifeCycleStatus as _ServiceQuotationStatus on $projection.ServiceQuotationStatus = _ServiceQuotationStatus.ServiceQuotationStatus
{
       $session.client                                                               as mandt,
       @ObjectModel.foreignKey.association: '_ServiceQuotationStatus'

  key  cast(ServiceQuotationStatus as crms4_qtan_stat_lc preserving type )           as ServiceQuotationStatus,
       @Semantics.language:true
       @ObjectModel.foreignKey.association: '_Language'
  key  Language,
       @Semantics.text: true
       cast(ServiceQuotationStatusName as  crms4_qtan_stat_lc_name preserving type ) as ServiceQuotationStatusName,
       _ServiceQuotationStatus

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTLIFECYCLEUSERSTSTEXT",
"I_SERVICEQUOTATIONSTATUSTEXT"
],
"ASSOCIATED":
[
"I_SRVCQTANLIFECYCLESTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/