I_ChangeRecdRefSpecTP_2

DDL: I_CHANGERECDREFSPECTP_2 SQL: ICHGRECREFSPCTP2 Type: view TRANSACTIONAL

Change Record Reference Object Specification

I_ChangeRecdRefSpecTP_2 is a Transactional CDS View that provides data about "Change Record Reference Object Specification" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefSpecBsc) and exposes 18 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefSpecBsc reference_Spec from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SpecIdfrBscForKeyDate _Identifier $projection.SpecificationInternalID = _Identifier.SpecificationInternalID
[0..1] E_ChgRecdRefSpecBsc _SpecExtension $projection.ChangeRecordReferenceUUID = _SpecExtension.ChangeRecordReferenceUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRECREFSPCTP2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Change Record Reference Object Specification view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
SpecificationInternalID _Specification SpecificationInternalID
SpecIdfgDescText
ChangeRecordUUID ChangeRecordUUID
ChangeRecord ChangeRecord
ChangeRecordReferenceType ChangeRecordReferenceType
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype
ChangeRecordReference ChangeRecordReference
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
IsMainReference IsMainReference
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
_ChangeRecordAPITP _ChangeRecordAPITP 
@AbapCatalog.sqlViewName: 'ICHGRECREFSPCTP2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #D,
     sizeCategory:   #L
   }
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Change Record Reference Object Specification'
define view I_ChangeRecdRefSpecTP_2
  as select from           I_ChgRecdRefSpecBsc        as reference_Spec
    left outer to one join I_SpecificationNonHistoric as _Specification on reference_Spec.ChgRecRefInternalKey1 = _Specification.SpecificationInternalID
  association        to parent I_ChangeRecordTP_2 as _ChangeRecordAPITP on $projection.ChangeRecordUUID = _ChangeRecordAPITP.ChangeRecordUUID
  //association [1..1] to I_ChangeRecordDraftTP     as _ChangeRecord      on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

  association [0..1] to I_SpecIdfrBscForKeyDate   as _Identifier        on $projection.SpecificationInternalID = _Identifier.SpecificationInternalID
  association [0..1] to E_ChgRecdRefSpecBsc       as _SpecExtension     on $projection.ChangeRecordReferenceUUID = _SpecExtension.ChangeRecordReferenceUUID
{
  key ChangeRecordReferenceUUID,
      case when _Specification.Specification is null then cast(ChangeRecordReference as esesubid)
      else cast( _Specification.Specification as esesubid)
      end as Specification,
      _Specification.SpecificationInternalID,

      _Identifier(P_KeyDate : $session.system_date).SpecIdfgDescText,

      ChangeRecordUUID,
      ChangeRecord,
      ChangeRecordReferenceType,
      ChangeRecordReferenceSubtype,
      ChangeRecordReference,
      ParentChangeRecordRefUUID,
      IsMainReference,
      //@Semantics.user.createdBy: true

      CreatedByUser,
      CreationDateTime,
      //@Semantics.user.lastChangedBy: true

      LastChangedByUser,
      LastChangeDateTime,
      //@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'

      ChangeRecordItemRelevance,
      ChangeRecordItemProcgStatus,
      ChangeRecordVirtualRefInd,
      //_ChangeRecordBsc,

      _ChangeRecordAPITP
}

Learn More