I_INSURPLCYCVRGPACKAGEBASIC

CDS View

Coverage Package in Insurance Policy

I_INSURPLCYCVRGPACKAGEBASIC is a CDS View in S/4HANA. Coverage Package in Insurance Policy. It contains 17 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 17 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_InsurApplCoveragePackage view_entity inner COMPOSITE Coverage Package in Insurance Appl
I_InsurOpenApplCoveragePackage view_entity from COMPOSITE Coverage Package in InsurOpenAppl
I_InsurPlcyCoveragePackage view_entity from COMPOSITE Coverage Package in Insurance Policy
P_InsurOpenApplCoveragePackage view_entity from COMPOSITE Insurance Open Application CoveragePackage
P_InsurOpenApplCoveragePackage view_entity union COMPOSITE Insurance Open Application CoveragePackage
R_InsurPlcyContrCvrgPackageTP view_entity from TRANSACTIONAL Coverage Package

Fields (17)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 5
KEY InsurPlcyInsurContr InsurPlcyInsurContr 5
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 5
KEY InsurPlcyUUID InsurPlcyUUID 3
InsurPlcyBusinessObject InsurPlcyBusinessObject 1
InsurPlcyCvrgPackageTemplate InsurPlcyCvrgPackageTemplate 4
InsurPlcyCvrgPckgAcctVariant InsurPlcyCvrgPckgAcctVariant 1
InsurPlcyCvrgPckgCanclnDteTime InsurPlcyCvrgPckgCanclnDteTime 4
InsurPlcyCvrgPckgCanclnReason InsurPlcyCvrgPckgCanclnReason 4
InsurPlcyCvrgPckgCommentID InsurPlcyCvrgPckgCommentID 1
InsurPlcyCvrgPckgGnrtnDate InsurPlcyCvrgPckgGnrtnDate 1
InsurPlcyCvrgPckgGnrtnDetnDate InsurPlcyCvrgPckgGnrtnDetnDate 1
InsurPlcyCvrgPckgIsCancld InsurPlcyCvrgPckgIsCancld 1
InsurPlcyCvrgPckgNumberID InsurPlcyCvrgPckgNumberID 1
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 4
InsurPlcyProductPackageID InsurPlcyProductPackageID 4
LastChangeDateTime LastChangeDateTime 4 
@EndUserText.label: 'Coverage Package in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyCoveragePackageID',
   semanticKey: [ 'InsurPlcyCoveragePackageID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
//@Metadata.allowExtensions: true

@Analytics: {
  technicalName: 'IPCvrgPckgBsc'
}

define view entity I_InsurPlcyCvrgPackageBasic
  as select from           /pm0/abdacovpac             as CoveragePackage

    left outer to one join I_INSURPLCYNOTELONGTXTBASIC as _LongText on CoveragePackage.comment_id = _LongText.InsurancePolicyNoteIdentifier


{

  key cast( CoveragePackage.policy_id  as /pm0/vdm_policy_uuid preserving type )            as InsurPlcyUUID,
  key CoveragePackage.policyproduct_id                                                      as InsurPlcyInsurContr,
  key CoveragePackage.covpac_id                                                             as InsurPlcyCoveragePackageID,
  key cast( CoveragePackage.journalno_id as /pm0/vdm_journal_number_id preserving type )    as InsurPlcyJrnlNmbr,
  key CoveragePackage.journalendno_id                                                       as InsurPlcyJrnlEndNmbr,
      CoveragePackage.pm_id                                                                 as InsurPlcyCvrgPackageTemplate,
      CoveragePackage.ppdpac_id                                                             as InsurPlcyProductPackageID,
      @Semantics.booleanIndicator: true
      CoveragePackage.cancel_fg                                                             as InsurPlcyCvrgPckgIsCancld,
      CoveragePackage.cancreas_cd                                                           as InsurPlcyCvrgPckgCanclnReason,
      @Consumption.hidden: true
      CoveragePackage.bo_cd                                                                 as InsurPlcyBusinessObject,

      @Semantics.dateTime:true
      cast( dats_tims_to_tstmp( CoveragePackage.ccldate_dt,
                                CoveragePackage.reversal_tm,
                                CoveragePackage.revtimezone_tt,
                                $session.client,
                               'NULL' ) as /pm0/vdm_covpc_cancel_datetime preserving type ) as InsurPlcyCvrgPckgCanclnDteTime,

      CoveragePackage.accvar_cd                                                             as InsurPlcyCvrgPckgAcctVariant,
      cast( CoveragePackage.comment_id    as /pm0/vdm_note_longtext_uuid preserving type )  as InsurPlcyCvrgPckgCommentID,
      _LongText.LongText,
      _LongText.TextObjectCategory,
      _LongText.TextObjectKey,
      _LongText.Language,
      @Semantics.businessDate.at: true
      CoveragePackage.generation_dt                                                         as InsurPlcyCvrgPckgGnrtnDate,
      @Semantics.businessDate.at: true
      CoveragePackage.generatio_det_dt                                                      as InsurPlcyCvrgPckgGnrtnDetnDate,
      CoveragePackage.covpacnum_vl                                                          as InsurPlcyCvrgPckgNumberID,
      @Semantics.systemDateTime.lastChangedAt: true
      CoveragePackage.change_ts                                                             as LastChangeDateTime

}

Learn More