I_ChangeRecordReferenceMatTP_2

DDL: I_CHANGERECORDREFERENCEMATTP_2 SQL: ICHGRECREFMATTP2 Type: view TRANSACTIONAL

Change Record Object Reference Material

I_ChangeRecordReferenceMatTP_2 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 18 fields with key field ChangeRecordReferenceUUID. It has 1 association to related views.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_Material Material left_outer
I_ChgRecdRefMatBsc reference_mat from

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECREFMATTP2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Change Record Object Reference Material view
VDM.viewType #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
MaterialasmatnrendasMaterial
_ChangeRecordAPITP _ChangeRecordAPITP
ChangeRecordUUID ChangeRecordUUID
ChangeRecord ChangeRecord
ChangeRecordType ChangeRecordType
ChangeRecordReferenceType ChangeRecordReferenceType
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype
ChangeRecordReference ChangeRecordReference
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
IsMainReference IsMainReference
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 
@AbapCatalog.sqlViewName: 'ICHGRECREFMATTP2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Change Record Object Reference Material'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: { semanticKey: ['Material']
//                writeDraftPersistence: 'PLMCRREFMAT_D',

 //               createEnabled,

//               deleteEnabled,

//                updateEnabled

              }
@AccessControl.personalData.blocking: #NOT_REQUIRED


@ObjectModel.usageType: { serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}

@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

define view I_ChangeRecordReferenceMatTP_2
  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 [1..1] to I_CHANGERECORDBehvTP as _ChangeRecordAPITP on $projection.ChangeRecordUUID = _ChangeRecordAPITP.ChangeRecordUUID

  association        to parent I_ChangeRecordTP_2 as _ChangeRecordAPITP on $projection.ChangeRecordUUID = _ChangeRecordAPITP.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefMatBsc        as _MatExtension      on $projection.ChangeRecordReferenceUUID = _MatExtension.ChangeRecordReferenceUUID

{
  key ChangeRecordReferenceUUID,
      case when Material.Material is null then cast(  ChangeRecordReference  as matnr )
      else cast(  Material.Material  as matnr )
      end as Material,
      _ChangeRecordAPITP,
      ChangeRecordUUID,
      ChangeRecord,
      ChangeRecordType,
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordReference,
      ParentChangeRecordRefUUID,
      IsMainReference,
      @Semantics.user.createdBy: true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      LastChangeDateTime,
      ChangeRecordItemRelevance,
      ChangeRecordVirtualRefInd,
      ChangeRecordItemProcgStatus
      //      Customer,

      //      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]

      //      _ChangeRecord

      //@ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]

      //_ChangeRecordAPITP


};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFMATBSC",
"I_MATERIAL"
],
"ASSOCIATED":
[
"E_CHGRECDREFMATBSC",
"I_CHANGERECORDTP_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More