I_EngSnpshtObjRefTP

@AbapCatalog.sqlViewName: 'IENGSNPOBJREFTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Snapshot Object Reference for transactional'

@VDM.viewType: #TRANSACTIONAL

@ObjectModel: {
-- Annotations for transactional processing  
  transactionalProcessingEnabled: true,
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: true,
  writeActivePersistence: 'MPE_SNP_OBJREF_V'
  //semanticKey: ['ref_key1','ref_key2','ref_key3','ref_key4','ref_key5'],

}

@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
                         
define view I_EngSnpshtObjRefTP
 as select from mpe_snp_obj_ref as reference
 association [1..1] to I_EngSnpshtHdrTP as _EngSnpshtHdr  on $projection.EngSnapshotUUID = _EngSnpshtHdr.EngSnapshotUUID
 association [0..1] to E_EngSnpshtRefEngBOM  as _EngBOMExtension  on $projection.EngSnapshotRefUUID = _EngBOMExtension.EngSnapshotRefUUID
 association [0..1] to E_EngSnpshtRefDoc     as _DocExtension     on $projection.EngSnapshotRefUUID = _DocExtension.EngSnapshotRefUUID
 association [0..1] to E_EngSnpshtRefVislDoc as _VisualDocExtension on $projection.EngSnapshotRefUUID = _VisualDocExtension.EngSnapshotRefUUID     
{
  key reference.uuid as EngSnapshotRefUUID,
      reference.hdr_uuid as EngSnapshotUUID,                                
      reference.type as EngSnpshtRefType,
      reference.ref_key1 as EngSnpshtRefKey1,
      reference.ref_key2 as EngSnpshtRefKey2,
      reference.ref_key3 as EngSnpshtRefKey3,
      reference.ref_key4 as EngSnpshtRefKey4,
      reference.ref_key5 as EngSnpshtRefKey5,
      @Semantics.user.createdBy: true    
      reference.created_by as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      reference.created_at as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      reference.changed_by as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      reference.changed_at as LastChangeDateTime,
      
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _EngSnpshtHdr
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MPE_SNP_OBJ_REF"
],
"ASSOCIATED":
[
"E_ENGSNPSHTREFDOC",
"E_ENGSNPSHTREFENGBOM",
"E_ENGSNPSHTREFVISLDOC",
"I_ENGSNPSHTHDRTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/