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

I_DocInfoRecdOrigChkOutUser

DDL: I_DOCINFORECDORIGCHKOUTUSER SQL: ICVDOCORIGSTACHK Type: view COMPOSITE
11 Fields 1 Data Sources 2 Associations

Originals Checked Out User Details

I_DocInfoRecdOrigChkOutUser is a Composite CDS View that provides data about "Originals Checked Out User Details" in SAP S/4HANA. It reads from 1 data source (I_DocInfoRecd) and exposes 11 fields with key fields DocumentType, DocumentVersion, DocumentPart, DocumentInfoRecord. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DocInfoRecd Doc_Header from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_DocInfoRecdOriginal _Original $projection.DocumentType = _Original.DocumentType and $projection.DocumentInfoRecord = _Original.DocumentInfoRecord and $projection.DocumentVersion = _Original.DocumentVersion and $projection.DocumentPart = _Original.DocumentPart -- DIR Description
[0..1] I_DocInfoRecdDescription _DocumentDescription $projection.DocumentPart = _DocumentDescription.DocumentPart and $projection.DocumentType = _DocumentDescription.DocumentType and $projection.DocumentVersion = _DocumentDescription.DocumentVersion and $projection.DocumentInfoRecord = _DocumentDescription.DocumentInfoRecord

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCORIGSTACHK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Originals Checked Out User Details view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.lifecycle.status #DEPRECATED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY DocumentType I_DocInfoRecd DocumentType Order Type
KEY DocumentVersion I_DocInfoRecd DocumentVersion Docu. Version
KEY DocumentPart I_DocInfoRecd DocumentPart Document Part
KEY DocumentInfoRecord I_DocInfoRecd DocumentInfoRecord Document
DocumentDescription
InternalDocumentStatus I_DocInfoRecd InternalDocumentStatus Status
FileName _Original FileName URL or Filenam Path
WorkstationApplication _Original WorkstationApplication Applic.
StorageCategory _Original StorageCategory Category
_Original _Original
_DocumentDescription _DocumentDescription

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_DocInfoRecdOrigChkOutUser.
-- 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: ICVDOCORIGSTACHK

CREATE VIEW I_DocInfoRecdOrigChkOutUser AS
SELECT
  Doc_Header.DocumentType AS DocumentType,
  Doc_Header.DocumentVersion AS DocumentVersion,
  Doc_Header.DocumentPart AS DocumentPart,
  Doc_Header.DocumentInfoRecord AS DocumentInfoRecord,
  _DocumentDescription[1:Language = $session.system_language].DocumentDescription AS DocumentDescription,
  Doc_Header.InternalDocumentStatus AS InternalDocumentStatus,
  _Original.FileName AS FileName,
  _Original.WorkstationApplication AS WorkstationApplication,
  _Original.StorageCategory AS StorageCategory
FROM I_DocInfoRecd AS Doc_Header
LEFT OUTER JOIN I_DocInfoRecdOriginal AS _Original ON DocumentType = _Original.DocumentType AND DocumentInfoRecord = _Original.DocumentInfoRecord AND DocumentVersion = _Original.DocumentVersion AND DocumentPart = _Original.DocumentPart  -- association [0..1]
LEFT OUTER JOIN I_DocInfoRecdDescription AS _DocumentDescription ON DocumentPart = _DocumentDescription.DocumentPart AND DocumentType = _DocumentDescription.DocumentType AND DocumentVersion = _DocumentDescription.DocumentVersion AND DocumentInfoRecord = _DocumentDescription.DocumentInfoRecord  -- association [0..1]
;

Learn More