I_DocumentInfoRecordTP
Document Info Record Transactional
I_DocumentInfoRecordTP is a Transactional CDS View that provides data about "Document Info Record Transactional" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecord) and exposes 45 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DocumentInfoRecord | Document | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_DocumentInfoRecordDescTP | _Desc | $projection.DocumentInfoRecordDocType = _Desc.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _Desc.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _Desc.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _Desc.DocumentInfoRecordDocPart |
| [0..*] | I_DocumentInfoRecordObjLinkTP | _ObjLink | $projection.DocumentInfoRecordDocType = _ObjLink.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _ObjLink.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _ObjLink.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _ObjLink.DocumentInfoRecordDocPart -------Extension |
| [1..1] | E_DocumentInfoRecord | _ManageDocDataExtension | $projection.DocumentInfoRecordDocType = _ManageDocDataExtension.DocumentInfoRecordDocType -- and $projection.DocumentInfoRecordDocNumber = _ManageDocDataExtension.DocumentInfoRecordDocNumber -- and $projection.DocumentInfoRecordDocVersion = _ManageDocDataExtension.DocumentInfoRecordDocVersion -- and $projection.DocumentInfoRecordDocPart = _ManageDocDataExtension.DocumentInfoRecordDocPart |
Annotations (21)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICVDOCINFORECTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Document Info Record Transactional | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.transactionalProcessingEnabled | true | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.writeDraftPersistence | DRAW_DRAFT | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.entityChangeStateId | ChangedDateTime | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ClientHandling.type | #INHERITED | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.modelCategory | #BUSINESS_OBJECT | view | |
| ObjectModel.sapObjectNodeType.name | DocumentInfoRecord | view |
Fields (45)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DocumentInfoRecordDocType | I_DocumentInfoRecord | DocumentInfoRecordDocType | |
| KEY | DocumentInfoRecordDocNumber | I_DocumentInfoRecord | DocumentInfoRecordDocNumber | |
| KEY | DocumentInfoRecordDocVersion | I_DocumentInfoRecord | DocumentInfoRecordDocVersion | |
| KEY | DocumentInfoRecordDocPart | I_DocumentInfoRecord | DocumentInfoRecordDocPart | |
| DocumentInfoRecord | I_DocumentInfoRecord | DocumentInfoRecord | ||
| DocInfoRecdIsMarkedForDeletion | I_DocumentInfoRecord | DocInfoRecdIsMarkedForDeletion | ||
| InternalDocumentStatus | I_DocumentInfoRecord | InternalDocumentStatus | ||
| IsDocInfoRecdCreatedFromCAD | I_DocumentInfoRecord | IsDocInfoRecdCreatedFromCAD | ||
| IsDocInfoRecdStructure | I_DocumentInfoRecord | IsDocInfoRecdStructure | ||
| DocInfoRecdSourceDocNumber | I_DocumentInfoRecord | DocInfoRecdSourceDocNumber | ||
| DocInfoRecdSourceDocVersion | I_DocumentInfoRecord | DocInfoRecdSourceDocVersion | ||
| DocInfoRecdSourceDocPart | I_DocumentInfoRecord | DocInfoRecdSourceDocPart | ||
| ResponsiblePersonName | I_DocumentInfoRecord | ResponsiblePersonName | ||
| CreatedByUser | I_DocumentInfoRecord | CreatedByUser | ||
| CreationDateTime | I_DocumentInfoRecord | CreationDateTime | ||
| LastChangedByUser | I_DocumentInfoRecord | LastChangedByUser | ||
| ChangedDateTime | I_DocumentInfoRecord | ChangedDateTime | ||
| DocInfoRecdDocTypeForEdit | I_DocumentInfoRecord | DocumentInfoRecordDocType | ||
| DocInfoRecdDocNumberForEdit | I_DocumentInfoRecord | DocumentInfoRecordDocNumber | ||
| DocInfoRecdDocVersionForEdit | I_DocumentInfoRecord | DocumentInfoRecordDocVersion | ||
| DocInfoRecdDocPartForEdit | I_DocumentInfoRecord | DocumentInfoRecordDocPart | ||
| LaboratoryOrDesignOffice | I_DocumentInfoRecord | LaboratoryOrDesignOffice | ||
| AuthorizationGroup | I_DocumentInfoRecord | AuthorizationGroup | ||
| DocumentDescriptionForEdit | ||||
| ExternalDocumentStatusForEdit | ||||
| ClassificationSideEffect | ||||
| _ChangedUser | I_DocumentInfoRecord | _ChangedUser | ||
| _CreatedUser | I_DocumentInfoRecord | _CreatedUser | ||
| _UserDetails | I_DocumentInfoRecord | _UserDetails | ||
| _ChangedUserVH | I_DocumentInfoRecord | _ChangedUserVH | ||
| _CreatedUserVH | I_DocumentInfoRecord | _CreatedUserVH | ||
| _UserDetailsVH | I_DocumentInfoRecord | _UserDetailsVH | ||
| _DocNumber | I_DocumentInfoRecord | _DocNumber | ||
| _DocPart | I_DocumentInfoRecord | _DocPart | ||
| _DocType | I_DocumentInfoRecord | _DocType | ||
| _DocVersion | I_DocumentInfoRecord | _DocVersion | ||
| _DocStatus | I_DocumentInfoRecord | _DocStatus | ||
| _Indicator | I_DocumentInfoRecord | _Indicator | ||
| _AuthGroup | I_DocumentInfoRecord | _AuthGroup | ||
| _LabOffice | I_DocumentInfoRecord | _LabOffice | ||
| _LogAccMObjectTypeActive | I_DocumentInfoRecord | _LogAccMObjectTypeActive | ||
| _LogAccMObjectUserAuthzn | I_DocumentInfoRecord | _LogAccMObjectUserAuthzn | ||
| _LogAccMObjSecureIDAssgmt | I_DocumentInfoRecord | _LogAccMObjSecureIDAssgmt | ||
| _Desc | _Desc | |||
| _ObjLink | _ObjLink |
@AbapCatalog.sqlViewName: 'ICVDOCINFORECTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [ '_ChangedUser', '_CreatedUser', '_UserDetails' ]
@EndUserText.label: 'Document Info Record Transactional'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.compositionRoot: true
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.draftEnabled: true
@ObjectModel.writeDraftPersistence: 'DRAW_DRAFT'
@ObjectModel.createEnabled: true //'EXTERNAL_CALCULATION'
@ObjectModel.updateEnabled: true //'EXTERNAL_CALCULATION'
@ObjectModel.deleteEnabled: true
@ObjectModel.entityChangeStateId: 'ChangedDateTime'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
-- BOPF Related Annotations
@ObjectModel.modelCategory: #BUSINESS_OBJECT
@ObjectModel.sapObjectNodeType.name: 'DocumentInfoRecord'
define view I_DocumentInfoRecordTP
as select from I_DocumentInfoRecord as Document
association [0..*] to I_DocumentInfoRecordDescTP as _Desc on $projection.DocumentInfoRecordDocType = _Desc.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocNumber = _Desc.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _Desc.DocumentInfoRecordDocVersion
and $projection.DocumentInfoRecordDocPart = _Desc.DocumentInfoRecordDocPart
association [0..*] to I_DocumentInfoRecordObjLinkTP as _ObjLink on $projection.DocumentInfoRecordDocType = _ObjLink.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocNumber = _ObjLink.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _ObjLink.DocumentInfoRecordDocVersion
and $projection.DocumentInfoRecordDocPart = _ObjLink.DocumentInfoRecordDocPart
-------Extension Association
-- association [1..1] to E_DocumentInfoRecord as _ManageDocDataExtension on $projection.DocumentInfoRecordDocType = _ManageDocDataExtension.DocumentInfoRecordDocType
-- and $projection.DocumentInfoRecordDocNumber = _ManageDocDataExtension.DocumentInfoRecordDocNumber
-- and $projection.DocumentInfoRecordDocVersion = _ManageDocDataExtension.DocumentInfoRecordDocVersion
-- and $projection.DocumentInfoRecordDocPart = _ManageDocDataExtension.DocumentInfoRecordDocPart
{
/* Document Info Record key Details */
@ObjectModel.mandatory:true
key Document.DocumentInfoRecordDocType as DocumentInfoRecordDocType,
key Document.DocumentInfoRecordDocNumber as DocumentInfoRecordDocNumber,
key Document.DocumentInfoRecordDocVersion as DocumentInfoRecordDocVersion,
key Document.DocumentInfoRecordDocPart as DocumentInfoRecordDocPart,
Document.DocumentInfoRecord as DocumentInfoRecord,
Document.DocInfoRecdIsMarkedForDeletion as DocInfoRecdIsMarkedForDeletion,
Document.InternalDocumentStatus as InternalDocumentStatus,
Document.IsDocInfoRecdCreatedFromCAD as IsDocInfoRecdCreatedFromCAD,
Document.IsDocInfoRecdStructure as IsDocInfoRecdStructure,
Document.DocInfoRecdSourceDocNumber as DocInfoRecdSourceDocNumber,
Document.DocInfoRecdSourceDocVersion as DocInfoRecdSourceDocVersion,
Document.DocInfoRecdSourceDocPart as DocInfoRecdSourceDocPart,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
Document.ResponsiblePersonName as ResponsiblePersonName,
Document.CreatedByUser as CreatedByUser,
Document.CreationDateTime as CreationDateTime,
Document.LastChangedByUser as LastChangedByUser,
Document.ChangedDateTime as ChangedDateTime,
//@ObjectModel.mandatory:true
//@ObjectModel.enabled: true
@ObjectModel: {
readOnly: 'EXTERNAL_CALCULATION'
// enabled: 'EXTERNAL_CALCULATION'
}
Document.DocumentInfoRecordDocType as DocInfoRecdDocTypeForEdit,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
readOnly: 'EXTERNAL_CALCULATION'
}
Document.DocumentInfoRecordDocNumber as DocInfoRecdDocNumberForEdit,
Document.DocumentInfoRecordDocVersion as DocInfoRecdDocVersionForEdit,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
readOnly: 'EXTERNAL_CALCULATION'
}
Document.DocumentInfoRecordDocPart as DocInfoRecdDocPartForEdit,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
Document.LaboratoryOrDesignOffice as LaboratoryOrDesignOffice,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
Document.AuthorizationGroup as AuthorizationGroup,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
cast( '' as dktxt ) as DocumentDescriptionForEdit,
//@ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
cast( '' as stabk ) as ExternalDocumentStatusForEdit,
@UI.hidden: true
cast(' ' as vchclf_side_effect_data) as ClassificationSideEffect,
Document._ChangedUser,
Document._CreatedUser,
Document._UserDetails,
Document._ChangedUserVH,
Document._CreatedUserVH,
Document._UserDetailsVH,
Document._DocNumber,
Document._DocPart,
Document._DocType,
Document._DocVersion,
Document._DocStatus,
Document._Indicator,
Document._AuthGroup,
Document._LabOffice,
Document._LogAccMObjectTypeActive,
Document._LogAccMObjectUserAuthzn,
Document._LogAccMObjSecureIDAssgmt,
@ObjectModel.association.type: #TO_COMPOSITION_CHILD
_Desc,
@ObjectModel.association.type: #TO_COMPOSITION_CHILD
_ObjLink
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORD"
],
"ASSOCIATED":
[
"I_DOCINFORECORDACCMSECIDASGT",
"I_DOCUMENTINFORECORDACCMACTV",
"I_DOCUMENTINFORECORDAUTHZNGRP",
"I_DOCUMENTINFORECORDDESCTP",
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCPRT",
"I_DOCUMENTINFORECORDDOCSTATUS",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION",
"I_DOCUMENTINFORECORDINDSTS",
"I_DOCUMENTINFORECORDLBTRYOFFC",
"I_DOCUMENTINFORECORDOBJLINKTP",
"I_DOCUMENTINFORECORDUAUTHACCM",
"I_DOCUMENTINFORECORDUSERVH",
"I_USER"
],
"BASE":
[
"I_DOCUMENTINFORECORD"
],
"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