I_INSURPLCYBASIC
Insurance Policy
I_INSURPLCYBASIC is a CDS View in S/4HANA. Insurance Policy. It contains 16 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsurancePolicy | view_entity | from | COMPOSITE | Insurance Policy |
| P_InsuranceOpenApplication | view_entity | from | COMPOSITE | Insurance Open Application |
| P_InsuranceOpenApplication | view_entity | union | COMPOSITE | Insurance Open Application |
| R_InsurancePolicyTP_2 | view_entity | from | TRANSACTIONAL | Policy |
| R_InsurPlcySrchPolicyTP | view_entity | from | TRANSACTIONAL | Search Insurance Policy |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 3 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 2 |
| InsrrIDByInsrr | InsrrIDByInsrr | 2 | |
| InsuranceMasterPolicyNumber | InsuranceMasterPolicyNumber | 1 | |
| InsurancePolicy | InsurancePolicy | 2 | |
| InsurApplLifeCycSts | InsurApplLifeCycSts | 2 | |
| InsurPlcyAcqnType | InsurPlcyAcqnType | 1 | |
| InsurPlcyAuthznSlsProductGroup | InsurPlcyAuthznSlsProductGroup | 2 | |
| InsurPlcyDistrChnl | InsurPlcyDistrChnl | 2 | |
| InsurPlcyExtApplNmbr | InsurPlcyExtApplNmbr | 1 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 2 | |
| InsurPlcySalesProductTemplate | InsurPlcySalesProductTemplate | 2 | |
| InsurPlcyStartDateTime | InsurPlcyStartDateTime | 2 | |
| InsurPolicyCancellationStatus | InsurPolicyCancellationStatus | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| PrdcssrInsurancePolicy | PrdcssrInsurancePolicy | 1 |
@EndUserText.label: 'Insurance Policy'
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'InsurPlcyUUID',
semanticKey: [ 'InsurancePolicy' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XL
},
supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Analytics: {
technicalName: 'IPPlcyBsc'
}
define view entity I_InsurPlcyBasic
as select from /pm0/abdapolicy as Policy
left outer to one join P_InsurPlcyAuthSlsProductGroup as AuthSlsProductGroup on Policy.pm_id = AuthSlsProductGroup.InsurPlcySalesProductTemplate
left outer to one join I_INSURPLCYNOTELONGTXTBASIC as _LongText on Policy.comment_id = _LongText.InsurancePolicyNoteIdentifier
{
key cast( Policy.secpol_id as /pm0/vdm_policy_uuid preserving type ) as InsurPlcyUUID,
key cast( Policy.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
key Policy.journalendno_id as InsurPlcyJrnlEndNmbr,
cast( Policy.policynr_tt as /pm0/vdm_policynr_tt preserving type ) as InsurancePolicy,
@Consumption.hidden: true
cast( AuthSlsProductGroup.InsurPlcySalesProductGroup as /pm0/vdm_auth_slsproduct_group preserving type ) as InsurPlcyAuthznSlsProductGroup,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Policy.polbeg_dt,
Policy.starttime_tm,
Policy.starttimezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_policy_start_datetime preserving type ) as InsurPlcyStartDateTime,
Policy.bostat_cd as InsurApplLifeCycSts,
Policy.salech_cd as InsurPlcyDistrChnl,
Policy.companykey_id as InsrrIDByInsrr,
Policy.pm_id as InsurPlcySalesProductTemplate,
Policy.acquistp_cd as InsurPlcyAcqnType,
@Consumption.hidden: true
Policy.bo_cd as InsurPlcyBusinessObject,
Policy.policynrprdcssr_tt as PrdcssrInsurancePolicy,
@Semantics.systemDateTime.lastChangedAt: true
Policy.change_ts as LastChangeDateTime,
@Semantics.booleanIndicator: true
Policy.noactive_ctrcts_fg as InsurPolicyCancellationStatus,
@Semantics.booleanIndicator: true
Policy.cancel_fg as InsurancePlcyPolicyIsCancelled,
Policy.policynrold_tt as InsurancePolicyNumberOld,
Policy.exchangerate_tp as InsurPlcyExchRateType,
Policy.currency_id as InsurPlcyCrcy,
cast( Policy.comment_id as /pm0/vdm_note_longtext_uuid preserving type ) as InsurancePolicyNoteIdentifier,
_LongText.LongText,
_LongText.TextObjectCategory,
_LongText.TextObjectKey,
_LongText.Language,
Policy.pagno_id as InsurPlcyExtApplNmbr,
Policy.commisposttx_cd as InsurPlcyCommissionPostingCode,
Policy.dupol_id as InsurancePolicyDuplicateID,
@Semantics.businessDate.at: true
Policy.generation_dt as InsurancePolicyGenerationDate,
Policy.sourgenerdate_cd as InsurPlcySrceOfGnrtnDteCode,
Policy.polpolicy_id as InsurancePolicyKey,
@Semantics.dateTime:true
Policy.origstate_ts as InsurPlcySrceDocStsDateTime,
Policy.amnnr_tt as InsurPlcyChangeOptionNumber,
Policy.amdaplpol_id as InsurPlcyChgOptnApplID,
Policy.amendmemo_tt as InsurPlcyChangeOptionText,
@Semantics.booleanIndicator: true
Policy.amdoffer_fg as InsurancePolicyIsChangeOption,
@Semantics.booleanIndicator: true
Policy.commispending_fg as InsurPlcyHasPndgCommsnCase,
Policy.amdoffrreason_cd as InsurPlcyChangeOptionCategory,
Policy.mpoljourno_id as InsurMstrPlcyJrnlNmbr,
Policy.mpattern_id as InsurMstrPlcySmplApplID,
Policy.predef_text_cd as InsurPlcyChgOptnRsn,
Policy.mpolicy_nr as InsuranceMasterPolicyNumber,
@Semantics.booleanIndicator: true
Policy.participation_fg as InsurPlcyIsCoinsurPrtcpnt,
@Semantics.businessDate.at: true
Policy.generatio_det_dt as InsurPlcyGnrtnDetnDte,
@Semantics.booleanIndicator: true
Policy.polprocess_fg as InsurPlcyHasPolicyProcessing,
Policy.shiftmode_cd as InsurancePolicyShiftType,
Policy.subjdplpol_cd as InsurancePolicySubjectCode,
@Semantics.booleanIndicator: true
Policy.reassessment_fg as InsurancePolicyHasReassessment,
Policy.reassessmemo_id as InsurPlcyReassessmentNoteID,
Policy.prmxmptendspe_cd as InsurPlcyPremWvrAnnulmentRsn,
Policy.dependstatus_id as InsurPlcyContractualDpndcySts
}