I_INSURPLCYEXTREFERENCEBASIC

CDS View

External Reference in Insurance Policy

I_INSURPLCYEXTREFERENCEBASIC is a CDS View in S/4HANA. External Reference in Insurance Policy. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
R_InsurPlcyContrExtRefTP view_entity from TRANSACTIONAL External Reference under Contract
R_InsurPlcyCvrgExtRefTP view_entity from TRANSACTIONAL External Reference under Coverage
R_InsurPlcyExternalReferenceTP view_entity from TRANSACTIONAL External Reference under Policy 
@EndUserText.label: 'External Reference in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
  }
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ObjectModel: {
  representativeKey: 'InsurPlcyExternalReferenceID',
  semanticKey: [ 'InsurPlcyExternalReferenceID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
      supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
//@Metadata.allowExtensions: true

@Analytics: {
  technicalName: 'IPExtReferenceBsc'
}
define view entity I_InsurPlcyExtReferenceBasic
  as select from /pm0/abdaexref as ExtReference
{
  key cast( ExtReference.policy_id as /pm0/vdm_policy_uuid preserving type )           as InsurPlcyUUID,
  key ExtReference.policyproduct_id                                                    as InsurPlcyInsurContr,
  key ExtReference.journalendno_id                                                     as InsurPlcyJrnlEndNmbr,
  key cast( ExtReference.journalno_id  as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key ExtReference.covpac_id                                                           as InsurPlcyCoveragePackageID,
  key ExtReference.coverage_id                                                         as InsurPlcyCoverageID,
  key ExtReference.covcp_id                                                            as InsurPlcyCoverageOptionID,
  key ExtReference.subject_id                                                          as InsurPlcyInsuredObjectID,
  key ExtReference.exref_id                                                            as InsurPlcyExternalReferenceID,
      ExtReference.ppdpac_id                                                           as InsurPlcyProductPackageID,
      @Semantics.booleanIndicator:true
      ExtReference.cancel_fg                                                           as InsurPlcyExtRefIsCancelled,
      ExtReference.refcom_cd                                                           as InsurPlcyExtRefCompany,
      ExtReference.refnumber_tt                                                        as InsurPlcyExtRefReferenceNumber,
      ExtReference.reftyp_cd                                                           as InsurPlcyExtRefReferenceType,
      ExtReference.pm_id                                                               as InsurPlcyExtRefTemplate,
      @Consumption.hidden: true
      ExtReference.bo_cd                                                               as InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      cast( ExtReference.change_ts      as vdm_lastchangedon preserving type )         as LastChangeDateTime

}

Learn More