I_INSURPLCYPREMPAYERBASIC

CDS View

Premium Payer in Insurance Policy

I_INSURPLCYPREMPAYERBASIC is a CDS View in S/4HANA. Premium Payer in Insurance Policy. It contains 19 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_InsurancePolicyPremPayer view_entity from COMPOSITE Premium Payer in Insurance Policy
I_InsurApplPremPayer view_entity inner COMPOSITE Premium Payer in Insurance Application
I_InsurOpenApplPremPayer view_entity from COMPOSITE Premium Payer in Insur Open Application
P_InsurOpenApplPremPayer view_entity from COMPOSITE Insurance Open Application Premium Payer
P_InsurOpenApplPremPayer view_entity union COMPOSITE Insurance Open Application Premium Payer
R_InsurPlcyPremiumPayerTP_2 view_entity from TRANSACTIONAL Premium Payer
R_InsurPlcySrchPremPayerTP view_entity from TRANSACTIONAL Search Premium Payer

Fields (19)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyContrPremPayerID InsurPlcyContrPremPayerID 5
KEY InsurPlcyInsurContr InsurPlcyInsurContr 5
KEY InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 4
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 5
KEY InsurPlcyUUID InsurPlcyUUID 2
AddressID AddressID 4
BankIdentification BankIdentification 3
CAPaymentMethod CAPaymentMethod 3
InsurPlcyCollectionType InsurPlcyCollectionType 3
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency 3
InsurPlcyPremiumPayerID InsurPlcyPremiumPayerID 4
InsurPlcyPremiumPayerTemplate InsurPlcyPremiumPayerTemplate 3
InsurPlcyPremPayerShareAmount InsurPlcyPremPayerShareAmount 3
InsurPlcyPremPayerSharePercent InsurPlcyPremPayerSharePercent 3
InsurPlcyPremPyrRmngAmtIsAssgd InsurPlcyPremPyrRmngAmtIsAssgd 3
InsurPlcyProductPackageID InsurPlcyProductPackageID 3
LastChangeDateTime LastChangeDateTime 3
PaymentCardID PaymentCardID 3
SEPAMandate SEPAMandate 3
@EndUserText.label: 'Premium Payer in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyContrPremPayerID',
   semanticKey: [ 'InsurPlcyPremiumPayerID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Analytics: {
  technicalName: 'IPPremPyrBsc'
}

define view entity I_InsurPlcyPremPayerBasic
  as select from /pm0/abdaprmpayr as PremPayer

  association [1..1] to I_Currency as _Currency on $projection.InsurPlcyPremiumCurrency = _Currency.Currency

{

  key cast( PremPayer.policy_id     as /pm0/vdm_policy_uuid preserving type )       as InsurPlcyUUID,
  key PremPayer.policyproduct_id                                                    as InsurPlcyInsurContr,
  key PremPayer.prmpayr_id                                                          as InsurPlcyContrPremPayerID,
  key cast( PremPayer.journalno_id  as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key PremPayer.journalendno_id                                                     as InsurPlcyJrnlEndNmbr,
      PremPayer.ppdpac_id                                                           as InsurPlcyProductPackageID,
      @Semantics.booleanIndicator:true
      PremPayer.cancel_fg                                                           as InsurPlcyPremPayerIsCanceled,        
      cast( PremPayer.addressnumber_id  as /pm0/vdm_address_id preserving type )    as AddressID,
      PremPayer.partner_id                                                          as InsurPlcyPremiumPayerID,
      cast( PremPayer.bankacc_id        as bu_bkvid preserving type )               as BankIdentification,
      cast( PremPayer.paymentcard_id    as bu_ccid preserving type )                as PaymentCardID,
      cast( PremPayer.incpaymethod_cd   as pymet_kk preserving type )               as CAPaymentMethod,
      PremPayer.pm_id                                                               as InsurPlcyPremiumPayerTemplate,
      cast( PremPayer.sepa_mandate_id   as sepa_mndid preserving type )             as SEPAMandate,
      @Consumption.hidden: true
      PremPayer.bo_cd                                                               as InsurPlcyBusinessObject,
      PremPayer.colltype_cd                                                         as InsurPlcyCollectionType,
      @Semantics.systemDateTime.lastChangedAt: true
      PremPayer.change_ts                                                           as LastChangeDateTime,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      PremPayer.share_am                                                            as InsurPlcyPremPayerShareAmount,
      PremPayer.share_vl                                                            as InsurPlcyPremPayerSharePercent,
      @Semantics.booleanIndicator:true
      PremPayer.allocremaind_fg                                                     as InsurPlcyPremPyrRmngAmtIsAssgd,
      PremPayer.paymacc_cd                                                          as InsurPlcyPremPayerCollAcctID,         
      PremPayer.paympart_cd                                                         as InsurPlcyPremPyrPaytPrtn,            
      PremPayer.insobj_cd                                                           as InsurPlcyPremPyrInsurObject,          
      PremPayer.paympolicy_id                                                       as InsurPlcyPremPyrSettlmtPlcy,           
      PremPayer.paympolpr_id                                                        as InsurPlcyPremPyrSettlmtContr,        
      PremPayer.checkno_id                                                          as InsurPlcyPremPyrCheckNmbr,             
      PremPayer.brokerinsobj_id                                                     as InsurPlcyPremPyrBrkrInsurObj,       
      PremPayer.brokerbp_id                                                         as InsurPlcyPremPyrBrkrBPNmbr,            
      PremPayer.def_mp_drv_fg                                                       as InsurPlcyPremPyrIsDefaulted,        
      PremPayer.def_mp_drv_cltyp_fg                                                 as InsurPlcyPremPyrIsBrkrCollDrvd,        
      @ObjectModel.foreignKey.association: '_Currency'
      PremPayer.currency_id                                                         as InsurPlcyPremiumCurrency,

      _Currency

}