P_DOCUMENTINFORECORDOBJECTLINK

CDS View

P_DOCUMENTINFORECORDOBJECTLINK is a CDS View in S/4HANA. It contains 22 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 22 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DocumentInfoRecordObjectLink view from BASIC Document Info Record Object Link

Fields (22)

KeyField CDS FieldsUsed in Views
KEY DocObjectLinkCounter DocObjectLinkCounter 1
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber 1
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart 1
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType 1
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion 1
KEY LinkedSAPObject LinkedSAPObject 1
KEY LinkedSAPObjectKey LinkedSAPObjectKey 1
ChangedDateTime ChangedDateTime 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DocInfoRecdAdditionalObjectKey DocInfoRecdAdditionalObjectKey 1
DocInfoRecdConfignMgmtFixed DocInfoRecdConfignMgmtFixed 1
DocInfoRecdIsMarkedForDeletion DocInfoRecdIsMarkedForDeletion 1
DocInfoRecdLinkStatus DocInfoRecdLinkStatus 1
DocInfoRecdLongTextUUID DocInfoRecdLongTextUUID 1
DocInfoRecdObjectLinkStatus DocInfoRecdObjectLinkStatus 1
DocLinkDirectionIsActive DocLinkDirectionIsActive 1
IsArchived IsArchived 1
IsDefaultDocument IsDefaultDocument 1
IsDocInfoRecdCreatedFromCAD IsDocInfoRecdCreatedFromCAD 1
LastChangedByUser LastChangedByUser 1
ObjectTypeDatabaseTable ObjectTypeDatabaseTable 1 
@AbapCatalog.sqlViewName: 'PCVDOCOBJLINK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_DocumentInfoRecordObjectLink
  as select from    drad             as obj_links
    left outer join drad_last_change as LastChange on  obj_links.dokar = LastChange.dokar
                                                   and obj_links.doknr = LastChange.doknr
                                                   and obj_links.dokvr = LastChange.dokvr
                                                   and obj_links.doktl = LastChange.doktl
                                                   and obj_links.dokob = LastChange.dokob
                                                   and obj_links.objky = LastChange.objky

{
      /*  Document Info Record key Details */
  key obj_links.dokar       as  DocumentInfoRecordDocType,
  key obj_links.doknr       as  DocumentInfoRecordDocNumber,
  key obj_links.dokvr       as  DocumentInfoRecordDocVersion,
  key obj_links.doktl       as  DocumentInfoRecordDocPart,

      /*  Object Type and Object Key Details */
  key obj_links.dokob       as  LinkedSAPObject,
  key obj_links.objky       as  LinkedSAPObjectKey,
  key obj_links.obzae       as  DocObjectLinkCounter,

     /* DIR Administrative Data */
      //@Semantics.businessDate.at: true

      //@Semantics.businessDate.createdAt: true

      //@Semantics.systemDateTime.createdAt: true

      LastChange.created_at as  CreationDateTime,

      @Semantics.user.createdBy: true
      LastChange.created_by as  CreatedByUser,

      //@Semantics.businessDate.at: true

      //@Semantics.businessDate.lastChangedAt: true

      //@Semantics.systemDateTime.lastChangedAt: true

      LastChange.changed_at as  ChangedDateTime,

      @Semantics.user.lastChangedBy: true
      LastChange.changed_by as  LastChangedByUser,
      
      obj_links.vrkstat     as  DocInfoRecdLinkStatus,
      obj_links.vrkstat1    as  DocInfoRecdObjectLinkStatus,
      obj_links.vobj        as  ObjectTypeDatabaseTable,
      obj_links.vkey        as  DocInfoRecdAdditionalObjectKey,
      obj_links.vdir        as  DocLinkDirectionIsActive,
      obj_links.viewflag    as  IsDefaultDocument,
      obj_links.delflag     as  DocInfoRecdIsMarkedForDeletion,
      obj_links.longtext_id as  DocInfoRecdLongTextUUID,
      obj_links.cad_pos     as  IsDocInfoRecdCreatedFromCAD,
      obj_links.cm_fixed    as  DocInfoRecdConfignMgmtFixed,
      obj_links.archflag    as  IsArchived
      //obj_links.cm_fixed    as  DocInfoRecdConfignMgmtIsFixed


 


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DRAD",
"DRAD_LAST_CHANGE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More