I_InsurClmHandlerAssignment

DDL: I_INSURCLMHANDLERASSIGNMENT SQL: ICLCLMHANDLASGN Type: view BASIC Package: ICL_VDM_COMMON
9 Fields 3 Data Sources 1 Associations

Sachbearbeiterzuordnung

I_InsurClmHandlerAssignment is a Basic CDS View that provides data about "Sachbearbeiterzuordnung" in SAP S/4HANA. It reads from 3 data sources (icl_rbp, iclclaim, iclclaimassign) and exposes 9 fields with key fields InsuranceClaim, InsurClmTargetEntryUUID, InsurClmPerformerUUID. It has 1 association to related views. Part of development package ICL_VDM_COMMON.

Data Sources (3)

SourceAliasJoin Type
icl_rbp icl_rbp inner
iclclaim iclclaim inner
iclclaimassign iclclaimassign from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_User _User $projection.ContactCardID = _User.UserID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICLCLMHANDLASGN view
VDM.private false view
VDM.viewType #BASIC view
EndUserText.label Sachbearbeiterzuordnung view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim icl_rbp claim Policy Snapshot
KEY InsurClmTargetEntryUUID tguid TargetUUID
KEY InsurClmPerformerUUID icl_rbp rbpguid UUID
ContactCardID rbpobjid Performer
InsurClmResponsibleRole rbprole Performer Role
InsurClmType iclclaim claimtype Complaint Cat.
InsurClmAuthznGrp iclclaim authclm AuthGroup (VIP)
InsurClmAssignCat assigncat Link Category
_User _User

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InsurClmHandlerAssignment.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICLCLMHANDLASGN

CREATE VIEW I_InsurClmHandlerAssignment AS
SELECT
  icl_rbp.claim AS InsuranceClaim,
  tguid AS InsurClmTargetEntryUUID,
  icl_rbp.rbpguid AS InsurClmPerformerUUID,
  rbpobjid AS ContactCardID,
  rbprole AS InsurClmResponsibleRole,
  iclclaim.claimtype AS InsurClmType,
  iclclaim.authclm AS InsurClmAuthznGrp,
  assigncat AS InsurClmAssignCat
FROM iclclaimassign
INNER JOIN icl_rbp ON /* join condition not captured in parsed metadata */
INNER JOIN iclclaim ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _User ON ContactCardID = _User.UserID  -- association [0..1]
;

Learn More