P_DocumentInfoRecordObjectLink

DDL: P_DOCUMENTINFORECORDOBJECTLINK SQL: PCVDOCOBJLINK Type: view BASIC

P_DocumentInfoRecordObjectLink is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (drad_last_change, drad) and exposes 22 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, LinkedSAPObject.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
drad_last_change LastChange left_outer
drad obj_links from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCVDOCOBJLINK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType drad dokar
KEY DocumentInfoRecordDocNumber drad doknr
KEY DocumentInfoRecordDocVersion drad dokvr
KEY DocumentInfoRecordDocPart drad doktl
KEY LinkedSAPObject drad dokob
KEY LinkedSAPObjectKey drad objky
KEY DocObjectLinkCounter drad obzae
CreationDateTime drad_last_change created_at
CreatedByUser drad_last_change created_by
ChangedDateTime drad_last_change changed_at
LastChangedByUser drad_last_change changed_by
DocInfoRecdLinkStatus drad vrkstat
DocInfoRecdObjectLinkStatus drad vrkstat1
ObjectTypeDatabaseTable drad vobj
DocInfoRecdAdditionalObjectKey drad vkey
DocLinkDirectionIsActive drad vdir
IsDefaultDocument drad viewflag
DocInfoRecdIsMarkedForDeletion drad delflag
DocInfoRecdLongTextUUID drad longtext_id
IsDocInfoRecdCreatedFromCAD drad cad_pos
DocInfoRecdConfignMgmtFixed drad cm_fixed
IsArchived drad archflag 
@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


 


}

Learn More