R_InsurancePolicyTP_2
Policy - TP
R_InsurancePolicyTP_2 is a Transactional CDS View that provides data about "Policy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyBasic) and exposes 79 fields with key field InsurPlcyUUID. It has 22 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InsurPlcyBasic | Policy | from |
Associations (22)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_InsurPlcyContractTP | _Contract | $projection.InsurPlcyUUID = _Contract.InsurPlcyUUID |
| [1..*] | R_InsurPlcyContrJrnlHdrTP | _ContractJournalHeader | $projection.InsurPlcyUUID = _ContractJournalHeader.InsurPlcyUUID |
| [0..*] | R_InsurPlcyApplJrnlHdrTP | _ApplicationJournalHeader | $projection.InsurPlcyUUID = _ApplicationJournalHeader.InsurPlcyUUID |
| [0..*] | R_InsurPlcyCashFlowHdrTP | _CashFlowDocumentHeader | $projection.InsurPlcyUUID = _CashFlowDocumentHeader.InsurPlcyUUID |
| [0..*] | R_InsurPlcyCBCCashFlowHdrTP | _CBCCashFlowDocumentHeader | $projection.InsurPlcyUUID = _CBCCashFlowDocumentHeader.InsurPlcyUUID |
| [0..*] | R_InsurPlcyCBCOverviewTP | _CBCOverview | $projection.InsurPlcyUUID = _CBCOverview.InsurPlcyUUID or $projection.InsurPlcyUUID = _CBCOverview.InsurPlcyApplUUID |
| [0..*] | R_InsurPlcyAccountingTP_2 | _TransferSettle | $projection.InsurancePolicy = _TransferSettle.InsurPlcyAcctgExtPlcyNmbr |
| [0..*] | R_InsurPlcyAccountingTP_2 | _TransferSettleRef | $projection.InsurancePolicy = _TransferSettleRef.InsurPlcyAcctgRefPlcyNmbr |
| [0..*] | R_InsurPlcyDualControlTP | _DualControl | $projection.InsurPlcyUUID = _DualControl.InsurPlcyUUID |
| [0..*] | R_InsurPlcyBnftCasesAndClaimTP | _BenefitCasesAndClaims | $projection.InsurPlcyUUID = _BenefitCasesAndClaims.InsurPlcyUUID |
| [0..*] | R_InsurPlcyPlndDteProcessingTP | _PlannedProcessing | $projection.InsurPlcyUUID = _PlannedProcessing.InsurPlcyUUID |
| [0..*] | R_InsurPlcyCoinsurCashFlowTP | _CoinsuranceCashFlow | $projection.InsurPlcyUUID = _CoinsuranceCashFlow.InsurPlcyUUID |
| [1..1] | E_InsurancePolicy | _Extension | $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr |
| [1..*] | R_InsurPlcyPolicyHolderTP_2 | _PolicyHolder | |
| [0..*] | R_InsurPlcyReltdContractTP | _RelatedContract | |
| [0..*] | R_InsurPlcyExternalReferenceTP | _ExternalReference | |
| [0..*] | R_InsurPlcyAgentTP | _Agent | |
| [0..*] | R_InsurPlcyClauseTP_2 | _Clause | |
| [0..*] | R_InsurPlcyCommissionTP | _Commission | |
| [0..*] | R_InsurPlcyDistrPlnRelshpTP | _DistributionPlan | |
| [0..*] | R_InsurPlcyContrBndlTP | _ContractBundle | |
| [0..*] | R_InsurPlcyDistrPlnRelshpTP_2 | _DistributionPlan_2 | |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Policy - TP | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.sapObjectNodeType.name | InsurancePolicy | view | |
| AbapCatalog.extensibility.extensible | true | view | |
| AbapCatalog.extensibility.elementSuffix | POL | view | |
| AbapCatalog.extensibility.allowNewDatasources | false | view | |
| AbapCatalog.extensibility.allowNewCompositions | true | view | |
| AbapCatalog.extensibility.quota.maximumFields | 408 | view | |
| AbapCatalog.extensibility.quota.maximumBytes | 8160 | view |
Fields (79)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InsurPlcyUUID | InsurPlcyUUID | ||
| InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | |||
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | |||
| InsurancePolicy | InsurancePolicy | |||
| InsurPlcyAuthznSlsProductGroup | InsurPlcyAuthznSlsProductGroup | |||
| InsurPolicyStartDate | InsurPolicyStartDate | |||
| InsurancePolicyStartTime | InsurancePolicyStartTime | |||
| InsurancePolicyStartTimeZone | InsurancePolicyStartTimeZone | |||
| InsurApplLifeCycSts | InsurApplLifeCycSts | |||
| InsurPlcyDistrChnl | InsurPlcyDistrChnl | |||
| InsrrIDByInsrr | InsrrIDByInsrr | |||
| InsurPlcySalesProductTemplate | InsurPlcySalesProductTemplate | |||
| InsurPlcyAcqnType | InsurPlcyAcqnType | |||
| InsurPlcyBusinessObject | InsurPlcyBusinessObject | |||
| PrdcssrInsurancePolicy | PrdcssrInsurancePolicy | |||
| LastChangeDateTime | LastChangeDateTime | |||
| InsurPolicyCancellationStatus | InsurPolicyCancellationStatus | |||
| InsurancePlcyPolicyIsCancelled | InsurancePlcyPolicyIsCancelled | |||
| InsurancePolicyNumberOld | InsurancePolicyNumberOld | |||
| InsurPlcyExchRateType | InsurPlcyExchRateType | |||
| InsurPlcyCrcy | InsurPlcyCrcy | |||
| InsurancePolicyNoteIdentifier | InsurancePolicyNoteIdentifier | |||
| LongText | LongText | |||
| TextObjectCategory | TextObjectCategory | |||
| TextObjectKey | TextObjectKey | |||
| Language | Language | |||
| InsurPlcyExtApplNmbr | InsurPlcyExtApplNmbr | |||
| InsurPlcyCommissionPostingCode | InsurPlcyCommissionPostingCode | |||
| InsurancePolicyDuplicateID | InsurancePolicyDuplicateID | |||
| InsurancePolicyGenerationDate | InsurancePolicyGenerationDate | |||
| InsurPlcySrceOfGnrtnDteCode | InsurPlcySrceOfGnrtnDteCode | |||
| InsurancePolicyKey | InsurancePolicyKey | |||
| InsurPlcySrceDocStsDateTime | InsurPlcySrceDocStsDateTime | |||
| InsurPlcyChangeOptionNumber | InsurPlcyChangeOptionNumber | |||
| InsurPlcyChgOptnApplID | InsurPlcyChgOptnApplID | |||
| InsurPlcyChangeOptionText | InsurPlcyChangeOptionText | |||
| InsurancePolicyIsChangeOption | InsurancePolicyIsChangeOption | |||
| InsurPlcyHasPndgCommsnCase | InsurPlcyHasPndgCommsnCase | |||
| InsurPlcyChangeOptionCategory | InsurPlcyChangeOptionCategory | |||
| InsurMstrPlcyJrnlNmbr | InsurMstrPlcyJrnlNmbr | |||
| InsurMstrPlcySmplApplID | InsurMstrPlcySmplApplID | |||
| InsurPlcyChgOptnRsn | InsurPlcyChgOptnRsn | |||
| InsuranceMasterPolicyNumber | InsuranceMasterPolicyNumber | |||
| InsurPlcyIsCoinsurPrtcpnt | InsurPlcyIsCoinsurPrtcpnt | |||
| InsurPlcyGnrtnDetnDte | InsurPlcyGnrtnDetnDte | |||
| InsurPlcyHasPolicyProcessing | InsurPlcyHasPolicyProcessing | |||
| InsurancePolicyShiftType | InsurancePolicyShiftType | |||
| InsurancePolicySubjectCode | InsurancePolicySubjectCode | |||
| InsurancePolicyHasReassessment | InsurancePolicyHasReassessment | |||
| InsurPlcyReassessmentNoteID | InsurPlcyReassessmentNoteID | |||
| InsurPlcyPremWvrAnnulmentRsn | InsurPlcyPremWvrAnnulmentRsn | |||
| InsurPlcyContractualDpndcySts | InsurPlcyContractualDpndcySts | |||
| InsurPlcyIsReleasePolicy | ||||
| InsurPlcyIsSavePolicy | ||||
| InsurPlcyIsCalctPolicy | ||||
| InsurPlcyIsCBCAmtSimulate | ||||
| InsurPlcyIsSmltePolicy | ||||
| InsurancePolicyLockKey | ||||
| _Contract | _Contract | |||
| _ContractBundle | _ContractBundle | |||
| _PolicyHolder | _PolicyHolder | |||
| _RelatedContract | _RelatedContract | |||
| _ExternalReference | _ExternalReference | |||
| _Agent | _Agent | |||
| _Clause | _Clause | |||
| _Commission | _Commission | |||
| _DistributionPlan | _DistributionPlan | |||
| _DistributionPlan_2 | _DistributionPlan_2 | |||
| _ContractJournalHeader | _ContractJournalHeader | |||
| _ApplicationJournalHeader | _ApplicationJournalHeader | |||
| _CashFlowDocumentHeader | _CashFlowDocumentHeader | |||
| _TransferSettle | _TransferSettle | |||
| _TransferSettleRef | _TransferSettleRef | |||
| _CBCCashFlowDocumentHeader | _CBCCashFlowDocumentHeader | |||
| _CBCOverview | _CBCOverview | |||
| _DualControl | _DualControl | |||
| _BenefitCasesAndClaims | _BenefitCasesAndClaims | |||
| _PlannedProcessing | _PlannedProcessing | |||
| _CoinsuranceCashFlow | _CoinsuranceCashFlow |
@EndUserText.label: 'Policy - TP'
@VDM: {
viewType:#TRANSACTIONAL,
lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel: {
semanticKey: [ 'InsurancePolicy' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
}
}
@ObjectModel.sapObjectNodeType.name: 'InsurancePolicy'
@AbapCatalog.extensibility: {
extensible: true,
elementSuffix: 'POL',
allowNewDatasources: false,
allowNewCompositions: true,
dataSources: [ '_Extension' ],
quota: {
maximumFields: 408, /*as per business context defined in CFD_REGISTERY max is 408 allowed*/
maximumBytes: 8160
}
}
define root view entity R_InsurancePolicyTP_2
as select from I_InsurPlcyBasic as Policy
composition [1..*] of R_InsurPlcyPolicyHolderTP_2 as _PolicyHolder //on $projection.InsurPlcyUUID = _PolicyHolder.InsurPlcyUUID
composition [0..*] of R_InsurPlcyReltdContractTP as _RelatedContract //on $projection.InsurPlcyUUID = _RelatedContract.InsurPlcyUUID
composition [0..*] of R_InsurPlcyExternalReferenceTP as _ExternalReference //on $projection.InsurPlcyUUID = _ExternalReference.InsurPlcyUUID
composition [0..*] of R_InsurPlcyAgentTP as _Agent //on $projection.InsurPlcyUUID = _Agent.InsurPlcyUUID
composition [0..*] of R_InsurPlcyClauseTP_2 as _Clause //on $projection.InsurPlcyUUID = _Clause.InsurPlcyUUID
composition [0..*] of R_InsurPlcyCommissionTP as _Commission //on $projection.InsurPlcyUUID = _Commission.InsurPlcyUUID
composition [0..*] of R_InsurPlcyDistrPlnRelshpTP as _DistributionPlan //on $projection.InsurPlcyUUID = _DistributionPlan.InsurPlcyUUID
composition [0..*] of R_InsurPlcyContrBndlTP as _ContractBundle //on $projection.InsurPlcyUUID = _ContractBundle.InsurPlcyUUID
composition [0..*] of R_InsurPlcyDistrPlnRelshpTP_2 as _DistributionPlan_2
association [0..*] to R_InsurPlcyContractTP as _Contract on $projection.InsurPlcyUUID = _Contract.InsurPlcyUUID
association [1..*] to R_InsurPlcyContrJrnlHdrTP as _ContractJournalHeader on $projection.InsurPlcyUUID = _ContractJournalHeader.InsurPlcyUUID
association [0..*] to R_InsurPlcyApplJrnlHdrTP as _ApplicationJournalHeader on $projection.InsurPlcyUUID = _ApplicationJournalHeader.InsurPlcyUUID
association [0..*] to R_InsurPlcyCashFlowHdrTP as _CashFlowDocumentHeader on $projection.InsurPlcyUUID = _CashFlowDocumentHeader.InsurPlcyUUID
association [0..*] to R_InsurPlcyCBCCashFlowHdrTP as _CBCCashFlowDocumentHeader on $projection.InsurPlcyUUID = _CBCCashFlowDocumentHeader.InsurPlcyUUID
association [0..*] to R_InsurPlcyCBCOverviewTP as _CBCOverview on $projection.InsurPlcyUUID = _CBCOverview.InsurPlcyUUID
or $projection.InsurPlcyUUID = _CBCOverview.InsurPlcyApplUUID
association [0..*] to R_InsurPlcyAccountingTP_2 as _TransferSettle on $projection.InsurancePolicy = _TransferSettle.InsurPlcyAcctgExtPlcyNmbr
association [0..*] to R_InsurPlcyAccountingTP_2 as _TransferSettleRef on $projection.InsurancePolicy = _TransferSettleRef.InsurPlcyAcctgRefPlcyNmbr
association [0..*] to R_InsurPlcyDualControlTP as _DualControl on $projection.InsurPlcyUUID = _DualControl.InsurPlcyUUID
association [0..*] to R_InsurPlcyBnftCasesAndClaimTP as _BenefitCasesAndClaims on $projection.InsurPlcyUUID = _BenefitCasesAndClaims.InsurPlcyUUID
association [0..*] to R_InsurPlcyPlndDteProcessingTP as _PlannedProcessing on $projection.InsurPlcyUUID = _PlannedProcessing.InsurPlcyUUID
association [0..*] to R_InsurPlcyCoinsurCashFlowTP as _CoinsuranceCashFlow on $projection.InsurPlcyUUID = _CoinsuranceCashFlow.InsurPlcyUUID
association [1..1] to E_InsurancePolicy as _Extension on $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID
and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr
{
key InsurPlcyUUID,
InsurPlcyJrnlNmbr,
InsurPlcyJrnlEndNmbr,
InsurancePolicy,
/*this is used in the Acces control role so should not be commented...comment in A view*/
InsurPlcyAuthznSlsProductGroup,
//Correction for 2380047004
// InsurPlcyStartDateTime,
InsurPolicyStartDate,
InsurancePolicyStartTime,
InsurancePolicyStartTimeZone,
//End of Correction
InsurApplLifeCycSts,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPolicyDistributionChannel'
InsurPlcyDistrChnl,
InsrrIDByInsrr,
InsurPlcySalesProductTemplate,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPolicyAcquisitionType'
InsurPlcyAcqnType,
InsurPlcyBusinessObject,
PrdcssrInsurancePolicy,
LastChangeDateTime,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyNoActiveContract'
InsurPolicyCancellationStatus,
InsurancePlcyPolicyIsCancelled,
InsurancePolicyNumberOld,
InsurPlcyExchRateType,
InsurPlcyCrcy,
InsurancePolicyNoteIdentifier,
LongText,
TextObjectCategory,
TextObjectKey,
Language,
InsurPlcyExtApplNmbr,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyCommsnPostingCode'
InsurPlcyCommissionPostingCode,
InsurancePolicyDuplicateID,
InsurancePolicyGenerationDate,
//@ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyGenerationDetDateSource'
InsurPlcySrceOfGnrtnDteCode,
InsurancePolicyKey,
InsurPlcySrceDocStsDateTime,
InsurPlcyChangeOptionNumber,
InsurPlcyChgOptnApplID,
InsurPlcyChangeOptionText,
InsurancePolicyIsChangeOption,
InsurPlcyHasPndgCommsnCase,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyChangeOptionCategory'
InsurPlcyChangeOptionCategory,
InsurMstrPlcyJrnlNmbr,
InsurMstrPlcySmplApplID,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyChangeOptionReason'
InsurPlcyChgOptnRsn,
InsuranceMasterPolicyNumber,
InsurPlcyIsCoinsurPrtcpnt,
InsurPlcyGnrtnDetnDte,
InsurPlcyHasPolicyProcessing,
// @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyShiftMode'
InsurancePolicyShiftType,
InsurancePolicySubjectCode,
InsurancePolicyHasReassessment,
InsurPlcyReassessmentNoteID,
@ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyPremWaiverAnnulment'
InsurPlcyPremWvrAnnulmentRsn,
InsurPlcyContractualDpndcySts,
cast ( ' ' as boolean preserving type ) as InsurPlcyIsReleasePolicy,
cast ( ' ' as boolean preserving type ) as InsurPlcyIsSavePolicy,
cast ( ' ' as boolean preserving type ) as InsurPlcyIsCalctPolicy,
cast ( ' ' as boolean preserving type ) as InsurPlcyIsCBCAmtSimulate,
cast ( ' ' as boolean preserving type ) as InsurPlcyIsSmltePolicy,
cast ( '0000000000000000000000' as /pm0/abd_svc_exa_lock_key ) as InsurancePolicyLockKey,
/*Associations*/
_Contract,
_ContractBundle,
_PolicyHolder,
_RelatedContract,
_ExternalReference,
_Agent,
_Clause,
_Commission,
_DistributionPlan,
_DistributionPlan_2,
_ContractJournalHeader,
_ApplicationJournalHeader,
_CashFlowDocumentHeader,
_TransferSettle,
_TransferSettleRef,
_CBCCashFlowDocumentHeader,
_CBCOverview,
_DualControl,
_BenefitCasesAndClaims,
_PlannedProcessing,
_CoinsuranceCashFlow
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA