I_LglCntntMRelshpUseCaseStatus

DDL: I_LGLCNTNTMRELSHPUSECASESTATUS SQL: ILCMRELUSECASST Type: view COMPOSITE

Basic view for all Legal Transactions and usecases

I_LglCntntMRelshpUseCaseStatus is a Composite CDS View that provides data about "Basic view for all Legal Transactions and usecases" in SAP S/4HANA. It reads from 2 data sources (I_LegalTransaction, I_LglCntntMUseCases) and exposes 10 fields with key fields LegalTransactionUUID, LglCntntMRelshpUseCase. It has 3 associations to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_LegalTransaction I_LegalTransaction from
I_LglCntntMUseCases I_LglCntntMUseCases cross

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_LglCntntMRltnLglTransUseCase _LT_RelRegn $projection.LegalTransactionUUID = _LT_RelRegn.LegalTransactionRelshpUUID and _LT_RelRegn.LglCntntMTopRelshpUseCase = 'X' and $projection.LglCntntMRelshpUseCase = _LT_RelRegn.LglCntntMRelshpUseCase
[1..1] I_LegalTransaction _TopLegalTransaction $projection.legaltransactiontopuuid = _TopLegalTransaction.LegalTransactionUUID
[0..1] I_LglCntntMUseCaseText _LglCntntMUseCaseText $projection.LglCntntMRelshpUseCase = _LglCntntMUseCaseText.LglCntntMRelshpUseCase and Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILCMRELUSECASST view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey LegalTransactionUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Basic view for all Legal Transactions and usecases view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionUUID LegalTransactionUUID
KEY LglCntntMRelshpUseCase I_LglCntntMUseCases LglCntntMRelshpUseCase
LglCntntMUseCaseRegUUID _LT_RelRegn LglCntntMUseCaseRegUUID
LglCntntMUseCaseExecStatus _LT_RelRegn LglCntntMUseCaseExecStatus
LegalTransactionTopUUID _LT_RelRegn LegalTransactionTopUUID
LglCntntMLegalTrLogHandler _LT_RelRegn LglCntntMLegalTrLogHandler
LglCntntMTopRelshpUseCase _LT_RelRegn LglCntntMTopRelshpUseCase
_LT_RelRegn _LT_RelRegn
_TopLegalTransaction _TopLegalTransaction
_LglCntntMUseCaseText _LglCntntMUseCaseText 
@AbapCatalog.sqlViewName: 'ILCMRELUSECASST'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@VDM.viewType : #COMPOSITE

@ObjectModel: {
  representativeKey: 'LegalTransactionUUID',
  usageType.serviceQuality: #C,
  usageType.sizeCategory: #XL,
  usageType.dataClass: #MIXED
}

@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations:  [ '_LT_RelRegn' ]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Basic view for all Legal Transactions and usecases'
define view I_LglCntntMRelshpUseCaseStatus
  as select from I_LegalTransaction
    cross join   I_LglCntntMUseCases
  association [0..1] to I_LglCntntMRltnLglTransUseCase as _LT_RelRegn           on  $projection.LegalTransactionUUID      = _LT_RelRegn.LegalTransactionRelshpUUID
                                                                                and _LT_RelRegn.LglCntntMTopRelshpUseCase = 'X'
                                                                                and $projection.LglCntntMRelshpUseCase    = _LT_RelRegn.LglCntntMRelshpUseCase
  association [1..1] to I_LegalTransaction             as _TopLegalTransaction  on  $projection.legaltransactiontopuuid = _TopLegalTransaction.LegalTransactionUUID
  association [0..1] to I_LglCntntMUseCaseText         as _LglCntntMUseCaseText on  $projection.LglCntntMRelshpUseCase = _LglCntntMUseCaseText.LglCntntMRelshpUseCase
                                                                                and Language                           = $session.system_language
{
  key LegalTransactionUUID,
  key I_LglCntntMUseCases.LglCntntMRelshpUseCase,
      _LT_RelRegn.LglCntntMUseCaseRegUUID as LglCntntMUseCaseRegUUID,
      _LT_RelRegn.LglCntntMUseCaseExecStatus,
      _LT_RelRegn.LegalTransactionTopUUID,
      _LT_RelRegn.LglCntntMLegalTrLogHandler,
      _LT_RelRegn.LglCntntMTopRelshpUseCase,
      _LT_RelRegn,
      _TopLegalTransaction,
      _LglCntntMUseCaseText
}
where
  LglCntntMRelshpUseCase = 'SSTS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEGALTRANSACTION",
"I_LGLCNTNTMRLTNLGLTRANSUSECASE",
"I_LGLCNTNTMUSECASES"
],
"ASSOCIATED":
[
"I_LEGALTRANSACTION",
"I_LGLCNTNTMRLTNLGLTRANSUSECASE",
"I_LGLCNTNTMUSECASETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More