I_InsurClmSubclmRoleBsdPerfrmr

DDL: I_INSURCLMSUBCLMROLEBSDPERFRMR Type: view BASIC Package: ICL_VDM_COMMON
10 Fields 3 Data Sources 3 Associations

Sachbearbeiterzuordnung

I_InsurClmSubclmRoleBsdPerfrmr 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 10 fields with key fields InsuranceClaim, InsurClmTargetEntryUUID. It has 3 associations 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 (3)

CardinalityTargetAliasCondition
[1..1] I_InsuranceClaim _Claim $projection.InsuranceClaim = _Claim.InsuranceClaim
[0..*] I_InsurClmSubclaim _Subclaim $projection.InsuranceClaim = _Subclaim.InsuranceClaim and $projection.InsurClmTargetEntryUUID = _Subclaim.InsurClmSubclaimAssignUUID
[0..1] I_User _User $projection.InsurClmPerformerObjID = _User.UserID

Annotations (9)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim icl_rbp claim Policy Snapshot
KEY InsurClmTargetEntryUUID tguid TargetUUID
InsurClmPerformerUUID icl_rbp rbpguid UUID
InsurClmPerformerObjID rbpobjid Performer
InsurClmResponsibleRole rbprole Performer Role
InsurClmType _Claim InsurClmType Claim Type
InsurClmAuthznGrp _Claim InsurClmAuthznGrp AuthGroup (VIP)
_User _User
_Claim _Claim
_Subclaim _Subclaim

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_InsurClmSubclmRoleBsdPerfrmr.
-- 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.

CREATE VIEW I_InsurClmSubclmRoleBsdPerfrmr AS
SELECT
  icl_rbp.claim AS InsuranceClaim,
  tguid AS InsurClmTargetEntryUUID,
  icl_rbp.rbpguid AS InsurClmPerformerUUID,
  rbpobjid AS InsurClmPerformerObjID,
  rbprole AS InsurClmResponsibleRole,
  _Claim.InsurClmType AS InsurClmType,
  _Claim.InsurClmAuthznGrp AS InsurClmAuthznGrp
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_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubclaim AS _Subclaim ON InsuranceClaim = _Subclaim.InsuranceClaim AND InsurClmTargetEntryUUID = _Subclaim.InsurClmSubclaimAssignUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _User ON InsurClmPerformerObjID = _User.UserID  -- association [0..1]
;

Learn More