I_ChangeRecordReferenceMatTP

DDL: I_CHANGERECORDREFERENCEMATTP SQL: ICHGRECREFMATTP Type: view TRANSACTIONAL

Change Record Object Reference Material

I_ChangeRecordReferenceMatTP is a Transactional CDS View that provides data about "Change Record Object Reference Material" in SAP S/4HANA. It reads from 2 data sources (I_Material, I_ChgRecdRefMatBsc) and exposes 26 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_Material Material left_outer
I_ChgRecdRefMatBsc reference_mat from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ChangeRecordDraftTP _ChangeRecord $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
[0..1] E_ChgRecdRefMatBsc _MatExtension $projection.ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECREFMATTP view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence PLMCRREFMAT_D view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Change Record Object Reference Material view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.preserveKey true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
MaterialasmatnrendasMaterial
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype
ChangeRecordReference ChangeRecordReference
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
IsMainReference IsMainReference
ChgRecdReasonForChange ChgRecdReasonForChange
ExpdCompltnDte ExpdCompltnDte
ChgRecdAuthznGrpText ChgRecdAuthznGrpText
ChgRecdNmbrChgSts ChgRecdNmbrChgSts
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus
ChgRecdCurrentItemProcgStatus I_ChgRecdRefMatBsc ChgRecdCurrentItemProcgStatus
ChangeNumber ChangeNumber
ChgRecdItmTgtSts ChgRecdItmTgtSts
ChgRecdItmDSgntr ChgRecdItmDSgntr
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus
ChangeRecordStatus ChangeRecordStatus
_ChangeRecord _ChangeRecord 
@AbapCatalog.sqlViewName: 'ICHGRECREFMATTP'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: { semanticKey: ['Material'],
                writeDraftPersistence: 'PLMCRREFMAT_D',
                createEnabled,
                deleteEnabled,
                updateEnabled
              }
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Change Record Object Reference Material'

@ObjectModel.usageType: { serviceQuality: #B,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}
@AbapCatalog.preserveKey:true
define view I_ChangeRecordReferenceMatTP
  as select from    I_ChgRecdRefMatBsc as reference_mat
    left outer join I_Material         as Material on reference_mat.ChgRecRefInternalKey1 = Material.Material
  association [1..1] to I_ChangeRecordDraftTP as _ChangeRecord on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefMatBsc    as _MatExtension on $projection.ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID
{
  key ChangeRecordReferenceUUID,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      case when Material.Material is null then cast(  ChangeRecordReference  as matnr )
      else cast(  Material.Material  as matnr )
      end as Material,

      ChangeRecordUUID,
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordReference,
      ParentChangeRecordRefUUID,
      IsMainReference,
      ChgRecdReasonForChange,
      ExpdCompltnDte,
      ChgRecdAuthznGrpText,
      ChgRecdNmbrChgSts,
      @Semantics.user.createdBy: true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      LastChangeDateTime,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      ChangeRecordItemRelevance,
      ChangeRecordVirtualRefInd,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      ChangeRecordItemProcgStatus,
      @ObjectModel.readOnly: true
      reference_mat.ChgRecdCurrentItemProcgStatus,
      ChangeNumber,
      @ObjectModel.readOnly: true
      ChgRecdItmTgtSts,
      @ObjectModel.readOnly: true
      ChgRecdItmDSgntr,
      @ObjectModel.readOnly: true
      ChangeRecordLifecycleStatus,
      @ObjectModel.readOnly: true
      ChangeRecordStatus,
      //      Customer,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecord
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFMATBSC",
"I_MATERIAL"
],
"ASSOCIATED":
[
"E_CHGRECDREFMATBSC",
"I_CHANGERECORDDRAFTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More