Which tables does I_DocInfoRecdDocumentPart use?

I_DocInfoRecdDocumentPart reads from 1 data source(s): draw.

How many fields does I_DocInfoRecdDocumentPart have?

I_DocInfoRecdDocumentPart has 9 fields. Key fields: DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart.

I_DocInfoRecdDocumentPart

DDL: I_DOCINFORECDDOCUMENTPART SQL: ICVDOCUMENTPART Type: view BASIC

Document Part Value Help

I_DocInfoRecdDocumentPart is a Basic CDS View (Dimension) that provides data about "Document Part Value Help" in SAP S/4HANA. It reads from 1 data source (draw) and exposes 9 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
draw	document	from

Associations (4)

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 Description`
[0..*]	I_DocInfoRecdDescription	_DocumentDescription	`$projection.DocumentPart = _DocumentDescription.DocumentPart and $projection.DocumentType = _DocumentDescription.DocumentType and $projection.DocumentVersion = _DocumentDescription.DocumentVersion and $projection.DocumentInfoRecord = _DocumentDescription.DocumentInfoRecord`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	ICVDOCUMENTPART	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Document Part Value Help	view
Metadata.allowExtensions	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	DocumentPart	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_DocumentInfoRecordDocPrt	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (9)

Key	Field	Source Table	Source Field	Description
KEY	DocumentType	draw	dokar
KEY	DocumentInfoRecord	draw	doknr
KEY	DocumentVersion	draw	dokvr
KEY	DocumentPart	draw	doktl
	DocumentDescription			Document Description
	_DocumentDescription		_DocumentDescription
	_DocumentType		_DocumentType
	_DocumentNumber		_DocumentNumber
	_DocumentVersion		_DocumentVersion

@AbapCatalog.sqlViewName: 'ICVDOCUMENTPART'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Document Part Value Help'
@Metadata.allowExtensions: true
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'DocumentPart'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle: {
  contract: {
    type: #PUBLIC_LOCAL_API
  },
  status: #DEPRECATED,
  successor: 'I_DocumentInfoRecordDocPrt'
}
@Metadata.ignorePropagatedAnnotations:true

define view I_DocInfoRecdDocumentPart
  as select from draw as document

  --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 Description Association
  association [0..*] to I_DocInfoRecdDescription     as _DocumentDescription on  $projection.DocumentPart       = _DocumentDescription.DocumentPart
                                                                             and $projection.DocumentType       = _DocumentDescription.DocumentType
                                                                             and $projection.DocumentVersion    = _DocumentDescription.DocumentVersion
                                                                             and $projection.DocumentInfoRecord = _DocumentDescription.DocumentInfoRecord

{                                                     
      @ObjectModel.foreignKey.association:'_DocumentType'
  key document.dokar  as  DocumentType,
      
      @ObjectModel.foreignKey.association:'_DocumentNumber'
  key document.doknr  as  DocumentInfoRecord,
                                    
      @ObjectModel.foreignKey.association:'_DocumentVersion'
  key document.dokvr  as  DocumentVersion,

  key document.doktl  as  DocumentPart,

      @Semantics.text: true
      @EndUserText.label:'Document Description'
      _DocumentDescription[1:Language = $session.system_language].DocumentDescription as  DocumentDescription,

      //Associations

      _DocumentDescription,
      _DocumentType,
      _DocumentNumber,
      _DocumentVersion
}

Depth:

I_DocInfoRecdDocumentPart view

draw