I_InsurancePolicyPremPayer

DDL: I_INSURANCEPOLICYPREMPAYER Type: view_entity COMPOSITE

Premium Payer in Insurance Policy

I_InsurancePolicyPremPayer is a Composite CDS View that provides data about "Premium Payer in Insurance Policy" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyPremPayerBasic) and exposes 28 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyContrPremPayerID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyPremPayerBasic PremPayer from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_Currency _Currency $projection.InsurPlcyPremiumCurrency = _Currency.Currency
[1..1] I_InsurancePolicy _InsurancePolicy $projection.InsurPlcyUUID = _InsurancePolicy.InsurPlcyUUID
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyPremiumPayerTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID
[0..1] I_BusinessPartner _BusinessPartner $projection.InsurPlcyPremiumPayerID = _BusinessPartner.BusinessPartner
[0..*] I_CAPaymentMethodText _CAPaymentMethodText $projection.CAPaymentMethod = _CAPaymentMethodText.CAPaymentMethod and $projection.InsurPlcyCountry = _CAPaymentMethodText.Country
[1..1] I_InsurPlcyCollectionType _InsurPlcyCollectionType $projection.InsurPlcyCollectionType = _InsurPlcyCollectionType.InsurPlcyCollectionType

Annotations (11)

NameValueLevelField
EndUserText.label Premium Payer in Insurance Policy view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyContrPremPayerID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IPPlcyPremPyr view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyPremPayerBasic InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyPremPayerBasic InsurPlcyInsurContr
KEY InsurPlcyContrPremPayerID I_InsurPlcyPremPayerBasic InsurPlcyContrPremPayerID
InsurPlcyJrnlNmbr I_InsurPlcyPremPayerBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyPremPayerBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyPremPayerBasic InsurPlcyProductPackageID
AddressID I_InsurPlcyPremPayerBasic AddressID
InsurPlcyPremiumPayerID I_InsurPlcyPremPayerBasic InsurPlcyPremiumPayerID
BankIdentification I_InsurPlcyPremPayerBasic BankIdentification
PaymentCardID I_InsurPlcyPremPayerBasic PaymentCardID
CAPaymentMethod I_InsurPlcyPremPayerBasic CAPaymentMethod
InsurPlcyPremiumPayerTemplate I_InsurPlcyPremPayerBasic InsurPlcyPremiumPayerTemplate
SEPAMandate I_InsurPlcyPremPayerBasic SEPAMandate
LastChangeDateTime I_InsurPlcyPremPayerBasic LastChangeDateTime
InsurPlcyCountry _InsuranceContract InsurPlcyCountry
InsurPlcyCollectionType I_InsurPlcyPremPayerBasic InsurPlcyCollectionType
InsurPlcyPremPayerShareAmount I_InsurPlcyPremPayerBasic InsurPlcyPremPayerShareAmount
InsurPlcyPremPayerSharePercent I_InsurPlcyPremPayerBasic InsurPlcyPremPayerSharePercent
InsurPlcyPremPyrRmngAmtIsAssgd I_InsurPlcyPremPayerBasic InsurPlcyPremPyrRmngAmtIsAssgd
InsurPlcyPremiumCurrency I_InsurPlcyPremPayerBasic InsurPlcyPremiumCurrency
_InsurancePolicy _InsurancePolicy
_InsuranceContract _InsuranceContract
_BusinessPartner _BusinessPartner
_Address _Address
_Currency _Currency
_InsurPlcyTemplateT _InsurPlcyTemplateT
_CAPaymentMethodText _CAPaymentMethodText
_InsurPlcyCollectionType _InsurPlcyCollectionType
@EndUserText.label: 'Premium Payer in Insurance Policy'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA'),
  privilegedAssociations:  [  '_BusinessPartner',
                              '_Address']
}
@ObjectModel: {
   representativeKey: 'InsurPlcyContrPremPayerID',
   semanticKey: [ 'InsurPlcyPremiumPayerID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPPlcyPremPyr'
}

define view entity I_InsurancePolicyPremPayer
  as select from I_InsurPlcyPremPayerBasic as PremPayer

  association        to parent I_InsuranceContract as _InsuranceContract       on  $projection.InsurPlcyUUID       = _InsuranceContract.InsurPlcyUUID
                                                                               and $projection.InsurPlcyInsurContr = _InsuranceContract.InsurPlcyInsurContr

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

  association [1..*] to I_InsurPlcyTemplateT       as _InsurPlcyTemplateT      on  $projection.InsurPlcyPremiumPayerTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate
  association [0..1] to I_Address                  as _Address                 on  $projection.AddressID = _Address.AddressID
  association [0..1] to I_BusinessPartner          as _BusinessPartner         on  $projection.InsurPlcyPremiumPayerID = _BusinessPartner.BusinessPartner

  association [0..*] to I_CAPaymentMethodText      as _CAPaymentMethodText     on  $projection.CAPaymentMethod  = _CAPaymentMethodText.CAPaymentMethod
                                                                               and $projection.InsurPlcyCountry = _CAPaymentMethodText.Country
  association [1..1] to I_InsurPlcyCollectionType  as _InsurPlcyCollectionType on  $projection.InsurPlcyCollectionType = _InsurPlcyCollectionType.InsurPlcyCollectionType

{

  key PremPayer.InsurPlcyUUID,
  key PremPayer.InsurPlcyInsurContr,
  key PremPayer.InsurPlcyContrPremPayerID,
      PremPayer.InsurPlcyJrnlNmbr,
      PremPayer.InsurPlcyJrnlEndNmbr,
      PremPayer.InsurPlcyProductPackageID,
      @ObjectModel.foreignKey.association: '_Address'
      PremPayer.AddressID,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
      @ObjectModel.sapObjectNodeTypeReference: 'BusinessPartner'
      PremPayer.InsurPlcyPremiumPayerID,
      PremPayer.BankIdentification,
      PremPayer.PaymentCardID,
      @ObjectModel.text.association: '_CAPaymentMethodText'
      @ObjectModel.sapObjectNodeTypeReference: 'ContrAcctgPaymentMethod'
      PremPayer.CAPaymentMethod,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      // @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'

      PremPayer.InsurPlcyPremiumPayerTemplate,
      PremPayer.SEPAMandate,
      @Semantics.systemDateTime.lastChangedAt: true
      PremPayer.LastChangeDateTime,
      _InsuranceContract.InsurPlcyCountry as InsurPlcyCountry,
      @ObjectModel.text.association: '_InsurPlcyCollectionType'
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyCollectionType'
      PremPayer.InsurPlcyCollectionType,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      PremPayer.InsurPlcyPremPayerShareAmount,
      PremPayer.InsurPlcyPremPayerSharePercent,
      PremPayer.InsurPlcyPremPyrRmngAmtIsAssgd,
      @ObjectModel.foreignKey.association: '_Currency'
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      PremPayer.InsurPlcyPremiumCurrency,

      /* Associations */
      _InsurancePolicy,
      _InsuranceContract,
      _BusinessPartner,
      _Address,
      _Currency,

      @Consumption.hidden: true
      _InsurPlcyTemplateT,
      @Consumption.hidden: true
      _CAPaymentMethodText,
      @Consumption.hidden: true
      _InsurPlcyCollectionType

}
where
      PremPayer.InsurPlcyJrnlEndNmbr    = 2147483647
  and PremPayer.InsurPlcyBusinessObject = 'P'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCECONTRACT",
"I_INSURPLCYPREMPAYERBASIC"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_BUSINESSPARTNER",
"I_CAPAYMENTMETHODTEXT",
"I_CURRENCY",
"I_INSURANCECONTRACT",
"I_INSURANCEPOLICY",
"I_INSURPLCYCOLLECTIONTYPE",
"I_INSURPLCYTEMPLATET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/