I_INSURPLCYCLAUSEBASIC

@EndUserText.label: 'Clause in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyClauseID',
   semanticKey: [ 'InsurPlcyClauseID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
  technicalName: 'IPClauseBsc'
}

define view entity I_InsurPlcyClauseBasic
  as select from /pm0/abdaclause as Clause

{

  key cast( Clause.policy_id  as /pm0/vdm_policy_uuid preserving type )           as InsurPlcyUUID,
  key Clause.policyproduct_id                                                     as InsurPlcyInsurContr,
  key cast( Clause.journalno_id as /pm0/vdm_journal_number_id preserving type )   as InsurPlcyJrnlNmbr,
  key Clause.journalendno_id                                                      as InsurPlcyJrnlEndNmbr,
  key Clause.covpac_id                                                            as InsurPlcyCoveragePackageID,
  key Clause.coverage_id                                                          as InsurPlcyCoverageID,
  key Clause.subject_id                                                           as InsurPlcyInsuredObjectID,
  key Clause.covcpco_id                                                           as InsurPlcySubCvrgID,
  key Clause.clause_id                                                            as InsurPlcyClauseID,    
      Clause.ppdpac_id                                                            as InsurPlcyProductPackageID,
      Clause.clause_td                                                            as InsurPlcyIndivClauseAgrmtText,
      cast( Clause.longtext_id as /pm0/vdm_clause_longtext_uuid preserving type ) as InsurPlcyClauseDetailTextUUID,
      Clause.clause_cd                                                            as InsurPlcyClauseType,
      @Semantics.businessDate.from: true
      cast( Clause.begin_dt as /pm0/vdm_clause_start_date preserving type )       as InsurPlcyClauseStartDate,
      @Semantics.businessDate.to: true
      cast( Clause.end_dt   as /pm0/vdm_clause_end_date   preserving type )       as InsurPlcyClauseEndDate,
      Clause.pm_id                                                                as InsurPlcyClauseTemplate,
      @Consumption.hidden: true
      Clause.bo_cd                                                                as InsurPlcyBusinessObject,
      @Semantics.systemDateTime.lastChangedAt: true
      Clause.change_ts                                                            as LastChangeDateTime
}
where
      Clause.covcp_id = 0
  and Clause.uwdcn_id = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PM0/ABDACLAUSE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/