I_InsOpApCoverageNamedDriver

DDL: I_INSOPAPCOVERAGENAMEDDRIVER Type: view_entity COMPOSITE Package: VDM_PMA_PLCY_OPEN_APPL_COMMON

InsOb NmdDrvr of Cvrg CvPcg in InsOpAp

I_InsOpApCoverageNamedDriver is a Composite CDS View that provides data about "InsOb NmdDrvr of Cvrg CvPcg in InsOpAp" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyNamedDriverBasic) and exposes 26 fields with key fields InsurPlcyApplUUID, InsuranceApplication, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 4 associations to related views. Part of development package VDM_PMA_PLCY_OPEN_APPL_COMMON.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyNamedDriverBasic NamedDriver from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_InsurPlcyNmdDrvrGender _InsurPlcyNmdDrvrGender $projection.InsurPlcyNamedDriverGender = _InsurPlcyNmdDrvrGender.InsurPlcyNamedDriverGender
[1..1] I_InsurPlcyDrvrMaritalStsLink _InsurPlcyNmdDrvrMaritalSts $projection.InsurPlcyNmdDrvrMaritalStatus = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrMaritalStatus and $projection.InsurPlcyNmdDrvrTemplate = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrTemplate
[1..1] I_InsurPlcyNmdDrvrCategoryLink _InsurPlcyNmdDrvrCategoryLink $projection.InsurPlcyNmdDrvrDrvrCategoryID = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrDrvrCategoryID and $projection.InsurPlcyNmdDrvrTemplate = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrTemplate
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyNmdDrvrTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

Annotations (11)

NameValueLevelField
EndUserText.label InsOb NmdDrvr of Cvrg CvPcg in InsOpAp view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsrdVehNmdDrvrID 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 IOACvgNmdDrvr view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyApplUUID OpenApplJrnl InsurPlcyApplUUID
KEY InsuranceApplication
KEY InsurPlcyInsurContr I_InsurPlcyNamedDriverBasic InsurPlcyInsurContr
KEY InsurPlcyCoveragePackageID I_InsurPlcyNamedDriverBasic InsurPlcyCoveragePackageID
KEY InsurPlcyCoverageID I_InsurPlcyNamedDriverBasic InsurPlcyCoverageID
KEY InsurPlcyInsuredObjectID I_InsurPlcyNamedDriverBasic InsurPlcyInsuredObjectID
KEY InsurPlcyInsrdVehNmdDrvrID I_InsurPlcyNamedDriverBasic InsurPlcyInsrdVehNmdDrvrID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyNamedDriverBasic InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyNamedDriverBasic InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID I_InsurPlcyNamedDriverBasic InsurPlcyProductPackageID
InsurPlcyNmdDrvrTemplate I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrTemplate
AddressID I_InsurPlcyNamedDriverBasic AddressID
InsurPlcyNamedDriver I_InsurPlcyNamedDriverBasic InsurPlcyNamedDriver
InsurPlcyNmdDrvrBirthDate I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrBirthDate
InsurPlcyNmdDrvrDrvrCategoryID I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrDrvrCategoryID
InsurPlcyNamedDriverGender I_InsurPlcyNamedDriverBasic InsurPlcyNamedDriverGender
InsurPlcyNmdDrvrDrvrLicNumber I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrDrvrLicNumber
InsurPlcyNmdDrvrDrvrLicIssDte I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrDrvrLicIssDte
InsurPlcyNmdDrvrMaritalStatus I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrMaritalStatus
LastChangeDateTime I_InsurPlcyNamedDriverBasic LastChangeDateTime
_InsurOpenApplInsuredObject _InsurOpenApplInsuredObject
_InsurPlcyNmdDrvrGender _InsurPlcyNmdDrvrGender
_InsurPlcyNmdDrvrMaritalSts _InsurPlcyNmdDrvrMaritalSts
_InsurPlcyNmdDrvrCategoryLink _InsurPlcyNmdDrvrCategoryLink
_InsurPlcyTemplateT _InsurPlcyTemplateT 
@EndUserText.label: 'InsOb NmdDrvr of Cvrg CvPcg in InsOpAp'
@VDM: {
  viewType:#COMPOSITE,
  lifecycle.contract.type:#PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyInsrdVehNmdDrvrID',
   semanticKey: [ 'InsurPlcyInsrdVehNmdDrvrID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:false
}
@Analytics: {
  technicalName: 'IOACvgNmdDrvr'
}
define view entity I_InsOpApCoverageNamedDriver
  as select from I_InsurPlcyNamedDriverBasic    as NamedDriver
  left outer to one join P_InsOpApNamedDriverLatest as OpenApplJrnl   on ( OpenApplJrnl.InsurPlcyUUID                  = NamedDriver.InsurPlcyUUID
                                                                        or OpenApplJrnl.InsurPlcyApplUUID              = NamedDriver.InsurPlcyUUID )
                                                                       and OpenApplJrnl.InsurPlcyInsurContr             = NamedDriver.InsurPlcyInsurContr
                                                                       and OpenApplJrnl.InsurPlcyCoveragePackageID      = NamedDriver.InsurPlcyCoveragePackageID
                                                                       and OpenApplJrnl.InsurPlcyCoverageID             = NamedDriver.InsurPlcyCoverageID
                                                                       and OpenApplJrnl.InsurPlcyInsuredObjectID        = NamedDriver.InsurPlcyInsuredObjectID
                                                                       and OpenApplJrnl.InsurPlcyInsrdVehNmdDrvrID      = NamedDriver.InsurPlcyInsrdVehNmdDrvrID
                                                                       and OpenApplJrnl.InsurPlcyJrnlNmbr               = NamedDriver.InsurPlcyJrnlNmbr
                                                                       and OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr  < NamedDriver.InsurPlcyJrnlEndNmbr
    
    association to parent I_InsurOpenApplInsuredObject as _InsurOpenApplInsuredObject on  $projection.InsurPlcyApplUUID               = _InsurOpenApplInsuredObject.InsurPlcyApplUUID
                                                                                      and $projection.InsuranceApplication            = _InsurOpenApplInsuredObject.InsuranceApplication
                                                                                      and $projection.InsurPlcyInsurContr             = _InsurOpenApplInsuredObject.InsurPlcyInsurContr
                                                                                      and $projection.InsurPlcyCoveragePackageID      = _InsurOpenApplInsuredObject.InsurPlcyCoveragePackageID
                                                                                      and $projection.InsurPlcyCoverageID             = _InsurOpenApplInsuredObject.InsurPlcyCoverageID
                                                                                      and $projection.InsurPlcyInsuredObjectID        = _InsurOpenApplInsuredObject.InsurPlcyInsuredObjectID
                                                                                      and $projection.InsurPlcyContrDataDetnJrnlNmbr  = _InsurOpenApplInsuredObject.InsurPlcyContrDataDetnJrnlNmbr                                                       
                                                                                
    association [1..1] to I_InsurPlcyNmdDrvrGender             as _InsurPlcyNmdDrvrGender       on  $projection.InsurPlcyNamedDriverGender     = _InsurPlcyNmdDrvrGender.InsurPlcyNamedDriverGender
    association [1..1] to I_InsurPlcyDrvrMaritalStsLink        as _InsurPlcyNmdDrvrMaritalSts   on  $projection.InsurPlcyNmdDrvrMaritalStatus  = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrMaritalStatus
                                                                                                and $projection.InsurPlcyNmdDrvrTemplate       = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrTemplate
    association [1..1] to I_InsurPlcyNmdDrvrCategoryLink       as _InsurPlcyNmdDrvrCategoryLink on  $projection.InsurPlcyNmdDrvrDrvrCategoryID = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrDrvrCategoryID
                                                                                                and $projection.InsurPlcyNmdDrvrTemplate       = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrTemplate
    association [1..*] to I_InsurPlcyTemplateT                 as _InsurPlcyTemplateT           on  $projection.InsurPlcyNmdDrvrTemplate       = _InsurPlcyTemplateT.InsurPlcyTemplate
    
  {
    key OpenApplJrnl.InsurPlcyApplUUID,
    key cast( OpenApplJrnl.InsuranceApplication as /pm0/vdm_applicationnr_tt preserving type ) as InsuranceApplication,
    key NamedDriver.InsurPlcyInsurContr,
    key NamedDriver.InsurPlcyCoveragePackageID,
    key NamedDriver.InsurPlcyCoverageID,
    key NamedDriver.InsurPlcyInsuredObjectID,
    key NamedDriver.InsurPlcyInsrdVehNmdDrvrID,
    key cast( OpenApplJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) as InsurPlcyContrDataDetnJrnlNmbr,
      NamedDriver.InsurPlcyJrnlNmbr,
      NamedDriver.InsurPlcyJrnlEndNmbr,
      @Consumption.hidden: true
      NamedDriver.InsurPlcyProductPackageID,
      @ObjectModel.text.association: '_InsurPlcyTemplateT'
      NamedDriver.InsurPlcyNmdDrvrTemplate,

      //FS-PM Auto specific Fields

      NamedDriver.AddressID,
      NamedDriver.InsurPlcyNamedDriver,
      NamedDriver.InsurPlcyNmdDrvrBirthDate,
      @ObjectModel.foreignKey.association: '_InsurPlcyNmdDrvrCategoryLink'
      NamedDriver.InsurPlcyNmdDrvrDrvrCategoryID,
      @ObjectModel.foreignKey.association: '_InsurPlcyNmdDrvrGender'
      NamedDriver.InsurPlcyNamedDriverGender,
      NamedDriver.InsurPlcyNmdDrvrDrvrLicNumber,
      NamedDriver.InsurPlcyNmdDrvrDrvrLicIssDte,
      @ObjectModel.foreignKey.association: '_InsurPlcyNmdDrvrMaritalSts'
      NamedDriver.InsurPlcyNmdDrvrMaritalStatus,
      @Semantics.systemDateTime.lastChangedAt: true
      NamedDriver.LastChangeDateTime,
      
      /* Associations */
      _InsurOpenApplInsuredObject,
      @Consumption.hidden: true
      _InsurPlcyNmdDrvrGender,
      @Consumption.hidden: true
      _InsurPlcyNmdDrvrMaritalSts,
      @Consumption.hidden: true
      _InsurPlcyNmdDrvrCategoryLink,
      @Consumption.hidden: true
      _InsurPlcyTemplateT
  }
  where
      NamedDriver.InsurPlcyCoveragePackageID <> 0
  and NamedDriver.InsurPlcyCoverageID        <> 0
  and OpenApplJrnl.InsurPlcyApplUUID         is not initial
  and OpenApplJrnl.InsuranceApplication      is not initial

Learn More