I_ChgRecdRefProdStrucVarTP

@AbapCatalog.sqlViewName: 'ICHGRECREFPSVTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@EndUserText.label: 'Change Record Obj Ref Product Struc Var'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.transactionalProcessingEnabled: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
  semanticKey: ['ProductStructureNodeName','Class','ProductStructureVariantName','ProdStrucVariantChangeNumber'],
                writeDraftPersistence: 'PLMCRREFPSV_D',
                createEnabled,
                deleteEnabled,
                updateEnabled
              }
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view I_ChgRecdRefProdStrucVarTP
  as select from           I_ChgRecdRefProdStrucVarBsc   as reference_psm
    left outer to one join I_ProductStructureVariantNode as _variant on  reference_psm.ChgRecRefInternalKey1  = _variant.ProductStructureVariantName
                                                                     and reference_psm.ChgRecRefInternalKey2  = _variant.ProductStructureNodeName
                                                                     and (
                                                                        reference_psm.ChgRecRefInternalKey3   = _variant.Class
                                                                        or(
                                                                          reference_psm.ChgRecRefInternalKey3 = ''
                                                                          and _variant.Class                  is null
                                                                        )
                                                                      )
                                                                     and reference_psm.ChgRecRefInternalKey4  = _variant.ProdStrucVariantChangeNumber
//  association [1..1] to I_ChangeRecordDraftTP as _ChangeRecord on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

{
  key ChangeRecordReferenceUUID,
      case
        when _variant.ProductStructureNodeName is null then cast(substring( reference_psm.ChangeRecordReference, 1, 40) as pvs_pnode)
        else cast(_variant.ProductStructureNodeName  as pvs_pnode)
        end as ProductStructureNodeName,


      case
       when _variant.Class is null then  cast(substring( reference_psm.ChangeRecordReference, 41, 18) as klasse_d)
       else cast(_variant.Class as klasse_d)
       end  as Class,

      case
       when _variant.ProductStructureVariantName is null then cast (substring( reference_psm.ChangeRecordReference, 59, 8) as pvs_posvar)
       else cast(_variant.ProductStructureVariantName as pvs_posvar)
       end  as ProductStructureVariantName,
      case
       when _variant.ProdStrucVariantChangeNumber is null then cast (substring( reference_psm.ChangeRecordReference, 67, 12) as pvs_aennr)
       else cast(_variant.ProdStrucVariantChangeNumber as pvs_aennr)
       end  as ProdStrucVariantChangeNumber,
      _variant.ProdStrucNodeDescription,
      _variant.ProdStrucVariantDescription,
      _variant.Material,
      _variant.ProductStructureNodeType,
      ChangeRecordUUID,
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordReference,
      ParentChangeRecordRefUUID,
      IsMainReference,
      @Semantics.user.createdBy: true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      LastChangeDateTime,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      ChangeRecordItemRelevance,
      ChangeRecordVirtualRefInd,
      ChangeRecordRefObjectUUID,
      ChangeRecordItemProcgStatus,
      ChgRecdItmTgtSts,
      ChgRecdItmDSgntr,
      ChgRecdCurrentItemProcgStatus,
      reference_psm.ChgRecdReasonForChange,
      reference_psm.ExpdCompltnDte,
      reference_psm.ChgRecdAuthznGrpText,
      reference_psm.ChgRecdNmbrChgSts,
      reference_psm.ChangeNumber
      //      Customer,

//      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]

//      _ChangeRecord


};