Which tables does I_DocumentInfoRecordDesc use?

I_DocumentInfoRecordDesc reads from 1 data source(s): drat.

I_DocumentInfoRecordDesc

Q: How many fields does I_DocumentInfoRecordDesc have?

I_DocumentInfoRecordDesc has 13 fields. Key fields: DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, Language.

DDL: I_DOCUMENTINFORECORDDESC SQL: ICVDOCDESC Type: view BASIC

Document Info Record Description

I_DocumentInfoRecordDesc is a Basic CDS View that provides data about "Document Info Record Description" in SAP S/4HANA. It reads from 1 data source (drat) and exposes 13 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, Language. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
drat	documentdesc	from

Associations (5)

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`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	ICVDOCDESC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.dataCategory	#TEXT	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	DocumentInfoRecordDocType	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
EndUserText.label	Document Info Record Description	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.modelingPattern	#LANGUAGE_DEPENDENT_TEXT	view

Fields (13)

Key	Field	Source Table	Source Field	Description
KEY	DocumentInfoRecordDocType	drat	dokar
KEY	DocumentInfoRecordDocNumber	drat	doknr
KEY	DocumentInfoRecordDocVersion	drat	dokvr
KEY	DocumentInfoRecordDocPart	drat	doktl
KEY	Language	drat	langu
	DocumentDescription	drat	dktxt	Document Description
	LongTextExists	drat	ltxin
	DocInfoRecdShortText	drat	dktxt_uc	Document Short Description
	_Language		_Language
	_DocType		_DocType
	_DocVersion		_DocVersion
	_DocPart		_DocPart
	_DocNumber		_DocNumber

@AbapCatalog.sqlViewName:'ICVDOCDESC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey:'DocumentInfoRecordDocType'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@EndUserText.label: 'Document Info Record Description'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle: {
  contract: {
    type:#PUBLIC_LOCAL_API
  }
}
@ObjectModel.supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT , #SQL_DATA_SOURCE , #CDS_MODELING_DATA_SOURCE , #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
define view I_DocumentInfoRecordDesc
  as select from drat as documentdesc

  --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

{
            @ObjectModel.foreignKey.association: '_DocType'
  key       documentdesc.dokar    as DocumentInfoRecordDocType,

            @ObjectModel.foreignKey.association: '_DocNumber'
  key       documentdesc.doknr    as DocumentInfoRecordDocNumber,

            @ObjectModel.foreignKey.association: '_DocVersion'
  key       documentdesc.dokvr    as DocumentInfoRecordDocVersion,

            @ObjectModel.foreignKey.association: '_DocPart'
  key       documentdesc.doktl    as DocumentInfoRecordDocPart,

            @Semantics.language: true
            @ObjectModel.foreignKey.association: '_Language'
  key       documentdesc.langu    as Language,

            @Semantics.text: true
            @EndUserText.label:'Document Description'
            documentdesc.dktxt    as DocumentDescription,

            documentdesc.ltxin    as LongTextExists,

            // DMS: short texts in capital letters

            @EndUserText.label:'Document Short Description'
            documentdesc.dktxt_uc as DocInfoRecdShortText,

            // Associations

            @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
            _Language,
            @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
            _DocType,
            _DocVersion,
            _DocPart,
            _DocNumber

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DRAT"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCPRT",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_DocumentInfoRecordDesc view

drat