R_InsurPlcyDistrPlnRelshpTP_3

DDL: R_INSURPLCYDISTRPLNRELSHPTP_3 Type: view_entity TRANSACTIONAL
29 Fields 2 Data Sources 3 Associations

Distribution Plan Relationship - TP

R_InsurPlcyDistrPlnRelshpTP_3 is a Transactional CDS View that provides data about "Distribution Plan Relationship - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyDistrPlnRelshpVers, I_InsurPlcyHghstVersPerAppl) and exposes 29 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyDistrPlnRelshpVers DistrPlnRelshp from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[0..*] R_InsurPlcyCoinsurHeaderTP_3 _CoinsuranceHeader $projection.InsurPlcyDistributionPlanNmbr = _CoinsuranceHeader.InsurPlcyCoinsurHdrDistrPlnID and $projection.InsurPlcyDistrPlanJournalNmbr = _CoinsuranceHeader.InsurPlcyCoinsurVersionID
[1..1] E_InsurPlcyDistrPlnRelshp _Extension ( $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID or $projection.InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyDistrPlnRelshpID = _Extension.InsurPlcyDistrPlnRelshpID

Annotations (12)

NameValueLevelField
EndUserText.label Distribution Plan Relationship - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name InsurPlcyDistributionPlnRelshp view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix DPR view
AbapCatalog.extensibility.allowNewDatasources false view
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyDistrPlnRelshpVers InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyDistrPlnRelshpVers InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyDistrPlnRelshpVers InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyDistrPlnRelshpVers InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyDistrPlnRelshpVers InsurPlcyCoverageID Coverage Key
KEY InsurPlcyDistrPlnRelshpID I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlnRelshpID DPR Key
InsurPlcyUUIDForEdit I_InsurPlcyDistrPlnRelshpVers InsurPlcyUUID Policy UUID
InsurPlcyApplUUIDForEdit I_InsurPlcyDistrPlnRelshpVers InsurPlcyApplUUID Policy UUID
InsurPlcyInsurContrForEdit I_InsurPlcyDistrPlnRelshpVers InsurPlcyInsurContr Contract Key
InsurPlcyCvPcgIDForEdit I_InsurPlcyDistrPlnRelshpVers InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageIDForEdit I_InsurPlcyDistrPlnRelshpVers InsurPlcyCoverageID Coverage Key
InPlDistrPlnRelshpIDForEdit I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlnRelshpID DPR Key
InsurPlcyOrderNumber I_InsurPlcyDistrPlnRelshpVers InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyDistrPlnRelshpVers InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyDistrPlnRelshpVers InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyDistrPlnRelshpVers InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyDistrPlnRelshpVers InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyDistrPlnRelshpVers InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyDistrPlanIsCancelled I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlanIsCancelled Rev. Flag
InsurPlcyDistributionPlanNmbr I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistributionPlanNmbr DP Number
InsurPlcyDistrRelshpTemplate I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrRelshpTemplate DistPl.Templ.No
InsurPlcyDistrPlanTemplate I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlanTemplate Template ID
InsurPlcyDistrPlanCoinsurType I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlanCoinsurType Coins. Type
InsurPlcyDistrPlanJournalNmbr I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlanJournalNmbr Journal Number
InsurPlcyDistrPlanContainerID I_InsurPlcyDistrPlnRelshpVers InsurPlcyDistrPlanContainerID Container ID
InsurPlcyBusinessObject I_InsurPlcyDistrPlnRelshpVers InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyDistrPlnRelshpVers LastChangeDateTime Timestamp
_CoinsuranceHeader _CoinsuranceHeader
_Policy _Policy

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_InsurPlcyDistrPlnRelshpTP_3.
-- 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_InsurPlcyDistrPlnRelshpTP_3 AS
SELECT
  DistrPlnRelshp.InsurPlcyUUID AS InsurPlcyUUID,
  DistrPlnRelshp.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  DistrPlnRelshp.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  DistrPlnRelshp.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  DistrPlnRelshp.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  DistrPlnRelshp.InsurPlcyDistrPlnRelshpID AS InsurPlcyDistrPlnRelshpID,
  DistrPlnRelshp.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  DistrPlnRelshp.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  DistrPlnRelshp.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  DistrPlnRelshp.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  DistrPlnRelshp.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  DistrPlnRelshp.InsurPlcyDistrPlnRelshpID AS InPlDistrPlnRelshpIDForEdit,
  DistrPlnRelshp.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  DistrPlnRelshp.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  DistrPlnRelshp.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  DistrPlnRelshp.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  DistrPlnRelshp.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  DistrPlnRelshp.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  DistrPlnRelshp.InsurPlcyDistrPlanIsCancelled AS InsurPlcyDistrPlanIsCancelled,
  DistrPlnRelshp.InsurPlcyDistributionPlanNmbr AS InsurPlcyDistributionPlanNmbr,
  DistrPlnRelshp.InsurPlcyDistrRelshpTemplate AS InsurPlcyDistrRelshpTemplate,
  DistrPlnRelshp.InsurPlcyDistrPlanTemplate AS InsurPlcyDistrPlanTemplate,
  DistrPlnRelshp.InsurPlcyDistrPlanCoinsurType AS InsurPlcyDistrPlanCoinsurType,
  DistrPlnRelshp.InsurPlcyDistrPlanJournalNmbr AS InsurPlcyDistrPlanJournalNmbr,
  DistrPlnRelshp.InsurPlcyDistrPlanContainerID AS InsurPlcyDistrPlanContainerID,
  DistrPlnRelshp.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  DistrPlnRelshp.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyDistrPlnRelshpVers AS DistrPlnRelshp
INNER JOIN I_InsurPlcyHghstVersPerAppl AS HighestVersion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurancePolicyTP_3 AS _Policy ON InsurPlcyUUID = _Policy.InsurPlcyUUID AND InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyCoinsurHeaderTP_3 AS _CoinsuranceHeader ON InsurPlcyDistributionPlanNmbr = _CoinsuranceHeader.InsurPlcyCoinsurHdrDistrPlnID AND InsurPlcyDistrPlanJournalNmbr = _CoinsuranceHeader.InsurPlcyCoinsurVersionID  -- association [0..*]
LEFT OUTER JOIN E_InsurPlcyDistrPlnRelshp AS _Extension ON ( InsurPlcyUUID = _Extension.InsurPlcyUUID OR InsurPlcyApplUUID = _Extension.InsurPlcyUUID ) AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyDistrPlnRelshpID = _Extension.InsurPlcyDistrPlnRelshpID  -- association [1..1]
;

Learn More