N_ChangeRecordObjPgClass

DDL: N_CHANGERECORDOBJPGCLASS SQL: NCHGRCDOBJPGCLS Type: view Package: VDM_PLMB_CR

Change Record Reference Object Class

N_ChangeRecordObjPgClass is a CDS View that provides data about "Change Record Reference Object Class" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordRefClassBsc) and exposes 29 fields with key field ChangeRecordReferenceUUID. It has 2 associations to related views. Part of development package VDM_PLMB_CR.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordRefClassBsc reference_class from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ClfnClassCharcBasic _ClassCharcBasic $projection.ClassInternalID = _ClassCharcBasic.ClassInternalID and _ClassCharcBasic.CharcPositionNumber = '001'
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName NCHGRCDOBJPGCLS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Change Record Reference Object Class view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.auxiliaryEntity.for.entity C_ChangeRecordObjPgClass view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID
Class Classification Class
ClassType Classification ClassType Class Type
ChangeNumber _ChangeRecordObjPg ChangeNumber
ClassName
ClassTypeName
ValidityStartDate ValidityStartDate
ClassStatus ClassStatus
ClassStatusName
ClassInternalID ClassInternalID
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus
ChangeRecordLifecycleStatus _ChangeRecordObjPg ChangeRecordLifecycleStatus
ChangeRecordItemIsNotEditable _ChangeRecordObjPg ChangeRecordItemIsNotEditable
ChangeRecordItmIsAddDelEnabled _ChangeRecordObjPg ChangeRecordItmIsAddDelEnabled
ChangeRecordType _ChangeRecordObjPg ChangeRecordType
ChangeRecordUUID ChangeRecordUUID
ChangeRecordReferenceType ChangeRecordReferenceType
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype
ParentChangeRecordRefUUID ParentChangeRecordRefUUID
ChangeRecordItemRelevance ChangeRecordItemRelevance
ChangeRecordReference ChangeRecordReference
ChgRecdItemProcgStatusIsEnbld _ChangeRecordObjPg ChgRecdItemProcgStatusIsEnbld
ChangeRecordStatus _ChangeRecordObjPg ChangeRecordStatus
CreatedByUser _ChangeRecordObjPg CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser _ChangeRecordObjPg LastChangedByUser
LastChangeDateTime LastChangeDateTime
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd
_ChangeRecordObjPg _ChangeRecordObjPg 
@AbapCatalog.sqlViewName: 'NCHGRCDOBJPGCLS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Change Record Reference Object Class'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel: {
   semanticKey: ['Class']
}

@ObjectModel.usageType: {serviceQuality: #C,
                          dataClass:  #CUSTOMIZING,
                          sizeCategory: #S}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true

@VDM.auxiliaryEntity.usage.type: [#ENTERPRISE_SEARCH]
@VDM.auxiliaryEntity.for.entity: 'C_ChangeRecordObjPgClass'
define view N_ChangeRecordObjPgClass
  as select from           I_ChangeRecordRefClassBsc as reference_class
  //    left outer to one join I_ClfnObjectClass         as Class          on reference_class.ChgRecRefInternalKey2 = Class.ChangeNumber

    left outer to one join I_ClfnClass               as Classification on  reference_class.ChgRecRefInternalKey1 = Classification.Class
                                                                       and reference_class.ChgRecRefInternalKey3 = Classification.ClassType

  association [0..*] to I_ClfnClassCharcBasic as _ClassCharcBasic   on  $projection.ClassInternalID          = _ClassCharcBasic.ClassInternalID
                                                                    and _ClassCharcBasic.CharcPositionNumber = '001'

  association [1..1] to C_ChangeRecordObjPg   as _ChangeRecordObjPg on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
  //  association [0..1] to E_ChangeRecordRefClassBsc as _ClassExtension  on  $projection.ChangeRecordReferenceUUID = _ClassExtension.ChangeRecordReferenceUUID


{


          @UI.hidden: true
          @ObjectModel.readOnly: true
  key     ChangeRecordReferenceUUID,

          @UI.lineItem:[{
               position:10,
                importance:#HIGH }
                            ]
          @UI.identification: {position: 10, importance: #HIGH}

          @ObjectModel.text.element:  [ 'ClassName' ]
          @Consumption.valueHelpDefinition: [{
                        entity:  { name:    'C_ChangeRecordClassVH',
                                element: 'Class' },
             additionalBinding:[
                       { localElement: 'ChangeNumber',
                                           element: 'ChangeNumber' },
                                { localElement: 'ClassType',
                                 element: 'ClassType' }]
           }]
          Classification.Class,
          @UI.lineItem:[{
              position:20,
              importance:#HIGH }
                  ]
          @UI.identification: {position:20, importance: #HIGH}
          @EndUserText.label: 'Class Type'
          @ObjectModel.text.element:  [ 'ClassTypeName' ]
          Classification.ClassType,
          @UI.lineItem:[{
             position:30,
             importance:#HIGH }
                 ]
          @UI.identification: {position:30, importance: #HIGH}
          _ChangeRecordObjPg.ChangeNumber,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          Classification._ClassDescription[1:Language = $session.system_language].ClassDescription            as ClassName,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          Classification._ClassType._ClassTypeText[1:Language = $session.system_language].ClassTypeName,
          @UI.lineItem:[{
          position:40,
          importance:#HIGH }
              ]
          @UI.identification: {position:40, importance: #HIGH}
          @ObjectModel.readOnly: true
          ValidityStartDate,
          @UI.lineItem:[{
              position:50,
              importance:#HIGH }
                  ]
          @UI.identification: {position:50, importance: #HIGH}
          @ObjectModel.readOnly: true
          @ObjectModel.text.element:  [ 'ClassStatusName' ]
          ClassStatus,
          @ObjectModel.readOnly: true
          Classification._ClassStatus._ClassStatusText[1:Language = $session.system_language].ClassStatusName as ClassStatusName,


          //           CharcInternalID,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          ClassInternalID,


          ChangeRecordItemProcgStatus,
          @ObjectModel.readOnly: true
          @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.ChangeRecordType                                                                 as ChangeRecordType,
          @UI.hidden: true
          ChangeRecordUUID,
          //          @UI.hidden: true

          //          @ObjectModel.readOnly: true

          //          CharcInternalID,

          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ChangeRecordReferenceSubtype,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.lineItem:[{
                      position:120,
                      importance:#HIGH }
                    ]

          @UI.identification: {position:120, importance: #HIGH}

          ChangeRecordItemRelevance,
          @UI.hidden: true
          ChangeRecordReference,
          @ObjectModel.readOnly:true
          @UI.hidden: true
          _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordStatus,
          @Semantics.user.createdBy: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.CreatedByUser,
          @UI.hidden: true
          CreationDateTime,
          @Semantics.user.lastChangedBy: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.LastChangedByUser,
          @UI.hidden: true
          LastChangeDateTime,
          @UI.hidden: true
          ChangeRecordVirtualRefInd,
          // @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]

          _ChangeRecordObjPg
          //    _ChangeRecordClassCharc,

          //  _ChangeRecordItemRelVH,

          // _ChangeRecordClassVH,

          //          _ProcessingStatusVH,

          //        _ProcessingStatusTxt


}

Learn More