I_INSURPLCYAGENTBASIC

CDS View

Representative in Insurance Policy

I_INSURPLCYAGENTBASIC is a CDS View in S/4HANA. Representative in Insurance Policy. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_InsurPlcyAgentTP view_entity from TRANSACTIONAL Agent 
@EndUserText.label: 'Representative in Insurance Policy'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
  }
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  representativeKey: 'InsurancePolicyAgentIdentifier',
  semanticKey: [ 'InsurancePolicyAgentIdentifier' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #XL
   },
      supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Analytics: {
  technicalName: 'IPAgtBsc'
}
define view entity I_InsurPlcyAgentBasic
  as select from /pm0/abdaagent as Agent
{
  key  cast( Agent.policy_id as /pm0/vdm_policy_uuid preserving type  )          as InsurPlcyUUID,
  key  policyproduct_id                                                          as InsurPlcyInsurContr,
  key  journalendno_id                                                           as InsurPlcyJrnlEndNmbr,
  key  cast( Agent.journalno_id as  /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
  key  agent_id                                                                  as InsurancePolicyAgentIdentifier,
       //@Consumption.hidden: true

       ppdpac_id                                                                 as InsurPlcyProductPackageID,
       @Semantics.booleanIndicator:true
       cancel_fg                                                                 as InsurPlcyAgentIsCanceled,
       reptyp_cd                                                                 as InsurPlcyRprstvType,
       scopeagent_cd                                                             as InsurPlcyScopeAgent,
       partner_id                                                                as InsurancePolicyAgentPartner,
       cast( Agent.addressnumber_id as /pm0/vdm_address_id preserving type )     as InsurPlcyAgentAddrNmbr,
       pm_id                                                                     as InsurPlcyAgentTemplate,
       @Consumption.hidden: true
       bo_cd                                                                     as InsurPlcyBusinessObject,
       @Semantics.systemDateTime.lastChangedAt: true
       change_ts                                                                 as LastChangeDateTime
}

Learn More