I_DocInfoRecd
Document Info Record Details
I_DocInfoRecd is a Basic CDS View (Dimension) that provides data about "Document Info Record Details" in SAP S/4HANA. It reads from 1 data source (P_DocInfoRecd) and exposes 27 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart. It has 10 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_DocInfoRecd | Doc_Info | from |
Associations (10)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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 --Get Responsible user full name |
| [0..1] | I_User | _UserDetails | $projection.ResponsiblePersonName = _UserDetails.UserID --Get DIR created user full name |
| [0..1] | I_User | _CreatedUser | $projection.CreatedByUser = _CreatedUser.UserID --Get DIR changed user full name |
| [0..1] | I_User | _ChangedUser | $projection.LastChangedByUser = _ChangedUser.UserID --Get DocumentInfoRecord created user value help |
| [1..1] | I_DocumentInfoRecordUserVH | _CreatedUserVH | $projection.DocumentType = _CreatedUserVH.DocumentInfoRecordDocType and $projection.DocumentPart = _CreatedUserVH.DocumentInfoRecordDocPart and $projection.DocumentInfoRecord = _CreatedUserVH.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _CreatedUserVH.DocumentInfoRecordDocVersion and $projection.CreatedByUser = _CreatedUserVH.ResponsiblePersonName --Get DocumentInfoRecord changed user value help |
| [1..1] | I_DocumentInfoRecordUserVH | _ChangedUserVH | $projection.DocumentType = _ChangedUserVH.DocumentInfoRecordDocType and $projection.DocumentPart = _ChangedUserVH.DocumentInfoRecordDocPart and $projection.DocumentInfoRecord = _ChangedUserVH.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _ChangedUserVH.DocumentInfoRecordDocVersion and $projection.LastChangedByUser = _ChangedUserVH.LastChangedByUser --Get DocumentInfoRecord Responsible user value help |
| [1..1] | I_DocumentInfoRecordUserVH | _UserDetailsVH | $projection.DocumentType = _UserDetailsVH.DocumentInfoRecordDocType and $projection.DocumentPart = _UserDetailsVH.DocumentInfoRecordDocPart and $projection.DocumentInfoRecord = _UserDetailsVH.DocumentInfoRecordDocNumber and $projection.DocumentVersion = _UserDetailsVH.DocumentInfoRecordDocVersion and $projection.ResponsiblePersonName = _UserDetailsVH.ResponsiblePersonName |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICVDOCINFORECD | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #BASIC | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.representativeKey | DocumentPart | view | |
| Metadata.allowExtensions | true | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.dataExtraction.enabled | true | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| EndUserText.label | Document Info Record Details | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | I_DocumentInfoRecord | view |
Fields (27)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DocumentType | P_DocInfoRecd | DocumentType | |
| KEY | DocumentInfoRecord | P_DocInfoRecd | DocumentInfoRecord | |
| KEY | DocumentVersion | P_DocInfoRecd | DocumentVersion | |
| KEY | DocumentPart | P_DocInfoRecd | DocumentPart | |
| DocInfoRecdIsMarkedForDeletion | P_DocInfoRecd | DocInfoRecdIsMarkedForDeletion | ||
| IsDocInfoRecdStructure | P_DocInfoRecd | IsDocInfoRecdStructure | ||
| DocumentIsCreatedByCAD | P_DocInfoRecd | DocumentIsCreatedByCAD | ||
| DocInfoRecdHierarchy | P_DocInfoRecd | DocInfoRecdHierarchy | ||
| InternalDocumentStatus | P_DocInfoRecd | InternalDocumentStatus | ||
| ChangeNumber | P_DocInfoRecd | ChangeNumber | ||
| LaboratoryOrDesignOffice | P_DocInfoRecd | LaboratoryOrDesignOffice | ||
| AuthorizationGroup | P_DocInfoRecd | AuthorizationGroup | ||
| ResponsiblePersonName | P_DocInfoRecd | ResponsiblePersonName | ||
| CreationDateTime | P_DocInfoRecd | CreationDateTime | ||
| CreatedByUser | P_DocInfoRecd | CreatedByUser | ||
| ChangedDateTime | P_DocInfoRecd | ChangedDateTime | ||
| LastChangedByUser | P_DocInfoRecd | LastChangedByUser | ||
| _DocumentType | _DocumentType | |||
| _DocumentVersion | _DocumentVersion | |||
| _DocumentNumber | _DocumentNumber | |||
| _DocumentPart | _DocumentPart | |||
| _UserDetails | _UserDetails | |||
| _CreatedUser | _CreatedUser | |||
| _ChangedUser | _ChangedUser | |||
| _CreatedUserVH | _CreatedUserVH | |||
| _ChangedUserVH | _ChangedUserVH | |||
| _UserDetailsVH | _UserDetailsVH |
@AbapCatalog.sqlViewName: 'ICVDOCINFORECD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'DocumentPart'
@AccessControl.privilegedAssociations: [ '_CreatedUser', '_ChangedUser', '_UserDetails' ]
@Metadata.allowExtensions: true
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@EndUserText.label: 'Document Info Record Details'
@VDM.lifecycle: {
contract: {
type: #PUBLIC_LOCAL_API
},
status: #DEPRECATED,
successor: 'I_DocumentInfoRecord'
}
define view I_DocInfoRecd
as select from P_DocInfoRecd as Doc_Info
--Get Document Type Association
association [1..1] to I_DocInfoRecdDocumentType as _DocumentType on $projection.DocumentType = _DocumentType.DocumentType
--Get Document Number Association
association [1..1] to I_DocInfoRecdNumber as _DocumentNumber on $projection.DocumentType = _DocumentNumber.DocumentType
and $projection.DocumentInfoRecord = _DocumentNumber.DocumentInfoRecord
--Get Document Version Association
association [1..1] to I_DocInfoRecdDocumentVersion as _DocumentVersion on $projection.DocumentType = _DocumentVersion.DocumentType
and $projection.DocumentInfoRecord = _DocumentVersion.DocumentInfoRecord
and $projection.DocumentVersion = _DocumentVersion.DocumentVersion
--Get Document Part Association
association [1..1] to I_DocInfoRecdDocumentPart as _DocumentPart on $projection.DocumentType = _DocumentPart.DocumentType
and $projection.DocumentPart = _DocumentPart.DocumentPart
and $projection.DocumentInfoRecord = _DocumentPart.DocumentInfoRecord
and $projection.DocumentVersion = _DocumentPart.DocumentVersion
--Get Responsible user full name
association [0..1] to I_User as _UserDetails on $projection.ResponsiblePersonName = _UserDetails.UserID
--Get DIR created user full name
association [0..1] to I_User as _CreatedUser on $projection.CreatedByUser = _CreatedUser.UserID
--Get DIR changed user full name
association [0..1] to I_User as _ChangedUser on $projection.LastChangedByUser = _ChangedUser.UserID
--Get DocumentInfoRecord created user value help
association [1..1] to I_DocumentInfoRecordUserVH as _CreatedUserVH on $projection.DocumentType = _CreatedUserVH.DocumentInfoRecordDocType
and $projection.DocumentPart = _CreatedUserVH.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecord = _CreatedUserVH.DocumentInfoRecordDocNumber
and $projection.DocumentVersion = _CreatedUserVH.DocumentInfoRecordDocVersion
and $projection.CreatedByUser = _CreatedUserVH.ResponsiblePersonName
--Get DocumentInfoRecord changed user value help
association [1..1] to I_DocumentInfoRecordUserVH as _ChangedUserVH on $projection.DocumentType = _ChangedUserVH.DocumentInfoRecordDocType
and $projection.DocumentPart = _ChangedUserVH.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecord = _ChangedUserVH.DocumentInfoRecordDocNumber
and $projection.DocumentVersion = _ChangedUserVH.DocumentInfoRecordDocVersion
and $projection.LastChangedByUser = _ChangedUserVH.LastChangedByUser
--Get DocumentInfoRecord Responsible user value help
association [1..1] to I_DocumentInfoRecordUserVH as _UserDetailsVH on $projection.DocumentType = _UserDetailsVH.DocumentInfoRecordDocType
and $projection.DocumentPart = _UserDetailsVH.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecord = _UserDetailsVH.DocumentInfoRecordDocNumber
and $projection.DocumentVersion = _UserDetailsVH.DocumentInfoRecordDocVersion
and $projection.ResponsiblePersonName = _UserDetailsVH.ResponsiblePersonName
{
@ObjectModel.foreignKey.association: '_DocumentType'
key Doc_Info.DocumentType as DocumentType,
@ObjectModel.foreignKey.association: '_DocumentNumber'
key Doc_Info.DocumentInfoRecord as DocumentInfoRecord,
@ObjectModel.foreignKey.association: '_DocumentVersion'
key Doc_Info.DocumentVersion as DocumentVersion,
key Doc_Info.DocumentPart as DocumentPart,
/* Deletion,Document Structure,CAD,hierarchy Indicator */
Doc_Info.DocInfoRecdIsMarkedForDeletion as DocInfoRecdIsMarkedForDeletion,
Doc_Info.IsDocInfoRecdStructure as IsDocInfoRecdStructure,
Doc_Info.DocumentIsCreatedByCAD as DocumentIsCreatedByCAD,
Doc_Info.DocInfoRecdHierarchy as DocInfoRecdHierarchy,
/* Document data */
Doc_Info.InternalDocumentStatus as InternalDocumentStatus,
Doc_Info.ChangeNumber as ChangeNumber,
Doc_Info.LaboratoryOrDesignOffice as LaboratoryOrDesignOffice,
Doc_Info.AuthorizationGroup as AuthorizationGroup,
@Consumption.valueHelpDefinition.association: '_UserDetailsVH'
@Semantics.user.responsible: true
Doc_Info.ResponsiblePersonName as ResponsiblePersonName,
/* DIR Administrative Data */
@Semantics.businessDate.at: true
@Semantics.businessDate.createdAt: true
Doc_Info.CreationDateTime as CreationDateTime,
@Consumption.valueHelpDefinition.association: '_CreatedUserVH'
@Semantics.user.createdBy: true
Doc_Info.CreatedByUser as CreatedByUser,
@Semantics.businessDate.at: true
@Semantics.businessDate.lastChangedAt: true
Doc_Info.ChangedDateTime as ChangedDateTime,
@Consumption.valueHelpDefinition.association: '_ChangedUserVH'
@Semantics.user.lastChangedBy: true
Doc_Info.LastChangedByUser as LastChangedByUser,
/* Associations */
_DocumentType,
_DocumentVersion,
_DocumentNumber,
_DocumentPart,
_UserDetails,
_CreatedUser,
_ChangedUser,
_CreatedUserVH,
_ChangedUserVH,
_UserDetailsVH
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_DOCINFORECD"
],
"ASSOCIATED":
[
"I_DOCINFORECDDOCUMENTPART",
"I_DOCINFORECDDOCUMENTTYPE",
"I_DOCINFORECDDOCUMENTVERSION",
"I_DOCINFORECDNUMBER",
"I_DOCUMENTINFORECORDUSERVH",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA