Which CDS Views use P_INSURPOLICYJOURNALKEYS?

P_INSURPOLICYJOURNALKEYS is used by 75 CDS view(s), including: I_InsurApplClause, I_InsurApplContractBeneficiary, I_InsurApplContractBonusMalus, I_InsurApplContrBonusMalusCert, I_InsurApplContrBonusMalusOwnr, I_InsurApplContrClause, I_InsurApplContrCoverage, I_InsurApplContrCvrgBnfcy, I_InsurApplContrCvrgBnMlCert, I_InsurApplContrCvrgBnMlOwner.

How many fields does P_INSURPOLICYJOURNALKEYS have?

P_INSURPOLICYJOURNALKEYS has 1 fields.

P_INSURPOLICYJOURNALKEYS

CDS View

Journal Key in Insurance Policy

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

CDS Views using this table (75)

View	Type	Join	VDM	Description
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)

Key	Field	CDS Fields	Used 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

Depth:

P_INSURPOLICYJOURNALKEYS

CDS Views using this table (75)

Fields (1)

Learn More