R_InsurPlcyCvrgPckgInsrdObjTP

DDL: R_INSURPLCYCVRGPCKGINSRDOBJTP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 5 Associations

Cvrg Pckg Insurd Object in Plcy - TP

R_InsurPlcyCvrgPckgInsrdObjTP is a Transactional CDS View that provides data about "Cvrg Pckg Insurd Object in Plcy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyCvrgPckgInsrdObject) and exposes 18 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyInsuredObjectID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyCvrgPckgInsrdObject Subject from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_InsurancePolicyInsuredObject _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and 0 = _Extension.InsurPlcyCoverageID and 0 = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[0..*] R_InsurancePolicyClauseTP _InsurancePolicyClause
[0..*] R_InsurancePolicyDeductibleTP _InsurancePolicyDeductible
[0..*] R_InsurPlcySurchargeDiscountTP _InsurPolicySurchargeDiscount
[0..1] R_InsurPlcyCvrgPckgBldngTP _InsurPlcyCvrgPckgInsrdBldng

Annotations (8)

NameValueLevelField
EndUserText.label Cvrg Pckg Insurd Object in Plcy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsuredObjectID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyCvrgPckgInsrdObject InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyCvrgPckgInsrdObject InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyCvrgPckgInsrdObject InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyInsuredObjectID I_InsurPlcyCvrgPckgInsrdObject InsurPlcyInsuredObjectID Ins. Obj. No.
InsurPlcyJrnlNmbr I_InsurPlcyCvrgPckgInsrdObject InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyCvrgPckgInsrdObject InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPolicyContractPackageID I_InsurPlcyCvrgPckgInsrdObject InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyInsuredObjectControl I_InsurPlcyCvrgPckgInsrdObject InsurPlcyInsrdObjectTemplate Object Module
InsurPlcyInsuredObjectCategory I_InsurPlcyCvrgPckgInsrdObject InsurPlcyInsuredObjectCategory Object Category
InsurPlcyInsrdObjSubCategory I_InsurPlcyCvrgPckgInsrdObject InsurPlcyInsrdObjSubCategory Object Type
InsurPlcyInsrdObjUnqID I_InsurPlcyCvrgPckgInsrdObject InsurPlcyInsrdObjUnqID Insurable Obj.
InsurInsrblObjJrnlNmbr I_InsurPlcyCvrgPckgInsrdObject InsurInsrblObjJrnlNmbr INSBO JournStat
LastChangeDateTime I_InsurPlcyCvrgPckgInsrdObject LastChangeDateTime Timestamp
_InsurPlcyCoveragePackage _InsurPlcyCoveragePackage
_InsurancePolicyClause _InsurancePolicyClause
_InsurancePolicyDeductible _InsurancePolicyDeductible
_InsurPolicySurchargeDiscount _InsurPolicySurchargeDiscount
_InsurPlcyCvrgPckgInsrdBldng _InsurPlcyCvrgPckgInsrdBldng

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_InsurPlcyCvrgPckgInsrdObjTP.
-- 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_InsurPlcyCvrgPckgInsrdObjTP AS
SELECT
  Subject.InsurPlcyUUID AS InsurPlcyUUID,
  Subject.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Subject.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Subject.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  Subject.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Subject.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Subject.InsurPlcyProductPackageID AS InsurPolicyContractPackageID,
  Subject.InsurPlcyInsrdObjectTemplate AS InsurPlcyInsuredObjectControl,
  Subject.InsurPlcyInsuredObjectCategory AS InsurPlcyInsuredObjectCategory,
  Subject.InsurPlcyInsrdObjSubCategory AS InsurPlcyInsrdObjSubCategory,
  Subject.InsurPlcyInsrdObjUnqID AS InsurPlcyInsrdObjUnqID,
  Subject.InsurInsrblObjJrnlNmbr AS InsurInsrblObjJrnlNmbr,
  Subject.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyCvrgPckgInsrdObject AS Subject
LEFT OUTER JOIN E_InsurancePolicyInsuredObject AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND 0 = _Extension.InsurPlcyCoverageID AND 0 = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Extension.InsurPlcyInsuredObjectID AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsurancePolicyClauseTP AS _InsurancePolicyClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyDeductibleTP AS _InsurancePolicyDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcySurchargeDiscountTP AS _InsurPolicySurchargeDiscount ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyCvrgPckgBldngTP AS _InsurPlcyCvrgPckgInsrdBldng ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More