R_InsurancePolicyTP

DDL: R_INSURANCEPOLICYTP Type: view_entity TRANSACTIONAL
19 Fields 1 Data Sources 6 Associations

Insurance Policy - TP

R_InsurancePolicyTP is a Transactional CDS View that provides data about "Insurance Policy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurancePolicy) and exposes 19 fields with key field InsurPlcyUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurancePolicy InsurancePolicy from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_InsurPlcyCashFlowHeader _InsurPlcyCashFlowHeader $projection.InsurancePolicy = _InsurPlcyCashFlowHeader.InsurancePolicy
[1..1] E_InsurancePolicy _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[1..*] R_InsuranceContractTP _InsuranceContract
[1..*] R_InsurPolicyPolicyHolderTP _InsurancePolicyholder
[1..*] R_InsurPlcyContrJrnlTP _InsurPlcyContrJrnl
[0..*] R_InsurPlcyPlannedProcessingTP _InsurPlcyPlndProcg

Annotations (8)

NameValueLevelField
EndUserText.label Insurance Policy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey InsurPlcyUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
InsurancePolicy InsurancePolicy Policy Number
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyAuthznSlsProductGroup InsurPlcyAuthznSlsProductGroup Auth. Sales Prod. Module Group
InsurPlcyStartDateTime InsurPlcyStartDateTime Policy Start
InsurApplLifeCycSts InsurApplLifeCycSts Policy Status
InsurPlcyDistrChnl InsurPlcyDistrChnl Distrib.Channel
InsrrIDByInsrr InsrrIDByInsrr Company ID
InsurancePolicyPolicyControl InsurPlcySalesProductTemplate SlsProdTempl.ID
InsurPlcyAcqnType InsurPlcyAcqnType Acq. Type
PrdcssrInsurancePolicy PrdcssrInsurancePolicy Previous Policy
InsurPolicyCancellationStatus InsurPolicyCancellationStatus Policy Cancellation
LastChangeDateTime LastChangeDateTime Timestamp
_InsuranceContract _InsuranceContract
_InsurancePolicyholder _InsurancePolicyholder
_InsurPlcyContrJrnl _InsurPlcyContrJrnl
_InsurPlcyPlndProcg _InsurPlcyPlndProcg
_InsurPlcyCashFlowHeader _InsurPlcyCashFlowHeader

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_InsurancePolicyTP.
-- 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_InsurancePolicyTP AS
SELECT
  InsurPlcyUUID,
  InsurancePolicy,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyAuthznSlsProductGroup,
  InsurPlcyStartDateTime,
  InsurApplLifeCycSts,
  InsurPlcyDistrChnl,
  InsrrIDByInsrr,
  InsurPlcySalesProductTemplate AS InsurancePolicyPolicyControl,
  InsurPlcyAcqnType,
  PrdcssrInsurancePolicy,
  InsurPolicyCancellationStatus,
  LastChangeDateTime
FROM I_InsurancePolicy AS InsurancePolicy
LEFT OUTER JOIN I_InsurPlcyCashFlowHeader AS _InsurPlcyCashFlowHeader ON InsurancePolicy = _InsurPlcyCashFlowHeader.InsurancePolicy  -- association [1..*]
LEFT OUTER JOIN E_InsurancePolicy AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsuranceContractTP AS _InsuranceContract ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_InsurPolicyPolicyHolderTP AS _InsurancePolicyholder ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_InsurPlcyContrJrnlTP AS _InsurPlcyContrJrnl ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_InsurPlcyPlannedProcessingTP AS _InsurPlcyPlndProcg ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More