I_CHANGERECDREFSPECTP_2

CDS View

Change Record Reference Object Specification

I_CHANGERECDREFSPECTP_2 is a CDS View in S/4HANA. Change Record Reference Object Specification. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ChangeRecordRefSpecification view_entity from COMPOSITE Specification Assignments to Change Records 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFSPECBSC",
"I_SPECIDFRBSCFORKEYDATE",
"I_SPECIFICATIONNONHISTORIC"
],
"ASSOCIATED":
[
"E_CHGRECDREFSPECBSC",
"I_CHANGERECORDTP_2",
"I_SPECIDFRBSCFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More