I_InsurOpenApplContractClause

DDL: I_INSUROPENAPPLCONTRACTCLAUSE Type: view_entity COMPOSITE Package: VDM_PM_PLCY_OPEN_APPL_COMMON

Contract Clause in InsurOpenApplication

I_InsurOpenApplContractClause is a Composite CDS View that provides data about "Contract Clause in InsurOpenApplication" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyClauseBasic) and exposes 27 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views. Part of development package VDM_PM_PLCY_OPEN_APPL_COMMON.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyClauseBasic Clause from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsurPlcyClauseTypeLink _InsurancePolicyClauseType $projection.InsurPlcyClauseType = _InsurancePolicyClauseType.InsurPlcyClauseType and $projection.InsurPlcyClauseTemplate = _InsurancePolicyClauseType.InsurPlcyClauseTemplate
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyClauseTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

Annotations (11)

NameValueLevelField
EndUserText.label Contract Clause in InsurOpenApplication view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyClauseID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IOAContrCls view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID OpenApplJrnl InsurPlcyApplUUID
KEY InsuranceApplication
KEY InsurPlcyInsurContr I_InsurPlcyClauseBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyClauseBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyClauseBasic InsurPlcyCoverageID
KEY InsurPlcySubCvrgID I_InsurPlcyClauseBasic InsurPlcySubCvrgID
KEY InsurPlcyInsuredObjectID I_InsurPlcyClauseBasic InsurPlcyInsuredObjectID
KEY InsurPlcyClauseID I_InsurPlcyClauseBasic InsurPlcyClauseID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyClauseBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyClauseBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyClauseBasic InsurPlcyProductPackageID
InsurPlcyUUID OpenApplJrnl InsurPlcyUUID
InsurPlcyClauseTemplate I_InsurPlcyClauseBasic InsurPlcyClauseTemplate
InsurPlcyIndivClauseAgrmtText I_InsurPlcyClauseBasic InsurPlcyIndivClauseAgrmtText
InsurPlcyClauseDetailTextUUID I_InsurPlcyClauseBasic InsurPlcyClauseDetailTextUUID
LongText LongText LongText
TextObjectCategory LongText TextObjectCategory
TextObjectKey LongText TextObjectKey
Language LongText Language
InsurPlcyClauseType I_InsurPlcyClauseBasic InsurPlcyClauseType
InsurPlcyClauseStartDate I_InsurPlcyClauseBasic InsurPlcyClauseStartDate
InsurPlcyClauseEndDate I_InsurPlcyClauseBasic InsurPlcyClauseEndDate
LastChangeDateTime I_InsurPlcyClauseBasic LastChangeDateTime
_InsurOpenApplContract _InsurOpenApplContract
_InsurancePolicyClauseType _InsurancePolicyClauseType
_InsurPlcyTemplateT _InsurPlcyTemplateT 
@EndUserText.label: 'Contract Clause in InsurOpenApplication'
@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: 'IOAContrCls'
}
define view entity I_InsurOpenApplContractClause
  as select from           I_InsurPlcyClauseBasic        as Clause
    left outer to one join P_InsurOpenApplClauseLatest   as OpenApplJrnl on  (
        OpenApplJrnl.InsurPlcyUUID                                                                                       = Clause.InsurPlcyUUID
        or OpenApplJrnl.InsurPlcyApplUUID                                                                                = Clause.InsurPlcyUUID
      )
                                                                         and OpenApplJrnl.InsurPlcyInsurContr            = Clause.InsurPlcyInsurContr
                                                                         and OpenApplJrnl.InsurPlcyCoveragePackageID     = Clause.InsurPlcyCoveragePackageID
                                                                         and OpenApplJrnl.InsurPlcyCoverageID            = Clause.InsurPlcyCoverageID
                                                                         and OpenApplJrnl.InsurPlcySubCvrgID             = Clause.InsurPlcySubCvrgID
                                                                         and OpenApplJrnl.InsurPlcyInsuredObjectID       = Clause.InsurPlcyInsuredObjectID
                                                                         and OpenApplJrnl.InsurPlcyClauseID              = Clause.InsurPlcyClauseID
                                                                         and OpenApplJrnl.InsurPlcyJrnlNmbr              = Clause.InsurPlcyJrnlNmbr
                                                                         and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr < Clause.InsurPlcyJrnlEndNmbr


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

  association        to parent I_InsurOpenApplContract as _InsurOpenApplContract     on  $projection.InsurPlcyApplUUID              = _InsurOpenApplContract.InsurPlcyApplUUID
                                                                                     and $projection.InsuranceApplication           = _InsurOpenApplContract.InsuranceApplication
                                                                                     and $projection.InsurPlcyInsurContr            = _InsurOpenApplContract.InsurPlcyInsurContr
                                                                                     and $projection.InsurPlcyContrDataDetnJrnlNmbr = _InsurOpenApplContract.InsurPlcyContrDataDetnJrnlNmbr


  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 OpenApplJrnl.InsurPlcyApplUUID,
  key cast( OpenApplJrnl.InsuranceApplication as /pm0/vdm_applicationnr_tt preserving type )              as InsuranceApplication,
  key Clause.InsurPlcyInsurContr,
  key Clause.InsurPlcyCoveragePackageID,
  key Clause.InsurPlcyCoverageID,
  key Clause.InsurPlcySubCvrgID,
  key Clause.InsurPlcyInsuredObjectID,
  key Clause.InsurPlcyClauseID,
  key cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      Clause.InsurPlcyJrnlNmbr,
      Clause.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      Clause.InsurPlcyProductPackageID,
      OpenApplJrnl.InsurPlcyUUID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      Clause.InsurPlcyClauseTemplate,
      Clause.InsurPlcyIndivClauseAgrmtText,
      Clause.InsurPlcyClauseDetailTextUUID,
      LongText.LongText,
      LongText.TextObjectCategory,
      LongText.TextObjectKey,
      LongText.Language,
      @ObjectModel.foreignKey.association: '_InsurancePolicyClauseType'
      Clause.InsurPlcyClauseType,
      @Semantics.businessDate.from: true
      Clause.InsurPlcyClauseStartDate,
      @Semantics.businessDate.to: true
      Clause.InsurPlcyClauseEndDate,
      @Semantics.systemDateTime.lastChangedAt: true
      Clause.LastChangeDateTime,

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

}
where
      Clause.InsurPlcyCoveragePackageID = 0
  and Clause.InsurPlcyCoverageID        = 0
  and Clause.InsurPlcySubCvrgID         = 0
  and Clause.InsurPlcyInsuredObjectID   = 0
  and OpenApplJrnl.InsurPlcyApplUUID    is not initial //Perf. Tuning: Make inner Join out of left outer Join

  and OpenApplJrnl.InsuranceApplication is not initial

Learn More