I_ConsentLifeCycleStatus

DDL: I_CONSENTLIFECYCLESTATUS SQL: ICNSNTLFST Type: view BASIC

Life cycle status of Consent

I_ConsentLifeCycleStatus is a Basic CDS View that provides data about "Life cycle status of Consent" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field ConsentLifeCycleStatus. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ConsentLifeCycleText _ConsentLifeCycleText $projection.ConsentLifeCycleStatus = _ConsentLifeCycleText.ConsentLifeCycleStatus

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICNSNTLFST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Life cycle status of Consent view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey ConsentLifeCycleStatus view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ConsentLifeCycleStatus Life Cycle Status
_ConsentLifeCycleText _ConsentLifeCycleText
@AbapCatalog.sqlViewName: 'ICNSNTLFST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Life cycle status of Consent'
@ObjectModel.usageType: { sizeCategory: #S, dataClass: #CUSTOMIZING, serviceQuality: #A }
@ObjectModel.representativeKey: 'ConsentLifeCycleStatus'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.resultSet.sizeCategory: #XS

define view I_ConsentLifeCycleStatus
  as select from dd07l
  association [0..*] to I_ConsentLifeCycleText as _ConsentLifeCycleText on $projection.ConsentLifeCycleStatus = _ConsentLifeCycleText.ConsentLifeCycleStatus
{
      @Consumption.filter.hidden:true
      @ObjectModel.text.association: '_ConsentLifeCycleText'
      @UI.textArrangement: #TEXT_ONLY
      @EndUserText.label: 'Life Cycle Status'
  key cast( left( domvalue_l, 2 ) as cme_consent_lifecycle_status) as ConsentLifeCycleStatus,
      @Consumption.filter.hidden:true
      _ConsentLifeCycleText
}
where
      domname  = 'CMA_CONSENT_LIFECYCLE_STATUS'
  and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_CONSENTLIFECYCLETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/