Which tables does I_DocumentInfoRecordSrchModel use?

I_DocumentInfoRecordSrchModel reads from 1 data source(s): I_DocumentInfoRecord.

I_DocumentInfoRecordSrchModel

Q: How many fields does I_DocumentInfoRecordSrchModel have?

I_DocumentInfoRecordSrchModel has 40 fields. Key fields: DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart.

DDL: I_DOCUMENTINFORECORDSRCHMODEL SQL: ICVDOCINFRCSRCHM Type: view COMPOSITE Package: CV_VDM_ESH

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. Part of development package CV_VDM_ESH.

Data Sources (1)

Source	Alias	Join Type
I_DocumentInfoRecord	I_DocumentInfoRecord	from

Associations (8)

Cardinality	Target	Alias	Condition
[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_DocInfoRecordAttchsWithCntnt	_DocInfoRecordAttchsWithCntnt	`$projection.DocumentInfoRecordDocType = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocPart and _DocInfoRecordAttchsWithCntnt.Language = $session.system_language`
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
KEY	DocumentInfoRecordDocType		DocumentInfoRecordDocType
KEY	DocumentInfoRecordDocNumber		DocumentInfoRecordDocNumber
KEY	DocumentInfoRecordDocVersion		DocumentInfoRecordDocVersion
KEY	DocumentInfoRecordDocPart		DocumentInfoRecordDocPart
	Plant		Plant
	ChangeNumber		ChangeNumber
	DocumentInfoRecord		DocumentInfoRecord
	InternalDocumentStatus		InternalDocumentStatus
	ExternalDocumentStatus
	DocumentStatusName
	AuthorizationGroup		AuthorizationGroup
	LaboratoryOrDesignOffice		LaboratoryOrDesignOffice
	AuthorizationGroupName
	IsDocInfoRecdCreatedFromCAD		IsDocInfoRecdCreatedFromCAD
	CADStatusDescription
	ChangedDateTime		ChangedDateTime
	ChangedBy		LastChangedByUser
	LastChangedByUserDescription	_ChangedUser	UserDescription
	CreationDate		CreationDateTime
	CreatedByUser		CreatedByUser
	CreatedByUserDescription	_CreatedUser	UserDescription
	DocumentTypeDescription
	DocumentDescription
	ResponsiblePersonName		ResponsiblePersonName
	DocInfoRecdIsMarkedForDeletion		DocInfoRecdIsMarkedForDeletion
	DeleteStatusDescription
	UserDescription	_UserDetails	UserDescription
	LaboratoryOrDesignOfficeName
	LogAccMContext
	_DocumentInfoRecordReserve		_DocumentInfoRecordReserve
	_DocumentInfoRecordStsLog		_DocumentInfoRecordStsLog
	_DocInfoRecordAttchsWithCntnt		_DocInfoRecordAttchsWithCntnt
	_DocInfoRecordObjLinkAddlInfo		_DocInfoRecordObjLinkAddlInfo
	_ClfnObjectClassForKeyDate		_ClfnObjectClassForKeyDate
	_ClfnObjectCharcValForKeyDate		_ClfnObjectCharcValForKeyDate
	_ChangeMaster		_ChangeMaster
	_Plant		_Plant
	_DocType		_DocType
	_DocNumber		_DocNumber
	_DocVersion		_DocVersion

@AbapCatalog.sqlViewName: 'ICVDOCINFRCSRCHM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
//@AccessControl.privilegedAssociations: ['_TextObjectPlainLongTextDrat']

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED }
@EndUserText.label: 'Document Info Record ( ESH )'



define view I_DocumentInfoRecordSrchModel
  as select from I_DocumentInfoRecord

  association [0..*] to I_ClfnObjectClassForKeyDate    as _ClfnObjectClassForKeyDate    on  $projection.DocumentInfoRecord             = _ClfnObjectClassForKeyDate.ClfnObjectID
                                                                                        and _ClfnObjectClassForKeyDate.ClfnObjectTable = 'DRAW'

  association [0..*] to I_ClfnObjectCharcValForKeyDate as _ClfnObjectCharcValForKeyDate on  $projection.DocumentInfoRecord                = _ClfnObjectCharcValForKeyDate.ClfnObjectID
                                                                                        and _ClfnObjectCharcValForKeyDate.ClfnObjectTable = 'DRAW'
  /*
  Problem with key fields on  $projection.DocumentInfoRecord <> _TextObjectPlainLongTextDrat.TextObjectKey (we have concatenate client in TextObjectKey)
  association [0..*] to I_TextObjectPlainLongText      as _TextObjectPlainLongTextDrat  on  $projection.DocumentInfoRecord                  = _TextObjectPlainLongTextDrat.TextObjectKey
                                                                                        and _TextObjectPlainLongTextDrat.TextObjectCategory = 'DRAT'
                                                                                        and _TextObjectPlainLongTextDrat.TextObjectType     = 'LTXT'
  */

  association [0..*] to I_DocumentInfoRecordStsLog     as _DocumentInfoRecordStsLog     on  $projection.DocumentInfoRecordDocType    = _DocumentInfoRecordStsLog.DocumentInfoRecordDocType
                                                                                        and $projection.DocumentInfoRecordDocNumber  = _DocumentInfoRecordStsLog.DocumentInfoRecordDocNumber
                                                                                        and $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecordStsLog.DocumentInfoRecordDocVersion
                                                                                        and $projection.DocumentInfoRecordDocPart    = _DocumentInfoRecordStsLog.DocumentInfoRecordDocPart
                                                                                        and $projection.InternalDocumentStatus       = _DocumentInfoRecordStsLog.DocumentInfoRecordStsLog

  association [0..1] to I_DocumentInfoRecordReserve    as _DocumentInfoRecordReserve    on  $projection.DocumentInfoRecordDocType    = _DocumentInfoRecordReserve.DocumentInfoRecordDocType
                                                                                        and $projection.DocumentInfoRecordDocNumber  = _DocumentInfoRecordReserve.DocumentInfoRecordDocNumber
                                                                                        and $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecordReserve.DocumentInfoRecordDocVersion
                                                                                        and $projection.DocumentInfoRecordDocPart    = _DocumentInfoRecordReserve.DocumentInfoRecordDocPart

  association [0..*] to I_DocInfoRecordAttchsWithCntnt as _DocInfoRecordAttchsWithCntnt on  $projection.DocumentInfoRecordDocType    = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocType
                                                                                        and $projection.DocumentInfoRecordDocNumber  = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocNumber
                                                                                        and $projection.DocumentInfoRecordDocVersion = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocVersion
                                                                                        and $projection.DocumentInfoRecordDocPart    = _DocInfoRecordAttchsWithCntnt.DocumentInfoRecordDocPart
                                                                                        and _DocInfoRecordAttchsWithCntnt.Language   = $session.system_language

  association [0..*] to I_DocInfoRecordObjLinkAddlInfo as _DocInfoRecordObjLinkAddlInfo on  $projection.DocumentInfoRecordDocType    = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocType
                                                                                        and $projection.DocumentInfoRecordDocNumber  = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocNumber
                                                                                        and $projection.DocumentInfoRecordDocVersion = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocVersion
                                                                                        and $projection.DocumentInfoRecordDocPart    = _DocInfoRecordObjLinkAddlInfo.DocumentInfoRecordDocPart

  association [0..1] to I_ChangeMaster                 as _ChangeMaster                 on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber

  association [0..1] to I_Plant                        as _Plant                        on  $projection.Plant = _Plant.Plant

{

  key DocumentInfoRecordDocType                                                                          as DocumentInfoRecordDocType,
  key DocumentInfoRecordDocNumber                                                                        as DocumentInfoRecordDocNumber,
  key DocumentInfoRecordDocVersion                                                                       as DocumentInfoRecordDocVersion,
  key DocumentInfoRecordDocPart                                                                          as DocumentInfoRecordDocPart,

      Plant                                                                                              as Plant,
      ChangeNumber                                                                                       as ChangeNumber,
      DocumentInfoRecord                                                                                 as DocumentInfoRecord,
      InternalDocumentStatus                                                                             as InternalDocumentStatus,
      _DocStatus._Text[ 1:Language = $session.system_language ].ExternalDocumentStatus                   as ExternalDocumentStatus,
      _DocStatus._Text[ 1:Language = $session.system_language ].DocumentStatusName                       as DocumentStatusName,
      AuthorizationGroup                                                                                 as AuthorizationGroup,
      LaboratoryOrDesignOffice                                                                           as LaboratoryOrDesignOffice,

      _AuthGroup._Text[ 1:Language = $session.system_language ].AuthorizationGroupName                   as AuthorizationGroupName,
      IsDocInfoRecdCreatedFromCAD                                                                        as IsDocInfoRecdCreatedFromCAD,
      _Indicator._Text._CadStatusText[ 1:Language = $session.system_language ].CADStatusDescription      as CADStatusDescription,
      ChangedDateTime                                                                                    as ChangedDateTime,
      LastChangedByUser                                                                                  as ChangedBy,
      _ChangedUser.UserDescription                                                                       as LastChangedByUserDescription,
      CreationDateTime                                                                                   as CreationDate,
      CreatedByUser                                                                                      as 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                                                                              as ResponsiblePersonName,
      DocInfoRecdIsMarkedForDeletion                                                                     as 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._LogAccMSecureIDRepository._LogAccMContext.LogAccMContext                as LogAccMContext,

      _DocumentInfoRecordReserve,
      _DocumentInfoRecordStsLog,
      _DocInfoRecordAttchsWithCntnt,
      _DocInfoRecordObjLinkAddlInfo,
      //      _TextObjectPlainLongTextDrat,

      _ClfnObjectClassForKeyDate,
      _ClfnObjectCharcValForKeyDate,
      _ChangeMaster,
      _Plant,
      _DocType,
      _DocNumber,
      _DocVersion
}

Depth:

I_DocumentInfoRecordSrchModel view

I_DocumentInfoRecord view

ESH_N_DOCINFORECORD view