I_ChangeRecordDocPart

DDL: I_CHANGERECORDDOCPART SQL: ICRDOCPRT Type: view COMPOSITE

Document Info Record Document Part

I_ChangeRecordDocPart is a Composite CDS View that provides data about "Document Info Record Document Part" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecordDocPrt) and exposes 9 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecordDocPrt DocPrt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DocumentInfoRecord _DocumentInfoRecord $projection.DocumentPart = _DocumentInfoRecord.DocumentInfoRecordDocPart and $projection.DocumentType = _DocumentInfoRecord.DocumentInfoRecordDocType and $projection.DocumentVersion = _DocumentInfoRecord.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecord = _DocumentInfoRecord.DocumentInfoRecordDocNumber

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICRDOCPRT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Document Info Record Document Part view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey DocumentPart view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DocumentType DocumentInfoRecordDocType
KEY DocumentInfoRecord DocumentInfoRecordDocNumber
KEY DocumentVersion DocumentInfoRecordDocVersion
KEY DocumentPart DocumentInfoRecordDocPart
DocumentDescription DocumentDescription
_DocDescription _DocDescription
_DocType _DocType
_DocNumber _DocNumber
_DocVersion _DocVersion
@AbapCatalog.sqlViewName: 'ICRDOCPRT'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Document Info Record Document Part'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.representativeKey: 'DocumentPart'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view I_ChangeRecordDocPart
  as select from I_DocumentInfoRecordDocPrt as DocPrt

  //

  //  --Get Document Description Association

  association [0..1] to I_DocumentInfoRecord as _DocumentInfoRecord on  $projection.DocumentPart       = _DocumentInfoRecord.DocumentInfoRecordDocPart
                                                                    and $projection.DocumentType       = _DocumentInfoRecord.DocumentInfoRecordDocType
                                                                    and $projection.DocumentVersion    = _DocumentInfoRecord.DocumentInfoRecordDocVersion
                                                                    and $projection.DocumentInfoRecord = _DocumentInfoRecord.DocumentInfoRecordDocNumber
{

  key   DocumentInfoRecordDocType    as DocumentType,
  key   DocumentInfoRecordDocNumber  as DocumentInfoRecord,
  key   DocumentInfoRecordDocVersion as DocumentVersion,
  key   DocumentInfoRecordDocPart    as DocumentPart,
        DocumentDescription,
        _DocDescription,
        _DocType,
        _DocNumber,
        _DocVersion
}
where
  _DocumentInfoRecord.DocInfoRecdIsMarkedForDeletion = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORD",
"I_DOCUMENTINFORECORDDOCPRT"
],
"ASSOCIATED":
[
"I_DOCUMENTINFORECORD",
"I_DOCUMENTINFORECORDDESC",
"I_DOCUMENTINFORECORDDOCNUMBER",
"I_DOCUMENTINFORECORDDOCTYPE",
"I_DOCUMENTINFORECORDDOCVERSION"
],
"BASE":
[
"I_DOCUMENTINFORECORDDOCPRT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/