R_INSURPLCYPLANNEDPROCESSING

CDS View

Insurance Policy Planned Processing

R_INSURPLCYPLANNEDPROCESSING is a CDS View in S/4HANA. Insurance Policy Planned Processing. 7 CDS views read from this table.

Used by 7 CDS view(s)

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_InsurContrPlannedProcessing view_entity from COMPOSITE Insurance Contract Planned Processing
I_InsurCvrgPlannedProcessing view_entity from COMPOSITE Insurance Coverage Planned Processing
I_InsurPlcyContrCvrgPlndProcg view_entity from COMPOSITE Cvrg Planned Procg of Contr in Policy
I_InsurPlcyContrCvrgSubCvrgDte view_entity from COMPOSITE SubCvrg Plnd Procg of Cvrg in Insur Plcy
I_InsurPlcyCvrgPckgPlndProcg view_entity from COMPOSITE Cvrg Pckg Plnd Processing in Insur Plcy
I_InsurPlcySubCvrgPlndProcg view_entity from COMPOSITE SubCoverage Plnd Procg of CvPcg in Plcy
I_InsurPolicyPlannedProcessing view_entity from COMPOSITE Insurance Policy Planned Processing 
@EndUserText.label: 'Insurance Policy Planned Processing'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE ]
}
@Metadata: {
  allowExtensions:false,
  ignorePropagatedAnnotations:true
}

define view entity R_InsurPlcyPlannedProcessing
  as

  select from P_InsurPlcyPlannedDate as PlannedDate
{
  key PlannedDate.InsurPlcyUUID,
  key PlannedDate.InsurPlcyInsurContr,
      PlannedDate.InsurPlcyCoveragePackageID,
      PlannedDate.InsurPlcyCoverageID,
      cast( 0 as /pm0/abd_covcpco_id )                            as InsurPlcySubCvrgID,
      PlannedDate.InsurPlcyProductPackageID,
      PlannedDate.InsurPlcyPlannedProcessingType,
      PlannedDate.InsurPolicyTimeModelFunction,
      PlannedDate.InsurPlcyPlndProcgEffctvDate,
      PlannedDate.InsurPlcyPlndProcgProcgRelDte,
      PlannedDate.InsurPlcyPlannedDateCategory,
      cast( '00001' as /pm0/abd_btsdtversion_id preserving type ) as InsurPlcyPlndProcgVersionValue
}
where
      PlannedDate.InsurPlcyJrnlEndNmbr    = 2147483647
  and PlannedDate.InsurPlcyBusinessObject = 'P'

union all

select from P_InsurPlcyBusTransaction as BusTransacDate
{
  key BusTransacDate.InsurPlcyUUID,
  key BusTransacDate.InsurPlcyInsurContr,
      BusTransacDate.InsurPlcyCoveragePackageID,
      BusTransacDate.InsurPlcyCoverageID,
      BusTransacDate.InsurPlcySubCvrgID,
      BusTransacDate.InsurPlcyProductPackageID,
      BusTransacDate.InsurPlcyPlannedProcessingType,
      BusTransacDate.InsurPolicyTimeModelFunction,
      BusTransacDate.InsurPlcyPlndProcgEffctvDate,
      BusTransacDate.InsurPlcyPlndProcgProcgRelDte,
      BusTransacDate.InsurPlcyPlannedDateCategory,
      max( BusTransacDate.InsurPlcyPlndProcgVersionValue ) as InsurPlcyPlndProcgVersionValue
}
where
  (
       InsurPlcyPlndProcessingStatus = '01' // SCHEDULED

    or InsurPlcyPlndProcessingStatus = '04' // REPLANNED

  )
  and  InsurPlcyPlndProcgStatusIsTmp = ''
group by
  BusTransacDate.InsurPlcyUUID,
  BusTransacDate.InsurPlcyInsurContr,
  BusTransacDate.InsurPlcyCoveragePackageID,
  BusTransacDate.InsurPlcyCoverageID,
  BusTransacDate.InsurPlcySubCvrgID,
  BusTransacDate.InsurPlcyProductPackageID,
  BusTransacDate.InsurPlcyPlannedProcessingType,
  BusTransacDate.InsurPolicyTimeModelFunction,
  BusTransacDate.InsurPlcyPlndProcgEffctvDate,
  BusTransacDate.InsurPlcyPlndProcgProcgRelDte,
  BusTransacDate.InsurPlcyPlannedDateCategory

union all

select from P_InsurPlcyCorrespondenceDate as CorrespncDate
{
  key CorrespncDate.InsurPlcyUUID,
  key CorrespncDate.InsurPlcyInsurContr,
      cast( 0 as /pm0/abd_covpac_id )                     as InsurPlcyCoveragePackageID,
      cast( 0 as /pm0/abd_coverage_id )                   as InsurPlcyCoverageID,
      cast( 0 as /pm0/abd_covcpco_id )                    as InsurPlcySubCvrgID,
      cast( 0 as /pm0/abd_ppdpac_id )                     as InsurPlcyProductPackageID,
      CorrespncDate.InsurPlcyPlannedProcessingType,
      CorrespncDate.InsurPolicyTimeModelFunction,
      CorrespncDate.InsurPlcyPlndProcgEffctvDate,
      CorrespncDate.InsurPlcyPlndProcgProcgRelDte,
      CorrespncDate.InsurPlcyPlannedDateCategory,
      max( CorrespncDate.InsurPlcyPlndProcgVersionValue ) as InsurPlcyPlndProcgVersionValue
}
where
  InsurPlcyApplUUID is initial
group by
  CorrespncDate.InsurPlcyUUID,
  CorrespncDate.InsurPlcyInsurContr,
  CorrespncDate.InsurPlcyPlannedProcessingType,
  CorrespncDate.InsurPolicyTimeModelFunction,
  CorrespncDate.InsurPlcyPlndProcgEffctvDate,
  CorrespncDate.InsurPlcyPlndProcgProcgRelDte,
  InsurPlcyPlannedDateCategory

union all 

select from I_InsurPlcyExternalDatesBasic as ExternalDates
{
  key ExternalDates.InsurPlcyUUID,
  key ExternalDates.InsurPlcyInsurContr,
      cast( 0 as /pm0/abd_covpac_id )                     as InsurPlcyCoveragePackageID,
      cast( 0 as /pm0/abd_coverage_id )                   as InsurPlcyCoverageID,
      cast( 0 as /pm0/abd_covcpco_id )                    as InsurPlcySubCvrgID,
      cast( 0 as /pm0/abd_ppdpac_id )                     as InsurPlcyProductPackageID,
      ExternalDates.InsurPlcyPlannedProcessingType,
      ExternalDates.InsurPolicyTimeModelFunction,
      ExternalDates.InsurPlcyPlndProcgEffctvDate,
      ExternalDates.InsurPlcyPlndProcgProcgRelDte,
      cast(4 as /pm0/abd_datetype_cd )                    as InsurPlcyPlannedDateCategory,
      max( ExternalDates.InsurPlcyPlndProcgVersionValue ) as InsurPlcyPlndProcgVersionValue
}
where
  InsurPlcyApplUUID is initial
group by
  ExternalDates.InsurPlcyUUID,
  ExternalDates.InsurPlcyInsurContr,
  ExternalDates.InsurPlcyPlannedProcessingType,
  ExternalDates.InsurPolicyTimeModelFunction,
  ExternalDates.InsurPlcyPlndProcgEffctvDate,
  ExternalDates.InsurPlcyPlndProcgProcgRelDte
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYEXTERNALDATESBASIC",
"P_INSURPLCYBUSTRANSACTION",
"P_INSURPLCYCORRESPONDENCEDATE",
"P_INSURPLCYPLANNEDDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More