I_INSURANCEPOLICYCONTRCLAUSE

CDS View

Contract Clause in Insurance Policy

I_INSURANCEPOLICYCONTRCLAUSE is a CDS View in S/4HANA. Contract Clause in Insurance Policy. It contains 17 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 17 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_InsurPlcyClause view_entity from CONSUMPTION Clause
R_InsurancePolicyContrClauseTP view_entity from TRANSACTIONAL Contract Clause in Insurance Policy - TP

Fields (17)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyClauseID InsurPlcyClauseID 1
KEY InsurPlcyInsurContr InsurPlcyInsurContr 1
KEY InsurPlcyUUID InsurPlcyUUID 1
InsurPlcyClauseDetailTextUUID InsurPlcyClauseDetailTextUUID 1
InsurPlcyClauseEndDate InsurPlcyClauseEndDate 1
InsurPlcyClauseStartDate InsurPlcyClauseStartDate 1
InsurPlcyClauseTemplate InsurancePolicyClauseControl 1
InsurPlcyClauseType InsurPlcyClauseType 1
InsurPlcyIndivClauseAgrmtText InsurPlcyIndivClauseAgrmtText 1
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 1
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 1
InsurPlcyProductPackageID InsurPolicyContractPackageID 1
Language Language 1
LastChangeDateTime LastChangeDateTime 1
LongText LongText 1
TextObjectCategory TextObjectCategory 1
TextObjectKey TextObjectKey 1 
@EndUserText.label: 'Contract Clause in Insurance Policy'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyClauseID',
   semanticKey: [ 'InsurPlcyClauseID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IPPlcyContrCls'
}

define view entity I_InsurancePolicyContrClause
  as select from           I_InsurPlcyClauseBasic        as Clause

    left outer to one join I_InsurPlcyClauseLongTxtBasic as LongText on Clause.InsurPlcyClauseDetailTextUUID = LongText.InsurPlcyClauseDetailTextUUID

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

  association [1..1] to I_InsurPlcyClauseTypeLink  as _InsurancePolicyClauseType on  $projection.InsurPlcyClauseType     = _InsurancePolicyClauseType.InsurPlcyClauseType
                                                                                 and $projection.InsurPlcyClauseTemplate = _InsurancePolicyClauseType.InsurPlcyClauseTemplate
  association [1..*] to I_InsurPlcyTemplateT       as _InsurPlcyTemplateT        on  $projection.InsurPlcyClauseTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

{

  key Clause.InsurPlcyUUID,
  key Clause.InsurPlcyInsurContr,
  key Clause.InsurPlcyCoveragePackageID,
  key Clause.InsurPlcyCoverageID,
  key Clause.InsurPlcySubCvrgID,
  key Clause.InsurPlcyInsuredObjectID,
  key Clause.InsurPlcyClauseID,
      Clause.InsurPlcyJrnlNmbr,
      Clause.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Clause.InsurPlcyProductPackageID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      // @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'

      Clause.InsurPlcyClauseTemplate,
      Clause.InsurPlcyIndivClauseAgrmtText,
      Clause.InsurPlcyClauseDetailTextUUID,
      LongText.LongText,
      LongText.TextObjectCategory,
      LongText.TextObjectKey,
      LongText.Language,
      @ObjectModel.foreignKey.association: '_InsurancePolicyClauseType'
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyClauseType'
      Clause.InsurPlcyClauseType,
      @Semantics.businessDate.from: true
      Clause.InsurPlcyClauseStartDate,
      @Semantics.businessDate.to: true
      Clause.InsurPlcyClauseEndDate,
      @Semantics.systemDateTime.lastChangedAt: true
      Clause.LastChangeDateTime,

      /* Associations */
      _InsuranceContract,
      @Consumption.hidden: true
      _InsurancePolicyClauseType,
      @Consumption.hidden: true
      _InsurPlcyTemplateT

}
where
      Clause.InsurPlcyJrnlEndNmbr       = 2147483647
  and Clause.InsurPlcyBusinessObject    = 'P'
  and Clause.InsurPlcyCoveragePackageID = 0
  and Clause.InsurPlcyCoverageID        = 0
  and Clause.InsurPlcySubCvrgID         = 0
  and Clause.InsurPlcyInsuredObjectID   = 0

Learn More