C_ChangeRecordObjPg

DDL: C_CHANGERECORDOBJPG SQL: CCHGRECTP Type: view CONSUMPTION

Administrative Data

C_ChangeRecordObjPg is a Consumption CDS View that provides data about "Administrative Data" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordDraftTP) and exposes 32 fields. It has 65 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordDraftTP Document from

Associations (65)

CardinalityTargetAliasCondition
[0..1] C_ChangeRecordTypeVH _ChangeRecordTypeVH $projection.ChangeRecordType = _ChangeRecordTypeVH.ChangeRecordType and $projection.ChangeRecordCategory = _ChangeRecordTypeVH.ChangeRecordCategory
[0..1] C_ChangeRecordTypeVH _ChangeRecordType $projection.ChangeRecordType = _ChangeRecordType.ChangeRecordType
[0..1] I_ChangeRecordAccCtrlCntxtVH _AccVH _AccVH.LogAccMContext = $projection.AccessControlContext
[1..1] C_ChangeRecdStatusVH _UserStatusVH $projection.ChangeRecordStatus = _UserStatusVH.ChangeRecordStatus
[0..*] C_ChangeRecordNextStatusVH _ChangeRecordNextStatusVH $projection.ChangeRecordType = _ChangeRecordNextStatusVH.ChangeRecordType and $projection.ChangeRecordStatus = _ChangeRecordNextStatusVH.ChangeRecordStatus
[0..1] I_ChangeRecordContactPerson _ChangeRecordContactPerson $projection.Partner = _ChangeRecordContactPerson.Partner
[0..1] I_ChgRecLifecycleStatusTxt _LifeCycleStatusText $projection.ChangeRecordLifecycleStatus = _LifeCycleStatusText.ChangeRecordLifecycleStatus
[0..*] C_ChangeRecdDigSignStatusVH _DigSignStatusText $projection.ChgRecdDigitalSignatureStatus = _DigSignStatusText.ChgRecdDigitalSignatureStatus
[0..1] I_ChgRecdUserStatusActionTxt _PendingActionText $projection.ChgRecdInitiatedStatusAction = _PendingActionText.ChgRecdInitiatedStatusAction and _PendingActionText.Language = $session.system_language
[0..*] C_ChangeRecordObjPgMatl _ChangeRecordReferenceMatTP $projection.ChangeRecordUUID = _ChangeRecordReferenceMatTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgBOM _ChangeRecordReferenceBOMTP $projection.ChangeRecordUUID = _ChangeRecordReferenceBOMTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgBOMItm _ChangeRecordRefBOMItmTP $projection.ChangeRecordUUID = _ChangeRecordRefBOMItmTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgEngBOM _ChgRecdRefEngBOMTP $projection.ChangeRecordUUID = _ChgRecdRefEngBOMTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgMfgBOM _ChgRecdRefMfgBOMTP $projection.ChangeRecordUUID = _ChgRecdRefMfgBOMTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgPurOrd _ChgRecdRefPurOrdTP $projection.ChangeRecordUUID = _ChgRecdRefPurOrdTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgProdnOrd _ChgRecdRefProdnOrdTP $projection.ChangeRecordUUID = _ChgRecdRefProdnOrdTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgPlngScp _ChgRecdRefPlngScpTP $projection.ChangeRecordUUID = _ChgRecdRefPlngScpTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgRouting _ChgRecdRefRoutingTP $projection.ChangeRecordUUID = _ChgRecdRefRoutingTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgOrdSpcfcRtg _ChgRecdRefOrdSpcfcRoutingTP $projection.ChangeRecordUUID = _ChgRecdRefOrdSpcfcRoutingTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgDoc _ChangeRecordReferenceDocTP $projection.ChangeRecordUUID = _ChangeRecordReferenceDocTP.ChangeRecordUUID
[0..*] C_ChgRecdObjPgProdStrucVar _ChgRecdRefProdStrucVarTP $projection.ChangeRecordUUID = _ChgRecdRefProdStrucVarTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgSpec _ChangeRecordReferenceSpecTP $projection.ChangeRecordUUID = _ChangeRecordReferenceSpecTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgEngSnpsht _ChgRecdRefEngSnpshtTP $projection.ChangeRecordUUID = _ChgRecdRefEngSnpshtTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgMasterRcp _ChgRecdRefMasterRecipeTP $projection.ChangeRecordUUID = _ChgRecdRefMasterRecipeTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgInspPlan _ChgRecdRefInspectionPlanTP $projection.ChangeRecordUUID = _ChgRecdRefInspectionPlanTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgRecipe _ChgRecdRefRecipeTP $projection.ChangeRecordUUID = _ChgRecdRefRecipeTP.ChangeRecordUUID
[0..*] C_ChangeRecdObjPgProdnRouting _ChgRecdRefProdnRoutingTP $projection.ChangeRecordUUID = _ChgRecdRefProdnRoutingTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgLabel _ChgRecdRefLabelTP $projection.ChangeRecordUUID = _ChgRecdRefLabelTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgPlngRouting _ChgRecdRefPlngRoutingTP $projection.ChangeRecordUUID = _ChgRecdRefPlngRoutingTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgTmplRouting _ChgRecdRefTmplRoutingTP $projection.ChangeRecordUUID = _ChgRecdRefTmplRoutingTP.ChangeRecordUUID
[0..*] C_ChgRecdObjPgMaintTskList _ChgRecdRefMaintTskListTP $projection.ChangeRecordUUID = _ChgRecdRefMaintTskListTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgMfgSnpsht _ChgRecdRefMfgSnpshtTP $projection.ChangeRecordUUID = _ChgRecdRefMfgSnpshtTP.ChangeRecordUUID
[0..1] I_ChangeMaster _ChangeMaster $projection.ChangeNumber = _ChangeMaster.ChangeNumber
[0..1] C_ChgRecdRefObjVisibility _ChgRecdRefObjVib $projection.ChangeRecordType = _ChgRecdRefObjVib.ChangeRecordType
[0..1] I_IssActyMgmtUserStatus1 _IssActyMgmtUserStatus $projection.ChangeRecordStatus = _IssActyMgmtUserStatus.IssActyMgmtUserStatus1
[0..*] C_ChangeRecordStatusProgress _ChangeRecordStatusProgress $projection.ChangeRecordUUID = _ChangeRecordStatusProgress.ChangeRecordUUID
[0..1] I_ChgRecdStatusColorConfign _ChangeRecordStatusColor $projection.ChangeRecordStatus = _ChangeRecordStatusColor.ChangeRecordStatus and $projection.ChangeRecordType = _ChangeRecordStatusColor.ChangeRecordType
[0..*] C_ChangeRecordItemCount _ChangeRecordItemCount $projection.ChangeRecordUUID = _ChangeRecordItemCount.ParentChangeRecordUUID
[0..*] C_ChgRecdImpMgmtNavy _ChangeRecordImpNavigation $projection.ChangeRecordType = _ChangeRecordImpNavigation.ChangeRecordType
[0..*] C_ChgRecdCmntTop _ChgRecdCmntTopTP $projection.ChangeRecordUUID = _ChgRecdCmntTopTP.ChangeRecordUUID
[0..*] C_ChgRecdObjRefCmntTop _ChgRecdObjRefCmntTopTP $projection.ChangeRecordUUID = _ChgRecdObjRefCmntTopTP.ChangeRecordUUID
[0..*] C_ChangeRecordChildTP _ChgRecdChildTP _ChgRecdChildTP.ParentChangeRecordUUID = $projection.ChangeRecordUUID
[0..1] C_ChgRecordChildVH _ChgRecordChildVH _ChgRecordChildVH.ChangeRecordUUID = $projection.ChangeRecordUUID
[0..1] C_ChgRecordChildVH _ChgRecordChildIsMerge _ChgRecordChildIsMerge.ChangeRecordUUID = $projection.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgClfn _ChangeRecordObjPgClfn $projection.ChangeRecordUUID = _ChangeRecordObjPgClfn.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgOrderBOM _ChangeRecordRefOrderBOMTP $projection.ChangeRecordUUID = _ChangeRecordRefOrderBOMTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgCharc _ChangeRecordRefCharcTP $projection.ChangeRecordUUID = _ChangeRecordRefCharcTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgClass _ChangeRecordRefClassTP $projection.ChangeRecordUUID = _ChangeRecordRefClassTP.ChangeRecordUUID
[0..*] C_ChgRecdRefStdBOM _ChangeRecordRefStdBOMTP $projection.ChangeRecordUUID = _ChangeRecordRefStdBOMTP.ChangeRecordUUID
[0..*] C_ChgRecdObjPgEquipTskList _ChgRecdRefEquipTskListTP $projection.ChangeRecordUUID = _ChgRecdRefEquipTskListTP.ChangeRecordUUID
[0..*] C_ChgRecdRefWBSElmntBOM _ChangeRecordRefWBSElmntBOMTP $projection.ChangeRecordUUID = _ChangeRecordRefWBSElmntBOMTP.ChangeRecordUUID
[0..*] C_ChgRecdRefEquipBOM _ChgRecdRefEquipBOMTP $projection.ChangeRecordUUID = _ChgRecdRefEquipBOMTP.ChangeRecordUUID
[0..*] C_ChgRecdRefRateRtgTskList _ChgRecdRefRateRtgTskListTP $projection.ChangeRecordUUID = _ChgRecdRefRateRtgTskListTP.ChangeRecordUUID
[0..*] C_ChgRecdObjRateRtgTskList _ChgRecdRateRtgTskListTP $projection.ChangeRecordUUID = _ChgRecdRateRtgTskListTP.ChangeRecordUUID
[0..*] C_ChgRecdRefCutPlngPrfl _ChgRecdRefCutPlngPrflTP $projection.ChangeRecordUUID = _ChgRecdRefCutPlngPrflTP.ChangeRecordUUID
[0..*] C_ChgRecdRefOpSetTskList _ChgRecdRefOpSetTskListTP $projection.ChangeRecordUUID = _ChgRecdRefOpSetTskListTP.ChangeRecordUUID
[0..*] C_ChgRecdFuncLocTskList _ChgRecdFuncLocTskListTP $projection.ChangeRecordUUID = _ChgRecdFuncLocTskListTP.ChangeRecordUUID
[0..*] C_ChgRecdRefFuncLocBOM _ChgRecdRefFuncLocBOMTP $projection.ChangeRecordUUID = _ChgRecdRefFuncLocBOMTP.ChangeRecordUUID
[0..*] C_ChgRecdRefVarBOM _ChgRecdRefVarBOMTP $projection.ChangeRecordUUID = _ChgRecdRefVarBOMTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgETOVersBOM _ChgRecdRefETOVersBOMTP $projection.ChangeRecordUUID = _ChgRecdRefETOVersBOMTP.ChangeRecordUUID
[0..*] C_ChangeRecordObjPgDefect _ChgRecdRefDefectTP $projection.ChangeRecordUUID = _ChgRecdRefDefectTP.ChangeRecordUUID
[1..1] C_ChangeRecordDetPg _ChangeRecordDetPg $projection.ChangeRecordUUID = _ChangeRecordDetPg.ChangeRecordUUID
[0..1] I_ChgRecChildTP _ChangeRecordParent $projection.ChangeRecordUUID = _ChangeRecordParent.ChangeRecordUUID
[0..*] C_ChgRecdObjPgEngCollabn _ChgRecdObjPgEngCollabn $projection.ChangeRecordUUID = _ChgRecdObjPgEngCollabn.ChangeRecordUUID
[0..*] C_ChgRecdPLMEPDCollabn _ChgRecdObjPgPLMEPDCollabn $projection.ChangeRecordUUID = _ChgRecdObjPgPLMEPDCollabn.ChangeRecordUUID

Annotations (24)

NameValueLevelField
AbapCatalog.sqlViewName CCHGRECTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Administrative Data view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.draftEnabled true view
UI.headerInfo.typeName Change Record view
UI.headerInfo.typeNamePlural Change Records view
UI.headerInfo.title.value ChgRecordDescriptionText view
UI.headerInfo.description.value ChangeRecord view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
Consumption.semanticObject ChangeRecord view

Fields (32)

KeyFieldSource TableSource FieldDescription
ChangeRecordUUID
ChangeRecord ChangeRecord
ChangeRecordCategory
ChgRecordIsUsingProcessRoute
ChgRecordIsUsingCollaboration
ChgRecdCollaborationIsHidden
ChgRecdItemProcgStatusIsEnbld
ChgRecdIsProdnEngOpsRlvt
ChangeRecordPurposeType
ChangeRecordType I_ChangeRecordDraftTP ChangeRecordType
ChangeRecordTypeDesc
ParentChangeRecordUUID I_ChangeRecordDraftTP ParentChangeRecordUUID
RootChangeRecordUUID I_ChangeRecordDraftTP RootChangeRecordUUID
ParentObjectUUID _ChangeRecordParent ParentChangeRecordUUID
ParentChangeRecord _ChangeRecordParent ParentChangeRecord Parent Change Record
ParentChgRecordDescriptionText _ChangeRecordParent ParentChgRecordDescriptionText Parent Change Record Text
RootChangeRecord Root Change Record
RootChangeRecordTxt
ChgRecordDescriptionText I_ChangeRecordDraftTP ChgRecordDescriptionText Description
ChangeRecordStatus I_ChangeRecordDraftTP ChangeRecordStatus
ChangeRecordStatusDescription _UserStatusVH ChangeRecordStatusDescription Record Status Description
ChangeRecordStatusColor _ChangeRecordStatusColor ChangeRecordStatusColor
ChangeNumber I_ChangeRecordDraftTP ChangeNumber
AccessControlContext I_ChangeRecordDraftTP AccessControlContext
ChangeNumberStatus _ChangeMaster ChangeNumberStatus
ChangeNumberValidFromDate _ChangeMaster ChangeNumberValidFromDate
CreatedByUser I_ChangeRecordDraftTP CreatedByUser
CreatedByUserFullName _CreatedByUserContactCard FullName Created By User Full Name
CreationDateTime I_ChangeRecordDraftTP CreationDateTime Created On
CreationDate
LastChangedByUser I_ChangeRecordDraftTP LastChangedByUser
LastChangedByUserFullName _LastChangedByUserContactCard FullName Changed By User Full Name
@AbapCatalog.sqlViewName: 'CCHGRECTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.privilegedAssociations: ['_CreatedByUserContactCard', '_LastChangedByUserContactCard']
@EndUserText.label: 'Administrative Data'//Please DON'T change this label, this label will show in UI

@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
    transactionalProcessingDelegated: true,
    compositionRoot: true,
    createEnabled: true,
    deleteEnabled:'EXTERNAL_CALCULATION',
    updateEnabled: 'EXTERNAL_CALCULATION',
    draftEnabled: true,
    semanticKey: ['ChangeRecord']
}


@UI.headerInfo:{
  typeName: 'Change Record',
  typeNamePlural: 'Change Records',
  title:  { value: 'ChgRecordDescriptionText' },
  description: {value: 'ChangeRecord'}
}

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

@Search.searchable: true
@Consumption.semanticObject: 'ChangeRecord'
@UI.presentationVariant:[{
    sortOrder.by:'LastChangeDateTime',
    sortOrder.direction: #DESC,
    requestAtLeast:'ChangeNumberValidFromDate'
}]//add

 
define view C_ChangeRecordObjPg
  as select from I_ChangeRecordDraftTP as Document

  association [0..1] to C_ChangeRecordTypeVH           as _ChangeRecordTypeVH           on  $projection.ChangeRecordType     = _ChangeRecordTypeVH.ChangeRecordType
                                                                                        and $projection.ChangeRecordCategory = _ChangeRecordTypeVH.ChangeRecordCategory
  association [0..1] to C_ChangeRecordTypeVH           as _ChangeRecordType             on  $projection.ChangeRecordType = _ChangeRecordType.ChangeRecordType
  association [0..1] to I_ChangeRecordAccCtrlCntxtVH   as _AccVH                        on  _AccVH.LogAccMContext = $projection.AccessControlContext
  //association [0..1] to C_UserStatusVH                 as _UserStatusVH                on  $projection.ChangeRecordType     = _UserStatusVH.ChangeRecordType 

  //                                                                                     and $projection.ChangeRecordStatus   = _UserStatusVH.ChangeRecordStatus

  //                                                                                     and $projection.ChangeRecordCategory = _UserStatusVH.ChangeRecordCategory

  association [1..1] to C_ChangeRecdStatusVH           as _UserStatusVH                 on  $projection.ChangeRecordStatus = _UserStatusVH.ChangeRecordStatus
  association [0..*] to C_ChangeRecordNextStatusVH     as _ChangeRecordNextStatusVH     on  $projection.ChangeRecordType   = _ChangeRecordNextStatusVH.ChangeRecordType
                                                                                        and $projection.ChangeRecordStatus = _ChangeRecordNextStatusVH.ChangeRecordStatus
  association [0..1] to I_ChangeRecordContactPerson    as _ChangeRecordContactPerson    on  $projection.Partner = _ChangeRecordContactPerson.Partner
  association [0..1] to I_ChgRecLifecycleStatusTxt     as _LifeCycleStatusText          on  $projection.ChangeRecordLifecycleStatus = _LifeCycleStatusText.ChangeRecordLifecycleStatus

  // association [0..1] to I_ChgRecdDigSignStatusTxt    as _DigSignStatusText           on  $projection.ChgRecdDigitalSignatureStatus = _DigSignStatusText.ChgRecdDigitalSignatureStatus

  association [0..*] to C_ChangeRecdDigSignStatusVH    as _DigSignStatusText            on  $projection.ChgRecdDigitalSignatureStatus = _DigSignStatusText.ChgRecdDigitalSignatureStatus
  association [0..1] to I_ChgRecdUserStatusActionTxt   as _PendingActionText            on  $projection.ChgRecdInitiatedStatusAction = _PendingActionText.ChgRecdInitiatedStatusAction
                                                                                        and _PendingActionText.Language              = $session.system_language
  //  association [0..1] to I_ChgRecordPartnerVH        as _ChangeRecordPartnerVH      on  $projection.Partner = _ChangeRecordPartnerVH.Partner

  association [0..*] to C_ChangeRecordObjPgMatl        as _ChangeRecordReferenceMatTP   on  $projection.ChangeRecordUUID = _ChangeRecordReferenceMatTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgBOM         as _ChangeRecordReferenceBOMTP   on  $projection.ChangeRecordUUID = _ChangeRecordReferenceBOMTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgBOMItm      as _ChangeRecordRefBOMItmTP      on  $projection.ChangeRecordUUID = _ChangeRecordRefBOMItmTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgEngBOM      as _ChgRecdRefEngBOMTP           on  $projection.ChangeRecordUUID = _ChgRecdRefEngBOMTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgMfgBOM      as _ChgRecdRefMfgBOMTP           on  $projection.ChangeRecordUUID = _ChgRecdRefMfgBOMTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgPurOrd      as _ChgRecdRefPurOrdTP           on  $projection.ChangeRecordUUID = _ChgRecdRefPurOrdTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgProdnOrd    as _ChgRecdRefProdnOrdTP         on  $projection.ChangeRecordUUID = _ChgRecdRefProdnOrdTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgPlngScp     as _ChgRecdRefPlngScpTP          on  $projection.ChangeRecordUUID = _ChgRecdRefPlngScpTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgRouting     as _ChgRecdRefRoutingTP          on  $projection.ChangeRecordUUID = _ChgRecdRefRoutingTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgOrdSpcfcRtg as _ChgRecdRefOrdSpcfcRoutingTP  on  $projection.ChangeRecordUUID = _ChgRecdRefOrdSpcfcRoutingTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgDoc         as _ChangeRecordReferenceDocTP   on  $projection.ChangeRecordUUID = _ChangeRecordReferenceDocTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjPgProdStrucVar     as _ChgRecdRefProdStrucVarTP     on  $projection.ChangeRecordUUID = _ChgRecdRefProdStrucVarTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgSpec        as _ChangeRecordReferenceSpecTP  on  $projection.ChangeRecordUUID = _ChangeRecordReferenceSpecTP.ChangeRecordUUID
  //association [0..*] to C_ChangeRecordObjectLink       as _ChangeRecordObjectLinkTP    on  $projection.ChangeRecordUUID = _ChangeRecordObjectLinkTP.ChangeRecordUUID

  association [0..*] to C_ChangeRecordObjPgEngSnpsht   as _ChgRecdRefEngSnpshtTP        on  $projection.ChangeRecordUUID = _ChgRecdRefEngSnpshtTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgMasterRcp   as _ChgRecdRefMasterRecipeTP     on  $projection.ChangeRecordUUID = _ChgRecdRefMasterRecipeTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgInspPlan    as _ChgRecdRefInspectionPlanTP   on  $projection.ChangeRecordUUID = _ChgRecdRefInspectionPlanTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgRecipe      as _ChgRecdRefRecipeTP           on  $projection.ChangeRecordUUID = _ChgRecdRefRecipeTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecdObjPgProdnRouting  as _ChgRecdRefProdnRoutingTP     on  $projection.ChangeRecordUUID = _ChgRecdRefProdnRoutingTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgLabel       as _ChgRecdRefLabelTP            on  $projection.ChangeRecordUUID = _ChgRecdRefLabelTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgPlngRouting as _ChgRecdRefPlngRoutingTP      on  $projection.ChangeRecordUUID = _ChgRecdRefPlngRoutingTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgTmplRouting as _ChgRecdRefTmplRoutingTP      on  $projection.ChangeRecordUUID = _ChgRecdRefTmplRoutingTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjPgMaintTskList     as _ChgRecdRefMaintTskListTP     on  $projection.ChangeRecordUUID = _ChgRecdRefMaintTskListTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgMfgSnpsht   as _ChgRecdRefMfgSnpshtTP        on  $projection.ChangeRecordUUID = _ChgRecdRefMfgSnpshtTP.ChangeRecordUUID
  association [0..1] to I_ChangeMaster                 as _ChangeMaster                 on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber
  association [0..1] to C_ChgRecdRefObjVisibility      as _ChgRecdRefObjVib             on  $projection.ChangeRecordType = _ChgRecdRefObjVib.ChangeRecordType

  association [0..1] to I_IssActyMgmtUserStatus1       as _IssActyMgmtUserStatus        on  $projection.ChangeRecordStatus = _IssActyMgmtUserStatus.IssActyMgmtUserStatus1
  association [0..*] to C_ChangeRecordStatusProgress   as _ChangeRecordStatusProgress   on  $projection.ChangeRecordUUID = _ChangeRecordStatusProgress.ChangeRecordUUID
  association [0..1] to I_ChgRecdStatusColorConfign    as _ChangeRecordStatusColor      on  $projection.ChangeRecordStatus = _ChangeRecordStatusColor.ChangeRecordStatus
                                                                                        and $projection.ChangeRecordType   = _ChangeRecordStatusColor.ChangeRecordType
  association [0..*] to C_ChangeRecordItemCount        as _ChangeRecordItemCount        on  $projection.ChangeRecordUUID = _ChangeRecordItemCount.ParentChangeRecordUUID

  association [0..*] to C_ChgRecdImpMgmtNavy           as _ChangeRecordImpNavigation    on  $projection.ChangeRecordType = _ChangeRecordImpNavigation.ChangeRecordType
  association [0..*] to C_ChgRecdCmntTop               as _ChgRecdCmntTopTP             on  $projection.ChangeRecordUUID = _ChgRecdCmntTopTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjRefCmntTop         as _ChgRecdObjRefCmntTopTP       on  $projection.ChangeRecordUUID = _ChgRecdObjRefCmntTopTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordChildTP          as _ChgRecdChildTP               on  _ChgRecdChildTP.ParentChangeRecordUUID = $projection.ChangeRecordUUID
  association [0..1] to C_ChgRecordChildVH             as _ChgRecordChildVH             on  _ChgRecordChildVH.ChangeRecordUUID = $projection.ChangeRecordUUID
  association [0..1] to C_ChgRecordChildVH             as _ChgRecordChildIsMerge        on  _ChgRecordChildIsMerge.ChangeRecordUUID = $projection.ChangeRecordUUID

  //association [0..1] to I_UserContactCard              as _UserContactCard             on  $projection.CreatedByUser = _UserContactCard.ContactCardID

  //association [0..1] to I_UserContactCard              as _ChangedByUser               on  $projection.LastChangedByUser = _ChangedByUser.ContactCardID


  association [0..*] to C_ChangeRecordObjPgClfn        as _ChangeRecordObjPgClfn        on  $projection.ChangeRecordUUID = _ChangeRecordObjPgClfn.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgOrderBOM    as _ChangeRecordRefOrderBOMTP    on  $projection.ChangeRecordUUID = _ChangeRecordRefOrderBOMTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgCharc       as _ChangeRecordRefCharcTP       on  $projection.ChangeRecordUUID = _ChangeRecordRefCharcTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgClass       as _ChangeRecordRefClassTP       on  $projection.ChangeRecordUUID = _ChangeRecordRefClassTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefStdBOM             as _ChangeRecordRefStdBOMTP      on  $projection.ChangeRecordUUID = _ChangeRecordRefStdBOMTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjPgEquipTskList     as _ChgRecdRefEquipTskListTP     on  $projection.ChangeRecordUUID = _ChgRecdRefEquipTskListTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefWBSElmntBOM        as _ChangeRecordRefWBSElmntBOMTP on  $projection.ChangeRecordUUID = _ChangeRecordRefWBSElmntBOMTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefEquipBOM           as _ChgRecdRefEquipBOMTP         on  $projection.ChangeRecordUUID = _ChgRecdRefEquipBOMTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefRateRtgTskList     as _ChgRecdRefRateRtgTskListTP   on  $projection.ChangeRecordUUID = _ChgRecdRefRateRtgTskListTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjRateRtgTskList     as _ChgRecdRateRtgTskListTP      on  $projection.ChangeRecordUUID = _ChgRecdRateRtgTskListTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefCutPlngPrfl        as _ChgRecdRefCutPlngPrflTP      on  $projection.ChangeRecordUUID = _ChgRecdRefCutPlngPrflTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefOpSetTskList       as _ChgRecdRefOpSetTskListTP     on  $projection.ChangeRecordUUID = _ChgRecdRefOpSetTskListTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdFuncLocTskList        as _ChgRecdFuncLocTskListTP      on  $projection.ChangeRecordUUID = _ChgRecdFuncLocTskListTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefFuncLocBOM         as _ChgRecdRefFuncLocBOMTP       on  $projection.ChangeRecordUUID = _ChgRecdRefFuncLocBOMTP.ChangeRecordUUID
  association [0..*] to C_ChgRecdRefVarBOM             as _ChgRecdRefVarBOMTP           on  $projection.ChangeRecordUUID = _ChgRecdRefVarBOMTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgETOVersBOM  as _ChgRecdRefETOVersBOMTP       on  $projection.ChangeRecordUUID = _ChgRecdRefETOVersBOMTP.ChangeRecordUUID
  association [0..*] to C_ChangeRecordObjPgDefect      as _ChgRecdRefDefectTP           on  $projection.ChangeRecordUUID = _ChgRecdRefDefectTP.ChangeRecordUUID  
  //association [0..*] to C_ChgRecdChildRootHierNode     as _ChgRecdChildRootHierNode      on  $projection.ChangeRecord = _ChgRecdChildRootHierNode.ChangeRecord

  association [1..1] to C_ChangeRecordDetPg            as _ChangeRecordDetPg            on  $projection.ChangeRecordUUID = _ChangeRecordDetPg.ChangeRecordUUID
  //Parent and root CR

  association [0..1] to I_ChgRecChildTP                as _ChangeRecordParent           on  $projection.ChangeRecordUUID = _ChangeRecordParent.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjPgEngCollabn       as _ChgRecdObjPgEngCollabn       on  $projection.ChangeRecordUUID = _ChgRecdObjPgEngCollabn.ChangeRecordUUID
  association [0..*] to C_ChgRecdPLMEPDCollabn         as _ChgRecdObjPgPLMEPDCollabn    on  $projection.ChangeRecordUUID = _ChgRecdObjPgPLMEPDCollabn.ChangeRecordUUID
  //  association[0..1] to I_ChangeRecordDescription as _ChgRecdText on $projection.ChangeRecordUUID = _ChgRecdText.ChangeRecordUUID

 
{
       --------------------------------------------
       //      @UI.facet: [

       //        ----HeaderFacets

       //        {purpose: #HEADER, type: #FIELDGROUP_REFERENCE, position: 10, targetQualifier: 'ChangeRecord'},

       //        {purpose: #HEADER, type: #FIELDGROUP_REFERENCE, position: 20, targetQualifier: 'ChangeNumber'},

       //        {purpose: #HEADER, type: #FIELDGROUP_REFERENCE, position: 30, targetQualifier: 'LifeCycle'},

       //        ----Facets: Items

       //        {type: #COLLECTION, position: 10, id: 'Items', label: 'Items'},

       //            ------DOC

       //        {type: #COLLECTION, position: 10, id: 'Document', parentId: 'Items', label: 'Document'},

       //        {type: #LINEITEM_REFERENCE, position: 10, id: 'DOCRef', parentId: 'Document', targetElement: '_ChangeRecordReferenceDocTP'},

       //            ------MAT

       //        {type: #COLLECTION, position: 20, id: 'Material', parentId: 'Items', label: 'Material'},

       //        {type: #LINEITEM_REFERENCE, position: 10, id: 'MATRef', parentId: 'Material', targetElement: '_ChangeRecordReferenceMatTP'},

       //            ------BOM

       //        {type: #COLLECTION, position: 30, id: 'BOM', parentId: 'Items', label: 'Material BOM'},

       //        {type: #LINEITEM_REFERENCE, position: 10, id: 'BOMRef', parentId: 'BOM', targetElement: '_ChangeRecordReferenceBOMTP'},

       //            ------BIT

       //        {type: #COLLECTION, position: 40, id: 'BIT', parentId: 'Items', label: 'Material BOM Item'},

       //        {type: #LINEITEM_REFERENCE, position: 10, id: 'BITRef', parentId: 'BIT', targetElement: '_ChangeRecordReferenceBITTP'},

       //        ----Facets: Attachments

       //        {type: #COLLECTION, position: 10, id: 'Attachments', label: 'Attachments'}

       //      ]

       --------------------------------------------
       @UI.facet: [
             {id:'CUSTOMFIELD', type: #FIELDGROUP_REFERENCE, position:10,  purpose:#FILTER, targetQualifier:'ChangeRecord', label: 'Change Record'}
            // {id:'idAdminData', type: #FIELDGROUP_REFERENCE, position:20,  purpose:#HEADER,parentId: 'idDetailDescription',targetQualifier: 'AdminData',label : 'Admin Data'}

        ]

       @UI.selectionField.exclude: true
       @UI.hidden: true
       //       @UI.identification:[

       //        {type: #FOR_ACTION, position: 10, dataAction: 'BOPF:START_WORKFLOW',  label: 'Start Workflow', importance: #HIGH}

       //         ]



  key  Document.ChangeRecordUUID,
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.9
       @Search.ranking: #HIGH
       @UI.lineItem:{
                  position:10,
                  importance:#HIGH
                }
       @ObjectModel.text.element: 'ChgRecordDescriptionText'
//       @Consumption.valueHelpDefinition: [{ entity: { element: 'ChangeRecord',

//                                                         name: 'C_ChangeRecordRootVH' } }]

       @UI.selectionField.position: 50
       @Consumption.semanticObject: 'ChangeRecord'
       ChangeRecord,

       @Consumption.filter.hidden: true
       @ObjectModel.readOnly: true
       @Search.defaultSearchElement: true
       @UI.selectionField.position: 10
       @ObjectModel.foreignKey.association: '_ChangeRecordTypeVH'
       @Consumption: { valueHelp: '_ChangeRecordTypeVH' }
       Document._ChangeRecordCategory.ChangeRecordCategory                        as ChangeRecordCategory,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       Document._ChangeRecordCategory.ChgRecordIsUsingProcessRoute                as ChgRecordIsUsingProcessRoute,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       Document._ChangeRecordCategory.ChgRecordIsUsingCollaboration               as ChgRecordIsUsingCollaboration,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       Document._ChangeRecordCategory.ChgRecdCollaborationIsHidden,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       Document._ChangeRecordCategory.ChgRecdItemProcgStatusIsEnbld               as ChgRecdItemProcgStatusIsEnbld,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       Document._ChangeRecordCategory.ChgRecdIsProdnEngOpsRlvt                    as ChgRecdIsProdnEngOpsRlvt,
       
       @ObjectModel.readOnly: true
       @UI.hidden: true
       Document._ChangeRecordCategory.ChangeRecordPurposeType                     as ChangeRecordPurposeType,       

       @UI.selectionField.position: 20
       @UI.fieldGroup:     { qualifier: 'ChangeRecord', position: 10, importance: #HIGH }
       @UI.lineItem:{
                      position:30
                    }
       @Search:      { defaultSearchElement: true}
       //       @ObjectModel.mandatory: true

       @ObjectModel.foreignKey.association: '_ChangeRecordTypeVH'

       @Consumption: { valueHelp: '_ChangeRecordTypeVH' }
       @ObjectModel.readOnly:'EXTERNAL_CALCULATION'
       //       @ObjectModel.readOnly:true

       @ObjectModel.text.element: [ 'ChangeRecordTypeDesc' ]
       Document.ChangeRecordType,

       @ObjectModel.readOnly: true
       Document._ChangeRecordCategory.ChangeRecordTypeDesc,


       //       @UI.selectionField.position: 10

       //       @ObjectModel.foreignKey.association: '_ChangeRecordTypeCreateVH'

       //       @Consumption: { valueHelp: '_ChangeRecordTypeCreateVH' }

       //       Document.ChangeRecordType as ChangeRecordTypeCreate,


       @UI.hidden: true
       Document.ParentChangeRecordUUID,
       @UI.hidden: true
       Document.RootChangeRecordUUID,
       @UI.hidden: true
       @ObjectModel.readOnly: true
       _ChangeRecordParent.ParentChangeRecordUUID                                 as ParentObjectUUID,
       @Consumption.valueHelpDefinition: [{ entity: { element: 'ParentChangeRecord',
                                            name: 'C_ChangeRecordParentVH' } , additionalBinding: [{ element: 'ChangeRecordUUID',
                                            localElement: 'ChangeRecordUUID' }] }]
       @ObjectModel.readOnly: true
       @EndUserText.label: 'Parent Change Record'
       @Search:      { fuzzinessThreshold: 0.8 , ranking: #LOW}
       _ChangeRecordParent.ParentChangeRecord                                     as ParentChangeRecord,
       @UI.hidden: true
       @ObjectModel.readOnly: true
       @EndUserText.label: 'Parent Change Record Text'
       _ChangeRecordParent.ParentChgRecordDescriptionText,
       @EndUserText.label: 'Root Change Record'
       @Consumption.valueHelpDefinition: [{ entity: { element: 'ChangeRecord',
                                                         name: 'C_ChangeRecordRootVH' } }]
       @UI.selectionField.position: 60
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement : true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CALCULATE_ROOT_RECORD'
       @ObjectModel.filter.transformedBy: 'ABAP:CL_CR_CALCULATE_ROOT_RECORD'
       @ObjectModel.text.element: ['RootChangeRecordTxt']
       @UI.lineItem: [
       {type: #FOR_INTENT_BASED_NAVIGATION, semanticObjectAction: 'manage', label: 'Root Change Record', importance:#HIGH} ]
       @Consumption.semanticObject: 'ChangeRecord'
       cast ('                    ' as /plmb/cr_id )                              as RootChangeRecord,
       @ObjectModel.readOnly: true
       @ObjectModel.virtualElement : true
       @UI.hidden: true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CALCULATE_ROOT_RECORD'
       cast ('                                        ' as /iam/issue_type_desc ) as RootChangeRecordTxt,


       //       @Semantics.text: true

       @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8  ,  ranking: #LOW}
       @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
       @EndUserText.label: 'Description'
       Document.ChgRecordDescriptionText,
       @UI.selectionField.position: 30
       // @UI.fieldGroup:     { qualifier: 'ChangeStatus', position: 10, importance: #HIGH }

       @UI.fieldGroup: { qualifier: 'ChangeNumber', position: 20 ,hidden: true }
       @UI.lineItem:{
                   position:40
                   }
       @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8 , ranking: #LOW}
       @ObjectModel.readOnly: true
       @Consumption: { valueHelp: '_UserStatusVH' }
       @ObjectModel.foreignKey.association: '_UserStatusVH'
       //             @ObjectModel.text.element:  [ 'ChangeRecordStatusDescription' ]

       Document.ChangeRecordStatus,
       @ObjectModel.readOnly: true
       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'C_ChangeRecdStatusVH',
                      element: 'ChangeRecordStatusDescription' }
         }]
       @EndUserText.label: 'Record Status Description'
       _UserStatusVH.ChangeRecordStatusDescription,
       @ObjectModel.readOnly: true
       @UI.hidden: true
       _ChangeRecordStatusColor.ChangeRecordStatusColor,
       //@ObjectModel.readOnly: true

       //@UI.hidden: true

       //_UserStatusVH.ChangeRecordStatusDescription as ChangeRecordStatusDescription,

       @UI.fieldGroup:     { qualifier: 'ChangeRecord', position: 20 }
       @Consumption.valueHelpDefinition: [
         { entity:  { name:    'I_ChangeMasterVH',
                      element: 'ChangeNumber' }
         }]
       @ObjectModel.foreignKey.association: '_ChangeMaster'
       @Consumption.semanticObject: 'ChangeMaster'
       @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8 , ranking: #LOW}
       //@ObjectModel.readOnly: true

       //@UI.identification:[ {type: #FOR_INTENT_BASED_NAVIGATION,  semanticObjectAction: 'manage', label: 'Manage Change Master', importance:#HIGH}  ]

       //@UI.lineItem: [

       //{type: #FOR_INTENT_BASED_NAVIGATION, semanticObjectAction: 'manage', label: 'Manage Change Master', importance:#HIGH}

       //]

       //       @ObjectModel.readOnly: true

       Document.ChangeNumber,

       //for ACM


       //@feature: '/PLMI/CR_FM_ACM'

       @UI.fieldGroup: { qualifier: 'ChangeNumber', position: 30 }
       @Consumption: { valueHelp: '_AccVH' }
       @ObjectModel.foreignKey.association: '_AccVH'
       //cast( Document.AccessControlContext as /plmb/auth_owning_acc_id_ext ) as AccessControlContext,

       Document.AccessControlContext,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       _ChangeMaster.ChangeNumberStatus,
       @UI.hidden: true
       @ObjectModel.readOnly: true
       _ChangeMaster.ChangeNumberValidFromDate,

       //@UI.fieldGroup: [{qualifier: 'AdminData', position: 10, importance: #HIGH, label: 'Created By', type:#AS_CONTACT, value:'_CreatedByUserContactCard'}],


       //@UI.fieldGroup: [{qualifier: 'AdminData', position: 10, importance: #HIGH, label: 'Created By' }]

       @UI.fieldGroup: [
       {qualifier: 'AdminData', position: 10, importance: #HIGH, label: 'Created By', type:#AS_CONTACT, value:'_CreatedByUserContactCard'},
       {qualifier: 'AdminData', position: 10, importance: #HIGH, label: 'Created By' }
       ]
       @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8 , ranking: #LOW}
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_ChangeRecordCreatedByVH',
                    element: 'CreatedByUser' }
       }]
       Document.CreatedByUser,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       @EndUserText.label: 'Created By User Full Name'
       _CreatedByUserContactCard.FullName                                         as CreatedByUserFullName,

       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @EndUserText.label: 'Created On'
       @EndUserText.quickInfo: 'Date on Which Record Was Created'
       @UI.fieldGroup: [{qualifier: 'AdminData', position: 30, importance: #HIGH, label: 'Created On'}]
       @Consumption.filter.selectionType: #INTERVAL
       Document.CreationDateTime,

       @ObjectModel.virtualElement : true
       @UI.hidden: true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
       @ObjectModel.filter.transformedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
       @ObjectModel.sort.transformedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
       @ObjectModel.readOnly: true
       @Consumption.filter.selectionType: #INTERVAL
       cast( '00000000' as /plmb/created_on )                                     as CreationDate,

       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @UI.fieldGroup: [
        {qualifier: 'AdminData', position: 20, importance: #HIGH, label: 'Last Changed By',  type:#AS_CONTACT, value: '_LastChangedByUserContactCard'},
        {qualifier: 'AdminData', position: 20, importance: #HIGH, label: 'Last Changed By'}
        ]
       @Search:      { defaultSearchElement: true, fuzzinessThreshold: 0.8 , ranking: #LOW}
       @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_ChangeRecordChangedByVH',
                    element: 'LastChangedByUser' }
       }]
       Document.LastChangedByUser,

       @ObjectModel.readOnly: true
       @UI.hidden: true
       @EndUserText.label: 'Changed By User Full Name'
       _LastChangedByUserContactCard.FullName                                     as LastChangedByUserFullName,

       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @EndUserText.label: 'Changed On'
       @EndUserText.quickInfo: 'Changed On'
       @Consumption.filter: {selectionType: #INTERVAL}
       @UI.fieldGroup: [{qualifier: 'AdminData', position: 40, importance: #HIGH, label: 'Changed On'}]
       Document.LastChangeDateTime,

       @ObjectModel.readOnly: true
       _ChangeRecordType.ChangeRecordScenarioID                                   as ChangeRecordScenarioID,

       @ObjectModel.virtualElement : true
       @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
       @ObjectModel.filter.transformedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
       @ObjectModel.sort.transformedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
       @ObjectModel.readOnly: true
       @UI.hidden: true
       @Consumption.filter.selectionType: #INTERVAL
       //@UI.fieldGroup: [{qualifier: 'AdminData', position: 60, importance: #HIGH, label: 'Changed On'}]

       cast( '00000000' as  /plmb/changed_on )                                    as LastChangeDate,
       //@UI.fieldGroup: [{qualifier: 'AdminData', position: 40, importance: #HIGH, label: 'Changed By', type:#AS_CONTACT, value: '_ChangedByUser'}]

       //_ChangedByUser,

       //       @EndUserText.label: 'Changed On'

       //       @ObjectModel.readOnly: true

       //      tstmp_to_dats( LastChangeDateTime,

       //                     abap_system_timezone( $session.client,'NULL' ),

       //                     $session.client,

       //                     'NULL' )      as LastChangeDate,


       //      @UI: {

       //        selectionField.position: 30,

       //        fieldGroup: { qualifier: 'ChangeNumber', position: 10, label: 'Change Responsible', importance: #HIGH, type: #AS_CONTACT, value: '_ChangeRecordContactPerson'},

       //        lineItem: { position:50, label: 'Change Responsible'}

       //