I_ChgRecdRefDefectTP

DDL: I_CHGRECDREFDEFECTTP SQL: ICRREFDEFECTTP Type: view TRANSACTIONAL

Change Record Ref Obj Defect - TP

I_ChgRecdRefDefectTP is a Transactional CDS View that provides data about "Change Record Ref Obj Defect - TP" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefDefectBsc) and exposes 26 fields with key field ChangeRecordReferenceUUID. It has 1 association to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefDefectBsc reference_defect from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICRREFDEFECTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PLMCRREFDEF_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Change Record Ref Obj Defect - TP view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefDefectBsc ChangeRecordReferenceUUID
Notification
NotificationItem
ChangeRecordUUID I_ChgRecdRefDefectBsc ChangeRecordUUID
ChangeRecordReferenceType I_ChgRecdRefDefectBsc ChangeRecordReferenceType
ChangeRecordReferenceSubtype I_ChgRecdRefDefectBsc ChangeRecordReferenceSubtype
ChangeRecordRefObjectUUID I_ChgRecdRefDefectBsc ChangeRecordRefObjectUUID
ChangeRecordReference I_ChgRecdRefDefectBsc ChangeRecordReference
ParentChangeRecordRefUUID I_ChgRecdRefDefectBsc ParentChangeRecordRefUUID
IsMainReference I_ChgRecdRefDefectBsc IsMainReference
CreatedByUser I_ChgRecdRefDefectBsc CreatedByUser
CreationDateTime I_ChgRecdRefDefectBsc CreationDateTime
LastChangedByUser I_ChgRecdRefDefectBsc LastChangedByUser
LastChangeDateTime I_ChgRecdRefDefectBsc LastChangeDateTime
ChangeRecordItemRelevance I_ChgRecdRefDefectBsc ChangeRecordItemRelevance
ChangeRecordVirtualRefInd I_ChgRecdRefDefectBsc ChangeRecordVirtualRefInd
ChgRecdReasonForChange I_ChgRecdRefDefectBsc ChgRecdReasonForChange
ExpdCompltnDte I_ChgRecdRefDefectBsc ExpdCompltnDte
ChgRecdAuthznGrpText I_ChgRecdRefDefectBsc ChgRecdAuthznGrpText
ChgRecdNmbrChgSts I_ChgRecdRefDefectBsc ChgRecdNmbrChgSts
ChangeNumber I_ChgRecdRefDefectBsc ChangeNumber
ChangeRecordItemProcgStatus I_ChgRecdRefDefectBsc ChangeRecordItemProcgStatus
ChgRecdCurrentItemProcgStatus I_ChgRecdRefDefectBsc ChgRecdCurrentItemProcgStatus
ChgRecdItmTgtSts I_ChgRecdRefDefectBsc ChgRecdItmTgtSts
ChgRecdItmDSgntr I_ChgRecdRefDefectBsc ChgRecdItmDSgntr
_ChangeRecord _ChangeRecord 
@AbapCatalog.sqlViewName: 'ICRREFDEFECTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #TRANSACTIONAL
@ObjectModel: { semanticKey: [ 'Notification','NotificationItem' ],
                writeDraftPersistence: 'PLMCRREFDEF_D',
                createEnabled,
                deleteEnabled,
                updateEnabled
              }
@ObjectModel.usageType: { serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L }
@EndUserText.label: 'Change Record Ref Obj Defect - TP'

define view I_ChgRecdRefDefectTP
  as select from I_ChgRecdRefDefectBsc as reference_defect
  association [1..1] to I_ChangeRecordDraftTP as _ChangeRecord on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
    
{
  key reference_defect.ChangeRecordReferenceUUID,
      cast(ChgRecRefInternalKey1 as qmnum) as Notification,
      cast(ChgRecRefInternalKey2 as felfd) as NotificationItem,
      
      reference_defect.ChangeRecordUUID,
      @ObjectModel.readOnly: true
      reference_defect.ChangeRecordReferenceType,
      reference_defect.ChangeRecordReferenceSubtype,
      reference_defect.ChangeRecordRefObjectUUID,
      reference_defect.ChangeRecordReference,
      reference_defect.ParentChangeRecordRefUUID,
      reference_defect.IsMainReference,
      @Semantics.user.createdBy: true
      @ObjectModel.readOnly: true
      reference_defect.CreatedByUser,
      reference_defect.CreationDateTime,
      @Semantics.user.lastChangedBy: true
      @ObjectModel.readOnly: true
      reference_defect.LastChangedByUser,
      reference_defect.LastChangeDateTime,
      reference_defect.ChangeRecordItemRelevance,
      reference_defect.ChangeRecordVirtualRefInd,      
      reference_defect.ChgRecdReasonForChange,      
      reference_defect.ExpdCompltnDte,
      reference_defect.ChgRecdAuthznGrpText,
      reference_defect.ChgRecdNmbrChgSts,
      reference_defect.ChangeNumber,      
      reference_defect.ChangeRecordItemProcgStatus,      
      reference_defect.ChgRecdCurrentItemProcgStatus,
      reference_defect.ChgRecdItmTgtSts,
      reference_defect.ChgRecdItmDSgntr,
      
      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecord

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFDEFECTBSC"
],
"ASSOCIATED":
[
"I_CHANGERECORDDRAFTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More