I_INSURCLMHANDLERASSIGNMENT

CDS View

Sachbearbeiterzuordnung

I_INSURCLMHANDLERASSIGNMENT is a CDS View in S/4HANA. Sachbearbeiterzuordnung. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmHandler view from COMPOSITE Fallsachbearbeiter

Fields (3)

KeyField CDS FieldsUsed in Views
KEY InsuranceClaim InsuranceClaim 1
InsurClmAuthznGrp InsurClmAuthznGrp 1
InsurClmType InsurClmType 1 
@AbapCatalog.sqlViewName: 'ICLCLMHANDLASGN'
@VDM.private: false
@VDM.viewType: #BASIC
@EndUserText.label: 'Sachbearbeiterzuordnung'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view I_InsurClmHandlerAssignment
  as select from iclclaimassign
    inner join   icl_rbp  on  iclclaimassign.claim = icl_rbp.claim
                          and iclclaimassign.sguid = icl_rbp.rbpguid
    inner join   iclclaim on  iclclaimassign.claim  = iclclaim.claim
                          and iclclaimassign.active = iclclaim.active

  association [0..1] to I_User                     as _User               on $projection.ContactCardID = _User.UserID

  //association [0..1] to I_InsurClmOrgUnitAnalytics as _OrganizationalUnit on $projection.ContactCardID = _OrganizationalUnit.UserID


{
  key icl_rbp.claim      as InsuranceClaim,
  key tguid              as InsurClmTargetEntryUUID,
  key icl_rbp.rbpguid    as InsurClmPerformerUUID,
      
      rbpobjid           as ContactCardID,

      rbprole            as InsurClmResponsibleRole,

      iclclaim.claimtype as InsurClmType,

      iclclaim.authclm   as InsurClmAuthznGrp,

      
      assigncat          as InsurClmAssignCat,
      
      //_OrganizationalUnit.OrganizationalUnit,


      _User
      //_OrganizationalUnit


}
where
      iclclaimassign.active    = #icl_active.'A'
  and iclclaimassign.assigncat = 'RC' //RBP Assignment for Claim

  and rbpotype                 = 'US' //User

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ICLCLAIM",
"ICLCLAIMASSIGN",
"ICL_RBP"
],
"ASSOCIATED":
[
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More