P_INSURPOLICYJOURNALKEYS

CDS View

P_INSURPOLICYJOURNALKEYS is a CDS View in S/4HANA. It contains 1 fields. 75 CDS views read from this table.

Used by 75 CDS view(s) 1 fields

CDS Views using this table (75)

ViewTypeJoinVDMDescription
I_InsurApplClause view_entity from COMPOSITE InsOb Clause of Cvrg Pckg in Insur Appl
I_InsurApplContractBeneficiary view_entity from COMPOSITE Contract Beneficiary in Insur Appl
I_InsurApplContractBonusMalus view_entity from COMPOSITE Contr Bn Ml in Insur Appl
I_InsurApplContrBonusMalusCert view_entity from COMPOSITE Contr Bn Ml Cert in Insur Appl
I_InsurApplContrBonusMalusOwnr view_entity from COMPOSITE Contr Bn Ml Ownr in Insur Appl
I_InsurApplContrClause view_entity from COMPOSITE Contract Clause in Insurance Appl
I_InsurApplContrCoverage view_entity from COMPOSITE Contract Coverage in Insurance Appl
I_InsurApplContrCvrgBnfcy view_entity from COMPOSITE Coverage Bnfcy of Contr in Insur Appl
I_InsurApplContrCvrgBnMlCert view_entity from COMPOSITE Cvrg Bn Ml Cert of Contr in Insur Appl
I_InsurApplContrCvrgBnMlOwner view_entity from COMPOSITE Cvrg Bn Ml Ownr of Contr in Insur Appl
I_InsurApplContrCvrgBonusMalus view_entity from COMPOSITE Crvg Bn Ml of Contr in Insur Appl
I_InsurApplContrCvrgClause view_entity from COMPOSITE Cvrg Clause of Contract in Insur Appl
I_InsurApplContrCvrgDeductible view_entity from COMPOSITE Cvrg Deductible of Contr in Insur Appl
I_InsurApplContrCvrgInsrdBldng view_entity from COMPOSITE Cvrg InsOb Bldng of Contr in Insur Appl
I_InsurApplContrCvrgInsrdObj view_entity from COMPOSITE Cvrg Insrd Object of Contr in Insur Appl
I_InsurApplContrCvrgInsrdVeh view_entity from COMPOSITE Cvrg InsOb Veh of Contr in Insur Appl
I_InsurApplContrCvrgLimit view_entity from COMPOSITE Coverage Limit of Contract in Insur Appl
I_InsurApplContrCvrgNmdDrvr view_entity from COMPOSITE Cvrg InsOb NmdDrvr of Contr in Appl
I_InsurApplContrCvrgObjClause view_entity from COMPOSITE Cvrg InsOb Clause of Contr in Insur Appl
I_InsurApplContrCvrgObjDcbl view_entity from COMPOSITE Cvrg InsOb Dcbl of Contr in Insur Appl
I_InsurApplContrCvrgObjSurchrg view_entity from COMPOSITE Cvrg InsOb SurDsc of Contr in Insur Appl
I_InsurApplContrCvrgPremComprn view_entity from COMPOSITE Cvrg Prem Comprn of Contr in Insur Appl
I_InsurApplContrCvrgSpclEquip view_entity from COMPOSITE Cvrg InsOb Spcl Equip of Contr in Appl
I_InsurApplContrCvrgSubCvrg view_entity from COMPOSITE Cvrg SubCoverage of Contr in Insur Appl
I_InsurApplContrCvrgSurcharge view_entity from COMPOSITE Cvrg Surchrg Disc of Contr in Insur Appl
I_InsurApplContrCvrgTypeRgnlCl view_entity from COMPOSITE Cvrg Type Rgnl Cl of Contr in Insur Appl
I_InsurApplContrDeductible view_entity from COMPOSITE Contract Deductible in Insurance Appl
I_InsurApplContrInsrdObjBldng view_entity from COMPOSITE InsOb Building of Contract in Insur Appl
I_InsurApplContrInsrdObjClause view_entity from COMPOSITE InsOb Clause of Contract in Insur Appl
I_InsurApplContrInsrdObjDcbl view_entity from COMPOSITE InsOb Deductible of Contr in Insur Appl
I_InsurApplContrInsuredObject view_entity from COMPOSITE Contract Insrd Obj in Insurance Appl
I_InsurApplContrInsuredVehicle view_entity from COMPOSITE InsOb Vehicle of Contract in Insur Appl
I_InsurApplContrLimit view_entity from COMPOSITE Contract Limit in Insurance Application
I_InsurApplContrNamedDriver view_entity from COMPOSITE InsOb Named Drvr of Contr in Insur Appl
I_InsurApplContrObjSurchrgDisc view_entity from COMPOSITE InsOb SurDsc of Contr in Insur Appl
I_InsurApplContrSpclEquip view_entity from COMPOSITE InsOb SpeEqi of Contr in Insur Appl
I_InsurApplContrSubCvrgClause view_entity from COMPOSITE SubCoverage Clause of Contr in Appl
I_InsurApplContrSubCvrgDcbl view_entity from COMPOSITE SubCoverage Dcbl of Contr in Insur Appl
I_InsurApplContrSubCvrgLimit view_entity from COMPOSITE SubCoverage Limit of Contr in Insur Appl
I_InsurApplContrSurchrgDisc view_entity from COMPOSITE Contr Surchrg Discount in Insur Appl
I_InsurApplCoverage view_entity from COMPOSITE Coverage of Cvrg Package in Insur Appl
I_InsurApplCoverageBonusMalus view_entity from COMPOSITE Cvrg Bn Ml of Cvrg Pckg in Insur Appl
I_InsurApplCoverageLimit view_entity from COMPOSITE Cvrg Limit of Cvrg Pckg in Insur Appl
I_InsurApplCoveragePackage view_entity from COMPOSITE Coverage Package in Insurance Appl
I_InsurApplCvrgBonusMalusCert view_entity from COMPOSITE Cvrg BnMl ClmSr of CvrgPckg in Ins Appl
I_InsurApplCvrgBonusMalusOwner view_entity from COMPOSITE Cvrg Bn Ml Owner of Cvrg Pckg in InsAppl
I_InsurApplCvrgClause view_entity from COMPOSITE Cvrg Clause of Cvrg Pckg in Insur Appl
I_InsurApplCvrgDeductible view_entity from COMPOSITE Cvrg Dcbl of Cvrg Pckg in Insur Appl
I_InsurApplCvrgInsrdObjClause view_entity from COMPOSITE InsOb Clause of Cvrg of CvPcg in Appl
I_InsurApplCvrgInsrdObjDcbl view_entity from COMPOSITE InsOb Dcbl of Cvrg under CvPcg in Appl
I_InsurApplCvrgInsuredVehicle view_entity from COMPOSITE InsOb Veh of Cvrg of CvPcg in Insur Appl
I_InsurApplCvrgNamedDriver view_entity from COMPOSITE InsOb Nmd Drvr of Cvrg of CvPcg in Appl
I_InsurApplCvrgObjSurchrgDisc view_entity from COMPOSITE InsOb SurDsc of Cvrg under CvPcg in Appl
I_InsurApplCvrgPckgClause view_entity from COMPOSITE Cvrg Pckg Clause in Insur Appl
I_InsurApplCvrgPckgCvrgBldng view_entity from COMPOSITE InsOb Bldng of Cvrg of CvPcg in Appl
I_InsurApplCvrgPckgInsrdBldng view_entity from COMPOSITE InsOb Bldng of Cvrg Pckg in Insur Appl
I_InsurApplCvrgPckgInsrdObject view_entity from COMPOSITE Cvrg Pckg Insurd Object in Insur Appl
I_InsurApplCvrgPckgInsrdVeh view_entity from COMPOSITE InsOb Insrd Veh of CvPcg in Insur Appl
I_InsurApplCvrgPckgNmdDrvr view_entity from COMPOSITE InsOb NmdDrvr of Cvrg Pckg in Insur Appl
I_InsurApplCvrgPckgSpclEquip view_entity from COMPOSITE InsOb Spcl Equip of CvPcg in Insur Appl
I_InsurApplCvrgPckgSurchrgDisc view_entity from COMPOSITE CvPcg SurDsc of Contr in Insur Appl
I_InsurApplCvrgPremComparison view_entity from COMPOSITE Cv Prem Comprn of Cv Pckg in Insur Appl
I_InsurApplCvrgSpclEquipment view_entity from COMPOSITE InsOb SpeEqi of Cvrg of CvPcg in Plcy
I_InsurApplCvrgSurchrgDiscount view_entity from COMPOSITE Cvrg Surchrg Disc of CvPcg in Insur Appl
I_InsurApplCvrgTypeRegionalCl view_entity from COMPOSITE Cv TypeRgnlCl of CvrgPckg in Insur Appl
I_InsurApplDeductible view_entity from COMPOSITE InsOb Dcbl of Cvrg Pckg in Insur Appl
I_InsurApplInsuredObject view_entity from COMPOSITE Cvrg InsOb of Cvrg Pckg in Insur Appl
I_InsurApplLimit view_entity from COMPOSITE SubCoverage Limit of CvPcg in Appl
I_InsurApplPolicyHolder view_entity from COMPOSITE Policy Holder in Insurance Application
I_InsurApplPremPayer view_entity from COMPOSITE Premium Payer in Insurance Application
I_InsurApplSubCoverage view_entity from COMPOSITE Cvrg SubCoverage of CvPcg in Insur Appl
I_InsurApplSubCvrgClause view_entity from COMPOSITE SubCoverage Clause of CvPcg in Appl
I_InsurApplSubCvrgDeductible view_entity from COMPOSITE SubCoverage Dcbl of CvPcg in Insur Appl
I_InsurApplSurchargeDiscount view_entity from COMPOSITE InsOb SurDsc of CvPcg in Insur Appl
R_InsurApplicationPremium view_entity from COMPOSITE Premium in Insurance Application

Fields (1)

KeyField CDS FieldsUsed in Views
InsurPlcyApplUUID InsurPlcyApplUUID 1 
@VDM:           {   viewType:           #COMPOSITE,
                    private:            true}
@Metadata.ignorePropagatedAnnotations: true

define view entity P_InsurPolicyJournalKeys
  as select from            I_InsurPlcyJournalHeaderBasic as JournalHeader
    left outer to many join I_InsurPlcyJournalEntryBasic  as JournalEntry on  JournalHeader.InsurPlcyApplUUID   = JournalEntry.InsurPlcyApplUUID
                                                                          and JournalHeader.InsurPlcyInsurContr = JournalEntry.InsurPlcyInsurContr
{

  key JournalHeader.InsurPlcyApplUUID,
  key JournalHeader.InsurPlcyUUID,
  key JournalHeader.InsurPlcyInsurContr,
      max( JournalEntry.InsurPlcyJrnlNmbr ) as InsurPlcyContrDataDetnJrnlNmbr

}
group by
  JournalHeader.InsurPlcyApplUUID,
  JournalHeader.InsurPlcyUUID,
  JournalHeader.InsurPlcyInsurContr
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYJOURNALENTRYBASIC",
"I_INSURPLCYJOURNALHEADERBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More