P_InsurancePolicyCoinsurance

DDL: P_INSURANCEPOLICYCOINSURANCE Type: view_entity COMPOSITE
46 Fields 2 Data Sources 2 Associations

Coinsurance in Insurance Policy

P_InsurancePolicyCoinsurance is a Composite CDS View that provides data about "Coinsurance in Insurance Policy" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyCoinsurSegmentBasic, I_InsurPlcyDistrPlnRelshpBasic) and exposes 46 fields with key field InsurPlcyUUIDendasInsurPlcyUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyCoinsurSegmentBasic _CoinsuranceShareSegment inner
I_InsurPlcyDistrPlnRelshpBasic DistrbutionPlanRelation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsurPlcyCoinsurSegmentBasic _OwnShare _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID = _OwnShare.InsurPlcyCoinsurHdrUUID and _OwnShare.InsurPlcyCoinsurSgmtIsOwnShare = 'X' and _OwnShare.InsurPlcyCoinsurJournalNumber <= DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr and DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr < _OwnShare.InsurPlcyCoinsurSgmtJrnlEndID
[1..1] I_InsurPlcyCoinsurSegmentBasic _Lead _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID = _Lead.InsurPlcyCoinsurHdrUUID and _Lead.InsurPlcyCoinsurSgmtPartcipn = '00001' and _Lead.InsurPlcyCoinsurJournalNumber <= DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr and DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr < _Lead.InsurPlcyCoinsurSgmtJrnlEndID

Annotations (8)

NameValueLevelField
EndUserText.label Coinsurance in Insurance Policy view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUIDendasInsurPlcyUUID
InsurPlcyInsurContr I_InsurPlcyDistrPlnRelshpBasic InsurPlcyInsurContr Contract Key
InsurPlcyCoveragePackageID I_InsurPlcyDistrPlnRelshpBasic InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageID I_InsurPlcyDistrPlnRelshpBasic InsurPlcyCoverageID Coverage Key
InsurPlcyDistrPlnRelshpID I_InsurPlcyDistrPlnRelshpBasic InsurPlcyDistrPlnRelshpID DPR Key
InsurPlcyJrnlEndNmbr I_InsurPlcyDistrPlnRelshpBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyDistrPlnRelshpBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyDistrPlnRelshpBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyDistrPlanIsCancelled I_InsurPlcyDistrPlnRelshpBasic InsurPlcyDistrPlanIsCancelled Rev. Flag
InsurPlcyDistributionPlanNmbr I_InsurPlcyDistrPlnRelshpBasic InsurPlcyDistributionPlanNmbr DP Number
InsurPlcyDistrPlanCoinsurType I_InsurPlcyDistrPlnRelshpBasic InsurPlcyDistrPlanCoinsurType Coins. Type
InsurPlcyDistrPlanJournalNmbr I_InsurPlcyDistrPlnRelshpBasic InsurPlcyDistrPlanJournalNmbr Journal Number
InsurPlcyBusinessObject I_InsurPlcyDistrPlnRelshpBasic InsurPlcyBusinessObject Process.Status
InsurPlcyCoinsurHdrUUID _CoinsuranceHeader InsurPlcyCoinsurHdrUUID Distr.Plan GUID
InsurPlcyCoinsurJournalNumber _CoinsuranceHeader InsurPlcyCoinsurJournalNumber Journal Number
InsurPlcyCoinsurHdrDistrPlnID _CoinsuranceHeader InsurPlcyCoinsurHdrDistrPlnID Distr.Plan No.
InsurPlcyCoinsurHdrCoinsurType _CoinsuranceHeader InsurPlcyCoinsurHdrCoinsurType Coins. Type
InsurPlcyCoinsurHdrLeaderID _CoinsuranceHeader InsurPlcyCoinsurHdrLeaderID Leading
InsurPlcyCoinsurHdrAddrNumber _CoinsuranceHeader InsurPlcyCoinsurHdrAddrNumber Address
InsurPlcyCoinsurHdrValdStrtDte _CoinsuranceHeader InsurPlcyCoinsurHdrValdStrtDte Start Date
InsurPlcyCoinsurHdrValdEndDte _CoinsuranceHeader InsurPlcyCoinsurHdrValdEndDte End Date
InsurPlcyCoinsurHdrReferenceID _CoinsuranceHeader InsurPlcyCoinsurHdrReferenceID Reference No.
InsurPlcyCoinsurHdrEffctvDte _CoinsuranceHeader InsurPlcyCoinsurHdrEffctvDte Effective Date
InsurPlcyCoinsurHdrTmplNmbr _CoinsuranceHeader InsurPlcyCoinsurHdrTmplNmbr DistPl.Templ.No
InsurPlcyCoinsurHdrTmplText _CoinsuranceHeader InsurPlcyCoinsurHdrTmplText DistrPlanTempl.
InsurPlcyCoinsurHdrJrnlEndNmbr _CoinsuranceHeader InsurPlcyCoinsurHdrJrnlEndNmbr Journal End No.
InsurPlcyCoinsurHdrIsCancld _CoinsuranceHeader InsurPlcyCoinsurHdrIsCancld Reversal
InsurPlcyCoinsurSegmentID I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSegmentID ShareSegment ID
InsurPlcyCoinsurSegmentUUID I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSegmentUUID ShareSgmnt GUID
InsurPlcyCoinsurSgmtCurrency I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtCurrency Currency
InsurPlcyCoinsurSgmtPartcipn I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtPartcipn Particip. Type
InsurPlcyCoinsurSgmtIsOwnShare I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtIsOwnShare Own Share
InsurPlcyCoinsurSgmtBP I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtBP BP
InsurPlcyCoinsurSgmtAddrNumber I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtAddrNumber Address
InsPlcyCoinsurSgmtCrspncIsRqd I_InsurPlcyCoinsurSegmentBasic InsPlcyCoinsurSgmtCrspncIsRqd Corr.Copy Req.
InsurPlcyCoinsurSgmtPremPct I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtPremPct Premium Share %
InsurPlcyCoinsurSgmtShrClmPct I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtShrClmPct Share As Percent
InsurPlcyCoinsurSgmtCoinsurID I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtCoinsurID Coinsurance Key
InsurPlcyCoinsurSgmtClaimType I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtClaimType ClaimSettlType
InsurPlcyCoinsurSgmtJrnlEndID I_InsurPlcyCoinsurSegmentBasic InsurPlcyCoinsurSgmtJrnlEndID Journal End No.
InsurPlcyCoinsurCommsnUUID _CoinsuranceCommission InsurPlcyCoinsurCommsnUUID LeadInsComGUID
InsurPlcyCoinsurCommsnID _CoinsuranceCommission InsurPlcyCoinsurCommsnID LeadInsComm.ID
InsurPlcyCoinsurCommsnType _CoinsuranceCommission InsurPlcyCoinsurCommsnType LeadInsCommType
InsPlcyCoinsurCommsnJrnlEndID _CoinsuranceCommission InsPlcyCoinsurCommsnJrnlEndID Journal End No.
_OwnShare _OwnShare
_Lead _Lead

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_InsurancePolicyCoinsurance.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_InsurancePolicyCoinsurance AS
SELECT
  case DistrbutionPlanRelation.InsurPlcyBusinessObject when 'A' then _JrnlHeader.InsurPlcyUUID else DistrbutionPlanRelation.InsurPlcyUUID end as InsurPlcyUUID AS InsurPlcyUUIDendasInsurPlcyUUID,
  DistrbutionPlanRelation.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  DistrbutionPlanRelation.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  DistrbutionPlanRelation.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  DistrbutionPlanRelation.InsurPlcyDistrPlnRelshpID AS InsurPlcyDistrPlnRelshpID,
  DistrbutionPlanRelation.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  DistrbutionPlanRelation.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  DistrbutionPlanRelation.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  DistrbutionPlanRelation.InsurPlcyDistrPlanIsCancelled AS InsurPlcyDistrPlanIsCancelled,
  DistrbutionPlanRelation.InsurPlcyDistributionPlanNmbr AS InsurPlcyDistributionPlanNmbr,
  DistrbutionPlanRelation.InsurPlcyDistrPlanCoinsurType AS InsurPlcyDistrPlanCoinsurType,
  DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr AS InsurPlcyDistrPlanJournalNmbr,
  DistrbutionPlanRelation.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID AS InsurPlcyCoinsurHdrUUID,
  _CoinsuranceHeader.InsurPlcyCoinsurJournalNumber AS InsurPlcyCoinsurJournalNumber,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrDistrPlnID AS InsurPlcyCoinsurHdrDistrPlnID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrCoinsurType AS InsurPlcyCoinsurHdrCoinsurType,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrLeaderID AS InsurPlcyCoinsurHdrLeaderID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrAddrNumber AS InsurPlcyCoinsurHdrAddrNumber,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrValdStrtDte AS InsurPlcyCoinsurHdrValdStrtDte,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrValdEndDte AS InsurPlcyCoinsurHdrValdEndDte,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrReferenceID AS InsurPlcyCoinsurHdrReferenceID,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrEffctvDte AS InsurPlcyCoinsurHdrEffctvDte,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrTmplNmbr AS InsurPlcyCoinsurHdrTmplNmbr,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrTmplText AS InsurPlcyCoinsurHdrTmplText,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrJrnlEndNmbr AS InsurPlcyCoinsurHdrJrnlEndNmbr,
  _CoinsuranceHeader.InsurPlcyCoinsurHdrIsCancld AS InsurPlcyCoinsurHdrIsCancld,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSegmentID AS InsurPlcyCoinsurSegmentID,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSegmentUUID AS InsurPlcyCoinsurSegmentUUID,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtCurrency AS InsurPlcyCoinsurSgmtCurrency,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtPartcipn AS InsurPlcyCoinsurSgmtPartcipn,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtIsOwnShare AS InsurPlcyCoinsurSgmtIsOwnShare,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtBP AS InsurPlcyCoinsurSgmtBP,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtAddrNumber AS InsurPlcyCoinsurSgmtAddrNumber,
  _CoinsuranceShareSegment.InsPlcyCoinsurSgmtCrspncIsRqd AS InsPlcyCoinsurSgmtCrspncIsRqd,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtPremPct AS InsurPlcyCoinsurSgmtPremPct,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtShrClmPct AS InsurPlcyCoinsurSgmtShrClmPct,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtCoinsurID AS InsurPlcyCoinsurSgmtCoinsurID,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtClaimType AS InsurPlcyCoinsurSgmtClaimType,
  _CoinsuranceShareSegment.InsurPlcyCoinsurSgmtJrnlEndID AS InsurPlcyCoinsurSgmtJrnlEndID,
  _CoinsuranceCommission.InsurPlcyCoinsurCommsnUUID AS InsurPlcyCoinsurCommsnUUID,
  _CoinsuranceCommission.InsurPlcyCoinsurCommsnID AS InsurPlcyCoinsurCommsnID,
  _CoinsuranceCommission.InsurPlcyCoinsurCommsnType AS InsurPlcyCoinsurCommsnType,
  _CoinsuranceCommission.InsPlcyCoinsurCommsnJrnlEndID AS InsPlcyCoinsurCommsnJrnlEndID
FROM I_InsurPlcyDistrPlnRelshpBasic AS DistrbutionPlanRelation
INNER JOIN I_InsurPlcyCoinsurSegmentBasic AS _CoinsuranceShareSegment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurPlcyCoinsurSegmentBasic AS _OwnShare ON _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID = _OwnShare.InsurPlcyCoinsurHdrUUID AND _OwnShare.InsurPlcyCoinsurSgmtIsOwnShare = 'X' AND _OwnShare.InsurPlcyCoinsurJournalNumber <= DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr AND DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr < _OwnShare.InsurPlcyCoinsurSgmtJrnlEndID  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyCoinsurSegmentBasic AS _Lead ON _CoinsuranceHeader.InsurPlcyCoinsurHdrUUID = _Lead.InsurPlcyCoinsurHdrUUID AND _Lead.InsurPlcyCoinsurSgmtPartcipn = '00001' AND _Lead.InsurPlcyCoinsurJournalNumber <= DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr AND DistrbutionPlanRelation.InsurPlcyDistrPlanJournalNmbr < _Lead.InsurPlcyCoinsurSgmtJrnlEndID  -- association [1..1]
;

Learn More