C_InsurClmPerformer

DDL: C_INSURCLMPERFORMER Type: view_entity CONSUMPTION Package: ICL_VDM_CLAIMINQUIRY
10 Fields 1 Data Sources 2 Associations 1 OData Services

Übersicht Fallbearbeiter

C_InsurClmPerformer is a Consumption CDS View that provides data about "Übersicht Fallbearbeiter" in SAP S/4HANA. It reads from 1 data source (I_InsurClmPerfrmrSubClmInqry) and exposes 10 fields with key fields InsuranceClaim, InsurClmPerformerObjID, InsurClmResponsibleRole, InsurClmSubclm. It has 2 associations to related views. It is exposed through 1 OData service (ICL_CLAIMINQUIRY_R). Part of development package ICL_VDM_CLAIMINQUIRY.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmPerfrmrSubClmInqry I_InsurClmPerfrmrSubClmInqry from

Associations (2)

CardinalityTargetAliasCondition
[1] I_InsurClmPerformerObjectID _ObjectID $projection.InsurClmPerformerObjID = _ObjectID.InsurClmPerformerObjID and $projection.InsurClmObjTypeOfPerformer = _ObjectID.InsurClmObjTypeOfPerformer
[1..1] I_InsuranceClaim _Claim $projection.InsuranceClaim = _Claim.InsuranceClaim

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Übersicht Fallbearbeiter view
Metadata.ignorePropagatedAnnotations true view
Search.searchable false view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Bearbeiter view
UI.headerInfo.typeNamePlural Liste der Sachbearbeiter view

OData Services (1)

ServiceBindingVersionContractRelease
ICL_CLAIMINQUIRY_R ICL_UI_CLAIMINQUIRY_R_O2 V2 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmPerformerObjID InsurClmPerformerObjID Bearbeiter
KEY InsurClmResponsibleRole InsurClmResponsibleRole Rollenname
KEY InsurClmSubclm InsurClmSubclm Subclaim
InsurClmObjTypeOfPerformer InsurClmObjTypeOfPerformer Objekttyp des Bearbeiters
FullName _ObjectID FullName Bearbeitername
InsurClmResponsibleRoleName InsurClmResponsibleRoleName
InsurClmObjTypeOfPerfrmrText _ObjTypeTxt InsurClmObjTypeOfPerfrmrText
_Claim _Claim
_ObjectID _ObjectID

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 C_InsurClmPerformer.
-- 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 C_InsurClmPerformer AS
SELECT
  InsuranceClaim,
  InsurClmPerformerObjID,
  InsurClmResponsibleRole,
  InsurClmSubclm,
  InsurClmObjTypeOfPerformer,
  _ObjectID.FullName AS FullName,
  InsurClmResponsibleRoleName,
  _ObjTypeTxt.InsurClmObjTypeOfPerfrmrText AS InsurClmObjTypeOfPerfrmrText
FROM I_InsurClmPerfrmrSubClmInqry
LEFT OUTER JOIN I_InsurClmPerformerObjectID AS _ObjectID ON InsurClmPerformerObjID = _ObjectID.InsurClmPerformerObjID AND InsurClmObjTypeOfPerformer = _ObjectID.InsurClmObjTypeOfPerformer  -- association [1]
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1..1]
;

Learn More