R_InsurancePolicyTP_2

DDL: R_INSURANCEPOLICYTP_2 Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
I_InsurPlcyBasic Policy from

Associations (22)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 

}