Deprecated NONE
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_DocInfoRecdObjectLink

DDL: C_DOCINFORECDOBJECTLINK SQL: CCVDOCOBJLNK Type: view CONSUMPTION
9 Fields 1 Data Sources 2 Associations

Document Info Record Object Link Details

C_DocInfoRecdObjectLink is a Consumption CDS View that provides data about "Document Info Record Object Link Details" in SAP S/4HANA. It reads from 1 data source (I_DocInfoRecdObjectLinkCount) and exposes 9 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart, LinkedSAPObject. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DocInfoRecdObjectLinkCount ObjLink from

Associations (2)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCVDOCOBJLNK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document Info Record Object Link Details view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #NONE view
VDM.lifecycle.status #DEPRECATED view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DocumentType I_DocInfoRecdObjectLinkCount DocumentType Order Type
KEY DocumentInfoRecord I_DocInfoRecdObjectLinkCount DocumentInfoRecord Document
KEY DocumentVersion I_DocInfoRecdObjectLinkCount DocumentVersion Docu. Version
KEY DocumentPart I_DocInfoRecdObjectLinkCount DocumentPart Document Part
KEY LinkedSAPObject I_DocInfoRecdObjectLinkCount LinkedSAPObject Object
ObjectLinkCount I_DocInfoRecdObjectLinkCount ObjectLinkCount Object Link Count
ObjectDescription
Associations_ObjectTypeDesc
_ObjectLink _ObjectLink

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_DocInfoRecdObjectLink.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCVDOCOBJLNK

CREATE VIEW C_DocInfoRecdObjectLink AS
SELECT
  ObjLink.DocumentType AS DocumentType,
  ObjLink.DocumentInfoRecord AS DocumentInfoRecord,
  ObjLink.DocumentVersion AS DocumentVersion,
  ObjLink.DocumentPart AS DocumentPart,
  ObjLink.LinkedSAPObject AS LinkedSAPObject,
  ObjLink.ObjectLinkCount AS ObjectLinkCount,
  _ObjectTypeDesc[1:Language = $session.system_language].ObjectDescription AS ObjectDescription
FROM I_DocInfoRecdObjectLinkCount AS ObjLink
LEFT OUTER JOIN I_DocInfoRecdObjectLinkText AS _ObjectTypeDesc ON LinkedSAPObject = _ObjectTypeDesc.LinkedSAPObject  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecdObjectLink AS _ObjectLink ON DocumentType = _ObjectLink.DocumentType AND DocumentPart = _ObjectLink.DocumentPart AND DocumentInfoRecord = _ObjectLink.DocumentInfoRecord AND DocumentVersion = _ObjectLink.DocumentVersion AND LinkedSAPObject = _ObjectLink.LinkedSAPObject  -- association [0..*]
;

Learn More