Deprecated SAP_INTERNAL_API
This CDS view is deprecated in S/4HANA. Use I_DocumentInfoRecordAttachment instead. View all deprecated CDS views →

I_DocInfoRecdOriginal

DDL: I_DOCINFORECDORIGINAL SQL: ICVDOCUORIGINAL Type: view BASIC
34 Fields 1 Data Sources 7 Associations

Document Original Details

I_DocInfoRecdOriginal is a Basic CDS View (Dimension) that provides data about "Document Original Details" in SAP S/4HANA. It reads from 1 data source (P_DocInfoRecdOriginal) and exposes 34 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart, DocumentIndex. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_DocInfoRecdOriginal P_DocInfoRecdOriginal from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_DocInfoRecdDocumentType _DocumentType $projection.DocumentType = _DocumentType.DocumentType --Get Document Number
[1..1] I_DocInfoRecdNumber _DocumentNumber $projection.DocumentType = _DocumentNumber.DocumentType and $projection.DocumentInfoRecord = _DocumentNumber.DocumentInfoRecord --Get Document Version
[1..1] I_DocInfoRecdDocumentVersion _DocumentVersion $projection.DocumentType = _DocumentVersion.DocumentType and $projection.DocumentInfoRecord = _DocumentVersion.DocumentInfoRecord and $projection.DocumentVersion = _DocumentVersion.DocumentVersion --Get Document Part
[1..1] I_DocInfoRecdDocumentPart _DocumentPart $projection.DocumentType = _DocumentPart.DocumentType and $projection.DocumentPart = _DocumentPart.DocumentPart and $projection.DocumentInfoRecord = _DocumentPart.DocumentInfoRecord and $projection.DocumentVersion = _DocumentPart.DocumentVersion --
[1..1] I_DocumentInfoRecordUserVH _CreatedUser $projection.DocumentType = _CreatedUser.DocumentInfoRecordDocType and $projection.DocumentPart = _CreatedUser.DocumentInfoRecordDocPart and $projection.DocumentInfoRecord = _CreatedUser.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _CreatedUser.DocumentInfoRecordDocVersion and $projection.CreatedByUser = _CreatedUser.ResponsiblePersonName --Get DocumentInfoRecord changed user full name
[1..1] I_DocumentInfoRecordUserVH _ChangedUser $projection.DocumentType = _ChangedUser.DocumentInfoRecordDocType and $projection.DocumentPart = _ChangedUser.DocumentInfoRecordDocPart and $projection.DocumentInfoRecord = _ChangedUser.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _ChangedUser.DocumentInfoRecordDocVersion and $projection.LastChangedByUser = _ChangedUser.LastChangedByUser --Get original checkedout user full name
[1..1] I_DocumentInfoRecordUserVH _CheckedOutUser $projection.DocumentType = _CheckedOutUser.DocumentInfoRecordDocType and $projection.DocumentPart = _CheckedOutUser.DocumentInfoRecordDocPart and $projection.DocumentInfoRecord = _CheckedOutUser.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _CheckedOutUser.DocumentInfoRecordDocVersion and $projection.OriginalCheckedOutUser = _CheckedOutUser.ResponsiblePersonName

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCUORIGINAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Document Original Details view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_DocumentInfoRecordAttachment view
Metadata.ignorePropagatedAnnotations true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY DocumentType P_DocInfoRecdOriginal DocumentType Order Type
KEY DocumentInfoRecord P_DocInfoRecdOriginal DocumentInfoRecord Document
KEY DocumentVersion P_DocInfoRecdOriginal DocumentVersion Docu. Version
KEY DocumentPart P_DocInfoRecdOriginal DocumentPart Document Part
KEY DocumentIndex P_DocInfoRecdOriginal DocumentIndex Counter
FileName P_DocInfoRecdOriginal FileName URL or Filenam Path
FileUUID P_DocInfoRecdOriginal FileUUID UUID
WorkstationApplication P_DocInfoRecdOriginal WorkstationApplication Applic.
FileSize P_DocInfoRecdOriginal FileSize Safety Data Sheet File Size
StorageCategory P_DocInfoRecdOriginal StorageCategory Category
IsOriginalVersionActive P_DocInfoRecdOriginal IsOriginalVersionActive Applic.
OriginalType P_DocInfoRecdOriginal OriginalType Original type
LogicalDocument P_DocInfoRecdOriginal LogicalDocument Log. document
LogicalDocumentIsReference P_DocInfoRecdOriginal LogicalDocumentIsReference Flag
LogicalDocumentClass P_DocInfoRecdOriginal LogicalDocumentClass LOIO class
PhysicalDocTechnicalStatus P_DocInfoRecdOriginal PhysicalDocTechnicalStatus Tech. Status
DocumentTitle P_DocInfoRecdOriginal DocumentTitle Title
DocumentFormat P_DocInfoRecdOriginal DocumentFormat Document format
OriginalIsProtected P_DocInfoRecdOriginal OriginalIsProtected Flag
OriginalCheckedOutUser P_DocInfoRecdOriginal OriginalCheckedOutUser Agent
OriginalCheckedOutTime P_DocInfoRecdOriginal OriginalCheckedOutTime Time Stamp
InternalComment P_DocInfoRecdOriginal InternalComment Comment
CreationDateTime P_DocInfoRecdOriginal CreationDateTime Timestamp
CreatedByUser P_DocInfoRecdOriginal CreatedByUser User Name
ChangedDateTime P_DocInfoRecdOriginal ChangedDateTime Time Stamp
LastChangedByUser P_DocInfoRecdOriginal LastChangedByUser User Name
PhysicalDocument P_DocInfoRecdOriginal PhysicalDocument Phys. Document
Associations_DocumentType
_DocumentNumber _DocumentNumber
_DocumentVersion _DocumentVersion
_DocumentPart _DocumentPart
_CreatedUser _CreatedUser
_ChangedUser _ChangedUser
_CheckedOutUser _CheckedOutUser

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 I_DocInfoRecdOriginal.
-- 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: ICVDOCUORIGINAL

CREATE VIEW I_DocInfoRecdOriginal AS
SELECT
  P_DocInfoRecdOriginal.DocumentType AS DocumentType,
  P_DocInfoRecdOriginal.DocumentInfoRecord AS DocumentInfoRecord,
  P_DocInfoRecdOriginal.DocumentVersion AS DocumentVersion,
  P_DocInfoRecdOriginal.DocumentPart AS DocumentPart,
  P_DocInfoRecdOriginal.DocumentIndex AS DocumentIndex,
  P_DocInfoRecdOriginal.FileName AS FileName,
  P_DocInfoRecdOriginal.FileUUID AS FileUUID,
  P_DocInfoRecdOriginal.WorkstationApplication AS WorkstationApplication,
  P_DocInfoRecdOriginal.FileSize AS FileSize,
  P_DocInfoRecdOriginal.StorageCategory AS StorageCategory,
  P_DocInfoRecdOriginal.IsOriginalVersionActive AS IsOriginalVersionActive,
  P_DocInfoRecdOriginal.OriginalType AS OriginalType,
  P_DocInfoRecdOriginal.LogicalDocument AS LogicalDocument,
  P_DocInfoRecdOriginal.LogicalDocumentIsReference AS LogicalDocumentIsReference,
  P_DocInfoRecdOriginal.LogicalDocumentClass AS LogicalDocumentClass,
  P_DocInfoRecdOriginal.PhysicalDocTechnicalStatus AS PhysicalDocTechnicalStatus,
  P_DocInfoRecdOriginal.DocumentTitle AS DocumentTitle,
  P_DocInfoRecdOriginal.DocumentFormat AS DocumentFormat,
  P_DocInfoRecdOriginal.OriginalIsProtected AS OriginalIsProtected,
  P_DocInfoRecdOriginal.OriginalCheckedOutUser AS OriginalCheckedOutUser,
  P_DocInfoRecdOriginal.OriginalCheckedOutTime AS OriginalCheckedOutTime,
  P_DocInfoRecdOriginal.InternalComment AS InternalComment,
  P_DocInfoRecdOriginal.CreationDateTime AS CreationDateTime,
  P_DocInfoRecdOriginal.CreatedByUser AS CreatedByUser,
  P_DocInfoRecdOriginal.ChangedDateTime AS ChangedDateTime,
  P_DocInfoRecdOriginal.LastChangedByUser AS LastChangedByUser,
  P_DocInfoRecdOriginal.PhysicalDocument AS PhysicalDocument
FROM P_DocInfoRecdOriginal
LEFT OUTER JOIN I_DocInfoRecdDocumentType AS _DocumentType ON DocumentType = _DocumentType.DocumentType  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdNumber AS _DocumentNumber ON DocumentType = _DocumentNumber.DocumentType AND DocumentInfoRecord = _DocumentNumber.DocumentInfoRecord  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentVersion AS _DocumentVersion ON DocumentType = _DocumentVersion.DocumentType AND DocumentInfoRecord = _DocumentVersion.DocumentInfoRecord AND DocumentVersion = _DocumentVersion.DocumentVersion  -- association [1..1]
LEFT OUTER JOIN I_DocInfoRecdDocumentPart AS _DocumentPart ON DocumentType = _DocumentPart.DocumentType AND DocumentPart = _DocumentPart.DocumentPart AND DocumentInfoRecord = _DocumentPart.DocumentInfoRecord AND DocumentVersion = _DocumentPart.DocumentVersion  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _CreatedUser ON DocumentType = _CreatedUser.DocumentInfoRecordDocType AND DocumentPart = _CreatedUser.DocumentInfoRecordDocPart AND DocumentInfoRecord = _CreatedUser.DocumentInfoRecordDocNumber AND DocumentVersion = _CreatedUser.DocumentInfoRecordDocVersion AND CreatedByUser = _CreatedUser.ResponsiblePersonName  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _ChangedUser ON DocumentType = _ChangedUser.DocumentInfoRecordDocType AND DocumentPart = _ChangedUser.DocumentInfoRecordDocPart AND DocumentInfoRecord = _ChangedUser.DocumentInfoRecordDocNumber AND DocumentVersion = _ChangedUser.DocumentInfoRecordDocVersion AND LastChangedByUser = _ChangedUser.LastChangedByUser  -- association [1..1]
LEFT OUTER JOIN I_DocumentInfoRecordUserVH AS _CheckedOutUser ON DocumentType = _CheckedOutUser.DocumentInfoRecordDocType AND DocumentPart = _CheckedOutUser.DocumentInfoRecordDocPart AND DocumentInfoRecord = _CheckedOutUser.DocumentInfoRecordDocNumber AND DocumentVersion = _CheckedOutUser.DocumentInfoRecordDocVersion AND OriginalCheckedOutUser = _CheckedOutUser.ResponsiblePersonName  -- association [1..1]
;

Learn More