E_InsurancePolicyPremium

DDL: E_INSURANCEPOLICYPREMIUM Type: view_entity EXTENSION Package: VDM_PM_PLCY_EXT

Insurance Premium - Extension

E_InsurancePolicyPremium is a Extension CDS View that provides data about "Insurance Premium - Extension" in SAP S/4HANA. It reads from 1 data source (/pm0/abdaprem) and exposes 9 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyCoverageOptionID. Part of development package VDM_PM_PLCY_EXT.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
/pm0/abdaprem Persistence from

Annotations (6)

NameValueLevelField
EndUserText.label Insurance Premium - 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/abdaprem policyproduct_id
KEY InsurPlcyCoveragePackageID /pm0/abdaprem covpac_id
KEY InsurPlcyCoverageID /pm0/abdaprem coverage_id
KEY InsurPlcyCoverageOptionID /pm0/abdaprem covcp_id
KEY InsurPlcyInsuredObjectID /pm0/abdaprem subject_id
KEY InsurancePolicyPremium /pm0/abdaprem premium_id
KEY InsurPlcyJrnlNmbr
KEY InsurPlcyJrnlEndNmbr /pm0/abdaprem journalendno_id 
@EndUserText.label: 'Insurance Premium - Extension'
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY
}
@VDM                                  : {
  viewType                            : #EXTENSION
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity E_InsurancePolicyPremium
  as select from           /pm0/abdaprem as Persistence
    left outer to one join /pm0/aldaprem as _LifePersistence on  Persistence.policy_id        = _LifePersistence.policy_id
                                                             and Persistence.policyproduct_id = _LifePersistence.policyproduct_id
                                                             and Persistence.covpac_id        = _LifePersistence.covpac_id
                                                             and Persistence.coverage_id      = _LifePersistence.coverage_id
                                                             and Persistence.covcp_id         = _LifePersistence.covcp_id
                                                             and Persistence.subject_id       = _LifePersistence.subject_id
                                                             and Persistence.premium_id       = _LifePersistence.premium_id
                                                             and Persistence.journalno_id     = _LifePersistence.journalno_id
                                                             and Persistence.journalendno_id  = _LifePersistence.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       Persistence.subject_id                                                         as InsurPlcyPremSubjectID,

  key       Persistence.premium_id                                                         as InsurancePolicyPremium,
  key       cast( Persistence.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key       Persistence.journalendno_id                                                    as InsurPlcyJrnlEndNmbr

}

Learn More