E_InsurPlcyExtRef

DDL: E_INSURPLCYEXTREF Type: view_entity EXTENSION Package: VDM_PM_PLCY_EXT

Insur Policy External Ref - Extension

E_InsurPlcyExtRef is a Extension CDS View that provides data about "Insur Policy External Ref - Extension" in SAP S/4HANA. It reads from 1 data source (/pm0/abdaexref) and exposes 9 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyJrnlEndNmbr, InsurPlcyJrnlNmbr, InsurPlcyCoveragePackageID. Part of development package VDM_PM_PLCY_EXT.

Data Sources (1)

SourceAliasJoin Type
/pm0/abdaexref Persistence from

Annotations (6)

NameValueLevelField
EndUserText.label Insur Policy External Ref - Extension view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #EXTENSION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID
KEY InsurPlcyInsurContr /pm0/abdaexref policyproduct_id
KEY InsurPlcyJrnlEndNmbr /pm0/abdaexref journalendno_id
KEY InsurPlcyJrnlNmbr
KEY InsurPlcyCoveragePackageID /pm0/abdaexref covpac_id
KEY InsurPlcyCoverageID /pm0/abdaexref coverage_id
KEY InsurPlcyCoverageOptionID /pm0/abdaexref covcp_id
KEY InsurPlcyInsuredObjectID /pm0/abdaexref subject_id
KEY InsurPlcyExternalReferenceID /pm0/abdaexref exref_id
@EndUserText.label: 'Insur Policy External Ref - Extension'
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@VDM                                  : {
  viewType                            : #EXTENSION
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
define view entity E_InsurPlcyExtRef as select from /pm0/abdaexref as Persistence
{
  key cast( Persistence.policy_id as /pm0/vdm_policy_uuid preserving type )           as InsurPlcyUUID,
  key Persistence.policyproduct_id                                                    as InsurPlcyInsurContr,
  key Persistence.journalendno_id                                                     as InsurPlcyJrnlEndNmbr,
  key cast( Persistence.journalno_id  as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  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 Persistence.exref_id                                                            as InsurPlcyExternalReferenceID
}