I_DocInfoRecordTP
CDS TP View for Document Info Record
I_DocInfoRecordTP is a Transactional CDS View that provides data about "CDS TP View for Document Info Record" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecord) and exposes 20 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocVersion, DocumentInfoRecordDocNumber, DocumentInfoRecordDocPart. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_DocumentInfoRecord | I_DocumentInfoRecord | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_DocInfoRecordDescriptionTP | _DocDesc | |
| [0..*] | I_DocInfoRecdObjLinkProdTP | _ProductObj | |
| [0..*] | I_DocInfoRecdObjLinkBOMTP | _BOMObj | |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IDIRHDRWODRTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | CDS TP View for Document Info Record | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.sapObjectNodeType.name | DocumentInfoRecord | view | |
| AbapCatalog.preserveKey | true | view |
Fields (20)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DocumentInfoRecordDocType | DocumentInfoRecordDocType | ||
| KEY | DocumentInfoRecordDocVersion | DocumentInfoRecordDocVersion | ||
| KEY | DocumentInfoRecordDocNumber | DocumentInfoRecordDocNumber | ||
| KEY | DocumentInfoRecordDocPart | DocumentInfoRecordDocPart | ||
| DocumentInfoRecord | DocumentInfoRecord | |||
| InternalDocumentStatus | InternalDocumentStatus | |||
| LaboratoryOrDesignOffice | LaboratoryOrDesignOffice | |||
| AuthorizationGroup | AuthorizationGroup | |||
| ChangeNumber | ChangeNumber | |||
| DocInfoRecdIsMarkedForDeletion | DocInfoRecdIsMarkedForDeletion | |||
| IsDocInfoRecdCreatedFromCAD | IsDocInfoRecdCreatedFromCAD | |||
| IsDocInfoRecdStructure | IsDocInfoRecdStructure | |||
| ResponsiblePersonName | ResponsiblePersonName | |||
| CreationDateTime | CreationDateTime | |||
| CreatedByUser | CreatedByUser | |||
| ChangedDateTime | ChangedDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| _DocDesc | _DocDesc | |||
| _ProductObj | _ProductObj | |||
| _BOMObj | _BOMObj |
@AbapCatalog.sqlViewName: 'IDIRHDRWODRTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS TP View for Document Info Record'
@VDM.viewType: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.sapObjectNodeType.name:'DocumentInfoRecord'
//@ObjectModel.entityChangeStateId: 'ChangedDateTime'
//@ObjectModel.compositionRoot:true
//@ObjectModel.createEnabled: true
//@ObjectModel.updateEnabled: true
//@ObjectModel.deleteEnabled: true
//@ObjectModel.transactionalProcessingEnabled: true
//@ObjectModel.writeActiveImplementedBy: 'ABAP:CL_PLM_RAP_PROVIDER_DMS'
@AbapCatalog.preserveKey: true
define root view I_DocInfoRecordTP
as select from I_DocumentInfoRecord
composition [0..*] of I_DocInfoRecordDescriptionTP as _DocDesc // on $projection.DocumentInfoRecordDocType = _DocDesc.DocumentInfoRecordDocType
// and $projection.DocumentInfoRecordDocNumber = _DocDesc.DocumentInfoRecordDocNumber
// and $projection.DocumentInfoRecordDocPart = _DocDesc.DocumentInfoRecordDocPart
// and $projection.DocumentInfoRecordDocVersion = _DocDesc.DocumentInfoRecordDocVersion
composition [0..*] of I_DocInfoRecdObjLinkProdTP as _ProductObj // on $projection.DocumentInfoRecordDocType = _ProductObj.DocumentInfoRecordDocType
//and $projection.DocumentInfoRecordDocNumber = _ProductObj.DocumentInfoRecordDocNumber
//and $projection.DocumentInfoRecordDocPart = _ProductObj.DocumentInfoRecordDocPart
//and $projection.DocumentInfoRecordDocVersion = _ProductObj.DocumentInfoRecordDocVersion
composition [0..*] of I_DocInfoRecdObjLinkBOMTP as _BOMObj //on $projection.DocumentInfoRecordDocType = _BOMObj.DocumentInfoRecordDocType
//and $projection.DocumentInfoRecordDocNumber = _BOMObj.DocumentInfoRecordDocNumber
//and $projection.DocumentInfoRecordDocPart = _BOMObj.DocumentInfoRecordDocPart
//and $projection.DocumentInfoRecordDocVersion = _BOMObj.DocumentInfoRecordDocVersion
{
key DocumentInfoRecordDocType as DocumentInfoRecordDocType,
key DocumentInfoRecordDocVersion as DocumentInfoRecordDocVersion,
key DocumentInfoRecordDocNumber as DocumentInfoRecordDocNumber,
key DocumentInfoRecordDocPart as DocumentInfoRecordDocPart,
DocumentInfoRecord as DocumentInfoRecord,
/* Document Info Record other Details */
InternalDocumentStatus as InternalDocumentStatus,
LaboratoryOrDesignOffice as LaboratoryOrDesignOffice,
AuthorizationGroup as AuthorizationGroup,
ChangeNumber as ChangeNumber,
/* Document Structure, CAD and Deletion Indicator */
DocInfoRecdIsMarkedForDeletion as DocInfoRecdIsMarkedForDeletion,
IsDocInfoRecdCreatedFromCAD as IsDocInfoRecdCreatedFromCAD,
IsDocInfoRecdStructure as IsDocInfoRecdStructure,
ResponsiblePersonName as ResponsiblePersonName,
/* DIR Administrative Data */
CreationDateTime as CreationDateTime,
CreatedByUser as CreatedByUser,
// @ObjectModel.readOnly: true
ChangedDateTime as ChangedDateTime,
LastChangedByUser as LastChangedByUser,
//@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_DocDesc,
//@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_ProductObj,
//@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_BOMObj
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORD"
],
"ASSOCIATED":
[
"I_DOCINFORECDOBJLINKBOMTP",
"I_DOCINFORECDOBJLINKPRODTP",
"I_DOCINFORECORDDESCRIPTIONTP"
],
"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