E_InsurancePolicyInsuredObject

@EndUserText.label: 'Insurance Insured Object - Extension'
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@VDM                                  : {
  viewType                            : #EXTENSION
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity E_InsurancePolicyInsuredObject
  as select from /pm0/abdasubjct  as Persistence
    inner join   /pm0/abdasubjct1 as _Persistence1 on  Persistence.policy_id        = _Persistence1.policy_id
                                                   and Persistence.policyproduct_id = _Persistence1.policyproduct_id
                                                   and Persistence.covpac_id        = _Persistence1.covpac_id
                                                   and Persistence.coverage_id      = _Persistence1.coverage_id
                                                   and Persistence.covcp_id         = _Persistence1.covcp_id
                                                   and Persistence.subject_id       = _Persistence1.subject_id
                                                   and Persistence.journalno_id     = _Persistence1.journalno_id
                                                   and Persistence.journalendno_id  = _Persistence1.journalendno_id
    inner join   /pm0/abdasubjct2 as _Persistence2 on  Persistence.policy_id        = _Persistence2.policy_id
                                                   and Persistence.policyproduct_id = _Persistence2.policyproduct_id
                                                   and Persistence.covpac_id        = _Persistence2.covpac_id
                                                   and Persistence.coverage_id      = _Persistence2.coverage_id
                                                   and Persistence.covcp_id         = _Persistence2.covcp_id
                                                   and Persistence.subject_id       = _Persistence2.subject_id
                                                   and Persistence.journalno_id     = _Persistence2.journalno_id
                                                   and Persistence.journalendno_id  = _Persistence2.journalendno_id
    inner join   /pm0/abdasubjct3 as _Persistence3 on  Persistence.policy_id        = _Persistence3.policy_id
                                                   and Persistence.policyproduct_id = _Persistence3.policyproduct_id
                                                   and Persistence.covpac_id        = _Persistence3.covpac_id
                                                   and Persistence.coverage_id      = _Persistence3.coverage_id
                                                   and Persistence.covcp_id         = _Persistence3.covcp_id
                                                   and Persistence.subject_id       = _Persistence3.subject_id
                                                   and Persistence.journalno_id     = _Persistence3.journalno_id
                                                   and Persistence.journalendno_id  = _Persistence3.journalendno_id
    inner join   /pm0/abdasubjct4 as _Persistence4 on  Persistence.policy_id        = _Persistence4.policy_id
                                                   and Persistence.policyproduct_id = _Persistence4.policyproduct_id
                                                   and Persistence.covpac_id        = _Persistence4.covpac_id
                                                   and Persistence.coverage_id      = _Persistence4.coverage_id
                                                   and Persistence.covcp_id         = _Persistence4.covcp_id
                                                   and Persistence.subject_id       = _Persistence4.subject_id
                                                   and Persistence.journalno_id     = _Persistence4.journalno_id
                                                   and Persistence.journalendno_id  = _Persistence4.journalendno_id
    inner join   /pm0/abdasubjct5 as _Persistence5 on  Persistence.policy_id        = _Persistence5.policy_id
                                                   and Persistence.policyproduct_id = _Persistence5.policyproduct_id
                                                   and Persistence.covpac_id        = _Persistence5.covpac_id
                                                   and Persistence.coverage_id      = _Persistence5.coverage_id
                                                   and Persistence.covcp_id         = _Persistence5.covcp_id
                                                   and Persistence.subject_id       = _Persistence5.subject_id
                                                   and Persistence.journalno_id     = _Persistence5.journalno_id
                                                   and Persistence.journalendno_id  = _Persistence5.journalendno_id
    inner join   /pm0/abdasubjct6 as _Persistence6 on  Persistence.policy_id        = _Persistence6.policy_id
                                                   and Persistence.policyproduct_id = _Persistence6.policyproduct_id
                                                   and Persistence.covpac_id        = _Persistence6.covpac_id
                                                   and Persistence.coverage_id      = _Persistence6.coverage_id
                                                   and Persistence.covcp_id         = _Persistence6.covcp_id
                                                   and Persistence.subject_id       = _Persistence6.subject_id
                                                   and Persistence.journalno_id     = _Persistence6.journalno_id
                                                   and Persistence.journalendno_id  = _Persistence6.journalendno_id
{
  key       cast( Persistence.policy_id as /pm0/vdm_policy_uuid preserving type )          as InsurPlcyUUID,
  key       Persistence.policyproduct_id                                                   as InsurPlcyInsurContr,
  key       Persistence.covpac_id                                                          as InsurPlcyCoveragePackageID,
  key       Persistence.coverage_id                                                        as InsurPlcyCoverageID,
  key       Persistence.covcp_id                                                           as InsurPlcyCoverageOptionID,
  key       Persistence.subject_id                                                         as InsurPlcyInsuredObjectID,
  key       cast( Persistence.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key       Persistence.journalendno_id                                                    as InsurPlcyJrnlEndNmbr

}