I_InsurClmBenefitSplitItem

DDL: I_INSURCLMBENEFITSPLITITEM Type: view_entity COMPOSITE Package: ICL_VDM_COMMON
30 Fields 1 Data Sources 2 Associations

Zusammengesetzte Verteilungsposition

I_InsurClmBenefitSplitItem is a Composite CDS View that provides data about "Zusammengesetzte Verteilungsposition" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBnftSplitItemBasic) and exposes 30 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBnftSpltItmUUID. It has 2 associations to related views. Part of development package ICL_VDM_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBnftSplitItemBasic _SplitItemBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsuranceClaim _InsuranceClaim $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim
[1..1] I_InsurClmBenefitSplitHeader _InsurClmBenefitSplitHdr $projection.InsurClmActive = _InsurClmBenefitSplitHdr.InsurClmActive and $projection.InsuranceClaim = _InsurClmBenefitSplitHdr.InsuranceClaim and $projection.InsurClmBnftSpltItmHdrUUID = _InsurClmBenefitSplitHdr.InsurClmBnftSpltHdrUUID

Annotations (10)

NameValueLevelField
EndUserText.label Zusammengesetzte Verteilungsposition view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey InsurClmBnftSpltItmUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmBnftSpltItmUUID InsurClmBnftSpltItmUUID Object GUID
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmBnftSplitItemNumber InsurClmBnftSplitItemNumber Item
InsurClmBnftSpltItmHdrUUID InsurClmBnftSpltItmHdrUUID Object GUID
InsurClmPrioOfBnftSpltValue InsurClmPrioOfBnftSpltValue Profile priority
InsurClmCalcBaseShrPct InsurClmCalcBaseShrPct Percent Share
InsurClmBnftSpltItmGrossAmt InsurClmBnftSpltItmGrossAmt Gross value
InsurClmBnftSpltItmNetAmt InsurClmBnftSpltItmNetAmt Stated Amount
InsurClmBnftSpltAmtFxdValue InsurClmBnftSpltAmtFxdValue BenSplAmt Fixed
InsurClmBnftSpltItmPaidAmt InsurClmBnftSpltItmPaidAmt Received
InsurClmBnftSpltItmCalcBaseAmt InsurClmBnftSpltItmCalcBaseAmt Calculatn Base
InsurClmBnftSpltOffsetKey InsurClmBnftSpltOffsetKey Offset ID
InsurClmBnftSpltNetPaytDueDate InsurClmBnftSpltNetPaytDueDate Promised For
InsurClmBankDetailsId InsurClmBankDetailsId Bank Details
InsurClmPaytMethod InsurClmPaytMethod Payment Method
InsurClmPaytAddrNmbrForChecks InsurClmPaytAddrNmbrForChecks Address
InsurClmAltvPostgTgtVal InsurClmAltvPostgTgtVal Alt.Posting Tgt
InsurClmPaytNote InsurClmPaytNote Purpose
InsurClmBnftSplitCurrency InsurClmBnftSplitCurrency Currency
InsurClmBnftSpltItmValidToDate InsurClmBnftSpltItmValidToDate Vers.Valid To
InsurClmNetAmtValidValue InsurClmNetAmtValidValue Out of Date
InsurClmBnftSpltItmSubclaim InsurClmBnftSpltItmSubclaim Subclaim
InsurClmIsOffstAmtAssgdSubclm InsurClmIsOffstAmtAssgdSubclm Offset Amt to Subclm
_InsuranceClaim _InsuranceClaim
_InsurClmBenefitSplitHdr _InsurClmBenefitSplitHdr
_Currency _Currency

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_InsurClmBenefitSplitItem.
-- 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_InsurClmBenefitSplitItem AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmBnftSpltItmUUID,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmBnftSplitItemNumber,
  InsurClmBnftSpltItmHdrUUID,
  InsurClmPrioOfBnftSpltValue,
  InsurClmCalcBaseShrPct,
  InsurClmBnftSpltItmGrossAmt,
  InsurClmBnftSpltItmNetAmt,
  InsurClmBnftSpltAmtFxdValue,
  InsurClmBnftSpltItmPaidAmt,
  InsurClmBnftSpltItmCalcBaseAmt,
  InsurClmBnftSpltOffsetKey,
  InsurClmBnftSpltNetPaytDueDate,
  InsurClmBankDetailsId,
  InsurClmPaytMethod,
  InsurClmPaytAddrNmbrForChecks,
  InsurClmAltvPostgTgtVal,
  InsurClmPaytNote,
  InsurClmBnftSplitCurrency,
  InsurClmBnftSpltItmValidToDate,
  InsurClmNetAmtValidValue,
  InsurClmBnftSpltItmSubclaim,
  InsurClmIsOffstAmtAssgdSubclm
FROM I_InsurClmBnftSplitItemBasic AS _SplitItemBasic
LEFT OUTER JOIN I_InsuranceClaim AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmBenefitSplitHeader AS _InsurClmBenefitSplitHdr ON InsurClmActive = _InsurClmBenefitSplitHdr.InsurClmActive AND InsuranceClaim = _InsurClmBenefitSplitHdr.InsuranceClaim AND InsurClmBnftSpltItmHdrUUID = _InsurClmBenefitSplitHdr.InsurClmBnftSpltHdrUUID  -- association [1..1]
;

Learn More