Which tables does C_ChangeRecordObjPgSpec use?

C_ChangeRecordObjPgSpec reads from 1 data source(s): I_ChangeRecordReferenceSpecTP.

How many fields does C_ChangeRecordObjPgSpec have?

C_ChangeRecordObjPgSpec has 42 fields. Key fields: ChangeRecordReferenceUUID.

C_ChangeRecordObjPgSpec

DDL: C_CHANGERECORDOBJPGSPEC SQL: CCHGRCDOBJPGSPEC Type: view CONSUMPTION Package: VDM_PLMB_CR_O

Change Record Reference Specification

C_ChangeRecordObjPgSpec is a Consumption CDS View that provides data about "Change Record Reference Specification" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordReferenceSpecTP) and exposes 42 fields with key field ChangeRecordReferenceUUID. It has 9 associations to related views. Part of development package VDM_PLMB_CR_O.

Data Sources (1)

Source	Alias	Join Type
I_ChangeRecordReferenceSpecTP	ChangeRecordReferenceSpecTP	from

Associations (9)

Cardinality	Target	Alias	Condition
[0..1]	I_SpecAssignedHeaderStatus	_AssignedHeaderStatus	`$projection.SpecificationInternalID = _AssignedHeaderStatus.SpecificationInternalID`
[1..1]	C_ChangeRecordObjPg	_ChangeRecordObjPg	`$projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID`
[1..1]	I_SpecificationVH	_SpecificationVH	`$projection.Specification = _SpecificationVH.Specification`
[1..1]	C_ChangeRecordItemRelSpecVH	_ChangeRecordItemRelVH	`$projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance and $projection.changerecordtype = _ChangeRecordItemRelVH.ChangeRecordType`
[1..1]	C_ChgRecordItemProcgStatusVH	_ProcessingStatusVH	`$projection.ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus and $projection.ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus`
[0..*]	I_ChgRecdItemProcgStatusText	_ProcessingStatusTxt	`$projection.ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus`
[0..1]	C_ChgRecdSpecIdfrForCurDate	_Identifier	`$projection.SpecificationInternalID = _Identifier.SpecificationInternalID`
[0..*]	I_ChangeRecordRefObjIcons	_ChangeRecordRefObjIcons	`$projection.ChangeRecordUUID = _ChangeRecordRefObjIcons.ChangeRecordUUID and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType`
[0..*]	C_ChangeRecdDigSignStatusVH	_DigSignStatusText	`$projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CCHGRCDOBJPGSPEC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#L	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.createEnabled	true	view
ObjectModel.deleteEnabled	EXTERNAL_CALCULATION	view
ObjectModel.transactionalProcessingDelegated	true	view
UI.headerInfo.typeName	Specification	view
UI.headerInfo.typeNamePlural	Specifications	view
UI.headerInfo.imageUrl	ChangeRecordRefObjIcon	view
UI.headerInfo.title.value	Specification	view
EndUserText.label	Change Record Reference Specification	view

Fields (42)

Key	Field	Source Table	Source Field	Description
KEY	ChangeRecordReferenceUUID		ChangeRecordReferenceUUID
	ChangeRecordRefObjIcon			Icon
	Specification	I_ChangeRecordReferenceSpecTP	Specification
	SpecificationInternalID	I_ChangeRecordReferenceSpecTP	SpecificationInternalID
	SpecIdfgDescText	_Identifier	SpecIdfgDescText
	SpecificationHeaderStatus	_AssignedHeaderStatus	SpecificationHeaderStatus
	ChangeRecordItemRelevance		ChangeRecordItemRelevance
	ChangeRecordItemProcgStatus		ChangeRecordItemProcgStatus	Processing Status
	ChgRecdCurrentItemProcgStatus		ChgRecdCurrentItemProcgStatus
	ChgRecdItemProcgStatusIsEnbld	_ChangeRecordObjPg	ChgRecdItemProcgStatusIsEnbld
	ChangeRecordLifecycleStatus	_ChangeRecordObjPg	ChangeRecordLifecycleStatus
	ChangeRecordItemIsNotEditable	_ChangeRecordObjPg	ChangeRecordItemIsNotEditable
	ChangeRecordItmIsAddDelEnabled	_ChangeRecordObjPg	ChangeRecordItmIsAddDelEnabled
	ChangeRecordStatus	_ChangeRecordObjPg	ChangeRecordStatus
	ChangeRecordType	_ChangeRecordObjPg	ChangeRecordType
	ChangeRecordUUID		ChangeRecordUUID
	ChangeRecordReferenceType		ChangeRecordReferenceType
	ParentChangeRecordRefUUID		ParentChangeRecordRefUUID
	ChangeRecordReference		ChangeRecordReference
	CreatedByUser		CreatedByUser
	CreationDateTime		CreationDateTime
	CreationDate
	LastChangedByUser		LastChangedByUser
	LastChangeDateTime		LastChangeDateTime
	LastChangeDate
	ChangeRecordVirtualRefInd		ChangeRecordVirtualRefInd
	ChgRecdItmDSgntr		ChgRecdItmDSgntr	Digital Signature Status
	DigitalSignUserIsAuthorized
	ChgRecdDigSignStatusTxt	_DigSignStatusText	ChgRecdDigSignStatusTxt	Digital Signature Status
	ChgRecdReasonForChange		ChgRecdReasonForChange
	ExpdCompltnDte		ExpdCompltnDte
	ChgRecdAuthznGrpText		ChgRecdAuthznGrpText
	ChgRecdNmbrChgSts		ChgRecdNmbrChgSts
	SpecificationType		SpecificationType
	ChgRecdObjDgtlSgntrEnable
	_ChangeRecordObjPg		_ChangeRecordObjPg
	_SpecificationVH		_SpecificationVH
	_ChangeRecordItemRelVH		_ChangeRecordItemRelVH
	_ProcessingStatusVH		_ProcessingStatusVH
	_ProcessingStatusTxt		_ProcessingStatusTxt
	_DigSignStatusText		_DigSignStatusText
	_SpecificationType		_SpecificationType

@AbapCatalog.sqlViewName: 'CCHGRCDOBJPGSPEC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey:true
@ObjectModel.usageType: {serviceQuality: #X,
                        dataClass: #MIXED,
                        sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
   semanticKey: ['Specification'],
   createEnabled: true,
   deleteEnabled: 'EXTERNAL_CALCULATION',
   updateEnabled,
   transactionalProcessingDelegated: true
}

@UI.headerInfo:{
  typeName: 'Specification',
  typeNamePlural: 'Specifications',
  imageUrl: 'ChangeRecordRefObjIcon',
  title:{value:'Specification'}
}

@EndUserText.label: 'Change Record Reference Specification'
@UI.presentationVariant.requestAtLeast: ['ChangeRecordType', 'ChangeRecordLifecycleStatus','ChangeRecordReferenceType' ]
define view C_ChangeRecordObjPgSpec
  as select from I_ChangeRecordReferenceSpecTP as ChangeRecordReferenceSpecTP

  association [0..1] to I_SpecAssignedHeaderStatus   as _AssignedHeaderStatus    on  $projection.SpecificationInternalID = _AssignedHeaderStatus.SpecificationInternalID

  association [1..1] to C_ChangeRecordObjPg          as _ChangeRecordObjPg       on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID

  association [1..1] to I_SpecificationVH            as _SpecificationVH         on  $projection.Specification = _SpecificationVH.Specification

  association [1..1] to C_ChangeRecordItemRelSpecVH  as _ChangeRecordItemRelVH   on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance
                                                                                 and $projection.changerecordtype          = _ChangeRecordItemRelVH.ChangeRecordType

  //and (

  //   $projection.ChangeRecordReferenceType               = _ChangeRecordItemRelVH.ChangeRecordReferenceType

  // or _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' '

  //)

  association [1..1] to C_ChgRecordItemProcgStatusVH as _ProcessingStatusVH      on  $projection.ChangeRecordItemProcgStatus   = _ProcessingStatusVH.ChgRecdNextItemProcgStatus
                                                                                 and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus
                                                                                 and $projection.ChangeRecordLifecycleStatus   = _ProcessingStatusVH.ChangeRecordLifecycleStatus
  association [0..*] to I_ChgRecdItemProcgStatusText as _ProcessingStatusTxt     on  $projection.ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus
  association [0..1] to C_ChgRecdSpecIdfrForCurDate  as _Identifier              on  $projection.SpecificationInternalID = _Identifier.SpecificationInternalID
  association [0..*] to I_ChangeRecordRefObjIcons    as _ChangeRecordRefObjIcons on  $projection.ChangeRecordUUID          = _ChangeRecordRefObjIcons.ChangeRecordUUID
                                                                                 and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType
  association [0..*] to C_ChangeRecdDigSignStatusVH  as _DigSignStatusText       on  $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus
{



          @UI.hidden: true
          @ObjectModel.readOnly: true
  key     ChangeRecordReferenceUUID,
          @UI.hidden: true
          @UI.lineItem:[
          { position:5,
            importance:#HIGH }
          ]
          @UI.identification: {position: 5, importance: #HIGH}
          @Semantics.imageUrl: true
          @ObjectModel.readOnly: true
          @EndUserText.label: 'Icon'
          _ChangeRecordRefObjIcons[ChangeRecordType = ChangeRecordType].ChangeRecordRefObjIcon as ChangeRecordRefObjIcon,
          @UI.lineItem:[{
                        position:10,
                           label: 'Specification',
                        importance:#HIGH }
                      ]
          @UI.identification: {position: 10, importance: #HIGH}
          @ObjectModel.mandatory: true
          @Consumption.valueHelp: '_SpecificationVH'
          @ObjectModel.text.element:  [ 'SpecIdfgDescText' ]
          @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
          ChangeRecordReferenceSpecTP.Specification                                            as Specification,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          ChangeRecordReferenceSpecTP.SpecificationInternalID                                  as SpecificationInternalID,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _Identifier.SpecIdfgDescText,
          @UI.lineItem:[{
                        position:20,
                           label: 'Status',
                        importance:#HIGH }
                      ]
          @UI.identification: {position: 20, importance: #HIGH}
          @ObjectModel.readOnly: true
          _AssignedHeaderStatus.SpecificationHeaderStatus,
          @UI.lineItem:[{
                                  position:30,
                                     label: 'Relevance',
                                  importance:#HIGH }
                                ]
          @UI.identification: {position: 30, importance: #HIGH}
          @ObjectModel.mandatory: true
          @ObjectModel.foreignKey.association: '_ChangeRecordItemRelVH'
          @Consumption.valueHelp: '_ChangeRecordItemRelVH'
          @UI.textArrangement: #TEXT_ONLY
          ChangeRecordItemRelevance,
          @UI.lineItem:[ {position:45, importance:#MEDIUM } ]
          @UI.identification: [{position: 70, importance: #MEDIUM }]
          @EndUserText.label: 'Processing Status'
          @Consumption.valueHelpDefinition: [{association: '_ProcessingStatusVH'}]
          @ObjectModel.foreignKey.association: '_ProcessingStatusVH'
          @UI.textArrangement: #TEXT_FIRST
          ChangeRecordItemProcgStatus,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          ChgRecdCurrentItemProcgStatus,
          @ObjectModel.readOnly:true
          @UI.hidden: true
          _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld,
          @UI.hidden: true
          _ChangeRecordObjPg.ChangeRecordLifecycleStatus                                       as ChangeRecordLifecycleStatus,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordItemIsNotEditable,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordItmIsAddDelEnabled,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordStatus,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordType,
          @UI.hidden: true
          ChangeRecordUUID,
          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.hidden: true
          ChangeRecordReference,
          @Semantics.user.createdBy: true
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 95 }]
          CreatedByUser,
          @UI.hidden: true
          CreationDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 100 }]
          cast( '00000000' as /plmb/created_on )                                               as CreationDate,
          @Semantics.user.lastChangedBy: true
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 105 }]
          LastChangedByUser,
          @UI.hidden: true
          LastChangeDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #MEDIUM, position: 110 }]
          cast( '00000000' as /plmb/changed_on )                                               as LastChangeDate,
          @UI.hidden: true
          ChangeRecordVirtualRefInd,


          @UI.hidden: true
          @UI.lineItem:[{importance:#MEDIUM, hidden: true }   ]
          @EndUserText.label: 'Digital Signature Status'
          @ObjectModel.foreignKey.association: '_DigSignStatusText'
          @Consumption: { valueHelp: '_DigSignStatusText' }
          ChgRecdItmDSgntr,

          @UI.lineItem:[{
              hidden: true,
              importance:#LOW }
            ]
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_I_DSGNTR_ENABLE'
          cast( '' as boolean)                                                                 as DigitalSignUserIsAuthorized,

          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #LOW, position: 90 }]
          @EndUserText.label: 'Digital Signature Status'
          _DigSignStatusText.ChgRecdDigSignStatusTxt                                           as ChgRecdDigSignStatusTxt,

          @UI.identification: [{importance: #MEDIUM, position: 115 }]
          ChgRecdReasonForChange,

          @UI.identification: [{importance: #MEDIUM, position: 120 }]
          ExpdCompltnDte,

          @UI.identification: [{importance: #MEDIUM, position: 125 }]
          @Consumption.valueHelpDefinition: [{ entity : { name : 'C_ChangeRecdAuthznGrpVH' , element: 'ChgRecdNmbrAuthznGrp'}}]
          ChgRecdAuthznGrpText,

          @UI.identification: [{importance: #MEDIUM, position: 130 }]
          @Consumption.valueHelpDefinition: [{ entity : { name : 'C_ChgRecdChgNmbrStatusVH' , element: 'ChgRecdNmbrChgSts'}}]
          ChgRecdNmbrChgSts,

          @UI.hidden: true
          SpecificationType,

          @UI.lineItem:[{
          hidden: true,
          importance:#LOW }
          ]
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_I_DSGNTR_ENABLE'
          cast( '' as boolean)                                                                 as ChgRecdObjDgtlSgntrEnable,

          @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
          _ChangeRecordObjPg,
          _SpecificationVH,
          _ChangeRecordItemRelVH,
          _ProcessingStatusVH,
          _ProcessingStatusTxt,
          _DigSignStatusText,
          _SpecificationType
}

Depth:

C_ChangeRecordObjPgSpec view

I_ChangeRecordReferenceSpecTP view