I_CABusinessLockReasonEnhanced

DDL: I_CABUSINESSLOCKREASONENHANCED Type: view_entity COMPOSITE

Enhanced Business Lock Reason

I_CABusinessLockReasonEnhanced is a Composite CDS View that provides data about "Enhanced Business Lock Reason" in SAP S/4HANA. It reads from 2 data sources (P_CABusinessLockReasonMult, I_CABusinessLockReason) and exposes 7 fields with key fields CABusinessProcess, CABusinessLockReasonEnhanced, CABusinessLockReasonEnhanced. It has 2 associations to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
P_CABusinessLockReasonMult BusLockReasonMult union_all
I_CABusinessLockReason I_CABusinessLockReason from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CABusinessProcess _BusProcess $projection.CABusinessProcess = _BusProcess.CABusinessProcess
[0..*] I_CABusinessLockReasonEnhcdTxT _Text $projection.CABusinessProcess = _Text.CABusinessProcess and $projection.CABusinessLockReasonEnhanced = _Text.CABusinessLockReasonEnhanced

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Enhanced Business Lock Reason view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CABusinessProcess CABusinessProcess
KEY CABusinessLockReasonEnhanced
_BusProcess _BusProcess
CABusinessProcess
KEY CABusinessLockReasonEnhanced P_CABusinessLockReasonMult CABusinessLockReasonEnhanced
_BusProcess _BusProcess
_Text _Text 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Enhanced Business Lock Reason'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view entity I_CABusinessLockReasonEnhanced
  as select from I_CABusinessLockReason
  association [1..1] to I_CABusinessProcess            as _BusProcess on  $projection.CABusinessProcess = _BusProcess.CABusinessProcess
  association [0..*] to I_CABusinessLockReasonEnhcdTxT as _Text       on  $projection.CABusinessProcess    = _Text.CABusinessProcess
                                                                      and $projection.CABusinessLockReasonEnhanced = _Text.CABusinessLockReasonEnhanced
{
  key CABusinessProcess,
  key cast( CABusinessLockReason as lockrenh_kk ) as CABusinessLockReasonEnhanced,
      /* Associations */
      _BusProcess,
      _Text
}

union all select from P_CABusinessLockReasonMult as BusLockReasonMult
  join                I_CABusinessProcess        as BusProc on BusProc.CABusinessProcess = '01'
                                                            or BusProc.CABusinessProcess = '02'
                                                            or BusProc.CABusinessProcess = '03'
                                                            or BusProc.CABusinessProcess = '10'
                                                            or BusProc.CABusinessProcess = '04'
                                                            or BusProc.CABusinessProcess = '07'
                                                            or BusProc.CABusinessProcess = '09'
                                                            or BusProc.CABusinessProcess = '05'
                                                            or BusProc.CABusinessProcess = '12'
association [1..1] to I_CABusinessProcess            as _BusProcess on  $projection.CABusinessProcess = _BusProcess.CABusinessProcess
association [0..*] to I_CABusinessLockReasonEnhcdTxT as _Text       on  $projection.CABusinessProcess    = _Text.CABusinessProcess
                                                                    and $projection.CABusinessLockReasonEnhanced = _Text.CABusinessLockReasonEnhanced
{
  key BusProc.CABusinessProcess,
  key BusLockReasonMult.CABusinessLockReasonEnhanced,
      _BusProcess,
      _Text

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CABUSINESSLOCKREASON",
"I_CABUSINESSPROCESS",
"P_CABUSINESSLOCKREASONMULT"
],
"ASSOCIATED":
[
"I_CABUSINESSLOCKREASONENHCDTXT",
"I_CABUSINESSPROCESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More