R_InsurClmBnftSplitPerdcHdrTP

DDL: R_INSURCLMBNFTSPLITPERDCHDRTP Type: view_entity TRANSACTIONAL Package: ICL_VDM_CLAIM_API
12 Fields 1 Data Sources 2 Associations

Benefit Split Header (Periodic) - TP

R_InsurClmBnftSplitPerdcHdrTP is a Transactional CDS View that provides data about "Benefit Split Header (Periodic) - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBnftSplitPerdcHdr) and exposes 12 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBnftSpltPerdcHdrUUID. It has 2 associations to related views. Part of development package ICL_VDM_CLAIM_API.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBnftSplitPerdcHdr I_InsurClmBnftSplitPerdcHdr from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_InsurClmBnftSplitPerdcHdr _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmBnftSpltPerdcHdrUUID = _Extension.InsurClmBnftSpltPerdcHdrUUID
[0..*] R_InsurClmBnftSplitPerdcItemTP _InsurClmBnftSplitPerdcItem

Annotations (8)

NameValueLevelField
EndUserText.label Benefit Split Header (Periodic) - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmBnftSpltPerdcHdrUUID InsurClmBnftSpltPerdcHdrUUID
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmBnftSpltPerdcHdrNmbr InsurClmBnftSpltPerdcHdrNmbr
InsurClmBnftSplitValidFromDate InsurClmBnftSplitValidFromDate
InsurClmBnftSpltValidToDate InsurClmBnftSpltValidToDate
InsurClmAddlPaytDueDateVal InsurClmAddlPaytDueDateVal Addl Due Date
_InsuranceClaim _InsuranceClaim
_InsurClmBnftSplitPerdcItem _InsurClmBnftSplitPerdcItem

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 R_InsurClmBnftSplitPerdcHdrTP.
-- 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 R_InsurClmBnftSplitPerdcHdrTP AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmBnftSpltPerdcHdrUUID,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmDatabaseLineStatus,
  InsurClmBnftSpltPerdcHdrNmbr,
  InsurClmBnftSplitValidFromDate,
  InsurClmBnftSpltValidToDate,
  InsurClmAddlPaytDueDateVal
FROM I_InsurClmBnftSplitPerdcHdr
LEFT OUTER JOIN E_InsurClmBnftSplitPerdcHdr AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmBnftSpltPerdcHdrUUID = _Extension.InsurClmBnftSpltPerdcHdrUUID  -- association [1..1]
LEFT OUTER JOIN R_InsurClmBnftSplitPerdcItemTP AS _InsurClmBnftSplitPerdcItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More