C_ChangeRecordClassCharc

@AbapCatalog.sqlViewName: 'CCHGRCDCLSCHR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Change Record Class Characteristics'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey:true
@ObjectModel.usageType: {serviceQuality: #C,
                        dataClass: #MIXED,
                        sizeCategory: #XXL}
@ClientHandling.algorithm: #SESSION_VARIABLE
//@ObjectModel: {

//   semanticKey: ['Characteristic'],

//   createEnabled: true,

//   deleteEnabled:'EXTERNAL_CALCULATION',

//   updateEnabled,

//   transactionalProcessingDelegated: true

//}


@UI.headerInfo:{
  typeName: 'Characteristcs Assigned',
  typeNamePlural: 'Characteristics Assigned',
  imageUrl: 'ProductImageURL'
//  title:{value:'MaterialName'}

}


define view C_ChangeRecordClassCharc
  as select from I_ClfnCharcBasic as CharcBasic

  association [0..*] to I_ClfnCharcDesc         as _CharcDesc       on  $projection.CharcInternalID  =  _CharcDesc.CharcInternalID
                                                                    and _CharcDesc.Language          = $session.system_language
                                                                    and _CharcDesc.IsDeleted         <> 'X'
                                                                    and _CharcDesc.ValidityStartDate <= $session.system_date
                                                                    and _CharcDesc.ValidityEndDate   >= $session.system_date

  association [0..1] to I_ClfnCharcDataTypeText as _CharTypeText    on  $projection.CharcDataType = _CharTypeText.CharcDataType
                                                                    and _CharTypeText.Language    = $session.system_language

  association [0..*] to I_ClfnClassCharcBasic   as _ClassCharcBasic on  $projection.CharcInternalID = _ClassCharcBasic.CharcInternalID


{


  key     _ClassCharcBasic.ClassInternalID,
          @UI.hidden: true
          @ObjectModel.readOnly: true
  key     CharcInternalID,

          @UI.lineItem:[{
               position:10,
                importance:#HIGH }
                            ]
          @UI.identification: {position: 10, importance: #HIGH}
          @ObjectModel.text.element:  [ 'CharcDescription' ]
          Characteristic,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          _CharcDesc[1:Language = $session.system_language].CharcDescription     as CharcDescription, // Cardinality is actually 1 due to selection by validity date

          @UI.lineItem:[{
              position:20,
              importance:#HIGH }
                  ]
          @UI.identification: {position:20, importance: #HIGH}
          @EndUserText.label: 'Data Type'
          @ObjectModel.text.element:  [ 'CharcDataTypeName' ]
          CharcDataType,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          _CharTypeText[1:Language = $session.system_language].CharcDataTypeName as CharcDataTypeName,

          @UI.lineItem:[{
              position:30,
              importance:#HIGH }
                  ]
          @UI.identification: {position:30, importance: #HIGH}
          @EndUserText.label: 'Number of Chars'
          CharcLength,
          @UI.lineItem:[{
             position:40,
             importance:#HIGH }
                 ]
          @UI.identification: {position:40, importance: #HIGH}
          CharcDecimals,


          @ObjectModel.readOnly: true
          CharcValueUnit,


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

          //   _ChangeRecordObjPg,

          // _ChangeRecordObjPgCharc,

          _CharcDesc,
          _CharTypeText


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCBASIC",
"I_CLFNCHARCDATATYPETEXT",
"I_CLFNCHARCDESC",
"I_CLFNCLASSCHARCBASIC"
],
"ASSOCIATED":
[
"I_CLFNCHARCDATATYPETEXT",
"I_CLFNCHARCDESC",
"I_CLFNCLASSCHARCBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/