I_CHANGERECORDTP_2

CDS View

Change Record API View

I_CHANGERECORDTP_2 is a CDS View in S/4HANA. Change Record API View. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ChangeRecord view_entity from COMPOSITE Change Record Header Data 
@AbapCatalog.sqlViewName: 'ICHGRECORDTP2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Change Record API View'

@Search.searchable: true


// Begin of CHIPPAGIRI changes

// commented for the BDL

//@ObjectModel.writeActiveImplementedBy: 'ABAP:CL_RAP_PLMI_CR'

// End of CHIPPAGIRI Changes

//@ObjectModel: { representativeKey: 'ChangeRecordUUID',

//               transactionalProcessingEnabled: true, //CHIPPAGIRI commented

 //               compositionRoot: true,

 //               createEnabled: true,

  //              deleteEnabled: true,

 //               updateEnabled: true

 //             }

@ObjectModel.representativeKey: 'ChangeRecordUUID'
@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #L}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel.sapObjectNodeType.name: 'ChangeRecord'
define root view I_ChangeRecordTP_2
  as select from I_ChangeRecordBsc
  composition [0..*] of I_ChangeRecordReferenceBOMTP_2 as _ChangeRecordReferenceBOMTP //on _ChangeRecordReferenceBOMTP.ChangeRecordUUID = $projection.ChangeRecordUUID

  composition [0..*] of I_ChangeRecordRefBOMItmTP_2    as _ChangeRecordRefBOMItmTP //   on _ChangeRecordRefBOMItmTP.ChangeRecordUUID = $projection.ChangeRecordUUID

  composition [0..*] of I_ChangeRecordReferenceMatTP_2 as _ChangeRecordReferenceMatTP //       on _ChangeRecordReferenceMatTP.ChangeRecordUUID = $projection.ChangeRecordUUID

  composition [0..*] of I_ChangeRecordReferenceDocTP_2 as _ChangeRecordReferenceDocTP // on _ChangeRecordReferenceDocTP.ChangeRecordUUID = $projection.ChangeRecordUUID

  composition [0..*] of I_ChgRecdRefProdStrucVarTP_2   as _ChangeRecordReferencePSVTP
  composition [0..*] of I_ChangeRecdRefInspPlanTP_2    as _ChangeRecordRefInspPlanTP
  composition [0..*] of I_ChangeRecdRefRecipeTP_2      as _ChangeRecordRefRecipeTP
  composition [0..*] of I_ChangeRecdRefMstrRecipeTP_2  as _ChangeRecordRefMasterRecipeTP
  composition [0..*] of I_ChangeRecdRefSpecTP_2        as _ChangeRecdRefSpecificationTP
  composition [0..*] of I_ChangeRecdRefLabelSetTP_2    as _ChangeRecordRefLabelSetTP
  composition [0..*] of I_ChangeRecdRefProdnRtgTP_2    as _ChangeRecordRefRoutingTP
  composition [0..*] of I_ChangeRecdRefTmplRoutingTP_2 as _ChangeRecordRefTmplRoutingTP
  composition [0..*] of I_ChangeRecdRefClassTP_2       as _ChangeRecordRefClassTP
  composition [0..*] of I_ChangeRecdRefCharcTP_2       as _ChangeRecordRefCharcTP
  composition [0..*] of I_ChgRecdRefEquipTskListTP_2   as _ChangeRecordRefEquipTskListTP
  composition [0..*] of I_ChgRecdFuncLocTskListTP_2    as _ChangeRecordFuncLocTskListTP
  composition [0..*] of I_ChgRecdRefOpSetTskListTP_2   as _ChangeRecordRefOpSetTskListTP
  composition [0..*] of I_ChgRecdRateRtgTskListTP_2    as _ChangeRecordRateRtgTskListTP
  composition [0..*] of I_ChgRecdRefRateRtgTskListTP_2 as _ChgRecdRefRateRtgTskListTP
  composition [0..*] of I_ChgRecdRefCutPlngPrflTP_2    as _ChgRecdCutPlngPrflTskListTP
  composition [0..*] of I_ChgRecdWBSBillOfMatTP_2      as _ChgRecdWBSBillOfMatTP
  composition [0..*] of I_ChgRecdEquipBillOfMatTP_2    as _ChgRecdEquipBillOfMatTP
  composition [0..*] of I_ChgRecdFuncLocBillOfMatTP_2  as _ChgRecdFuncLocBillOfMatTP
  composition [0..*] of I_ChgRecdRefMaintTskListTP_2   as _ChgRecdRefMaintTskListTP
  composition [0..*] of I_ChgRecdRefStdBillOfMatTP_2   as _ChangeRecordRefStdBOMTP
  composition [0..*] of I_ChgRecdVarBillOfMatTP_2      as _ChangeRecordRefVarTP

  association [0..1] to E_ChangeRecordBsc              as _HeaderExtension             on $projection.ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID
  association [0..1] to I_ChgRecordLifecycleStatus     as _ChangeRecordLifeCycleStatus on $projection.ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus
  association [0..1] to I_ChgRecordUserStatus          as _ChangeRecordUserStatus      on $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus
{
  key ChangeRecordUUID,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.9
      @Search.ranking: #HIGH
      ChangeRecord,
      ChangeRecordType,
      ParentChangeRecordUUID,
      RootChangeRecordUUID,
      ChangeRecordCategory,
      ChgRecordApplication,
      ChangeRecordPriority,
      ChangeRecordStatus,
      ChangeRecordDetailDescription,
      ChgRecdExpectedCompletionDate,
      ChangeNumber,
      @Semantics.user.createdBy: true
      CreatedByUser,
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      //LastChangeDateTime,

      case
        when LastChangeDateTime = fltp_to_dec( 0.0 as timestampl )
        then fltp_to_dec( 19720401000000.0 as timestampl )
        else LastChangeDateTime
      end as LastChangeDateTime,
      Partner,
      ChangeRecordLifecycleStatus,
      ChgRecordDescriptionText,
      _ChangeRecordReferenceMatTP,
      _ChangeRecordReferenceBOMTP,
      _ChangeRecordRefBOMItmTP,
      _ChangeRecordReferenceDocTP,
      _ChangeRecordReferencePSVTP,
      _ChangeRecordRefInspPlanTP,
      _ChangeRecordRefRecipeTP,
      _ChangeRecordRefMasterRecipeTP,
      _ChangeRecdRefSpecificationTP,
      _ChangeRecordRefLabelSetTP,
      _ChangeRecordRefRoutingTP,
      _ChangeRecordRefTmplRoutingTP,
      _ChangeRecordRefClassTP,
      _ChangeRecordRefCharcTP,
      _ChangeRecordRefEquipTskListTP,
      _ChangeRecordFuncLocTskListTP,
      _ChangeRecordRefOpSetTskListTP,
      _ChangeRecordRateRtgTskListTP,
      _ChgRecdRefRateRtgTskListTP,
      _ChgRecdCutPlngPrflTskListTP,
      _ChgRecdWBSBillOfMatTP,
      _ChgRecdEquipBillOfMatTP,
      _ChgRecdFuncLocBillOfMatTP,
      _ChgRecdRefMaintTskListTP,
      _ChangeRecordRefStdBOMTP,
      _ChangeRecordRefVarTP,
      _ChangeRecordLifeCycleStatus,
      _ChangeRecordUserStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDBSC"
],
"ASSOCIATED":
[
"E_CHANGERECORDBSC",
"I_CHANGERECDREFCHARCTP_2",
"I_CHANGERECDREFCLASSTP_2",
"I_CHANGERECDREFINSPPLANTP_2",
"I_CHANGERECDREFLABELSETTP_2",
"I_CHANGERECDREFMSTRRECIPETP_2",
"I_CHANGERECDREFPRODNRTGTP_2",
"I_CHANGERECDREFRECIPETP_2",
"I_CHANGERECDREFSPECTP_2",
"I_CHANGERECDREFTMPLROUTINGTP_2",
"I_CHANGERECORDREFBOMITMTP_2",
"I_CHANGERECORDREFERENCEBOMTP_2",
"I_CHANGERECORDREFERENCEDOCTP_2",
"I_CHANGERECORDREFERENCEMATTP_2",
"I_CHGRECDEQUIPBILLOFMATTP_2",
"I_CHGRECDFUNCLOCBILLOFMATTP_2",
"I_CHGRECDFUNCLOCTSKLISTTP_2",
"I_CHGRECDRATERTGTSKLISTTP_2",
"I_CHGRECDREFCUTPLNGPRFLTP_2",
"I_CHGRECDREFEQUIPTSKLISTTP_2",
"I_CHGRECDREFMAINTTSKLISTTP_2",
"I_CHGRECDREFOPSETTSKLISTTP_2",
"I_CHGRECDREFPRODSTRUCVARTP_2",
"I_CHGRECDREFRATERTGTSKLISTTP_2",
"I_CHGRECDREFSTDBILLOFMATTP_2",
"I_CHGRECDVARBILLOFMATTP_2",
"I_CHGRECDWBSBILLOFMATTP_2",
"I_CHGRECORDLIFECYCLESTATUS",
"I_CHGRECORDUSERSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More