I_InsurClmHandler

DDL: I_INSURCLMHANDLER Type: view COMPOSITE

Fallsachbearbeiter

I_InsurClmHandler is a Composite CDS View that provides data about "Fallsachbearbeiter" in SAP S/4HANA. It reads from 2 data sources (I_InsurClmHandlerAssignment, I_InsurClmResponsibleRole) and exposes 7 fields with key field InsuranceClaim. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_InsurClmHandlerAssignment I_InsurClmHandlerAssignment from
I_InsurClmResponsibleRole I_InsurClmResponsibleRole inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserContactCard _UserContactCard.ContactCardID = $projection.ContactCardID

Annotations (9)

NameValueLevelField
EndUserText.label Fallsachbearbeiter view
AbapCatalog.sqlViewName IICLCLMHANDLER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmHandlerAssignment InsuranceClaim
ContactCardID ContactCardID
FullName _UserContactCard FullName
PhoneNumber _UserContactCard PhoneNumber
EmailAddress _UserContactCard EmailAddress
InsurClmType I_InsurClmHandlerAssignment InsurClmType
InsurClmAuthznGrp I_InsurClmHandlerAssignment InsurClmAuthznGrp 
@EndUserText.label: 'Fallsachbearbeiter'

@AbapCatalog: {
  sqlViewName: 'IICLCLMHANDLER',
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
  dataClass: #MIXED,
  sizeCategory: #L,
  serviceQuality: #C
}

define view I_InsurClmHandler
  as select from I_InsurClmHandlerAssignment
    inner join   I_InsurClmResponsibleRole on  I_InsurClmHandlerAssignment.InsuranceClaim          = I_InsurClmResponsibleRole.InsuranceClaim
                                           and I_InsurClmHandlerAssignment.InsurClmResponsibleRole = I_InsurClmResponsibleRole.InsurClmResponsibleRole

  association [0..1] to I_UserContactCard as _UserContactCard on _UserContactCard.ContactCardID = $projection.ContactCardID
{
  key  I_InsurClmHandlerAssignment.InsuranceClaim,

       ContactCardID,

       @Semantics.name.fullName: true
       _UserContactCard.FullName          as FullName,
       
       @Semantics.telephone.type: [#WORK]
       _UserContactCard.PhoneNumber       as PhoneNumber,
       
       @Semantics.eMail.type:  [ #PREF, #WORK ]
       @Semantics.eMail.address: true
       _UserContactCard.EmailAddress      as EmailAddress,
       
       //For authorizations

       I_InsurClmHandlerAssignment.InsurClmType,
       I_InsurClmHandlerAssignment.InsurClmAuthznGrp
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURCLMHANDLERASSIGNMENT",
"I_INSURCLMRESPONSIBLEROLE",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More