R_InsurClmLimitDeductibleTP

DDL: R_INSURCLMLIMITDEDUCTIBLETP Type: view_entity TRANSACTIONAL
10 Fields 1 Data Sources 1 Associations

Policy Snapshot: Limit and Deductible - TP

R_InsurClmLimitDeductibleTP is a Transactional CDS View that provides data about "Policy Snapshot: Limit and Deductible - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmLimitDeductible) and exposes 10 fields with key fields InsuranceClaim, InsurClmContractVersion, InsurClmCoverage, InsurBnftType, InsurClmInsuredObject. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmLimitDeductible I_InsurClmLimitDeductible from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurClmLimitDeductible _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmContractVersion = _Extension.InsurClmContractVersion and $projection.InsurClmCoverage = _Extension.InsurClmCoverage and $projection.InsurBnftType = _Extension.InsurBnftType and $projection.InsurClmInsuredObject = _Extension.InsurClmInsuredObject and $projection.InsurClmLimitDcblPriority = _Extension.InsurClmLimitDcblPriority

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Policy Snapshot: Limit and Deductible - TP view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 1000 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 (10)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmContractVersion InsurClmContractVersion Contrct Counter
KEY InsurClmCoverage InsurClmCoverage Coverage No.
KEY InsurBnftType InsurBnftType Benefit Type
KEY InsurClmInsuredObject InsurClmInsuredObject Insured Object
KEY InsurClmLimitDcblPriority InsurClmLimitDcblPriority Workflow priority
InsurClmLimitUnit InsurClmLimitUnit Unit of Measure
InsurClmDeductiblePercent InsurClmDeductiblePercent Deductible (%)
InsurClmDeductibleUnit InsurClmDeductibleUnit Unit of Measure
_PolicySnapshot _PolicySnapshot

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_InsurClmLimitDeductibleTP.
-- 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_InsurClmLimitDeductibleTP AS
SELECT
  InsuranceClaim,
  InsurClmContractVersion,
  InsurClmCoverage,
  InsurBnftType,
  InsurClmInsuredObject,
  InsurClmLimitDcblPriority,
  InsurClmLimitUnit,
  InsurClmDeductiblePercent,
  InsurClmDeductibleUnit
FROM I_InsurClmLimitDeductible
LEFT OUTER JOIN E_InsurClmLimitDeductible AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmContractVersion = _Extension.InsurClmContractVersion AND InsurClmCoverage = _Extension.InsurClmCoverage AND InsurBnftType = _Extension.InsurBnftType AND InsurClmInsuredObject = _Extension.InsurClmInsuredObject AND InsurClmLimitDcblPriority = _Extension.InsurClmLimitDcblPriority  -- association [1..1]
;

Learn More