R_InsurPlcyAnswRskAssmtTP_2

DDL: R_INSURPLCYANSWRSKASSMTTP_2 Type: view_entity TRANSACTIONAL
46 Fields 2 Data Sources 2 Associations

Risk Assessment Answers - TP

R_InsurPlcyAnswRskAssmtTP_2 is a Transactional CDS View that provides data about "Risk Assessment Answers - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyAnswRskAssmtVersion, I_InsurPlcyHghstVersPerAppl) and exposes 46 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyAnswRskAssmtVersion AnswRiskAssessment from
I_InsurPlcyHghstVersPerAppl HighestVersion inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InsurancePolicyTP_3 _Policy $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Policy.InsurPlcyApplUUID
[1..1] E_InsurPlcyAnswRskAssmt _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 and $projection.InsurPlcyRskAssmtAnswID = _Extension.InsurPlcyRskAssmtAnswID

Annotations (12)

NameValueLevelField
EndUserText.label Risk Assessment Answers - 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 InsurancePolicy view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix RAA view
AbapCatalog.extensibility.allowNewDatasources false view
Metadata.ignorePropagatedAnnotations true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyAnswRskAssmtVersion InsurPlcyUUID Policy UUID
KEY InsurPlcyApplUUID I_InsurPlcyAnswRskAssmtVersion InsurPlcyApplUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyAnswRskAssmtVersion InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyAnswRskAssmtVersion InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyAnswRskAssmtVersion InsurPlcyCoverageID Coverage Key
KEY InsurPlcyRskAssmtQstnID I_InsurPlcyAnswRskAssmtVersion InsurPlcyRskAssmtQstnID Question Key
KEY InsurPlcyRskAssmtAnswID I_InsurPlcyAnswRskAssmtVersion InsurPlcyRskAssmtAnswID Answer
InsurPlcyOrderNumber I_InsurPlcyAnswRskAssmtVersion InsurPlcyOrderNumber Sequence Number
InsurPlcyBusProcType I_InsurPlcyAnswRskAssmtVersion InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator I_InsurPlcyAnswRskAssmtVersion InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlEndNmbr I_InsurPlcyAnswRskAssmtVersion InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyJrnlNmbr I_InsurPlcyAnswRskAssmtVersion InsurPlcyJrnlNmbr Journal Number
InsurPlcyProductPackageID I_InsurPlcyAnswRskAssmtVersion InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyAnswRskAssmtIsCancld I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtIsCancld Rev. Flag
InsurPlcyRskAssmtQstnApplQstn I_InsurPlcyAnswRskAssmtVersion InsurPlcyRskAssmtQstnApplQstn Appl. Question
InsurPlcyRskAssmtIsNotAnswered I_InsurPlcyAnswRskAssmtVersion InsurPlcyRskAssmtIsNotAnswered No Answer
InsurPlcyAnswIsCmpltlyAnswered I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswIsCmpltlyAnswered Complete?
InsurPlcyAnswRskAddictiveDrug I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAddictiveDrug Addictive Subs.
InsurPlcyAnswRskAssmtFrequency I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtFrequency Frequency
InsurPlcyAnswRskAssmtPersnHght I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtPersnHght Height
InsurPlcyAnswRskAssmtPersnWgt I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtPersnWgt Weight
InsurPlcyAnswRskAssmtStartDate I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtStartDate Start Date
InsurPlcyAnswRskAssmtEndDate I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtEndDate End Date
InsurPlcyAnswRskAssmtHobby I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtHobby Hobby
InsurPlcyAnswRskAssmtPrevIlln I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtPrevIlln Prev. Illness
InsurPlcyAnswRskAssmtCountry I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtCountry Country/Region
InsurPlcyAnswRskAssmtBP I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtBP BusPartner
InsurPlcyAnswRskAssmtAddr I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtAddr Address
InsurPlcyAnswRskAssmtDte I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtDte Date
InsurPlcyAnswRskAssmtDrug I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtDrug Medication
InsurPlcyAnswRskAssmtCmntTxt I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtCmntTxt Comments
InsurPlcyAnswRskAssmtAmt I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtAmt Amount
InsurPlcyAnswRskAssmtDurnYrs I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtDurnYrs Dur. in Years
InsurPlcyAnswRskAssmtDurnMnths I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtDurnMnths Duration Months
InsurPlcyAnswRskAssmtDurnDays I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtDurnDays Duration (Days)
InsurPlcyAnswRskAssmtCmntID I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtCmntID Note Long Text
InsurPlcyAnswRskAssmtAnswYesNo I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtAnswYesNo Answer
InsurPlcyAnswRskAssmtCrcy I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtCrcy Currency
InsurPlcyAnswRskBodyMassIdxVal I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskBodyMassIdxVal BMI
InsurPlcyBodyMassIdxCrrtnVal I_InsurPlcyAnswRskAssmtVersion InsurPlcyBodyMassIdxCrrtnVal BMI Corr. Value
InsurPlcyAnswRskAssmtWgtUnit I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtWgtUnit Weight UnitMeas
InsurPlcyAnswRskAssmtHghtUnit I_InsurPlcyAnswRskAssmtVersion InsurPlcyAnswRskAssmtHghtUnit Height UnitMeas
InsurPlcyBusinessObject I_InsurPlcyAnswRskAssmtVersion InsurPlcyBusinessObject
LastChangeDateTime I_InsurPlcyAnswRskAssmtVersion LastChangeDateTime Timestamp
_Currency I_InsurPlcyAnswRskAssmtVersion _Currency
_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_InsurPlcyAnswRskAssmtTP_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_InsurPlcyAnswRskAssmtTP_2 AS
SELECT
  AnswRiskAssessment.InsurPlcyUUID AS InsurPlcyUUID,
  AnswRiskAssessment.InsurPlcyApplUUID AS InsurPlcyApplUUID,
  AnswRiskAssessment.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  AnswRiskAssessment.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  AnswRiskAssessment.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  AnswRiskAssessment.InsurPlcyRskAssmtQstnID AS InsurPlcyRskAssmtQstnID,
  AnswRiskAssessment.InsurPlcyRskAssmtAnswID AS InsurPlcyRskAssmtAnswID,
  AnswRiskAssessment.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  AnswRiskAssessment.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  AnswRiskAssessment.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  AnswRiskAssessment.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  AnswRiskAssessment.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  AnswRiskAssessment.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtIsCancld AS InsurPlcyAnswRskAssmtIsCancld,
  AnswRiskAssessment.InsurPlcyRskAssmtQstnApplQstn AS InsurPlcyRskAssmtQstnApplQstn,
  AnswRiskAssessment.InsurPlcyRskAssmtIsNotAnswered AS InsurPlcyRskAssmtIsNotAnswered,
  AnswRiskAssessment.InsurPlcyAnswIsCmpltlyAnswered AS InsurPlcyAnswIsCmpltlyAnswered,
  AnswRiskAssessment.InsurPlcyAnswRskAddictiveDrug AS InsurPlcyAnswRskAddictiveDrug,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtFrequency AS InsurPlcyAnswRskAssmtFrequency,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtPersnHght AS InsurPlcyAnswRskAssmtPersnHght,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtPersnWgt AS InsurPlcyAnswRskAssmtPersnWgt,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtStartDate AS InsurPlcyAnswRskAssmtStartDate,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtEndDate AS InsurPlcyAnswRskAssmtEndDate,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtHobby AS InsurPlcyAnswRskAssmtHobby,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtPrevIlln AS InsurPlcyAnswRskAssmtPrevIlln,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtCountry AS InsurPlcyAnswRskAssmtCountry,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtBP AS InsurPlcyAnswRskAssmtBP,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtAddr AS InsurPlcyAnswRskAssmtAddr,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtDte AS InsurPlcyAnswRskAssmtDte,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtDrug AS InsurPlcyAnswRskAssmtDrug,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtCmntTxt AS InsurPlcyAnswRskAssmtCmntTxt,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtAmt AS InsurPlcyAnswRskAssmtAmt,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtDurnYrs AS InsurPlcyAnswRskAssmtDurnYrs,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtDurnMnths AS InsurPlcyAnswRskAssmtDurnMnths,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtDurnDays AS InsurPlcyAnswRskAssmtDurnDays,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtCmntID AS InsurPlcyAnswRskAssmtCmntID,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtAnswYesNo AS InsurPlcyAnswRskAssmtAnswYesNo,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtCrcy AS InsurPlcyAnswRskAssmtCrcy,
  AnswRiskAssessment.InsurPlcyAnswRskBodyMassIdxVal AS InsurPlcyAnswRskBodyMassIdxVal,
  AnswRiskAssessment.InsurPlcyBodyMassIdxCrrtnVal AS InsurPlcyBodyMassIdxCrrtnVal,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtWgtUnit AS InsurPlcyAnswRskAssmtWgtUnit,
  AnswRiskAssessment.InsurPlcyAnswRskAssmtHghtUnit AS InsurPlcyAnswRskAssmtHghtUnit,
  AnswRiskAssessment.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  AnswRiskAssessment.LastChangeDateTime AS LastChangeDateTime,
  AnswRiskAssessment._Currency AS _Currency
FROM I_InsurPlcyAnswRskAssmtVersion AS AnswRiskAssessment
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_InsurPlcyAnswRskAssmt 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 AND InsurPlcyRskAssmtAnswID = _Extension.InsurPlcyRskAssmtAnswID  -- association [1..1]
;

Learn More