C_ChangeRecordObjPgPlngRouting

DDL: C_CHANGERECORDOBJPGPLNGROUTING SQL: CCHGRCDOBJPGPLR Type: view CONSUMPTION

Change Record Ref Object Plng Routing

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

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefPlngRoutingTP ChangeRecordReferencePLRTP from

Associations (7)

CardinalityTargetAliasCondition
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[1..1] I_BillOfOperations _BillOfOperations $projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant
[1..1] C_ChangeRecordItemRelPlngRtgVH _ChangeRecordItemRelVH $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance and $projection.ChangeRecordType = _ChangeRecordItemRelVH.ChangeRecordType
[0..*] I_ChangeRecordRefObjIcons _ChangeRecordRefObjIcons $projection.ChangeRecordUUID = _ChangeRecordRefObjIcons.ChangeRecordUUID and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType
[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 (18)

NameValueLevelField
AbapCatalog.sqlViewName CCHGRCDOBJPGPLR 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 Planning Routing view
UI.headerInfo.typeNamePlural Planning Routings view
UI.headerInfo.imageUrl ChangeRecordRefObjIcon view
UI.headerInfo.title.value BillOfOperationsGroup view
EndUserText.label Change Record Ref Object Plng Routing view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
ChangeRecordRefObjIcon Icon
BillOfOperationsGroup
BillOfOperationsDesc
BillOfOperationsType I_ChgRecdRefPlngRoutingTP BillOfOperationsType
BillOfOperationsVariant I_ChgRecdRefPlngRoutingTP BillOfOperationsVariant
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
ChangeRecordReference ChangeRecordReference
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
CreationDate
LastChangedByUser LastChangedByUser
LastChangeDateTime LastChangeDateTime
LastChangeDate
ChangeRecordItemRelevance ChangeRecordItemRelevance
Material
MaterialDescription
NumberOfMaterials
ChangeRecordType _ChangeRecordObjPg ChangeRecordType
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
ChgRecdReasonForChange ChgRecdReasonForChange
ExpdCompltnDte ExpdCompltnDte
ChgRecdAuthznGrpText ChgRecdAuthznGrpText
ChgRecdNmbrChgSts ChgRecdNmbrChgSts
ChangeNumber ChangeNumber
_ChangeRecordItemRelVH _ChangeRecordItemRelVH
_ChangeRecordObjPg _ChangeRecordObjPg
_ProcessingStatusVH _ProcessingStatusVH
_ProcessingStatusTxt _ProcessingStatusTxt
_DigSignStatusText _DigSignStatusText
@AbapCatalog.sqlViewName: 'CCHGRCDOBJPGPLR'
@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'],
   createEnabled: true,
   deleteEnabled,
     updateEnabled:'EXTERNAL_CALCULATION' ,
   transactionalProcessingDelegated: true
}
@UI.headerInfo:{
  typeName: 'Planning Routing',
  typeNamePlural: 'Planning Routings',
  imageUrl: 'ChangeRecordRefObjIcon',
  title:{value:'BillOfOperationsGroup'}
  }
@UI.presentationVariant.requestAtLeast: ['BillOfOperationsGroup','BillOfOperationsType','BillOfOperationsVariant','ChangeRecordType','Material','MaterialDescription','NumberOfMaterials', 'ChangeRecordType', 'ChangeRecordReferenceType']
@EndUserText.label: 'Change Record Ref Object Plng Routing'

define view C_ChangeRecordObjPgPlngRouting
  as select from I_ChgRecdRefPlngRoutingTP as ChangeRecordReferencePLRTP
  association [1..1] to C_ChangeRecordObjPg            as _ChangeRecordObjPg       on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
  association [1..1] to I_BillOfOperations             as _BillOfOperations        on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                                   and $projection.BillOfOperationsGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                                   and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant
  association [1..1] to C_ChangeRecordItemRelPlngRtgVH as _ChangeRecordItemRelVH   on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance
                                                                                   and $projection.ChangeRecordType          = _ChangeRecordItemRelVH.ChangeRecordType
  //                                                                                   and (

  //                                                                                      $projection.ChangeRecordReferenceType               = _ChangeRecordItemRelVH.ChangeRecordReferenceType

  //                                                                                      or _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' '

  //                                                                                    )

  association [0..*] to I_ChangeRecordRefObjIcons      as _ChangeRecordRefObjIcons on  $projection.ChangeRecordUUID          = _ChangeRecordRefObjIcons.ChangeRecordUUID
                                                                                   and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.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..*] to C_ChangeRecdDigSignStatusVH    as _DigSignStatusText       on  $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus


{

          @UI.hidden: 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,importance:#HIGH },
                 identification:{position: 10, importance: #HIGH }
               }
          @Consumption.valueHelpDefinition: [
                                             { entity: {name: 'C_ChangeRecordPlngRtgVH',
                                                        element: 'BillOfOperationsGroup'},
                                               additionalBinding: [{ localElement: 'BillOfOperationsVariant',
                                                                     element: 'BillOfOperationsVariant' }]
                                               }
                                             ]
          @ObjectModel.text.element:  [ 'BillOfOperationsDesc' ]
          cast(ChangeRecordReferencePLRTP.BillOfOperationsGroup as mpe_rtg_routing_group preserving type) as BillOfOperationsGroup,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsDesc,

          @UI.hidden: true
          ChangeRecordReferencePLRTP.BillOfOperationsType                                                 as BillOfOperationsType,

          @UI: {
                 lineItem:{position:20,importance:#HIGH },
                 identification:{position: 20, importance: #HIGH }
               }
          ChangeRecordReferencePLRTP.BillOfOperationsVariant                                              as BillOfOperationsVariant,

          @UI.hidden: true
          ChangeRecordUUID,
          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.hidden: true
          ChangeRecordReference,
          @UI.identification: {position: 95, importance: #MEDIUM}
          @Semantics.user.createdBy: true
          @ObjectModel.readOnly: true

          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: {
                  lineItem:{position:30,importance:#MEDIUM },
                  identification:{position: 30, importance: #MEDIUM }
               }
          @ObjectModel.foreignKey.association: '_ChangeRecordItemRelVH'
          @Consumption.valueHelp: '_ChangeRecordItemRelVH'
          @ObjectModel.mandatory: true
          @UI.textArrangement: #TEXT_ONLY
          ChangeRecordItemRelevance,

          @UI.hidden:true
          @ObjectModel:{ readOnly:true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_CR_PLNG_ROUTING_MATERIAL'}
          cast ('' as matnr)                                                                              as Material,

          @UI.hidden:true
          @ObjectModel:{ readOnly:true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_CR_PLNG_ROUTING_MATERIAL'}
          cast ('' as maktx)                                                                              as MaterialDescription,

          @UI.hidden:true
          @ObjectModel:{ readOnly:true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_CR_PLNG_ROUTING_MATERIAL'}
          cast (0 as abap.int1 )                                                                          as NumberOfMaterials,

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


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

          @UI.identification: {position: 115, importance: #MEDIUM}
          ChgRecdReasonForChange,
          @UI.identification: {position: 120, importance: #MEDIUM}
          ExpdCompltnDte,

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

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

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

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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDOBJPG",
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSCHANGESTATE",
"I_CHANGERECORDREFOBJICONS",
"I_CHGRECDREFPLNGROUTINGTP"
],
"ASSOCIATED":
[
"C_CHANGERECDDIGSIGNSTATUSVH",
"C_CHANGERECORDITEMRELPLNGRTGVH",
"C_CHANGERECORDOBJPG",
"C_CHGRECORDITEMPROCGSTATUSVH",
"I_BILLOFOPERATIONS",
"I_CHANGERECORDREFOBJICONS",
"I_CHGRECDITEMPROCGSTATUSTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/