E_InsuranceContract

DDL: E_INSURANCECONTRACT Type: view_entity EXTENSION Package: VDM_PM_PLCY_EXT

Insurance Contract - Extension

E_InsuranceContract is a Extension CDS View that provides data about "Insurance Contract - Extension" in SAP S/4HANA. It reads from 1 data source (/pm0/abdapolpr) and exposes 4 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyJrnlNmbr, InsurPlcyJrnlEndNmbr. Part of development package VDM_PM_PLCY_EXT.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
/pm0/abdapolpr Persistence from

Annotations (6)

NameValueLevelField
EndUserText.label Insurance Contract - 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 (4)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID
KEY InsurPlcyInsurContr /pm0/abdapolpr policyproduct_id
KEY InsurPlcyJrnlNmbr
KEY InsurPlcyJrnlEndNmbr /pm0/abdapolpr journalendno_id 
@EndUserText.label: 'Insurance Contract - Extension'
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@VDM                                  : {
  viewType                            : #EXTENSION
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

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

}

Learn More