I_CustMgmtLifecycleUserStsText

DDL: I_CUSTMGMTLIFECYCLEUSERSTSTEXT Type: view BASIC Package: CRMS4_ORDER

Life Cycle Status in Service - Text

I_CustMgmtLifecycleUserStsText is a Basic CDS View that provides data about "Life Cycle Status in Service - Text" in SAP S/4HANA. It reads from 1 data source (crms4c_stat_lc_t) and exposes 5 fields with key fields Language, CustMgmtLifecycleUserStatus. It has 2 associations to related views. It is exposed through 1 OData service (C_BUSSOLUTIONORDER_SRV). Part of development package CRMS4_ORDER.

Data Sources (1)

SourceAliasJoin Type
crms4c_stat_lc_t crms4c_stat_lc_t from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CustMgmtLifecycleUserStatus _CustMgmtLifecycleUserStatus $projection.CustMgmtLifecycleUserStatus = _CustMgmtLifecycleUserStatus.CustMgmtLifecycleUserStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (17)

NameValueLevelField
EndUserText.label Life Cycle Status in Service - Text view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CustMgmtLifecycleUserStatus view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICMLFCYCUSERSTST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 2 view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSSOLUTIONORDER_SRV C_BUSSOLUTIONORDER V2 C1 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Language language
KEY CustMgmtLifecycleUserStatus stat_lifecycle
CustMgmtLifecycleUserStsName description
_CustMgmtLifecycleUserStatus _CustMgmtLifecycleUserStatus
_Language _Language
@EndUserText.label: 'Life Cycle Status in Service - Text'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    dataCategory: #TEXT,
    representativeKey: 'CustMgmtLifecycleUserStatus',
    usageType: {serviceQuality: #B, sizeCategory: #S, dataClass: #CUSTOMIZING}
}
@Metadata: {
    ignorePropagatedAnnotations: true
}
@ClientHandling: {
    algorithm: #SESSION_VARIABLE
}
@AbapCatalog: {
    sqlViewName: 'ICMLFCYCUSERSTST',
    compiler.compareFilter: true,
    preserveKey: true,
    buffering: {status: #ACTIVE, type: #GENERIC, numberOfKeyFields: 2}
}

define view I_CustMgmtLifecycleUserStsText
  as select from crms4c_stat_lc_t
  association [0..1] to I_CustMgmtLifecycleUserStatus as _CustMgmtLifecycleUserStatus on $projection.CustMgmtLifecycleUserStatus = _CustMgmtLifecycleUserStatus.CustMgmtLifecycleUserStatus
  association [0..1] to I_Language                    as _Language                    on $projection.Language = _Language.Language
{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key language       as Language,
      @ObjectModel.foreignKey.association: '_CustMgmtLifecycleUserStatus'
  key stat_lifecycle as CustMgmtLifecycleUserStatus,
      @Semantics.text: true
      description    as CustMgmtLifecycleUserStsName,

      _CustMgmtLifecycleUserStatus,
      _Language
}