A_InsurClmClaimInquiry

DDL: A_INSURCLMCLAIMINQUIRY Type: view_entity CONSUMPTION
35 Fields 1 Data Sources 4 Associations

Fallübersicht

A_InsurClmClaimInquiry is a Consumption CDS View that provides data about "Fallübersicht" in SAP S/4HANA. It reads from 1 data source (I_InsurClmClaimOverview) and exposes 35 fields with key field InsuranceClaim. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmClaimOverview ClaimOverview from

Parameters (1)

NameTypeDefault
P_InsuranceClaim icl_claim

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_InsurClmClaimOverview _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim
[0..*] A_InsurClmSubclaimInquiry _Subclaims $projection.InsuranceClaim = _Subclaims.InsuranceClaim
[0..*] A_InsurClmSubclaimPayment _Payments $projection.InsuranceClaim = _Payments.InsuranceClaim
[0..*] A_InsurClmPrtcpntInquiry _Participants $projection.InsuranceClaim = _Participants.InsuranceClaim

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Fallübersicht view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
OData.entityType.name ClaimInquiry_Type view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
InsuranceContract InsuranceContract Contract
InsurClmPolicyProduct InsurClmPolicyProduct Policy Product
InsurClmLifeCycSts InsurClmLifeCycSts Status
InsurClmLifeCycStsName InsurClmLifeCycStsName
InsurClmType InsurClmType Claim Type
InsurClmTypeGeneration InsurClmTypeGeneration Generation
InsurClmTypeVers InsurClmTypeVers Clm Type Versn
InsurClmAuthznGrp InsurClmAuthznGrp AuthGroup (VIP)
InsurClmPolicyProdGeneration InsurClmPolicyProdGeneration Generation
InsurClmPolicyProductVersion InsurClmPolicyProductVersion Version
InsurClmIncdntType InsurClmIncdntType Incident Type
InsurClmIncdntTypeName InsurClmIncdntTypeName
InsurClmDateOfLoss InsurClmDateOfLoss Date of Loss
InsurClmAgentReportedDate InsurClmAgentReportedDate Reptd to Agent
InsurClmCauseOfLoss InsurClmCauseOfLoss Cause
InsurClmLossLocAddressID InsurClmLossLocAddressID Loss Location
InsurClmDescriptionOfLossLoc InsurClmDescriptionOfLossLoc
InsurClaimBundle InsurClaimBundle Claim Bundle
InsurClmTimeOfLoss InsurClmTimeOfLoss Time
InsurClmComplexity InsurClmComplexity Complexity
InsurClmComplexityName InsurClmComplexityName
InsurClmCovered InsurClmCovered Compensable
InsurancePolicy InsurancePolicy Policy Number
InsurClmContractStartDateTime InsurClmContractStartDateTime
InsurClmContractEndDateTime InsurClmContractEndDateTime
InsurClmLocationText InsurClmLocationText
InsurClmDescriptionOfLoss InsurClmDescriptionOfLoss
InsurClmCauseOfLossName InsurClmCauseOfLossName
FullName FullName Name
InsurClmPolicyHolderName InsurClmPolicyHolderName
InsurancePolicyholder InsurancePolicyholder BusPartner
_Subclaims _Subclaims
_Payments _Payments
_Participants _Participants

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 A_InsurClmClaimInquiry.
-- 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.
-- Parameters: P_InsuranceClaim : icl_claim

CREATE VIEW A_InsurClmClaimInquiry AS
SELECT
  InsuranceClaim,
  InsuranceContract,
  InsurClmPolicyProduct,
  InsurClmLifeCycSts,
  InsurClmLifeCycStsName,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmAuthznGrp,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmIncdntType,
  InsurClmIncdntTypeName,
  InsurClmDateOfLoss,
  InsurClmAgentReportedDate,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  InsurClmDescriptionOfLossLoc,
  InsurClaimBundle,
  InsurClmTimeOfLoss,
  InsurClmComplexity,
  InsurClmComplexityName,
  InsurClmCovered,
  InsurancePolicy,
  InsurClmContractStartDateTime,
  InsurClmContractEndDateTime,
  InsurClmLocationText,
  InsurClmDescriptionOfLoss,
  InsurClmCauseOfLossName,
  FullName,
  InsurClmPolicyHolderName,
  InsurancePolicyholder
FROM I_InsurClmClaimOverview AS ClaimOverview
LEFT OUTER JOIN E_InsurClmClaimOverview AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN A_InsurClmSubclaimInquiry AS _Subclaims ON InsuranceClaim = _Subclaims.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN A_InsurClmSubclaimPayment AS _Payments ON InsuranceClaim = _Payments.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN A_InsurClmPrtcpntInquiry AS _Participants ON InsuranceClaim = _Participants.InsuranceClaim  -- association [0..*]
;

Learn More