I_SrvcDocLifecycleStatusText

DDL: I_SRVCDOCLIFECYCLESTATUSTEXT Type: view COMPOSITE Package: CRMS4_REPORT

Srvc Transaction Life Cycle Status - Txt

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

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_CustMgmtLifecycleUserStsText I_CustMgmtLifecycleUserStsText from
I_SrvcLifeCycleSystemStatusT I_SrvcLifeCycleSystemStatusT union

Associations (1)

CardinalityTargetAliasCondition
[1] I_SrvcDocLifecycleStatus _ServiceDocumentStatus $projection.ServiceDocumentStatus = _ServiceDocumentStatus.ServiceDocumentStatus

Annotations (16)

NameValueLevelField
EndUserText.label Srvc Transaction Life Cycle Status - Txt view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVDOCLFCSTTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ServiceDocumentStatus view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentStatus
KEY Language Language
ServiceDocumentStatusName
_Language _Language
KEY ServiceDocumentStatus
KEY Language Language
ServiceDocumentStatusName
_Language _Language
_ServiceDocumentStatus _ServiceDocumentStatus 
@EndUserText.label: 'Srvc Transaction Life Cycle Status - Txt'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
  sqlViewName: 'ISRVDOCLFCSTTXT',
  compiler.compareFilter: true,
  preserveKey: true
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel: {
   dataCategory: #TEXT,
   representativeKey: 'ServiceDocumentStatus',
   usageType: {
     dataClass:      #CUSTOMIZING,
     serviceQuality: #B,
     sizeCategory:   #M
   },
   supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, 
                            #SQL_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ],
   modelingPattern: #LANGUAGE_DEPENDENT_TEXT
}
@Analytics.dataExtraction.enabled: true
@Metadata.ignorePropagatedAnnotations: true

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

define view I_SrvcDocLifecycleStatusText
  as select from I_CustMgmtLifecycleUserStsText

  association [1] to I_SrvcDocLifecycleStatus as _ServiceDocumentStatus on $projection.ServiceDocumentStatus = _ServiceDocumentStatus.ServiceDocumentStatus

{
      @ObjectModel.foreignKey.association: '_ServiceDocumentStatus'
  key cast(CustMgmtLifecycleUserStatus as crms4_stat_lifecycle preserving type ) as ServiceDocumentStatus,
      @Semantics.language: true
  key Language,
      @Semantics.text: true
      cast(CustMgmtLifecycleUserStsName as crms4_stat_lifecycle_desc )           as ServiceDocumentStatusName,

      _Language,
      _ServiceDocumentStatus
}

union select from I_SrvcLifeCycleSystemStatusT

association [1] to I_SrvcDocLifecycleStatus as _ServiceDocumentStatus on $projection.ServiceDocumentStatus = _ServiceDocumentStatus.ServiceDocumentStatus

{
       $session.client                                                          as mandt,
       @ObjectModel.foreignKey.association: '_ServiceDocumentStatus'
  key  cast(SrvcLifeCycleSystemStatus as crms4_stat_lifecycle preserving type ) as ServiceDocumentStatus,
       @Semantics.language:true
       @ObjectModel.foreignKey.association: '_Language'
  key  Language,
       @Semantics.text: true
       cast (SrvcLifeCycleSystemStatusName as crms4_stat_lifecycle_desc )       as ServiceDocumentStatusName,

       _Language,
       _ServiceDocumentStatus
}

Learn More