I_DocumentInfoRecordSrchModel

DDL: I_DOCUMENTINFORECORDSRCHMODEL SQL: ICVDOCINFRCSRCHM Type: view COMPOSITE
40 Fields 1 Data Sources 8 Associations

Document Info Record ( ESH )

I_DocumentInfoRecordSrchModel is a Composite CDS View that provides data about "Document Info Record ( ESH )" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecord) and exposes 40 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecord I_DocumentInfoRecord from

Associations (8)

CardinalityTargetAliasCondition
[0..*] I_ClfnObjectClassForKeyDate _ClfnObjectClassForKeyDate $projection.DocumentInfoRecord = _ClfnObjectClassForKeyDate.ClfnObjectID and _ClfnObjectClassForKeyDate.ClfnObjectTable = 'DRAW'
[0..*] I_ClfnObjectCharcValForKeyDate _ClfnObjectCharcValForKeyDate $projection.DocumentInfoRecord = _ClfnObjectCharcValForKeyDate.ClfnObjectID and _ClfnObjectCharcValForKeyDate.ClfnObjectTable = 'DRAW'
[0..*] I_DocumentInfoRecordStsLog _DocumentInfoRecordStsLog $projection.DocumentInfoRecordDocType = _DocumentInfoRecordStsLog.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecordStsLog.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecordStsLog.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocumentInfoRecordStsLog.DocumentInfoRecordDocPart and $projection.InternalDocumentStatus = _DocumentInfoRecordStsLog.DocumentInfoRecordStsLog
[0..1] I_DocumentInfoRecordReserve _DocumentInfoRecordReserve $projection.DocumentInfoRecordDocType = _DocumentInfoRecordReserve.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecordReserve.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecordReserve.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocumentInfoRecordReserve.DocumentInfoRecordDocPart
[0..*] I_DocInfoRecdAttchCntntWthDesc _DocInfoRecdAttchCntntWthDesc $projection.DocumentInfoRecordDocType = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocPart
[0..*] I_DocInfoRecordObjLinkAddlInfo _DocInfoRecordObjLinkAddlInfo $projection.DocumentInfoRecordDocType = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocPart
[0..1] I_ChangeMaster _ChangeMaster $projection.ChangeNumber = _ChangeMaster.ChangeNumber
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICVDOCINFRCSRCHM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Document Info Record ( ESH ) view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart DocumentInfoRecordDocPart Document Part
Plant Plant Valuation Area
ChangeNumber ChangeNumber Change Number
DocumentInfoRecord DocumentInfoRecord Document
InternalDocumentStatus InternalDocumentStatus Status
ExternalDocumentStatus
DocumentStatusName
AuthorizationGroup AuthorizationGroup AuthorizGroup
LaboratoryOrDesignOffice LaboratoryOrDesignOffice Lab/Office
AuthorizationGroupName
IsDocInfoRecdCreatedFromCAD IsDocInfoRecdCreatedFromCAD CAD Indicator
CADStatusDescription
ChangedDateTime ChangedDateTime Time Stamp
ChangedBy LastChangedByUser User Name
LastChangedByUserDescription _ChangedUser UserDescription Full Name
CreationDate CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserDescription _CreatedUser UserDescription Full Name
DocumentTypeDescription
DocumentDescription
ResponsiblePersonName ResponsiblePersonName User
DocInfoRecdIsMarkedForDeletion DocInfoRecdIsMarkedForDeletion Deletion ind.
DeleteStatusDescription
UserDescription _UserDetails UserDescription Full Name
LaboratoryOrDesignOfficeName
LogAccMContext
_DocumentInfoRecordReserve _DocumentInfoRecordReserve
_DocumentInfoRecordStsLog _DocumentInfoRecordStsLog
_DocInfoRecdAttchCntntWthDesc _DocInfoRecdAttchCntntWthDesc
_DocInfoRecordObjLinkAddlInfo _DocInfoRecordObjLinkAddlInfo
_ClfnObjectClassForKeyDate _ClfnObjectClassForKeyDate
_ClfnObjectCharcValForKeyDate _ClfnObjectCharcValForKeyDate
_ChangeMaster _ChangeMaster
_Plant _Plant
_DocType _DocType
_DocNumber _DocNumber
_DocVersion _DocVersion

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_DocumentInfoRecordSrchModel.
-- 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: ICVDOCINFRCSRCHM

CREATE VIEW I_DocumentInfoRecordSrchModel AS
SELECT
  DocumentInfoRecordDocType,
  DocumentInfoRecordDocNumber,
  DocumentInfoRecordDocVersion,
  DocumentInfoRecordDocPart,
  Plant,
  ChangeNumber,
  DocumentInfoRecord,
  InternalDocumentStatus,
  _DocStatus._Text[ 1:Language = $session.system_language ].ExternalDocumentStatus AS ExternalDocumentStatus,
  _DocStatus._Text[ 1:Language = $session.system_language ].DocumentStatusName AS DocumentStatusName,
  AuthorizationGroup,
  LaboratoryOrDesignOffice,
  _AuthGroup._Text[ 1:Language = $session.system_language ].AuthorizationGroupName AS AuthorizationGroupName,
  IsDocInfoRecdCreatedFromCAD,
  _Indicator._Text._CadStatusText[ 1:Language = $session.system_language ].CADStatusDescription AS CADStatusDescription,
  ChangedDateTime,
  LastChangedByUser AS ChangedBy,
  _ChangedUser.UserDescription AS LastChangedByUserDescription,
  CreationDateTime AS CreationDate,
  CreatedByUser,
  _CreatedUser.UserDescription AS CreatedByUserDescription,
  _DocType._Text[ 1:Language = $session.system_language ].DocumentTypeDescription AS DocumentTypeDescription,
  _DocDesc[ 1:Language = $session.system_language ].DocumentDescription AS DocumentDescription,
  ResponsiblePersonName,
  DocInfoRecdIsMarkedForDeletion,
  _Indicator._Text._DeltnStatusText[ 1:Language = $session.system_language ].DeleteStatusDescription AS DeleteStatusDescription,
  _UserDetails.UserDescription AS UserDescription,
  _LabOffice._Text[ 1:Language = $session.system_language ].LaboratoryOrDesignOfficeName AS LaboratoryOrDesignOfficeName,
  _LogAccMObjSecureIDAssgmt_01._LogAccMSecureIDRepository._LogAccMContext.LogAccMContext AS LogAccMContext
FROM I_DocumentInfoRecord
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClfnObjectClassForKeyDate ON DocumentInfoRecord = _ClfnObjectClassForKeyDate.ClfnObjectID AND _ClfnObjectClassForKeyDate.ClfnObjectTable = 'DRAW'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _ClfnObjectCharcValForKeyDate ON DocumentInfoRecord = _ClfnObjectCharcValForKeyDate.ClfnObjectID AND _ClfnObjectCharcValForKeyDate.ClfnObjectTable = 'DRAW'  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordStsLog AS _DocumentInfoRecordStsLog ON DocumentInfoRecordDocType = _DocumentInfoRecordStsLog.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocumentInfoRecordStsLog.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocumentInfoRecordStsLog.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _DocumentInfoRecordStsLog.DocumentInfoRecordDocPart AND InternalDocumentStatus = _DocumentInfoRecordStsLog.DocumentInfoRecordStsLog  -- association [0..*]
LEFT OUTER JOIN I_DocumentInfoRecordReserve AS _DocumentInfoRecordReserve ON DocumentInfoRecordDocType = _DocumentInfoRecordReserve.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocumentInfoRecordReserve.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocumentInfoRecordReserve.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _DocumentInfoRecordReserve.DocumentInfoRecordDocPart  -- association [0..1]
LEFT OUTER JOIN I_DocInfoRecdAttchCntntWthDesc AS _DocInfoRecdAttchCntntWthDesc ON DocumentInfoRecordDocType = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _DocInfoRecdAttchCntntWthDesc.DocumentInfoRecordDocPart  -- association [0..*]
LEFT OUTER JOIN I_DocInfoRecordObjLinkAddlInfo AS _DocInfoRecordObjLinkAddlInfo ON DocumentInfoRecordDocType = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocType AND DocumentInfoRecordDocNumber = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocNumber AND DocumentInfoRecordDocVersion = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocVersion AND DocumentInfoRecordDocPart = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocPart  -- association [0..*]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;

Learn More