I_INSURPLCYNAMEDDRIVERBASIC

CDS View

Named Driver in Insurance Policy

I_INSURPLCYNAMEDDRIVERBASIC is a CDS View in S/4HANA. Named Driver in Insurance Policy. It contains 19 fields. 14 CDS views read from this table.

Used by 14 CDS view(s) 19 fields

CDS Views using this table (14)

ViewTypeJoinVDMDescription
I_InsOpApContractNamedDriver view_entity from COMPOSITE InsOb NmdDrvr of Contr in InsOpAp
I_InsOpApContrCvrgNmdDrvr view_entity from COMPOSITE Cvrg InsOb NmdDrvr of Contr in InsOpAp
I_InsOpApCoverageNamedDriver view_entity from COMPOSITE InsOb NmdDrvr of Cvrg CvPcg in InsOpAp
I_InsOpApCvrgPckgNmdDrvr view_entity from COMPOSITE InsOb NmdDrvr of Cvrg Pckg in InsOpAp
I_InsurApplContrCvrgNmdDrvr view_entity inner COMPOSITE Cvrg InsOb NmdDrvr of Contr in Appl
I_InsurApplContrNamedDriver view_entity inner COMPOSITE InsOb Named Drvr of Contr in Insur Appl
I_InsurApplCvrgNamedDriver view_entity inner COMPOSITE InsOb Nmd Drvr of Cvrg of CvPcg in Appl
I_InsurApplCvrgPckgNmdDrvr view_entity inner COMPOSITE InsOb NmdDrvr of Cvrg Pckg in Insur Appl
I_InsurPlcyContrObjNmdDrvr view_entity from COMPOSITE InsOb Named Drvr of Contr in Insur Plcy
I_InsurPlcyCvrgInsrdObjNmdDrvr view_entity from COMPOSITE Cvrg InsOb NmdDrvr of Contr in Plcy
I_InsurPlcyCvrgPckgObjNmdDrvr view_entity from COMPOSITE InsOb NmdDrvr of Cvrg Pckg in Insur Plcy
I_InsurPolicyInsrdObjNmdDrvr view_entity from COMPOSITE InsOb Nmd Drvr of Cvrg of CvPcg in Plcy
P_InsurOpenApplNamedDriver view_entity from COMPOSITE Insur Open Application Named Driver
P_InsurOpenApplNamedDriver view_entity union COMPOSITE Insur Open Application Named Driver

Fields (19)

KeyField CDS FieldsUsed in Views
KEY InsurPlcyCoverageID InsurPlcyCoverageID 13
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID 13
KEY InsurPlcyInsrdVehNmdDrvrID InsurPlcyInsrdVehNmdDrvrID 13
KEY InsurPlcyInsurContr InsurPlcyInsurContr 13
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID 13
KEY InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr 9
KEY InsurPlcyUUID InsurPlcyUUID 8
AddressID AddressID 12
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr 8
InsurPlcyNamedDriver InsurPlcyNamedDriver 12
InsurPlcyNamedDriverGender InsurPlcyNamedDriverGender 12
InsurPlcyNmdDrvrBirthDate InsurPlcyNmdDrvrBirthDate 12
InsurPlcyNmdDrvrDrvrCategoryID InsurPlcyNmdDrvrDrvrCategoryID 12
InsurPlcyNmdDrvrDrvrLicIssDte InsurPlcyNmdDrvrDrvrLicIssDte 12
InsurPlcyNmdDrvrDrvrLicNumber InsurPlcyNmdDrvrDrvrLicNumber 12
InsurPlcyNmdDrvrMaritalStatus InsurPlcyNmdDrvrMaritalStatus 12
InsurPlcyNmdDrvrTemplate InsurPlcyNmdDrvrTemplate 12
InsurPlcyProductPackageID InsurPlcyProductPackageID 12
LastChangeDateTime LastChangeDateTime 12 
@EndUserText.label: 'Named Driver in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsrdVehNmdDrvrID',
   semanticKey: [ 'InsurPlcyInsrdVehNmdDrvrID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
  technicalName: 'IPNmdDrvrBsc'
}
define view entity I_InsurPlcyNamedDriverBasic
  as select from /mva/amdanamdrv as NamedDriver
{

  key cast( NamedDriver.policy_id as /pm0/vdm_policy_uuid preserving type )              as InsurPlcyUUID,
  key NamedDriver.policyproduct_id                                                       as InsurPlcyInsurContr,
  key NamedDriver.covpac_id                                                              as InsurPlcyCoveragePackageID,
  key NamedDriver.coverage_id                                                            as InsurPlcyCoverageID,
  key NamedDriver.subject_id                                                             as InsurPlcyInsuredObjectID,
  key NamedDriver.namdrv_id                                                              as InsurPlcyInsrdVehNmdDrvrID,
  key cast( NamedDriver.journalno_id as /pm0/vdm_journal_number_id preserving type )     as InsurPlcyJrnlNmbr,
  key NamedDriver.journalendno_id                                                        as InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      NamedDriver.ppdpac_id                                                              as InsurPlcyProductPackageID,
      cast( NamedDriver.pm_id as /mva/vdm_namdrv_template_code preserving type )         as InsurPlcyNmdDrvrTemplate,
      @Consumption.hidden: true
      NamedDriver.bo_cd                                                                  as InsurPlcyBusinessObject,
      cast ( NamedDriver.addressnumber_id as /mva/vdm_addressnumber_id preserving type ) as AddressID,
      NamedDriver.partner_id                                                             as InsurPlcyNamedDriver,
      NamedDriver.birth_dt                                                               as InsurPlcyNmdDrvrBirthDate,
      NamedDriver.drivercategory_cd                                                      as InsurPlcyNmdDrvrDrvrCategoryID,
      NamedDriver.gender_cd                                                              as InsurPlcyNamedDriverGender,
      NamedDriver.driverlicence_id                                                       as InsurPlcyNmdDrvrDrvrLicNumber,
      NamedDriver.licence_dt                                                             as InsurPlcyNmdDrvrDrvrLicIssDte,
      NamedDriver.maritalstatus_cd                                                       as InsurPlcyNmdDrvrMaritalStatus,
      @Semantics.systemDateTime.lastChangedAt: true
      NamedDriver.change_ts                                                              as LastChangeDateTime

}
where
  NamedDriver.covcp_id = 0

Learn More