I_SrvcQtanLifeCycleStatusText

DDL: I_SRVCQTANLIFECYCLESTATUSTEXT Type: view COMPOSITE Package: CRMS4_SERV_QUOTATION_UI

Srvc Quotation Life Cycle Status - Txt

I_SrvcQtanLifeCycleStatusText is a Composite CDS View that provides data about "Srvc Quotation Life Cycle Status - Txt" in SAP S/4HANA. It reads from 2 data sources (I_CustMgmtLifecycleUserStsText, I_ServiceQuotationStatusText) and exposes 7 fields with key fields ServiceQuotationStatus, Language, ServiceQuotationStatus, Language. It has 1 association to related views. Part of development package CRMS4_SERV_QUOTATION_UI.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtLifecycleUserStsText I_CustMgmtLifecycleUserStsText from
I_ServiceQuotationStatusText I_ServiceQuotationStatusText union

Associations (1)

CardinalityTargetAliasCondition
[1] I_SrvcQtanLifeCycleStatus _ServiceQuotationStatus $projection.ServiceQuotationStatus = _ServiceQuotationStatus.ServiceQuotationStatus

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVQTANLFCSTTXT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ServiceQuotationStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #COMPOSITE view
EndUserText.label Srvc Quotation Life Cycle Status - Txt view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotationStatus
KEY Language Language
ServiceQuotationStatusName CustMgmtLifecycleUserStsName
KEY ServiceQuotationStatus
KEY Language Language
ServiceQuotationStatusName
_ServiceQuotationStatus _ServiceQuotationStatus 
@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

}

Learn More