I_InsurClmSrvcsBnftSpltItm

DDL: I_INSURCLMSRVCSBNFTSPLTITM Type: view_entity TRANSACTIONAL

Claim Services Benefit Split Item

I_InsurClmSrvcsBnftSpltItm is a Transactional CDS View that provides data about "Claim Services Benefit Split Item" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBnftSplitItemBasic) and exposes 35 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBnftSpltItmUUID.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBnftSplitItemBasic _InsurClmBensplitItm from

Annotations (9)

NameValueLevelField
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Claim Services Benefit Split Item view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (35)

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

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_InsurClmSrvcsBnftSpltItm.
-- 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_InsurClmSrvcsBnftSpltItm AS
SELECT
  _InsurClmBensplitItm.InsurClmActive AS InsurClmActive,
  _InsurClmBensplitItm.InsuranceClaim AS InsuranceClaim,
  _InsurClmBensplitItm.InsurClmBnftSpltItmUUID AS InsurClmBnftSpltItmUUID,
  _InsurClmBensplitItm.ChangedOnDateTime AS ChangedOnDateTime,
  _InsurClmBensplitItm.LastChangedByUser AS LastChangedByUser,
  _InsurClmBensplitItm.InsurClmDatabaseLineStatus AS InsurClmDatabaseLineStatus,
  _InsurClmBensplitItm.InsurClmBnftSplitItemNumber AS InsurClmBnftSplitItemNumber,
  _InsurClmBensplitItm.InsurClmBnftSpltItmHdrUUID AS InsurClmBnftSpltItmHdrUUID,
  _InsurClmBensplitItm.InsurClmPrioOfBnftSpltValue AS InsurClmPrioOfBnftSpltValue,
  _InsurClmBensplitItm.InsurClmCalcBaseShrPct AS InsurClmCalcBaseShrPct,
  _InsurClmBensplitItm.InsurClmBnftSpltItmGrossAmt AS InsurClmBnftSpltItmGrossAmt,
  _InsurClmBensplitItm.InsurClmBnftSpltItmNetAmt AS InsurClmBnftSpltItmNetAmt,
  _InsurClmBensplitItm.InsurClmBnftSpltAmtFxdValue AS InsurClmBnftSpltAmtFxdValue,
  _InsurClmBensplitItm.InsurClmBnftSpltItmPaidAmt AS InsurClmBnftSpltItmPaidAmt,
  _InsurClmBensplitItm.InsurClmBnftSpltItmCalcBaseAmt AS InsurClmBnftSpltItmCalcBaseAmt,
  _InsurClmBensplitItm.InsurClmBnftSpltOffsetKey AS InsurClmBnftSpltOffsetKey,
  _InsurClmBensplitItm.InsurClmBnftSpltNetPaytDueDate AS InsurClmBnftSpltNetPaytDueDate,
  _InsurClmBensplitItm.InsurClmBankDetailsId AS InsurClmBankDetailsId,
  _InsurClmBensplitItm.InsurClmPaytMethod AS InsurClmPaytMethod,
  _InsurClmBensplitItm.InsurClmPaytAddrNmbrForChecks AS InsurClmPaytAddrNmbrForChecks,
  _InsurClmBensplitItm.InsurClmBnftSpltItmValidToID AS InsurClmBnftSpltItmValidToID,
  _InsurClmBensplitItm.InsurClmAltvPostgTgtVal AS InsurClmAltvPostgTgtVal,
  _InsurClmBensplitItm.InsurClmPaytNote AS InsurClmPaytNote,
  _InsurClmBensplitItm.InsurClmBnftSplitCurrency AS InsurClmBnftSplitCurrency,
  _InsurClmBensplitItm.InsurClmBnftSpltItmValidToDate AS InsurClmBnftSpltItmValidToDate,
  _InsurClmBensplitItm.InsurClmNetAmtValidValue AS InsurClmNetAmtValidValue,
  _InsurClmBensplitItm.InsurClmBnftSpltItmSubclaim AS InsurClmBnftSpltItmSubclaim,
  _InsurClmBensplitItm.InsurClmIsOffstAmtAssgdSubclm AS InsurClmIsOffstAmtAssgdSubclm,
  _Payee.InsurClmRecipient AS InsurClmRecipient,
  _Beneficiary.InsurClmBeneficiary AS InsurClmBeneficiary,
  _TaxPayer.InsurClmTaxHdrTaxPayer AS InsurClmTaxHdrTaxPayer,
  _PaymentLink.InsurClmPaymentDatabaseStatus AS InsurClmPaymentDatabaseStatus,
  _PaymentLink.InsurClmTargetEntryUUID AS InsurClmTargetEntryUUID,
  _InsurClmBensplitItm._Currency AS _Currency
FROM I_InsurClmBnftSplitItemBasic AS _InsurClmBensplitItm
;