R_InsurPlcyCoinsurCommsnTP

DDL: R_INSURPLCYCOINSURCOMMSNTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API_COMMON
15 Fields 1 Data Sources 1 Associations

Coinsurance Commission

R_InsurPlcyCoinsurCommsnTP is a Transactional CDS View that provides data about "Coinsurance Commission" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCoinsurCommsnBasic) and exposes 15 fields with key field InsurPlcyCoinsurCommsnUUID. It has 1 association to related views. Part of development package VDM_PM_PLCY_API_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCoinsurCommsnBasic CoinsuranceCommission from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyCoinsurCommsn _Extension $projection.InsurPlcyCoinsurCommsnUUID = _Extension.InsurPlcyCoinsurCommsnUUID and $projection.InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber

Annotations (8)

NameValueLevelField
EndUserText.label Coinsurance Commission 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 (15)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyCoinsurCommsnUUID InsurPlcyCoinsurCommsnUUID LeadInsComGUID
InsurPlcyCoinsurJournalNumber InsurPlcyCoinsurJournalNumber Journal Number
InsurPlcyCoinsurHdrUUID InsurPlcyCoinsurHdrUUID Distr.Plan GUID
InsurPlcyCoinsurSegmentID InsurPlcyCoinsurSegmentID ShareSegment ID
InsurPlcyCoinsurCommsnID InsurPlcyCoinsurCommsnID LeadInsComm.ID
InsurPlcyCoinsurCommsnType InsurPlcyCoinsurCommsnType LeadInsCommType
InsurPlcyCoinsurCommsnPercent InsurPlcyCoinsurCommsnPercent Comm. Percent
InsurPlcyCoinsurCommsnTmplNmbr InsurPlcyCoinsurCommsnTmplNmbr DistPl.Templ.No
InsurPlcyCoinsurCommsnTmplText InsurPlcyCoinsurCommsnTmplText DistrPlanTempl.
InsPlcyCoinsurCommsnJrnlEndID InsPlcyCoinsurCommsnJrnlEndID Journal End No.
InsurPlcyCoinsurCommsnIsCancld InsurPlcyCoinsurCommsnIsCancld Reversal
InsurPlcyCoinsurCommsnChgUsr InsurPlcyCoinsurCommsnChgUsr Last Changed By
LastChangeDateTime LastChangeDateTime Timestamp
InsurPlcyCoinsurCommsnCrtedUsr InsurPlcyCoinsurCommsnCrtedUsr Creator Name
InsPlcyCoinsurCommsnCrtnDteTme InsPlcyCoinsurCommsnCrtnDteTme UTC Time Stamp Entry

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_InsurPlcyCoinsurCommsnTP.
-- 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_InsurPlcyCoinsurCommsnTP AS
SELECT
  InsurPlcyCoinsurCommsnUUID,
  InsurPlcyCoinsurJournalNumber,
  InsurPlcyCoinsurHdrUUID,
  InsurPlcyCoinsurSegmentID,
  InsurPlcyCoinsurCommsnID,
  InsurPlcyCoinsurCommsnType,
  InsurPlcyCoinsurCommsnPercent,
  InsurPlcyCoinsurCommsnTmplNmbr,
  InsurPlcyCoinsurCommsnTmplText,
  InsPlcyCoinsurCommsnJrnlEndID,
  InsurPlcyCoinsurCommsnIsCancld,
  InsurPlcyCoinsurCommsnChgUsr,
  LastChangeDateTime,
  InsurPlcyCoinsurCommsnCrtedUsr,
  InsPlcyCoinsurCommsnCrtnDteTme
FROM I_InsurPlcyCoinsurCommsnBasic AS CoinsuranceCommission
LEFT OUTER JOIN E_InsurancePolicyCoinsurCommsn AS _Extension ON InsurPlcyCoinsurCommsnUUID = _Extension.InsurPlcyCoinsurCommsnUUID AND InsurPlcyCoinsurJournalNumber = _Extension.InsurPlcyCoinsurJournalNumber  -- association [1..1]
;

Learn More