I_ChangeRecordDocStatus

DDL: I_CHANGERECORDDOCSTATUS SQL: ICHGRECDOCST Type: view COMPOSITE Package: VDM_PLMB_CR

Change Record Document Status

I_ChangeRecordDocStatus is a Composite CDS View that provides data about "Change Record Document Status" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecord) and exposes 9 fields with key fields DocumentType, DocumentInfoRecord, DocumentVersion, DocumentPart. It has 1 association to related views. Part of development package VDM_PLMB_CR.

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecord I_DocumentInfoRecord from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DocumentInfoRecordDocStatus _DocStatus $projection.DocumentType = _DocStatus.DocumentInfoRecordDocType and $projection.InternalDocumentStatus = _DocStatus.InternalDocumentStatus

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECDOCST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change Record Document Status view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DocumentType DocumentInfoRecordDocType
KEY DocumentInfoRecord DocumentInfoRecordDocNumber
KEY DocumentVersion DocumentInfoRecordDocVersion
KEY DocumentPart DocumentInfoRecordDocPart
InternalDocumentStatus InternalDocumentStatus
_DocType _DocType
_DocNumber _DocNumber
_DocVersion _DocVersion
_DocStatus _DocStatus
@AbapCatalog.sqlViewName: 'ICHGRECDOCST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Change Record Document Status'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #XXL}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ChangeRecordDocStatus
  as select from I_DocumentInfoRecord
  --Get Document Status Text Association
  association [0..1] to I_DocumentInfoRecordDocStatus as _DocStatus on $projection.DocumentType           = _DocStatus.DocumentInfoRecordDocType
                                                                   and $projection.InternalDocumentStatus = _DocStatus.InternalDocumentStatus
                                                                 
{
  key DocumentInfoRecordDocType as DocumentType,
  key DocumentInfoRecordDocNumber as DocumentInfoRecord,
  key DocumentInfoRecordDocVersion as DocumentVersion,
  key DocumentInfoRecordDocPart as DocumentPart,
      InternalDocumentStatus,
      _DocType,
      _DocNumber,
      _DocVersion,
      _DocStatus
}