E_InsuranceContract

@EndUserText.label: 'Insurance Policy Contract - Extension'
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@VDM                                  : {
  viewType                            : #EXTENSION
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'BPD',
  allowNewDatasources: false,
  dataSources: ['Persistence'],
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}
define view entity E_InsuranceContract
  as select from           /pm0/abdapolpr as Persistence
//    left outer to one join /pm0/aldapolpr as _LifePersistence    on  Persistence.policy_id        = _LifePersistence.policy_id

//                                                                 and Persistence.policyproduct_id = _LifePersistence.policyproduct_id

//                                                                 and Persistence.journalno_id     = _LifePersistence.journalno_id

//                                                                 and Persistence.journalendno_id  = _LifePersistence.journalendno_id

//    left outer to one join /pm0/apdapolpr as _GeneralPersistence on  Persistence.policy_id        = _GeneralPersistence.policy_id

//                                                                 and Persistence.policyproduct_id = _GeneralPersistence.policyproduct_id

//                                                                 and Persistence.journalno_id     = _GeneralPersistence.journalno_id

//                                                                 and Persistence.journalendno_id  = _GeneralPersistence.journalendno_id

{
  key       cast( Persistence.policy_id as /pm0/vdm_policy_uuid preserving type )          as InsurPlcyUUID,
  key       Persistence.policyproduct_id                                                   as InsurPlcyInsurContr,
  key       cast( Persistence.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key       Persistence.journalendno_id                                                    as InsurPlcyJrnlEndNmbr

}