I_CABusinessLockReasonText

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Business Lock Reason - Text'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { dataCategory: #TEXT,
                modelingPattern: #LANGUAGE_DEPENDENT_TEXT,
                representativeKey: 'CABusinessLockReason',
                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #LANGUAGE_DEPENDENT_TEXT,
                                         #SQL_DATA_SOURCE ],
                usageType: { dataClass: #CUSTOMIZING,
                             serviceQuality: #C,
                             sizeCategory: #S } }

@VDM.viewType: #COMPOSITE

define view entity I_CABusinessLockReasonText

  as select from I_CADunningLockReasonText as DunLockRsnTxt
    join         I_CABusinessProcess       as BusProc on BusProc.CABusinessProcess = '01'
  association [1..1] to I_CABusinessProcess as _BusProcess on $projection.CABusinessProcess = _BusProcess.CABusinessProcess
  association [0..1] to I_Language          as _Language   on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_BusProcess'
  key BusProc.CABusinessProcess,
  key DunLockRsnTxt.CADunningLockReason     as CABusinessLockReason,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key DunLockRsnTxt.Language,
      @Semantics.text: true
      DunLockRsnTxt.CADunningLockReasonName as CABusinessLockReasonName,
      _BusProcess,
      _Language
}

union all select from I_CAPaymentLockReasonText as PaytLockRsnTxt
  join                I_CABusinessProcess       as BusProc on BusProc.CABusinessProcess = '02'
                                                           or BusProc.CABusinessProcess = '03'
                                                           or BusProc.CABusinessProcess = '10'
association [1..1] to I_CABusinessProcess as _BusProcess on $projection.CABusinessProcess = _BusProcess.CABusinessProcess
association [0..1] to I_Language          as _Language   on $projection.Language = _Language.Language
{
  key BusProc.CABusinessProcess,
  key PaytLockRsnTxt.CAPaymentLockReason     as CABusinessLockReason,
  key PaytLockRsnTxt.Language,
      PaytLockRsnTxt.CAPaymentLockReasonName as CABusinessLockReasonName,
      _BusProcess,
      _Language
}

union all select from I_CAInterestLockReasonText as IntrstLockRsnTxt
  join                I_CABusinessProcess        as BusProc on BusProc.CABusinessProcess = '04'
association [1..1] to I_CABusinessProcess as _BusProcess on $projection.CABusinessProcess = _BusProcess.CABusinessProcess
association [0..1] to I_Language          as _Language   on $projection.Language = _Language.Language
{
  key BusProc.CABusinessProcess,
  key IntrstLockRsnTxt.CAInterestLockReason     as CABusinessLockReason,
  key IntrstLockRsnTxt.Language,
      IntrstLockRsnTxt.CAInterestLockReasonText as CABusinessLockReasonName,
      _BusProcess,
      _Language
}

union all select from I_CACorrespncDunLockRsnText as CorrespncDunLockRsnTxt
  join                I_CABusinessProcess         as BusProc on BusProc.CABusinessProcess = '07'
association [1..1] to I_CABusinessProcess as _BusProcess on $projection.CABusinessProcess = _BusProcess.CABusinessProcess
association [0..1] to I_Language          as _Language   on $projection.Language = _Language.Language
{
  key BusProc.CABusinessProcess,
  key CorrespncDunLockRsnTxt.CACorrespncDunLockReason     as CABusinessLockReason,
  key CorrespncDunLockRsnTxt.Language,
      CorrespncDunLockRsnTxt.CACorrespncDunLockReasonText as CABusinessLockReasonName,
      _BusProcess,
      _Language
}

union all select from I_CAPostgAndClrgLockRsnText as PostgAndClrgLockRsnTxt
  join                I_CABusinessProcess         as BusProc on BusProc.CABusinessProcess = '09'
association [1..1] to I_CABusinessProcess as _BusProcess on $projection.CABusinessProcess = _BusProcess.CABusinessProcess
association [0..1] to I_Language          as _Language   on $projection.Language = _Language.Language
{
  key BusProc.CABusinessProcess,
  key PostgAndClrgLockRsnTxt.CAPostgAndClrgLockReason     as CABusinessLockReason,
  key PostgAndClrgLockRsnTxt.Language,
      PostgAndClrgLockRsnTxt.CAPostgAndClrgLockReasonName as CABusinessLockReasonName,
      _BusProcess,
      _Language
}

union all select from I_CAInvcgLockReasonText as InvocgLockRsnTxt
  join                I_CABusinessProcess     as BusProc on BusProc.CABusinessProcess = '05'
                                                         or BusProc.CABusinessProcess = '12'
association [1..1] to I_CABusinessProcess as _BusProcess on $projection.CABusinessProcess = _BusProcess.CABusinessProcess
association [0..1] to I_Language          as _Language   on $projection.Language = _Language.Language
{
  key BusProc.CABusinessProcess,
  key InvocgLockRsnTxt.CAInvcgLockReason     as CABusinessLockReason,
  key InvocgLockRsnTxt.Language,
      InvocgLockRsnTxt.CAInvcgLockReasonName as CABusinessLockReasonName,
      _BusProcess,
      _Language
}