R_InsurPlcyCoinsurSgmtTP

DDL: R_INSURPLCYCOINSURSGMTTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API_COMMON
28 Fields 1 Data Sources 2 Associations

Coinsurance Segment

R_InsurPlcyCoinsurSgmtTP is a Transactional CDS View that provides data about "Coinsurance Segment" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCoinsurSegmentBasic) and exposes 28 fields with key field InsurPlcyCoinsurSegmentUUID. It has 2 associations to related views. Part of development package VDM_PM_PLCY_API_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCoinsurSegmentBasic CoinsuranceShareSegment from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_InsurPlcyCoinsurCommsnTP _CoinsuranceCommission $projection.InsurPlcyCoinsurHdrUUID = _CoinsuranceCommission.InsurPlcyCoinsurHdrUUID and $projection.InsurPlcyCoinsurSegmentID = _CoinsuranceCommission.InsurPlcyCoinsurSegmentID
[1..1] E_InsurPolicyCoInsurSegment _Extension $projection.InsurPlcyCoinsurSegmentUUID = _Extension.InsurPlcyCoinsurSegmentUUID and $projection.InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber

Annotations (8)

NameValueLevelField
EndUserText.label Coinsurance Segment view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsurancePolicy view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyCoinsurSegmentUUID InsurPlcyCoinsurSegmentUUID ShareSgmnt GUID
InsurPlcyCoinsurJournalNumber InsurPlcyCoinsurJournalNumber Journal Number
InsurPlcyCoinsurHdrUUID InsurPlcyCoinsurHdrUUID Distr.Plan GUID
InsurPlcyCoinsurSegmentID InsurPlcyCoinsurSegmentID ShareSegment ID
InsurPlcyCoinsurSgmtCurrency InsurPlcyCoinsurSgmtCurrency Currency
InsurPlcyCoinsurSgmtPartcipn InsurPlcyCoinsurSgmtPartcipn Particip. Type
InsurPlcyCoinsurSgmtIsOwnShare InsurPlcyCoinsurSgmtIsOwnShare Own Share
InsurPlcyCoinsurSgmtBP InsurPlcyCoinsurSgmtBP BP
InsurPlcyCoinsurSgmtAddrNumber InsurPlcyCoinsurSgmtAddrNumber Address
InsPlcyCoinsurSgmtCrspncIsRqd InsPlcyCoinsurSgmtCrspncIsRqd Corr.Copy Req.
InsurPlcyCoinsurSgmtPremPct InsurPlcyCoinsurSgmtPremPct Premium Share %
InsurPlcyCoinsurSgmtShrClmPct InsurPlcyCoinsurSgmtShrClmPct Share As Percent
InsurPlcyCoinsurSgmtCoinsurID InsurPlcyCoinsurSgmtCoinsurID Coinsurance Key
InsurPlcyCoinsurSgmtPremTxType InsurPlcyCoinsurSgmtPremTxType PremTax Stt.Type
InsurPlcyCoinsurSgmtPremType InsurPlcyCoinsurSgmtPremType PremStt. Type
InsurPlcyCoinsurSgmtClaimType InsurPlcyCoinsurSgmtClaimType ClaimSettlType
InsurPlcyCoinsurSgmtTemplate InsurPlcyCoinsurSgmtTemplate DistPl.Templ.No
InsurPlcyCoinsurSgmtTmplText InsurPlcyCoinsurSgmtTmplText DistrPlanTempl.
InsurPlcyCoinsurSgmtIsFronting InsurPlcyCoinsurSgmtIsFronting Fronting
InsPlcyCoinsurSgmtPartcipnBus InsPlcyCoinsurSgmtPartcipnBus Particip.Bus.
InsurPlcyCoinsurSgmtJrnlEndID InsurPlcyCoinsurSgmtJrnlEndID Journal End No.
InsurPlcyCoinsurSgmtIsCancld InsurPlcyCoinsurSgmtIsCancld Reversal
InsurPlcyCoinsurSgmtLastChgdBy InsurPlcyCoinsurSgmtLastChgdBy Last Changed By
LastChangeDateTime LastChangeDateTime Timestamp
InsurPlcyCoinsurSgmtCreatedBy InsurPlcyCoinsurSgmtCreatedBy Creator Name
InsPlcyCoinsurSgmtCrtedDteTme InsPlcyCoinsurSgmtCrtedDteTme UTC Time Stamp Entry
_CoinsuranceCommission _CoinsuranceCommission
_Currency _Currency

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 R_InsurPlcyCoinsurSgmtTP.
-- 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 R_InsurPlcyCoinsurSgmtTP AS
SELECT
  InsurPlcyCoinsurSegmentUUID,
  InsurPlcyCoinsurJournalNumber,
  InsurPlcyCoinsurHdrUUID,
  InsurPlcyCoinsurSegmentID,
  InsurPlcyCoinsurSgmtCurrency,
  InsurPlcyCoinsurSgmtPartcipn,
  InsurPlcyCoinsurSgmtIsOwnShare,
  InsurPlcyCoinsurSgmtBP,
  InsurPlcyCoinsurSgmtAddrNumber,
  InsPlcyCoinsurSgmtCrspncIsRqd,
  InsurPlcyCoinsurSgmtPremPct,
  InsurPlcyCoinsurSgmtShrClmPct,
  InsurPlcyCoinsurSgmtCoinsurID,
  InsurPlcyCoinsurSgmtPremTxType,
  InsurPlcyCoinsurSgmtPremType,
  InsurPlcyCoinsurSgmtClaimType,
  InsurPlcyCoinsurSgmtTemplate,
  InsurPlcyCoinsurSgmtTmplText,
  InsurPlcyCoinsurSgmtIsFronting,
  InsPlcyCoinsurSgmtPartcipnBus,
  InsurPlcyCoinsurSgmtJrnlEndID,
  InsurPlcyCoinsurSgmtIsCancld,
  InsurPlcyCoinsurSgmtLastChgdBy,
  LastChangeDateTime,
  InsurPlcyCoinsurSgmtCreatedBy,
  InsPlcyCoinsurSgmtCrtedDteTme
FROM I_InsurPlcyCoinsurSegmentBasic AS CoinsuranceShareSegment
LEFT OUTER JOIN R_InsurPlcyCoinsurCommsnTP AS _CoinsuranceCommission ON InsurPlcyCoinsurHdrUUID = _CoinsuranceCommission.InsurPlcyCoinsurHdrUUID AND InsurPlcyCoinsurSegmentID = _CoinsuranceCommission.InsurPlcyCoinsurSegmentID  -- association [0..*]
LEFT OUTER JOIN E_InsurPolicyCoInsurSegment AS _Extension ON InsurPlcyCoinsurSegmentUUID = _Extension.InsurPlcyCoinsurSegmentUUID AND InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber  -- association [1..1]
;

Learn More