E_InsurancePolicyInsuredObject

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

@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'IOB',
  allowNewDatasources: false,
  dataSources: ['Persistence','_Persistence1','_Persistence2','_Persistence4','_Persistence5','_Persistence6'],
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}

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

  association [1..1] to E_InsurPlcyInsrdObj1 as _Persistence1 on  $projection.InsurPlcyUUID              = _Persistence1.InsurPlcyUUID
                                                              and $projection.InsurPlcyInsurContr        = _Persistence1.InsurPlcyInsurContr
                                                              and $projection.InsurPlcyCoveragePackageID = _Persistence1.InsurPlcyCoveragePackageID
                                                              and $projection.InsurPlcyCoverageID        = _Persistence1.InsurPlcyCoverageID
                                                              and $projection.InsurPlcyCoverageOptionID  = _Persistence1.InsurPlcyCoverageOptionID
                                                              and $projection.InsurPlcyInsuredObjectID   = _Persistence1.InsurPlcyInsuredObjectID
                                                              and $projection.InsurPlcyJrnlNmbr          = _Persistence1.InsurPlcyJrnlNmbr
                                                              and $projection.InsurPlcyJrnlEndNmbr       = _Persistence1.InsurPlcyJrnlEndNmbr
  association [1..1] to E_INSURPLCYINSRDOBJ2 as _Persistence2 on  $projection.InsurPlcyUUID              = _Persistence2.InsurPlcyUUID
                                                              and $projection.InsurPlcyInsurContr        = _Persistence2.InsurPlcyInsurContr
                                                              and $projection.InsurPlcyCoveragePackageID = _Persistence2.InsurPlcyCoveragePackageID
                                                              and $projection.InsurPlcyCoverageID        = _Persistence2.InsurPlcyCoverageID
                                                              and $projection.InsurPlcyCoverageOptionID  = _Persistence2.InsurPlcyCoverageOptionID
                                                              and $projection.InsurPlcyInsuredObjectID   = _Persistence2.InsurPlcyInsuredObjectID
                                                              and $projection.InsurPlcyJrnlNmbr          = _Persistence2.InsurPlcyJrnlNmbr
                                                              and $projection.InsurPlcyJrnlEndNmbr       = _Persistence2.InsurPlcyJrnlEndNmbr
  association [1..1] to E_INSURPLCYINSRDOBJ4 as _Persistence4 on  $projection.InsurPlcyUUID              = _Persistence4.InsurPlcyUUID
                                                              and $projection.InsurPlcyInsurContr        = _Persistence4.InsurPlcyInsurContr
                                                              and $projection.InsurPlcyCoveragePackageID = _Persistence4.InsurPlcyCoveragePackageID
                                                              and $projection.InsurPlcyCoverageID        = _Persistence4.InsurPlcyCoverageID
                                                              and $projection.InsurPlcyCoverageOptionID  = _Persistence4.InsurPlcyCoverageOptionID
                                                              and $projection.InsurPlcyInsuredObjectID   = _Persistence4.InsurPlcyInsuredObjectID
                                                              and $projection.InsurPlcyJrnlNmbr          = _Persistence4.InsurPlcyJrnlNmbr
                                                              and $projection.InsurPlcyJrnlEndNmbr       = _Persistence4.InsurPlcyJrnlEndNmbr
  association [1..1] to E_INSURPLCYINSRDOBJ5 as _Persistence5 on  $projection.InsurPlcyUUID              = _Persistence5.InsurPlcyUUID
                                                              and $projection.InsurPlcyInsurContr        = _Persistence5.InsurPlcyInsurContr
                                                              and $projection.InsurPlcyCoveragePackageID = _Persistence5.InsurPlcyCoveragePackageID
                                                              and $projection.InsurPlcyCoverageID        = _Persistence5.InsurPlcyCoverageID
                                                              and $projection.InsurPlcyCoverageOptionID  = _Persistence5.InsurPlcyCoverageOptionID
                                                              and $projection.InsurPlcyInsuredObjectID   = _Persistence5.InsurPlcyInsuredObjectID
                                                              and $projection.InsurPlcyJrnlNmbr          = _Persistence5.InsurPlcyJrnlNmbr
                                                              and $projection.InsurPlcyJrnlEndNmbr       = _Persistence5.InsurPlcyJrnlEndNmbr
  association [1..1] to E_INSURPLCYINSRDOBJ6 as _Persistence6 on  $projection.InsurPlcyUUID              = _Persistence6.InsurPlcyUUID
                                                              and $projection.InsurPlcyInsurContr        = _Persistence6.InsurPlcyInsurContr
                                                              and $projection.InsurPlcyCoveragePackageID = _Persistence6.InsurPlcyCoveragePackageID
                                                              and $projection.InsurPlcyCoverageID        = _Persistence6.InsurPlcyCoverageID
                                                              and $projection.InsurPlcyCoverageOptionID  = _Persistence6.InsurPlcyCoverageOptionID
                                                              and $projection.InsurPlcyInsuredObjectID   = _Persistence6.InsurPlcyInsuredObjectID
                                                              and $projection.InsurPlcyJrnlNmbr          = _Persistence6.InsurPlcyJrnlNmbr
                                                              and $projection.InsurPlcyJrnlEndNmbr       = _Persistence6.InsurPlcyJrnlEndNmbr
{
  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

}