R_DocumentInfoRecordRelationTP

DDL: R_DOCUMENTINFORECORDRELATIONTP Type: view_entity TRANSACTIONAL
27 Fields 1 Data Sources 1 Associations

Document Info Record Relation - TP

R_DocumentInfoRecordRelationTP is a Transactional CDS View that provides data about "Document Info Record Relation - TP" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecordRelation) and exposes 27 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, LinkedSAPObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecordRelation I_DocumentInfoRecordRelation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_DocumentInfoRecordTP _DocInfoRecord $projection.DocInfoRecdDocNumberForEdit = _DocInfoRecord.DocumentInfoRecordDocNumber and $projection.DocInfoRecdDocPartForEdit = _DocInfoRecord.DocumentInfoRecordDocPart and $projection.DocInfoRecdDocVersionForEdit = _DocInfoRecord.DocumentInfoRecordDocVersion and $projection.DocInfoRecdDocTypeForEdit = _DocInfoRecord.DocumentInfoRecordDocType

Annotations (8)

NameValueLevelField
ObjectModel.sapObjectNodeType.name DocumentInfoRecordRelation view
EndUserText.label Document Info Record Relation - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart Document Part
KEY LinkedSAPObject LinkedSAPObject Object
KEY LinkedSAPObjectKey LinkedSAPObjectKey SAP Object Key
KEY DocObjectLinkCounter DocObjectLinkCounter Obj.Ctr
DocInfoRecdDocNumberForEdit Document
DocInfoRecdDocTypeForEdit Document Type
DocInfoRecdDocVersionForEdit Doc. Version
DocInfoRecdDocPartForEdit Document Part
DocInfoRecdLinkStatus DocInfoRecdLinkStatus Link status
DocInfoRecdObjectLinkStatus DocInfoRecdObjectLinkStatus Object link status
ObjectTypeDatabaseTable ObjectTypeDatabaseTable Table
DocInfoRecdAdditionalObjectKey DocInfoRecdAdditionalObjectKey Object Key
DocLinkDirectionIsActive DocLinkDirectionIsActive Active
IsDefaultDocument IsDefaultDocument View indocator
DocInfoRecdIsMarkedForDeletion DocInfoRecdIsMarkedForDeletion Deletion ind.
DocInfoRecdLongTextUUID UUID
IsDocInfoRecdCreatedFromCAD IsDocInfoRecdCreatedFromCAD CAD Indicator
DocInfoRecdConfignMgmtFixed DocInfoRecdConfignMgmtFixed Fixed
IsArchived IsArchived Archiving
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
ChangedDateTime ChangedDateTime Time Stamp
LastChangedByUser LastChangedByUser User Name
_DocInfoRecord _DocInfoRecord

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 R_DocumentInfoRecordRelationTP.
-- 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.

CREATE VIEW R_DocumentInfoRecordRelationTP AS
SELECT
  DocumentInfoRecordDocType,
  DocumentInfoRecordDocNumber,
  DocumentInfoRecordDocVersion,
  DocumentInfoRecordDocPart,
  LinkedSAPObject,
  LinkedSAPObjectKey,
  DocObjectLinkCounter,
  cast (DocumentInfoRecordDocNumber as doknr preserving type ) AS DocInfoRecdDocNumberForEdit,
  cast (DocumentInfoRecordDocType as dokar preserving type ) AS DocInfoRecdDocTypeForEdit,
  cast (DocumentInfoRecordDocVersion as dokvr preserving type) AS DocInfoRecdDocVersionForEdit,
  cast (DocumentInfoRecordDocPart as doktl_d preserving type) AS DocInfoRecdDocPartForEdit,
  DocInfoRecdLinkStatus,
  DocInfoRecdObjectLinkStatus,
  ObjectTypeDatabaseTable,
  DocInfoRecdAdditionalObjectKey,
  DocLinkDirectionIsActive,
  IsDefaultDocument,
  DocInfoRecdIsMarkedForDeletion,
  cast ( DocInfoRecdLongTextUUID as sysuuid_c preserving type ) AS DocInfoRecdLongTextUUID,
  IsDocInfoRecdCreatedFromCAD,
  DocInfoRecdConfignMgmtFixed,
  IsArchived,
  CreationDateTime,
  CreatedByUser,
  ChangedDateTime,
  LastChangedByUser
FROM I_DocumentInfoRecordRelation
LEFT OUTER JOIN R_DocumentInfoRecordTP AS _DocInfoRecord ON DocInfoRecdDocNumberForEdit = _DocInfoRecord.DocumentInfoRecordDocNumber AND DocInfoRecdDocPartForEdit = _DocInfoRecord.DocumentInfoRecordDocPart AND DocInfoRecdDocVersionForEdit = _DocInfoRecord.DocumentInfoRecordDocVersion AND DocInfoRecdDocTypeForEdit = _DocInfoRecord.DocumentInfoRecordDocType  -- association [1..1]
;

Learn More