I_SrvcQtanLifeCycleStatus

DDL: I_SRVCQTANLIFECYCLESTATUS Type: view COMPOSITE

Service Quotation Life Cycle Status

I_SrvcQtanLifeCycleStatus is a Composite CDS View (Dimension) that provides data about "Service Quotation Life Cycle Status" in SAP S/4HANA. It reads from 2 data sources (I_CustMgmtLifecycleUserStatus, I_ServiceQuotationStatus) and exposes 3 fields with key fields ServiceQuotationStatus, ServiceQuotationStatus. It has 1 association to related views.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtLifecycleUserStatus I_CustMgmtLifecycleUserStatus from
I_ServiceQuotationStatus I_ServiceQuotationStatus union

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_SrvcQtanLifeCycleStatusText _ServiceQuotationStatusText $projection.ServiceQuotationStatus = _ServiceQuotationStatusText.ServiceQuotationStatus

Annotations (15)

NameValueLevelField
EndUserText.label Service Quotation Life Cycle Status view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVQTANLFCSTAT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey ServiceQuotationStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotationStatus
KEY ServiceQuotationStatus
_ServiceQuotationStatusText _ServiceQuotationStatusText 
@EndUserText.label: 'Service Quotation Life Cycle Status'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'ISRVQTANLFCSTAT',
  compiler.compareFilter: true
}
@ObjectModel: {
  representativeKey: 'ServiceQuotationStatus',
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S
  },
  supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
 
}
@Analytics: {
    dataCategory: #DIMENSION,
    internalName: #LOCAL
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck:#NOT_REQUIRED
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true


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

define view I_SrvcQtanLifeCycleStatus
  as select from I_CustMgmtLifecycleUserStatus
  association [1..*] to I_SrvcQtanLifeCycleStatusText as _ServiceQuotationStatusText on $projection.ServiceQuotationStatus = _ServiceQuotationStatusText.ServiceQuotationStatus
{
 
      @ObjectModel.text.association: '_ServiceQuotationStatusText'
      @Search.defaultSearchElement: true
  key cast(CustMgmtLifecycleUserStatus as crms4_stat_lifecycle preserving type ) as ServiceQuotationStatus,
 
      _ServiceQuotationStatusText
}
union select from I_ServiceQuotationStatus
association [1..*] to I_SrvcQtanLifeCycleStatusText as _ServiceQuotationStatusText on $projection.ServiceQuotationStatus = _ServiceQuotationStatusText.ServiceQuotationStatus
{
 
      $session.client                                                     as mandt,
      @ObjectModel.text.association: '_ServiceQuotationStatusText'
      @Search.defaultSearchElement: true
  key cast(ServiceQuotationStatus as crms4_qtan_stat_lc preserving type ) as ServiceQuotationStatus,
 
      _ServiceQuotationStatusText
 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTMGMTLIFECYCLEUSERSTATUS",
"I_SERVICEQUOTATIONSTATUS"
],
"ASSOCIATED":
[
"I_SRVCQTANLIFECYCLESTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More