I_DocInfoRecdObjectLinkCount

DDL: I_DOCINFORECDOBJECTLINKCOUNT SQL: ICVDOCOBJCNT Type: view BASIC Package: CV_VDM

Object Link Count

I_DocInfoRecdObjectLinkCount is a Basic CDS View that provides data about "Object Link Count" in SAP S/4HANA. It reads from 1 data source (drad) and exposes 8 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart, LinkedSAPObject. It has 2 associations to related views. Part of development package CV_VDM.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
drad obj_links from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_DocInfoRecdObjectLink _ObjectLink $projection.DocumentPart = _ObjectLink.DocumentPart and $projection.DocumentInfoRecord = _ObjectLink.DocumentInfoRecord and $projection.DocumentType = _ObjectLink.DocumentType and $projection.DocumentVersion = _ObjectLink.DocumentVersion and $projection.LinkedSAPObject = _ObjectLink.LinkedSAPObject
[0..*] I_DocInfoRecdObjectLinkText _ObjectTypeDesc $projection.LinkedSAPObject = _ObjectTypeDesc.LinkedSAPObject

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCOBJCNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Object Link Count view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_DocumentInfoRecordObjLinkCnt view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY DocumentType drad dokar
KEY DocumentInfoRecord drad doknr
KEY DocumentVersion drad dokvr
KEY DocumentPart drad doktl
KEY LinkedSAPObject drad dokob
ObjectLinkCount Object Link Count
_ObjectLink _ObjectLink
_ObjectTypeDesc _ObjectTypeDesc 
@AbapCatalog.sqlViewName: 'ICVDOCOBJCNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Object Link Count'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle: {
  contract: {
    type: #SAP_INTERNAL_API
  },
  status: #DEPRECATED,
  successor: 'I_DocumentInfoRecordObjLinkCnt'
}
@Metadata.ignorePropagatedAnnotations:true

define view I_DocInfoRecdObjectLinkCount
  as select from drad as obj_links

  association [0..*] to I_DocInfoRecdObjectLink     as _ObjectLink     on  $projection.DocumentPart       = _ObjectLink.DocumentPart
                                                                       and $projection.DocumentInfoRecord = _ObjectLink.DocumentInfoRecord
                                                                       and $projection.DocumentType       = _ObjectLink.DocumentType
                                                                       and $projection.DocumentVersion    = _ObjectLink.DocumentVersion
                                                                       and $projection.LinkedSAPObject    = _ObjectLink.LinkedSAPObject

  association [0..*] to I_DocInfoRecdObjectLinkText as _ObjectTypeDesc on  $projection.LinkedSAPObject = _ObjectTypeDesc.LinkedSAPObject

{

  key obj_links.dokar as  DocumentType,
  key obj_links.doknr as  DocumentInfoRecord,
  key obj_links.dokvr as  DocumentVersion,
  key obj_links.doktl as  DocumentPart,
  key obj_links.dokob as  LinkedSAPObject,
      @EndUserText.label:'Object Link Count'
      count(*)        as  ObjectLinkCount,
      
      /* Associations */
      _ObjectLink,
      _ObjectTypeDesc
}
group by
  dokar,
  doknr,
  dokvr,
  doktl,
  dokob

Learn More