R_InsurancePolicyQuestionTP_2

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

Risk Assessment Questions - TP

R_InsurancePolicyQuestionTP_2 is a Transactional CDS View that provides data about "Risk Assessment Questions - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyHghstVersPerAppl, I_InsurPolicyQuestionVersion) 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_InsurPlcyHghstVersPerAppl HighestVersion inner
I_InsurPolicyQuestionVersion Question from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurancePolicyQuestion _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.InsurPlcyRskAssmtQstnID = _Extension.InsurPlcyRskAssmtQstnID
[0..*] R_InsurPlcyAnswRskAssmtTP_2 _RiskAssessmentAnswer $projection.InsurPlcyUUIDForEdit = _RiskAssessmentAnswer.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _RiskAssessmentAnswer.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _RiskAssessmentAnswer.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _RiskAssessmentAnswer.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _RiskAssessmentAnswer.InsurPlcyCoverageID and $projection.InsurPlcyRskAssmtQstnIDForEdit = _RiskAssessmentAnswer.InsurPlcyRskAssmtQstnID

Annotations (11)

NameValueLevelField
EndUserText.label Risk Assessment Questions - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.sapObjectNodeType.name InsurancePolicyQuestion view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix RAQ view
Metadata.ignorePropagatedAnnotations true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPolicyQuestionVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPolicyQuestionVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPolicyQuestionVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPolicyQuestionVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPolicyQuestionVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyRskAssmtQstnID I_InsurPolicyQuestionVersion InsurPlcyRskAssmtQstnID Question Key
InsurPlcyUUIDForEdit I_InsurPolicyQuestionVersion InsurPlcyUUID Policy UUID
InsurPlcyApplUUIDForEdit I_InsurPolicyQuestionVersion InsurPlcyApplUUID Policy UUID
InsurPlcyInsurContrForEdit I_InsurPolicyQuestionVersion InsurPlcyInsurContr Contract Key
InsurPlcyCvPcgIDForEdit I_InsurPolicyQuestionVersion InsurPlcyCoveragePackageID Cov.Package ID
InsurPlcyCoverageIDForEdit I_InsurPolicyQuestionVersion InsurPlcyCoverageID Coverage Key
InsurPlcyRskAssmtQstnIDForEdit I_InsurPolicyQuestionVersion InsurPlcyRskAssmtQstnID Question Key
InsurPlcyOrderNumber I_InsurPolicyQuestionVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPolicyQuestionVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPolicyQuestionVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPolicyQuestionVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPolicyQuestionVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPolicyQuestionVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyRskAssmtQstnIsCancld I_InsurPolicyQuestionVersion InsurPlcyRskAssmtQstnIsCancld Rev. Flag
InsurancePolicy I_InsurPolicyQuestionVersion InsurancePolicy Policy Number
InsurancePolicyContract I_InsurPolicyQuestionVersion InsurancePolicyContract Contract Number
InsurancePolicyApplication I_InsurPolicyQuestionVersion InsurancePolicyApplication Application No.
InsurPlcyElementaryProdID I_InsurPolicyQuestionVersion InsurPlcyElementaryProdID Element. Prod.
InsurPlcyRskAssmtQstnApplQstn I_InsurPolicyQuestionVersion InsurPlcyRskAssmtQstnApplQstn Appl. Question
InsurPlcyRskAssmtQstnPrtn I_InsurPolicyQuestionVersion InsurPlcyRskAssmtQstnPrtn BusPartner
InsurPlcyBusinessObject I_InsurPolicyQuestionVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPolicyQuestionVersion LastChangeDateTime Timestamp
_RiskAssessmentAnswer _RiskAssessmentAnswer
_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_InsurancePolicyQuestionTP_2.
-- 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_InsurancePolicyQuestionTP_2 AS
SELECT
  Question.InsurPlcyUUID AS InsurPlcyUUID,
  Question.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  Question.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Question.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Question.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Question.InsurPlcyRskAssmtQstnID AS InsurPlcyRskAssmtQstnID,
  Question.InsurPlcyUUID AS InsurPlcyUUIDForEdit,
  Question.InsurPlcyApplUUID AS InsurPlcyApplUUIDForEdit,
  Question.InsurPlcyInsurContr AS InsurPlcyInsurContrForEdit,
  Question.InsurPlcyCoveragePackageID AS InsurPlcyCvPcgIDForEdit,
  Question.InsurPlcyCoverageID AS InsurPlcyCoverageIDForEdit,
  Question.InsurPlcyRskAssmtQstnID AS InsurPlcyRskAssmtQstnIDForEdit,
  Question.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  Question.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  Question.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  Question.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Question.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Question.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Question.InsurPlcyRskAssmtQstnIsCancld AS InsurPlcyRskAssmtQstnIsCancld,
  Question.InsurancePolicy AS InsurancePolicy,
  Question.InsurancePolicyContract AS InsurancePolicyContract,
  Question.InsurancePolicyApplication AS InsurancePolicyApplication,
  Question.InsurPlcyElementaryProdID AS InsurPlcyElementaryProdID,
  Question.InsurPlcyRskAssmtQstnApplQstn AS InsurPlcyRskAssmtQstnApplQstn,
  Question.InsurPlcyRskAssmtQstnPrtn AS InsurPlcyRskAssmtQstnPrtn,
  Question.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Question.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPolicyQuestionVersion AS Question
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 E_InsurancePolicyQuestion 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 InsurPlcyRskAssmtQstnID = _Extension.InsurPlcyRskAssmtQstnID  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyAnswRskAssmtTP_2 AS _RiskAssessmentAnswer ON InsurPlcyUUIDForEdit = _RiskAssessmentAnswer.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _RiskAssessmentAnswer.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _RiskAssessmentAnswer.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _RiskAssessmentAnswer.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _RiskAssessmentAnswer.InsurPlcyCoverageID AND InsurPlcyRskAssmtQstnIDForEdit = _RiskAssessmentAnswer.InsurPlcyRskAssmtQstnID  -- association [0..*]
;

Learn More