C_ChangeRecordObjPgTmplRouting

DDL: C_CHANGERECORDOBJPGTMPLROUTING SQL: CCHGRCDOBJPGTER Type: view CONSUMPTION

Change Record Ref Object Tmpl Routing

C_ChangeRecordObjPgTmplRouting is a Consumption CDS View that provides data about "Change Record Ref Object Tmpl Routing" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefTmplRoutingTP) and exposes 39 fields with key field ChangeRecordReferenceUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefTmplRoutingTP ChangeRecordReferenceTERTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsVersion _BillOfOperationsGroupVH $projection.BillOfOperationsType = _BillOfOperationsGroupVH.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsGroupVH.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsGroupVH.BillOfOperationsVariant and $projection.BillOfOperationsVersion = _BillOfOperationsGroupVH.BillOfOperationsVersion
[1..1] C_ChangeRecordItemRelTmplRtgVH _ChangeRecordItemRelVH $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance and $projection.changerecordtype = _ChangeRecordItemRelVH.ChangeRecordType
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[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..*] C_ChangeRecdDigSignStatusVH _DigSignStatusText $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CCHGRCDOBJPGTER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.transactionalProcessingDelegated true view
UI.headerInfo.typeName Shop Floor Routing Template view
UI.headerInfo.typeNamePlural Shop Floor Routing Templates view
UI.headerInfo.title.value BillOfOperationsGroup view
EndUserText.label Change Record Ref Object Tmpl Routing view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
BillOfOperationsGroup
BillOfOperationsType I_ChgRecdRefTmplRoutingTP BillOfOperationsType
BillOfOperationsVariant
BillOfOperationsVersion
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
ChangeRecordReference ChangeRecordReference
ChgRecdItemProcgStatusIsEnbld _ChangeRecordObjPg ChgRecdItemProcgStatusIsEnbld
ChangeRecordLifecycleStatus _ChangeRecordObjPg ChangeRecordLifecycleStatus
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus Processing Status
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus
ChgRecdItmDSgntr ChgRecdItmDSgntr Digital Signature Status
DigitalSignUserIsAuthorized
ChgRecdDigSignStatusTxt _DigSignStatusText ChgRecdDigSignStatusTxt Digital Signature Status
ChgRecdObjDgtlSgntrEnable
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
CreationDate
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
LastChangeDate
ChgRecdReasonForChange ChgRecdReasonForChange
ExpdCompltnDte ExpdCompltnDte
ChgRecdAuthznGrpText ChgRecdAuthznGrpText
ChgRecdNmbrChgSts ChgRecdNmbrChgSts
ChangeNumber ChangeNumber
ChangeRecordItemRelevance ChangeRecordItemRelevance
BOOVersionStatusText
RoutingIsReworkRouting
Plant I_ChgRecdRefTmplRoutingTP Plant
ChangeRecordType _ChangeRecordObjPg ChangeRecordType
_ChangeRecordObjPg _ChangeRecordObjPg
_ChangeRecordItemRelVH _ChangeRecordItemRelVH
_BillOfOperationsGroupVH _BillOfOperationsGroupVH
_ProcessingStatusVH _ProcessingStatusVH
_ProcessingStatusTxt _ProcessingStatusTxt
_DigSignStatusText _DigSignStatusText
@AbapCatalog.sqlViewName: 'CCHGRCDOBJPGTER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking:#NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@ObjectModel: {
   semanticKey: ['BillOfOperationsType','BillOfOperationsGroup','BillOfOperationsVariant','BillOfOperationsVersion'],
   createEnabled: true,
   deleteEnabled,
   updateEnabled:'EXTERNAL_CALCULATION' ,
   transactionalProcessingDelegated: true
}
@UI.headerInfo:{
  typeName: 'Shop Floor Routing Template',
  typeNamePlural: 'Shop Floor Routing Templates',
  title:{value:'BillOfOperationsGroup'}
  }
@UI.presentationVariant.requestAtLeast: ['BillOfOperationsGroup','BillOfOperationsType','BillOfOperationsVariant','BillOfOperationsVersion','Plant','ChangeRecordType','ChangeRecordReferenceType' ]
@EndUserText.label: 'Change Record Ref Object Tmpl Routing'

define view C_ChangeRecordObjPgTmplRouting
  as select from I_ChgRecdRefTmplRoutingTP as ChangeRecordReferenceTERTP
  association [1..1] to I_BillOfOperationsVersion      as _BillOfOperationsGroupVH on  $projection.BillOfOperationsType    = _BillOfOperationsGroupVH.BillOfOperationsType
                                                                                   and $projection.BillOfOperationsGroup   = _BillOfOperationsGroupVH.BillOfOperationsGroup
                                                                                   and $projection.BillOfOperationsVariant = _BillOfOperationsGroupVH.BillOfOperationsVariant
                                                                                   and $projection.BillOfOperationsVersion = _BillOfOperationsGroupVH.BillOfOperationsVersion
  association [1..1] to C_ChangeRecordItemRelTmplRtgVH as _ChangeRecordItemRelVH   on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance
                                                                                   and $projection.changerecordtype          = _ChangeRecordItemRelVH.ChangeRecordType
  //and (

  //  $projection.ChangeRecordReferenceType               = _ChangeRecordItemRelVH.ChangeRecordReferenceType

  // _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' '

  // )

  association [1..1] to C_ChangeRecordObjPg            as _ChangeRecordObjPg       on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
  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..*] to C_ChangeRecdDigSignStatusVH    as _DigSignStatusText       on  $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus

{

          @UI.hidden: true
  key     ChangeRecordReferenceUUID,

          @UI: {
                 lineItem:{position:10,importance:#HIGH },
                 identification:{position: 10, importance: #HIGH }
               }
          @Consumption.valueHelpDefinition: [
                                               { entity:  { name:    'C_ChangeRecordTmplRtgVH',
                                                            element: 'BillOfOperationsGroup' },
                                                 additionalBinding:[ { localElement: 'BillOfOperationsVariant',
                                                                       element: 'BillOfOperationsVariant' },
                                                                     { localElement: 'BillOfOperationsVersion',
                                                                       element: 'BillOfOperationsVersion' }]
                                                }
                                            ]
          cast (ChangeRecordReferenceTERTP.BillOfOperationsGroup as mpe_rtg_reft_group preserving type )    as BillOfOperationsGroup,

          @UI.hidden: true
          ChangeRecordReferenceTERTP.BillOfOperationsType,

          @UI: {
                 lineItem:{position:20,importance:#HIGH },
                 identification:{position: 20, importance: #HIGH }
               }
          cast(ChangeRecordReferenceTERTP.BillOfOperationsVariant as mpe_rtg_reft_variant preserving type ) as BillOfOperationsVariant,

          @UI: {
                lineItem:{position:30,importance:#HIGH },
                identification:{position: 30, importance: #HIGH }
              }
          cast(ChangeRecordReferenceTERTP.BillOfOperationsVersion as mpe_rtg_reft_version preserving type ) as BillOfOperationsVersion,

          @UI.hidden: true
          ChangeRecordUUID,
          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.hidden: true
          ChangeRecordReference,


          @ObjectModel.readOnly:true
          @UI.hidden: true
          _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordLifecycleStatus                                                    as ChangeRecordLifecycleStatus,

          //           @UI.hidden: true

          //           @ObjectModel.readOnly: true

          //           _ChangeRecordObjPg.ChangeRecordStatus,


          @UI.lineItem:[ {position: 70, 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,
          //           @UI.hidden: true

          //           @ObjectModel.readOnly: true

          //           _ChangeRecordObjPg.ChangeRecordItemIsNotEditable,

          //           @UI.hidden: true

          //           @ObjectModel.readOnly: true

          //           _ChangeRecordObjPg.ChangeRecordItmIsAddDelEnabled,

          @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.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,


          @Semantics.user.createdBy: true
          @ObjectModel.readOnly: true
          @UI.identification: [{position: 95, importance: #MEDIUM }]
          CreatedByUser,

          @UI.hidden: true
          CreationDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: [{position: 100, importance: #MEDIUM }]
          cast( '00000000' as /plmb/created_on )                                                            as CreationDate,

          @Semantics.user.lastChangedBy: true
          @ObjectModel.readOnly: true
          @UI.identification: [{position: 105, importance: #MEDIUM }]
          LastChangedByUser,

          @UI.hidden: true
          LastChangeDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: [{position: 110, importance: #MEDIUM }]
          cast( '00000000' as /plmb/changed_on )                                                            as LastChangeDate,

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

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

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

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

          @UI.lineItem:[{position:80,importance:#MEDIUM }]
          @UI.identification: {position: 80, importance: #MEDIUM}
          @ObjectModel.readOnly: true
          @Consumption.semanticObject: 'ChangeMaster'
          ChangeNumber,


          @UI: {
                  lineItem:{position:40,importance:#MEDIUM },
                  identification:{position: 40, importance: #MEDIUM }
               }
          @ObjectModel.foreignKey.association: '_ChangeRecordItemRelVH'
          @Consumption.valueHelp: '_ChangeRecordItemRelVH'
          @ObjectModel.mandatory: true
          @UI.textArrangement: #TEXT_ONLY
          ChangeRecordItemRelevance,

          --Routing Status(Processing Status)
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @UI: {
                  lineItem:{position:50,importance:#MEDIUM }
                }
          _BillOfOperationsGroupVH._BOOVersionStatus._Text[1: Language=$session.system_language].BOOVersionStatusText,

          @ObjectModel.readOnly: true
          _BillOfOperationsGroupVH._BillOfOperations.RoutingIsReworkRouting as RoutingIsReworkRouting,

          @UI.hidden: true
          ChangeRecordReferenceTERTP.Plant,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordType,

          @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
          _ChangeRecordObjPg,

          _ChangeRecordItemRelVH,
          _BillOfOperationsGroupVH,
          _ProcessingStatusVH,
          _ProcessingStatusTxt,
          _DigSignStatusText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDOBJPG",
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSVERSION",
"I_BOOVERSIONSTATUS",
"I_BOOVERSIONSTATUSTEXT",
"I_CHGRECDREFTMPLROUTINGTP"
],
"ASSOCIATED":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDITEMRELTMPLRTGVH",
"C_CHANGERECORDOBJPG",
"C_CHGRECORDITEMPROCGSTATUSVH",
"I_BILLOFOPERATIONSVERSION",
"I_CHGRECDITEMPROCGSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/