I_INSURANCECONTRACTBASIC
Contract in Insurance Policy
I_INSURANCECONTRACTBASIC is a CDS View in S/4HANA. Contract in Insurance Policy. It contains 23 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InsuranceContract | view_entity | from | COMPOSITE | Contract in Insurance Policy |
| I_InsurApplContract | view_entity | from | COMPOSITE | Contract in Insurance Appl |
| I_InsurOpenApplContract | view_entity | from | COMPOSITE | Contract in Insur Open Appl |
| P_InsurOpenApplContract | view_entity | from | COMPOSITE | |
| P_InsurOpenApplContract | view_entity | union | COMPOSITE | |
| P_InsurPlcyPremDevContract | view_entity | inner | COMPOSITE |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InsurPlcyInsurContr | InsurPlcyInsurContr | 4 |
| KEY | InsurPlcyUUID | InsurPlcyUUID | 2 |
| InsrrIDByInsrr | InsrrIDByInsrr | 3 | |
| InsuranceContract | InsuranceContract | 4 | |
| InsurApplLifeCycSts | InsurApplLifeCycSts | 4 | |
| InsurApplRjcnRsn | InsurApplRjcnRsn | 3 | |
| InsurCollDisbmtInsurObj | InsurCollDisbmtInsurObj | 3 | |
| InsurContrCanclnRsn | InsurContrCanclnRsn | 3 | |
| InsurContrLifeCycSts | InsurContrLifeCycSts | 3 | |
| InsurContrRnwlType | InsurContrRnwlType | 3 | |
| InsurContrTrifVar | InsurContrTrifVar | 3 | |
| InsurPlcyContractEndDateTime | InsurPlcyContractEndDateTime | 3 | |
| InsurPlcyContractStartDateTime | InsurPlcyContractStartDateTime | 3 | |
| InsurPlcyContrCanclnDateTime | InsurPlcyContrCanclnDateTime | 3 | |
| InsurPlcyContrStartIsDayOfRegn | InsurPlcyContrStartIsDayOfRegn | 3 | |
| InsurPlcyCountry | InsurPlcyCountry | 3 | |
| InsurPlcyDiscountProtection | InsurPlcyDiscountProtection | 3 | |
| InsurPlcyJrnlEndNmbr | InsurPlcyJrnlEndNmbr | 3 | |
| InsurPlcyJrnlNmbr | InsurPlcyJrnlNmbr | 4 | |
| InsurPlcyLineOfBusiness | InsurPlcyLineOfBusiness | 3 | |
| InsurPlcyProductPackageID | InsurPlcyProductPackageID | 3 | |
| InsurPlcyProductTemplate | InsurPlcyProductTemplate | 3 | |
| LastChangeDateTime | LastChangeDateTime | 3 |
@EndUserText.label: 'Contract in Insurance Policy'
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'InsurPlcyInsurContr',
semanticKey: [ 'InsuranceContract' ],
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #XL
},
supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
}
@Metadata.allowExtensions: true
@Analytics: {
technicalName: 'IPContrBsc'
}
define view entity I_InsuranceContractBasic
as select from /pm0/abdapolpr as Contract
// Join to sibling data - if available
left outer to one join /mva/amdapolpr as MV_Contract on Contract.policy_id = MV_Contract.policy_id
and Contract.ppdpac_id = MV_Contract.ppdpac_id
and Contract.policyproduct_id = MV_Contract.policyproduct_id
and Contract.journalendno_id = MV_Contract.journalendno_id
and Contract.journalno_id = MV_Contract.journalno_id
{
key cast( Contract.policy_id as /pm0/vdm_policy_uuid preserving type ) as InsurPlcyUUID,
key Contract.policyproduct_id as InsurPlcyInsurContr,
key cast( Contract.journalno_id as /pm0/vdm_journal_number_id preserving type ) as InsurPlcyJrnlNmbr,
key Contract.journalendno_id as InsurPlcyJrnlEndNmbr,
@Consumption.hidden: true
Contract.ppdpac_id as InsurPlcyProductPackageID,
Contract.applnr_tt as InsuranceContract,
Contract.pm_id as InsurPlcyProductTemplate,
Contract.lob_cd as InsurPlcyLineOfBusiness,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Contract.polprodbeg_dt,
Contract.starttime_tm,
Contract.starttimezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_contr_start_datetime preserving type ) as InsurPlcyContractStartDateTime,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Contract.polprodend_dt,
Contract.endtime_tm,
Contract.endtimezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_contr_end_datetime preserving type ) as InsurPlcyContractEndDateTime,
Contract.companykey_cd as InsrrIDByInsrr,
Contract.actinactst_cd as InsurContrLifeCycSts,
Contract.targrpb_cd as InsurContrTrifVar,
cast( Contract.insobject_id as vtref_kk preserving type ) as InsurCollDisbmtInsurObj,
Contract.extvaria_cd as InsurContrRnwlType,
Contract.cancreas_cd as InsurContrCanclnRsn,
@Semantics.dateTime:true
cast( dats_tims_to_tstmp( Contract.ccldate_dt,
Contract.reversal_tm,
Contract.revtimezone_tt,
$session.client,
'NULL' ) as /pm0/vdm_contr_cancel_datetime preserving type ) as InsurPlcyContrCanclnDateTime,
Contract.refusalreason_cd as InsurApplRjcnRsn,
Contract.bostat_cd as InsurApplLifeCycSts,
//FS-PM Auto sibling specific fields
MV_Contract./mva/start_fg as InsurPlcyContrStartIsDayOfRegn,
MV_Contract./mva/ncmdptyp_cd as InsurPlcyDiscountProtection,
@Consumption.hidden: true
Contract.bo_cd as InsurPlcyBusinessObject,
@Semantics.systemDateTime.lastChangedAt: true
Contract.change_ts as LastChangeDateTime,
Contract.country_cd as InsurPlcyCountry
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/MVA/AMDAPOLPR",
"/PM0/ABDAPOLPR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/