A_ChangeRecordReferenceDoc

DDL: A_CHANGERECORDREFERENCEDOC Type: view_entity COMPOSITE

Document Assignments to Change Records

A_ChangeRecordReferenceDoc is a Composite CDS View that provides data about "Document Assignments to Change Records" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordReferenceDocTP_2) and exposes 14 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordReferenceDocTP_2 I_ChangeRecordReferenceDocTP_2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChangeRecordDocStatus _ChangeRecordDocStatus $projection.DocumentType = _ChangeRecordDocStatus.DocumentType and $projection.DocumentInfoRecord = _ChangeRecordDocStatus.DocumentInfoRecord and $projection.DocumentVersion = _ChangeRecordDocStatus.DocumentVersion and $projection.DocumentPart = _ChangeRecordDocStatus.DocumentPart
[0..1] E_ChgRecdRefDocBsc _DocExtension $projection.ChangeRecordReferenceUUID = _DocExtension.ChangeRecordReferenceUUID

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Document Assignments to Change Records view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
ChangeRecord ChangeRecord
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
DocumentInfoRecord DocumentInfoRecord
DocumentType DocumentType
DocumentPart DocumentPart
DocumentVersion DocumentVersion
ChangeRecordItemRelevance ChangeRecordItemRelevance
ExternalDocumentStatus
_ChangeRecord _ChangeRecord 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
//       createEnabled: true,

   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata: {
  ignorePropagatedAnnotations: true
}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@EndUserText.label: 'Document Assignments to Change Records'
define view entity  A_ChangeRecordReferenceDoc
  as select from I_ChangeRecordReferenceDocTP_2   
  association        to parent A_ChangeRecord   as _ChangeRecord          on  $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
  association [0..1] to I_ChangeRecordDocStatus as _ChangeRecordDocStatus on  $projection.DocumentType       = _ChangeRecordDocStatus.DocumentType
                                                                          and $projection.DocumentInfoRecord = _ChangeRecordDocStatus.DocumentInfoRecord
                                                                          and $projection.DocumentVersion    = _ChangeRecordDocStatus.DocumentVersion
                                                                          and $projection.DocumentPart       = _ChangeRecordDocStatus.DocumentPart
 association [0..1] to E_ChgRecdRefDocBsc    as _DocExtension on $projection.ChangeRecordReferenceUUID = _DocExtension.ChangeRecordReferenceUUID                                                                          
{
  key    ChangeRecordReferenceUUID,
         ChangeRecord,
         ChangeRecordUUID,
         ChangeRecordReferenceType,
         CreatedByUser,
         CreationDateTime,
         LastChangedByUser,         
         case
            when LastChangeDateTime = fltp_to_dec( 0.00 as timestampl )
            then fltp_to_dec( 19720401000000.00 as timestampl )
            else LastChangeDateTime
         end                                                                                                                  as  LastChangeDateTime,
         DocumentInfoRecord,
         DocumentType,
         DocumentPart,
         DocumentVersion,
         ChangeRecordItemRelevance,
         _ChangeRecordDocStatus._DocStatus._Text[1:Language = $session.system_language].ExternalDocumentStatus                as  ExternalDocumentStatus,         
         _ChangeRecord

}

Learn More