C_ChgMasterForChgRecordOvPg

DDL: C_CHGMASTERFORCHGRECORDOVPG SQL: CCHGMSRECDOVPG Type: view CONSUMPTION

Change Master For Change Record Overview Page

C_ChgMasterForChgRecordOvPg is a Consumption CDS View that provides data about "Change Master For Change Record Overview Page" in SAP S/4HANA. It reads from 2 data sources (I_ChangeRecordBsc, I_ChangeMaster) and exposes 7 fields with key field ChangeNumber.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_ChangeRecordBsc _Document left_outer
I_ChangeMaster ChangeMaster from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CCHGMSRECDOVPG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Change Master For Change Record Overview Page view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber I_ChangeMaster ChangeNumber
ChangeNumberDescription I_ChangeMaster ChangeNumberDescription
ChangeRecord I_ChangeRecordBsc ChangeRecord
Partner I_ChangeRecordBsc Partner
ChgRecordDescriptionText I_ChangeRecordBsc ChgRecordDescriptionText
ChangeRecordType I_ChangeRecordBsc ChangeRecordType
ChangeNumberValidFromDate 
@AbapCatalog.sqlViewName: 'CCHGMSRECDOVPG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Change Master For Change Record Overview Page'

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

@UI.selectionVariant: [{

  qualifier: 'ChangeMaster'

 }]

@UI.presentationVariant: [{
  qualifier:'SortByEffectiveDate',
  sortOrder: [{ by: 'ChangeNumberValidFromDate', direction: #ASC }]
 }]

define view C_ChgMasterForChgRecordOvPg
  as select from I_ChangeMaster as ChangeMaster
  //  left outer join I_ChangeRecordBsc as _Document on ChangeMaster.ChangeNumber = _Document.ChangeNumber

  left outer join I_ChangeRecordBsc as _Document on ChangeMaster.ChangeNumber = _Document.ChangeNumber
{
        //i_changemaster

        @Consumption.semanticObject: 'ChangeMaster'
        @UI.lineItem: [
            {
                qualifier: 'ChangeMaster',
                position:10,
                label:'Change Number'
            }
//            {

//                qualifier: 'ChangeMaster',

//                type: #FOR_INTENT_BASED_NAVIGATION,

//                semanticObjectAction: 'manage'

//            }

        ]
        @ObjectModel.text.element:  [ 'ChangeNumberDescription' ]
        @UI.textArrangement: #TEXT_SEPARATE
    key ChangeMaster.ChangeNumber,
        ChangeMaster.ChangeNumberDescription,
        @Consumption.semanticObject: 'ChangeRecord'
        @UI.lineItem: [
            {
                qualifier: 'ChangeMaster',
                position:20,
                label:'Linked Change Record'
            }
        ]
        @ObjectModel.text.element:  [ 'ChgRecordDescriptionText' ]
        _Document.ChangeRecord,
        _Document.Partner, 
        _Document.ChgRecordDescriptionText,
        _Document.ChangeRecordType,
        @UI.lineItem: [{qualifier: 'ChangeMaster',position:30,label:'Valid From'}]
        cast(ChangeMaster.ChangeNumberValidFromDate as abap.dats) as ChangeNumberValidFromDate
}

where
  //to filter out dirty data

      ChangeMaster.ChangeNumber != ' '
  and ChangeNumberValidFromDate >= $session.system_date
  //avoid Change Master(valid from 9999-12-31) generated from Change Record

  and ChangeNumberValidFromDate != '99991231'

Learn More