I_DocumentInfoRecordDescTP
DocumentInfoRecdDescriptionTransactional
I_DocumentInfoRecordDescTP is a Transactional CDS View that provides data about "DocumentInfoRecdDescriptionTransactional" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecordDesc) and exposes 15 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, Language. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DocumentInfoRecordDesc | Desc | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_DocumentInfoRecordDocType | _DocType | $projection.DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType --Get Document Number |
| [0..1] | I_DocumentInfoRecordDocNumber | _DocNumber | $projection.DocumentInfoRecordDocType = _DocNumber.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocNumber.DocumentInfoRecordDocNumber --Get Document Part |
| [0..1] | I_DocumentInfoRecordDocPrt | _DocPart | $projection.DocumentInfoRecordDocType = _DocPart.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocPart = _DocPart.DocumentInfoRecordDocPart and $projection.DocumentInfoRecordDocNumber = _DocPart.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocPart.DocumentInfoRecordDocVersion --Get Document Version |
| [0..1] | I_DocumentInfoRecordDocVersion | _DocVersion | $projection.DocumentInfoRecordDocType = _DocVersion.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocVersion.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocVersion.DocumentInfoRecordDocVersion |
| [0..1] | I_Language | _Language | $projection.Language = _Language.Language |
| [0..1] | I_Language | _LanguageForEdit | _LanguageForEdit.LanguageISOCode = $projection.LanguageForEdit and _LanguageForEdit.Language = $projection.Language |
| [1..1] | I_DocumentInfoRecordTP | _DocInfo | $projection.DocumentInfoRecordDocType = _DocInfo.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocInfo.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocInfo.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocInfo.DocumentInfoRecordDocPart |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICVDOCDESCTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | DocumentInfoRecdDescriptionTransactional | view | |
| ObjectModel.representativeKey | DocumentInfoRecordDocType | view | |
| ObjectModel.dataCategory | #TEXT | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.writeDraftPersistence | DRAT_DRAFT | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ClientHandling.type | #INHERITED | view |
Fields (15)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DocumentInfoRecordDocType | I_DocumentInfoRecordDesc | DocumentInfoRecordDocType | |
| KEY | DocumentInfoRecordDocNumber | I_DocumentInfoRecordDesc | DocumentInfoRecordDocNumber | |
| KEY | DocumentInfoRecordDocVersion | I_DocumentInfoRecordDesc | DocumentInfoRecordDocVersion | |
| KEY | DocumentInfoRecordDocPart | I_DocumentInfoRecordDesc | DocumentInfoRecordDocPart | |
| KEY | Language | I_DocumentInfoRecordDesc | Language | |
| LanguageForEdit | _Language | LanguageISOCode | ||
| DocumentDescription | I_DocumentInfoRecordDesc | DocumentDescription | ||
| LongTextExists | I_DocumentInfoRecordDesc | LongTextExists | ||
| _DocNumber | _DocNumber | |||
| _DocPart | _DocPart | |||
| _DocType | _DocType | |||
| _DocVersion | _DocVersion | |||
| _Language | _Language | |||
| _LanguageForEdit | _LanguageForEdit | |||
| _DocInfo | _DocInfo |
@AbapCatalog.sqlViewName: 'ICVDOCDESCTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'DocumentInfoRecdDescriptionTransactional'
@ObjectModel.representativeKey:'DocumentInfoRecordDocType'
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@ObjectModel.writeDraftPersistence:'DRAT_DRAFT'
@ObjectModel.draftEnabled: true
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
define view I_DocumentInfoRecordDescTP
as select from I_DocumentInfoRecordDesc as Desc
--Get Document Type Association
association [1..1] to I_DocumentInfoRecordDocType as _DocType on $projection.DocumentInfoRecordDocType = _DocType.DocumentInfoRecordDocType
--Get Document Number Association
association [0..1] to I_DocumentInfoRecordDocNumber as _DocNumber on $projection.DocumentInfoRecordDocType = _DocNumber.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocNumber = _DocNumber.DocumentInfoRecordDocNumber
--Get Document Part Association
association [0..1] to I_DocumentInfoRecordDocPrt as _DocPart on $projection.DocumentInfoRecordDocType = _DocPart.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocPart = _DocPart.DocumentInfoRecordDocPart
and $projection.DocumentInfoRecordDocNumber = _DocPart.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _DocPart.DocumentInfoRecordDocVersion
--Get Document Version Association
association [0..1] to I_DocumentInfoRecordDocVersion as _DocVersion on $projection.DocumentInfoRecordDocType = _DocVersion.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocNumber = _DocVersion.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _DocVersion.DocumentInfoRecordDocVersion
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [0..1] to I_Language as _LanguageForEdit on _LanguageForEdit.LanguageISOCode = $projection.LanguageForEdit
and _LanguageForEdit.Language = $projection.Language
association [1..1] to I_DocumentInfoRecordTP as _DocInfo on $projection.DocumentInfoRecordDocType = _DocInfo.DocumentInfoRecordDocType
and $projection.DocumentInfoRecordDocNumber = _DocInfo.DocumentInfoRecordDocNumber
and $projection.DocumentInfoRecordDocVersion = _DocInfo.DocumentInfoRecordDocVersion
and $projection.DocumentInfoRecordDocPart = _DocInfo.DocumentInfoRecordDocPart
{
@ObjectModel.foreignKey.association: '_DocType'
key Desc.DocumentInfoRecordDocType as DocumentInfoRecordDocType,
@ObjectModel.foreignKey.association: '_DocNumber'
key Desc.DocumentInfoRecordDocNumber as DocumentInfoRecordDocNumber,
@ObjectModel.foreignKey.association: '_DocVersion'
key Desc.DocumentInfoRecordDocVersion as DocumentInfoRecordDocVersion,
@ObjectModel.foreignKey.association: '_DocPart'
key Desc.DocumentInfoRecordDocPart as DocumentInfoRecordDocPart,
@Semantics.language: true
@ObjectModel.foreignKey.association: '_Language'
key Desc.Language as Language,
// @ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
@ObjectModel.foreignKey.association: '_LanguageForEdit'
@Semantics.language:false
_Language.LanguageISOCode as LanguageForEdit,
// @ObjectModel.updateEnabled: true
@ObjectModel: {
enabled: 'EXTERNAL_CALCULATION',
readOnly: 'EXTERNAL_CALCULATION',
mandatory: 'EXTERNAL_CALCULATION'
}
@Semantics.text: true
Desc.DocumentDescription as DocumentDescription,
Desc.LongTextExists as LongTextExists,
_DocNumber,
_DocPart,
_DocType,
_DocVersion,
_Language,
_LanguageForEdit,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
_DocInfo
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORDDESC",
"I_LANGUAGE"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCPRT",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION",
"I_DOCUMENTINFORECORDTP",
"I_LANGUAGE"
],
"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