I_DocumentInfoRecordObjLinkTP

@AbapCatalog.sqlViewName: 'ICVDOCOBJLINKTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
-- VDM Releated Annotations
@VDM.viewType: #TRANSACTIONAL
//@Search.searchable: true

--BOPF Releated Annotations
//@ObjectModel.transactionalProcessingEnabled: true // All views included in this CDS Views are automatically included in BOPF

//@ObjectModel.draftEnabled:  true

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true 
@ObjectModel.deleteEnabled: true       
@ObjectModel.writeDraftPersistence: 'DRAD_DRAFT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Object Link Transactional View'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
  
define view I_DocumentInfoRecordObjLinkTP as select from I_DocumentInfoRecordObjectLink as Doc_ObjLink

  association [1..1] to I_DocumentInfoRecordTP as _DocumentInfoRecord on  $projection.DocumentInfoRecordDocType    = _DocumentInfoRecord.DocumentInfoRecordDocType
                                                                      and $projection.DocumentInfoRecordDocNumber  = _DocumentInfoRecord.DocumentInfoRecordDocNumber
                                                                      and $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecord.DocumentInfoRecordDocVersion
                                                                      and $projection.DocumentInfoRecordDocPart    = _DocumentInfoRecord.DocumentInfoRecordDocPart
 
 --Get DocumentInfoRecord created user full name 
  association [1..1] to I_DocumentInfoRecordUserVH   as _CreatedUser   on  $projection.DocumentInfoRecordDocType    = _CreatedUser.DocumentInfoRecordDocType
                                                                       and $projection.DocumentInfoRecordDocPart    = _CreatedUser.DocumentInfoRecordDocPart
                                                                       and $projection.DocumentInfoRecordDocNumber  = _CreatedUser.DocumentInfoRecordDocNumber
                                                                       and $projection.DocumentInfoRecordDocVersion = _CreatedUser.DocumentInfoRecordDocVersion
                                                                       and $projection.CreatedByUser                = _CreatedUser.ResponsiblePersonName
                          
  --Get DocumentInfoRecord changed user full name
  association [1..1] to I_DocumentInfoRecordUserVH   as _ChangedUser   on  $projection.DocumentInfoRecordDocType    = _ChangedUser.DocumentInfoRecordDocType
                                                                       and $projection.DocumentInfoRecordDocPart    = _ChangedUser.DocumentInfoRecordDocPart
                                                                       and $projection.DocumentInfoRecordDocNumber  = _ChangedUser.DocumentInfoRecordDocNumber
                                                                       and $projection.DocumentInfoRecordDocVersion = _ChangedUser.DocumentInfoRecordDocVersion
                                                                       and $projection.LastChangedByUser            = _ChangedUser.LastChangedByUser

  {
  
      /*  Document Info Record  key Details */
      @ObjectModel.mandatory:true
  key Doc_ObjLink.DocumentInfoRecordDocType      as DocumentInfoRecordDocType,
      @ObjectModel.mandatory:true
  key Doc_ObjLink.DocumentInfoRecordDocNumber    as DocumentInfoRecordDocNumber,
      @ObjectModel.mandatory:true  
  key Doc_ObjLink.DocumentInfoRecordDocVersion   as DocumentInfoRecordDocVersion,
      @ObjectModel.mandatory:true  
  key Doc_ObjLink.DocumentInfoRecordDocPart      as DocumentInfoRecordDocPart,
      /*  Object Type and Object Key Details */
      @ObjectModel.mandatory:true
  key Doc_ObjLink.LinkedSAPObject                as LinkedSAPObject,
      @ObjectModel.mandatory:true
  key Doc_ObjLink.LinkedSAPObjectKey             as LinkedSAPObjectKey,
      @ObjectModel.mandatory:true
  key Doc_ObjLink.DocObjectLinkCounter           as DocObjectLinkCounter,
           
     // @Semantics.systemDateTime.createdAt: true

      //@Semantics.businessDate.at: true      

      //@Semantics.businessDate.createdAt: true

      Doc_ObjLink.CreationDateTime               as CreationDateTime,
                
      @Semantics.user.createdBy: true
      Doc_ObjLink.CreatedByUser                  as CreatedByUser,     
 
     // @Semantics.systemDate.lastChangedAt: true

      //@Semantics.businessDate.at: true

      //@Semantics.businessDate.lastChangedAt: true

      Doc_ObjLink.ChangedDateTime                as ChangedDateTime,

      @Semantics.user.lastChangedBy: true      
      Doc_ObjLink.LastChangedByUser              as LastChangedByUser,   
      
      Doc_ObjLink.DocInfoRecdAdditionalObjectKey as DocInfoRecdAdditionalObjectKey,
      Doc_ObjLink.DocInfoRecdConfignMgmtFixed    as DocInfoRecdConfignMgmtFixed, 
      
      //Doc_ObjLink.DocInfoRecdConfignMgmtIsFixed    as DocInfoRecdConfignMgmtIsFixed, 

      
      
            
      Doc_ObjLink.DocInfoRecdIsMarkedForDeletion as DocInfoRecdIsMarkedForDeletion,
      
      Doc_ObjLink.DocInfoRecdLinkStatus          as DocInfoRecdLinkStatus,  
      
      Doc_ObjLink.DocInfoRecdLongTextUUID        as DocInfoRecdLongTextUUID,  //??

      Doc_ObjLink.DocInfoRecdObjectLinkStatus    as DocInfoRecdObjectLinkStatus, 
      Doc_ObjLink.DocLinkDirectionIsActive       as DocLinkDirectionIsActive,      
      Doc_ObjLink.IsDocInfoRecdCreatedFromCAD    as IsDocInfoRecdCreatedFromCAD,
      
      Doc_ObjLink.IsDefaultDocument              as IsDefaultDocument,
      Doc_ObjLink.ObjectTypeDatabaseTable        as ObjectTypeDatabaseTable,
      Doc_ObjLink.IsArchived                     as IsArchived,
                        
      _CreatedUser,
      _ChangedUser,
      @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _DocumentInfoRecord
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORDOBJECTLINK"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORDTP",
"I_DOCUMENTINFORECORDUSERVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/