I_InsurClmBnftSplitPerdcHdr

DDL: I_INSURCLMBNFTSPLITPERDCHDR Type: view_entity COMPOSITE Package: ICL_VDM_COMMON
12 Fields 1 Data Sources 2 Associations

Leistungsverteilung (periodisch)

I_InsurClmBnftSplitPerdcHdr is a Composite CDS View that provides data about "Leistungsverteilung (periodisch)" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBnftSplitPerdcHdrBsc) and exposes 12 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBnftSpltPerdcHdrUUID. It has 2 associations to related views. Part of development package ICL_VDM_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBnftSplitPerdcHdrBsc _InsurClmBnftSplitPerdcHdr from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsuranceClaim _InsuranceClaim $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim
[0..*] I_InsurClmBnftSplitPerdcItem _BnftSplitPerdcItem $projection.InsurClmActive = _BnftSplitPerdcItem.InsurClmActive and $projection.InsuranceClaim = _BnftSplitPerdcItem.InsuranceClaim and $projection.InsurClmBnftSpltPerdcHdrUUID = _BnftSplitPerdcItem.InsurClmBnftSpltPerdcItmUUID

Annotations (10)

NameValueLevelField
EndUserText.label Leistungsverteilung (periodisch) view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey InsurClmBnftSpltPerdcHdrUUID 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 (12)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmBnftSpltPerdcHdrUUID InsurClmBnftSpltPerdcHdrUUID Object GUID
ChangedOnDateTime I_InsurClmBnftSplitPerdcHdrBsc ChangedOnDateTime Last Changed At
LastChangedByUser I_InsurClmBnftSplitPerdcHdrBsc LastChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmBnftSpltPerdcHdrNmbr InsurClmBnftSpltPerdcHdrNmbr Benef.Split To
InsurClmBnftSplitValidFromDate InsurClmBnftSplitValidFromDate Vers.Valid From
InsurClmBnftSpltValidToDate InsurClmBnftSpltValidToDate Vers.Valid To
InsurClmAddlPaytDueDateVal InsurClmAddlPaytDueDateVal Addl Due Date
_InsuranceClaim _InsuranceClaim
_BnftSplitPerdcItem _BnftSplitPerdcItem

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_InsurClmBnftSplitPerdcHdr.
-- 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_InsurClmBnftSplitPerdcHdr AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmBnftSpltPerdcHdrUUID,
  _InsurClmBnftSplitPerdcHdr.ChangedOnDateTime AS ChangedOnDateTime,
  _InsurClmBnftSplitPerdcHdr.LastChangedByUser AS LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmBnftSpltPerdcHdrNmbr,
  InsurClmBnftSplitValidFromDate,
  InsurClmBnftSpltValidToDate,
  InsurClmAddlPaytDueDateVal
FROM I_InsurClmBnftSplitPerdcHdrBsc AS _InsurClmBnftSplitPerdcHdr
LEFT OUTER JOIN I_InsuranceClaim AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmBnftSplitPerdcItem AS _BnftSplitPerdcItem ON InsurClmActive = _BnftSplitPerdcItem.InsurClmActive AND InsuranceClaim = _BnftSplitPerdcItem.InsuranceClaim AND InsurClmBnftSpltPerdcHdrUUID = _BnftSplitPerdcItem.InsurClmBnftSpltPerdcItmUUID  -- association [0..*]
;

Learn More