I_DocumentInfoRecordObjectLink

DDL: I_DOCUMENTINFORECORDOBJECTLINK SQL: ICVDOCOBJECTLINK Type: view BASIC Package: VDM_DMS

Document Info Record Object Link

I_DocumentInfoRecordObjectLink is a Basic CDS View that provides data about "Document Info Record Object Link" in SAP S/4HANA. It reads from 1 data source (P_DocumentInfoRecordObjectLink) and exposes 26 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, LinkedSAPObject. It has 4 associations to related views. Part of development package VDM_DMS.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
P_DocumentInfoRecordObjectLink ObjLink from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_DocumentInfoRecordObjLinkT _Text $projection.LinkedSAPObject = _Text.LinkedSAPObject --Get DocumentInfoRecord created user full name
[1..1] I_DocumentInfoRecordUserVH _CreatedUser $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
[1..1] I_DocumentInfoRecordUserVH _ChangedUser $projection.DocumentInfoRecordDocType = _ChangedUser.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _ChangedUser.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _ChangedUser.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _ChangedUser.DocumentInfoRecordDocVersion and $projection.LastChangedByUser = _ChangedUser.LastChangedByUser
[0..*] I_DocumentInfoRecordDesc _DocumentInfoRecordDesc $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecordDesc.DocumentInfoRecordDocNumber

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCOBJECTLINK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document Info Record Object Link view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType P_DocumentInfoRecordObjectLink DocumentInfoRecordDocType
KEY DocumentInfoRecordDocNumber P_DocumentInfoRecordObjectLink DocumentInfoRecordDocNumber
KEY DocumentInfoRecordDocVersion P_DocumentInfoRecordObjectLink DocumentInfoRecordDocVersion
KEY DocumentInfoRecordDocPart P_DocumentInfoRecordObjectLink DocumentInfoRecordDocPart
KEY LinkedSAPObject P_DocumentInfoRecordObjectLink LinkedSAPObject
KEY LinkedSAPObjectKey P_DocumentInfoRecordObjectLink LinkedSAPObjectKey
KEY DocObjectLinkCounter P_DocumentInfoRecordObjectLink DocObjectLinkCounter
CreationDateTime P_DocumentInfoRecordObjectLink CreationDateTime
CreatedByUser P_DocumentInfoRecordObjectLink CreatedByUser
ChangedDateTime P_DocumentInfoRecordObjectLink ChangedDateTime
LastChangedByUser P_DocumentInfoRecordObjectLink LastChangedByUser
DocInfoRecdLinkStatus P_DocumentInfoRecordObjectLink DocInfoRecdLinkStatus
DocInfoRecdObjectLinkStatus P_DocumentInfoRecordObjectLink DocInfoRecdObjectLinkStatus
ObjectTypeDatabaseTable P_DocumentInfoRecordObjectLink ObjectTypeDatabaseTable
DocInfoRecdAdditionalObjectKey P_DocumentInfoRecordObjectLink DocInfoRecdAdditionalObjectKey
DocLinkDirectionIsActive P_DocumentInfoRecordObjectLink DocLinkDirectionIsActive
IsDefaultDocument P_DocumentInfoRecordObjectLink IsDefaultDocument
DocInfoRecdIsMarkedForDeletion P_DocumentInfoRecordObjectLink DocInfoRecdIsMarkedForDeletion
DocInfoRecdLongTextUUID P_DocumentInfoRecordObjectLink DocInfoRecdLongTextUUID
IsDocInfoRecdCreatedFromCAD P_DocumentInfoRecordObjectLink IsDocInfoRecdCreatedFromCAD
DocInfoRecdConfignMgmtFixed P_DocumentInfoRecordObjectLink DocInfoRecdConfignMgmtFixed
IsArchived P_DocumentInfoRecordObjectLink IsArchived
_CreatedUser _CreatedUser
_ChangedUser _ChangedUser
_Text _Text
_DocumentInfoRecordDesc _DocumentInfoRecordDesc 
@AbapCatalog.sqlViewName: 'ICVDOCOBJECTLINK'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Document Info Record Object Link'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
//@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern: #NONE

define view I_DocumentInfoRecordObjectLink
  as select from P_DocumentInfoRecordObjectLink as ObjLink 

  --Get Linked object description
  association [0..*] to I_DocumentInfoRecordObjLinkT as _Text                   on  $projection.LinkedSAPObject = _Text.LinkedSAPObject
  
  --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
  association [0..*] to I_DocumentInfoRecordDesc     as _DocumentInfoRecordDesc on  $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecordDesc.DocumentInfoRecordDocNumber
{
      /*  Document Info Record key Details */
  key ObjLink.DocumentInfoRecordDocType      as DocumentInfoRecordDocType,
  key ObjLink.DocumentInfoRecordDocNumber    as DocumentInfoRecordDocNumber,
  key ObjLink.DocumentInfoRecordDocVersion   as DocumentInfoRecordDocVersion,
  key ObjLink.DocumentInfoRecordDocPart      as DocumentInfoRecordDocPart,

      /*  Object Type and Object Key Details */
  key ObjLink.LinkedSAPObject                as LinkedSAPObject,
  key ObjLink.LinkedSAPObjectKey             as LinkedSAPObjectKey,
  key ObjLink.DocObjectLinkCounter           as DocObjectLinkCounter,

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

      //@Semantics.businessDate.createdAt: true

      ObjLink.CreationDateTime               as CreationDateTime,

      @Consumption.valueHelpDefinition.association: '_CreatedUser'
      @Semantics.user.createdBy: true
      ObjLink.CreatedByUser                  as CreatedByUser,

      //@Semantics.businessDate.at: true

      //@Semantics.businessDate.lastChangedAt: true

      ObjLink.ChangedDateTime                as ChangedDateTime,

      @Consumption.valueHelpDefinition.association: '_ChangedUser'
      @Semantics.user.lastChangedBy: true
      ObjLink.LastChangedByUser              as LastChangedByUser,

      ObjLink.DocInfoRecdLinkStatus          as DocInfoRecdLinkStatus,
      ObjLink.DocInfoRecdObjectLinkStatus    as DocInfoRecdObjectLinkStatus,
      ObjLink.ObjectTypeDatabaseTable        as ObjectTypeDatabaseTable,
      ObjLink.DocInfoRecdAdditionalObjectKey as DocInfoRecdAdditionalObjectKey,
      @Semantics.booleanIndicator: true
      ObjLink.DocLinkDirectionIsActive       as DocLinkDirectionIsActive,
      ObjLink.IsDefaultDocument              as IsDefaultDocument,
      @Semantics.booleanIndicator: true
      ObjLink.DocInfoRecdIsMarkedForDeletion as DocInfoRecdIsMarkedForDeletion,
      @Semantics.uuid: true
      ObjLink.DocInfoRecdLongTextUUID        as DocInfoRecdLongTextUUID,
      @Semantics.booleanIndicator: true
      ObjLink.IsDocInfoRecdCreatedFromCAD    as IsDocInfoRecdCreatedFromCAD,
      ObjLink.DocInfoRecdConfignMgmtFixed    as DocInfoRecdConfignMgmtFixed,
      //ObjLink.DocInfoRecdConfignMgmtIsFixed  as DocInfoRecdConfignMgmtIsFixed,

      ObjLink.IsArchived                     as IsArchived,
      
      //Associations

      _CreatedUser,
      _ChangedUser,
      _Text,
      _DocumentInfoRecordDesc
}

Learn More