I_ChangeRecordRefCharcTP

@AbapCatalog.sqlViewName: 'ICHGRECREFCHRTP'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Chg Recd Ref Object Characteristic - TP'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
semanticKey: [ 'Characteristic','ChangeNumber'],
                writeDraftPersistence: 'PLMCRREFCHR_D',
                createEnabled,
                deleteEnabled,
                updateEnabled
              }

@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #XXL}
@AbapCatalog.preserveKey:true
define view I_ChangeRecordRefCharcTP
  as select from           I_ChangeRecordRefCharcBsc as reference_charc

    left outer to one join I_ClfnCharcBasic          as Characteristic on  reference_charc.ChgRecRefInternalKey1 =  Characteristic.Characteristic
                                                                       and reference_charc.ChgRecRefInternalKey2 =  Characteristic.ChangeNumber
                                                                       and reference_charc.ChgRecRefInternalKey3 =  Characteristic.CharcDataType
                                                                       and Characteristic.Characteristic         <> ''


  association [1..1] to I_ChangeRecordDraftTP     as _ChangeRecordTP on $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID

  //  association [0..1] to I_ClfnClassCharcBasic as _ClassCharc     on $projection.CharcInternalID = _ClassCharc.CharcInternalID


  //  association [0..*] to I_ClfnClassTypeText   as _ClassTypeText  on $projection.classtype = _ClassTypeText.ClassType

  association [0..1] to E_ChangeRecordRefCharcBsc as _CharcExtension on $projection.ChangeRecordReferenceUUID = _CharcExtension.ChangeRecordReferenceUUID
{

  key        ChangeRecordReferenceUUID,

             @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
             case
               when Characteristic.Characteristic is null then cast(SUBSTRING( reference_charc.ChangeRecordReference, 1, 30) as atnam)
               else cast(Characteristic.Characteristic as atnam)
               end as Characteristic,

             @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
             case
              when Characteristic.ChangeNumber is null then  cast(SUBSTRING( reference_charc.ChangeRecordReference, 31, 12) as aennr)
              else cast(Characteristic.ChangeNumber as aennr)
              end  as ChangeNumber,

             @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
             case
              when Characteristic.CharcDataType is null then  cast(SUBSTRING( reference_charc.ChangeRecordReference, 43, 4) as atfor)
              else cast(Characteristic.CharcDataType as atfor)
              end  as CharcDataType,

             Characteristic.CharcStatus,
             Characteristic.ValidityStartDate,
             Characteristic.CharcInternalID,
             Characteristic.CharcDecimals,
             Characteristic.CharcLength,
             Characteristic.CharcValueUnit,
             ChgRecdReasonForChange,
             ExpdCompltnDte,
             ChgRecdAuthznGrpText,
             ChgRecdNmbrChgSts,
             
             
                   

             //             _ClassCharc.ClassInternalID,

             //             _ClassCharc.ClassType,




             reference_charc.ChangeRecordUUID,

             reference_charc.ChangeRecordReferenceType,
             reference_charc.ChangeRecordReferenceSubtype,
             reference_charc.ChangeRecordReference,
             reference_charc.ParentChangeRecordRefUUID,
             reference_charc.IsMainReference,
             @Semantics.user.createdBy: true
             reference_charc.CreatedByUser,
             reference_charc.CreationDateTime,
             @Semantics.user.lastChangedBy: true
             reference_charc.LastChangedByUser,
             reference_charc.LastChangeDateTime,

             @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
             reference_charc.ChangeRecordItemRelevance,
             reference_charc.ChangeRecordVirtualRefInd,

             reference_charc.ChangeRecordRefObjectUUID,
             @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
             reference_charc.ChangeRecordItemProcgStatus,
             @ObjectModel.readOnly: true
             reference_charc.ChgRecdCurrentItemProcgStatus,
             @ObjectModel.readOnly: true
             reference_charc.ChgRecdItmTgtSts,
             @ObjectModel.readOnly: true
             reference_charc.ChgRecdItmDSgntr,
             @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
             _ChangeRecordTP
             //             _ClassTypeText


}
where
  reference_charc.ChangeRecordReferenceType = 'CHR'