I_InsClmSrvcsPerdcBnftSpltItm

DDL: I_INSCLMSRVCSPERDCBNFTSPLTITM Type: view_entity TRANSACTIONAL
25 Fields 1 Data Sources 3 Associations

Claim Services Periodic Benefit Item

I_InsClmSrvcsPerdcBnftSpltItm is a Transactional CDS View that provides data about "Claim Services Periodic Benefit Item" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBnftSplitPerdcItmBsc) and exposes 25 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBnftSpltPerdcItmUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBnftSplitPerdcItmBsc _InsurClmSrvcsPerdcBnftSpltItm from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_InsuranceClaimServicesPayee _Payee _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim = _Payee.InsuranceClaim and _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSplitItemNumber = _Payee.InsurClmBenefitSpltSubobject
[1..1] I_InsurClmSrvcsBeneficiary _Beneficiary _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim = _Beneficiary.InsuranceClaim and _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSplitItemNumber = _Beneficiary.InsurClmBenefitSpltSubobject
[1..1] I_InsurClmSrvcsPaymentLink _PaymentLink _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim = _PaymentLink.InsuranceClaim and _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltPerdcItmUUID = _PaymentLink.InsurClmTargetEntryUUID

Annotations (9)

NameValueLevelField
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Claim Services Periodic Benefit 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 (25)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive I_InsurClmBnftSplitPerdcItmBsc InsurClmActive Active/Suspense
KEY InsuranceClaim I_InsurClmBnftSplitPerdcItmBsc InsuranceClaim Claim Number
KEY InsurClmBnftSpltPerdcItmUUID I_InsurClmBnftSplitPerdcItmBsc InsurClmBnftSpltPerdcItmUUID Object GUID
ChangedOnDateTime I_InsurClmBnftSplitPerdcItmBsc ChangedOnDateTime Last Changed At
LastChangedByUser I_InsurClmBnftSplitPerdcItmBsc LastChangedByUser User Name
InsurClmDatabaseLineStatus I_InsurClmBnftSplitPerdcItmBsc InsurClmDatabaseLineStatus Status
InsurClmBnftSplitItemNumber I_InsurClmBnftSplitPerdcItmBsc InsurClmBnftSplitItemNumber Item
InsurClmBnftSpltPerdItmHdrUUID I_InsurClmBnftSplitPerdcItmBsc InsurClmBnftSpltPerdItmHdrUUID Object GUID
InsurClmPrioOfBnftSpltValue I_InsurClmBnftSplitPerdcItmBsc InsurClmPrioOfBnftSpltValue Profile priority
InsurClmCalcBaseShrPct I_InsurClmBnftSplitPerdcItmBsc InsurClmCalcBaseShrPct Percent Share
InsurClmBnftSpltOffsetKey I_InsurClmBnftSplitPerdcItmBsc InsurClmBnftSpltOffsetKey Offset ID
InsurClmBnftSpltNetPaytDueDate I_InsurClmBnftSplitPerdcItmBsc InsurClmBnftSpltNetPaytDueDate Promised For
InsurClmBankDetailsId I_InsurClmBnftSplitPerdcItmBsc InsurClmBankDetailsId Bank Details
InsurClmPaytMethod I_InsurClmBnftSplitPerdcItmBsc InsurClmPaytMethod Payment Method
InsurClmPaytAddrNmbrForChecks I_InsurClmBnftSplitPerdcItmBsc InsurClmPaytAddrNmbrForChecks Address
InsurClmAltvPostgTgtVal I_InsurClmBnftSplitPerdcItmBsc InsurClmAltvPostgTgtVal Alt.Posting Tgt
InsurClmPaytNote I_InsurClmBnftSplitPerdcItmBsc InsurClmPaytNote Purpose
InsurClmRecipient _Payee InsurClmRecipient
InsurClmBeneficiary _Beneficiary InsurClmBeneficiary
InsurClmPaymentDatabaseStatus _PaymentLink InsurClmPaymentDatabaseStatus Internal Status
InsurClmTargetEntryUUID _PaymentLink InsurClmTargetEntryUUID TargetUUID
InsurClmBnftSpltItmValidToDate I_InsurClmBnftSplitPerdcItmBsc InsurClmBnftSpltItmValidToDate Vers.Valid To
_Payee _Payee
_Beneficiary _Beneficiary
_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_InsClmSrvcsPerdcBnftSpltItm.
-- 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_InsClmSrvcsPerdcBnftSpltItm AS
SELECT
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmActive AS InsurClmActive,
  _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim AS InsuranceClaim,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltPerdcItmUUID AS InsurClmBnftSpltPerdcItmUUID,
  _InsurClmSrvcsPerdcBnftSpltItm.ChangedOnDateTime AS ChangedOnDateTime,
  _InsurClmSrvcsPerdcBnftSpltItm.LastChangedByUser AS LastChangedByUser,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmDatabaseLineStatus AS InsurClmDatabaseLineStatus,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSplitItemNumber AS InsurClmBnftSplitItemNumber,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltPerdItmHdrUUID AS InsurClmBnftSpltPerdItmHdrUUID,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmPrioOfBnftSpltValue AS InsurClmPrioOfBnftSpltValue,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmCalcBaseShrPct AS InsurClmCalcBaseShrPct,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltOffsetKey AS InsurClmBnftSpltOffsetKey,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltNetPaytDueDate AS InsurClmBnftSpltNetPaytDueDate,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBankDetailsId AS InsurClmBankDetailsId,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmPaytMethod AS InsurClmPaytMethod,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmPaytAddrNmbrForChecks AS InsurClmPaytAddrNmbrForChecks,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmAltvPostgTgtVal AS InsurClmAltvPostgTgtVal,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmPaytNote AS InsurClmPaytNote,
  _Payee.InsurClmRecipient AS InsurClmRecipient,
  _Beneficiary.InsurClmBeneficiary AS InsurClmBeneficiary,
  _PaymentLink.InsurClmPaymentDatabaseStatus AS InsurClmPaymentDatabaseStatus,
  _PaymentLink.InsurClmTargetEntryUUID AS InsurClmTargetEntryUUID,
  _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltItmValidToDate AS InsurClmBnftSpltItmValidToDate
FROM I_InsurClmBnftSplitPerdcItmBsc AS _InsurClmSrvcsPerdcBnftSpltItm
LEFT OUTER JOIN I_InsuranceClaimServicesPayee AS _Payee ON _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim = _Payee.InsuranceClaim AND _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSplitItemNumber = _Payee.InsurClmBenefitSpltSubobject  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSrvcsBeneficiary AS _Beneficiary ON _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim = _Beneficiary.InsuranceClaim AND _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSplitItemNumber = _Beneficiary.InsurClmBenefitSpltSubobject  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSrvcsPaymentLink AS _PaymentLink ON _InsurClmSrvcsPerdcBnftSpltItm.InsuranceClaim = _PaymentLink.InsuranceClaim AND _InsurClmSrvcsPerdcBnftSpltItm.InsurClmBnftSpltPerdcItmUUID = _PaymentLink.InsurClmTargetEntryUUID  -- association [1..1]
;

Learn More