What is I_InsurPlcyAnswRskAssmtVersion in SAP S/4HANA?

I_InsurPlcyAnswRskAssmtVersion is a composite CDS view in SAP S/4HANA. Answers Risk Assessment It contains 88 fields.

What VDM layer is I_InsurPlcyAnswRskAssmtVersion?

I_InsurPlcyAnswRskAssmtVersion is classified as a Composite view that combines data from multiple basic views.

I_InsurPlcyAnswRskAssmtVersion

Q: Which tables does I_InsurPlcyAnswRskAssmtVersion read from?

I_InsurPlcyAnswRskAssmtVersion reads data from: I_InsurPlcyAnswRskAssmtBasic_2, I_InsurPlcyAnswRskAssmtBasic_2, P_InPlAnswRskAssmtLoadJrnlAppl, P_InPlAnswRskAssmtLoadJrnlAppl.

DDL: I_INSURPLCYANSWRSKASSMTVERSION Type: view_entity COMPOSITE

88 Fields 4 Data Sources

Answers Risk Assessment

I_InsurPlcyAnswRskAssmtVersion is a Composite CDS View that provides data about "Answers Risk Assessment" in SAP S/4HANA. It reads from 4 data sources (I_InsurPlcyAnswRskAssmtBasic_2, I_InsurPlcyAnswRskAssmtBasic_2, P_InPlAnswRskAssmtLoadJrnlAppl, P_InPlAnswRskAssmtLoadJrnlAppl) and exposes 88 fields with key fields InsurPlcyUUID, InsurPlcyOrderNumber, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID.

Data Sources (4)

Source	Alias	Join Type
I_InsurPlcyAnswRskAssmtBasic_2	AnswRskAssmt	from
I_InsurPlcyAnswRskAssmtBasic_2	AnswRskAssmt	union_all
P_InPlAnswRskAssmtLoadJrnlAppl	AnswRskAssmtLoadJrnlAppl	inner
P_InPlAnswRskAssmtLoadJrnlAppl	AnswRskAssmtLoadJrnlAppl	inner

Annotations (7)

Name	Value	Level
EndUserText.label	Answers Risk Assessment	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view

Fields (88)

Key	Field	Source Table	Source Field	Description
KEY	InsurPlcyUUID
KEY	InsurPlcyOrderNumber	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyOrderNumber	Sequence Number
KEY	InsurPlcyInsurContr	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyInsurContr	Contract Key
KEY	InsurPlcyCoveragePackageID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyCoveragePackageID	Cov.Package ID
KEY	InsurPlcyCoverageID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyCoverageID	Coverage Key
KEY	InsurPlcyRskAssmtQstnID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyRskAssmtQstnID	Question Key
KEY	InsurPlcyRskAssmtAnswID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyRskAssmtAnswID	Answer
	InsurPlcyApplUUID
	InsurPlcyBusProcType	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyBusProcType	Bus. Process
	InsurPlcyBusProcessNumerator	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyBusProcessNumerator	Bus. Proc. No.
	InsurPlcyJrnlEndNmbr	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyJrnlEndNmbr	Term. Jour. No.
	InsurPlcyJrnlNmbr	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyJrnlNmbr	Journal Number
	InsurPlcyProductPackageID	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyProductPackageID	Prod. Pckg. Key
	InsurPlcyAnswRskAssmtIsCancld	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtIsCancld	Rev. Flag
	InsurPlcyRskAssmtQstnApplQstn	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyRskAssmtQstnApplQstn	Appl. Question
	InsurPlcyRskAssmtIsNotAnswered	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyRskAssmtIsNotAnswered	No Answer
	InsurPlcyAnswIsCmpltlyAnswered	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswIsCmpltlyAnswered	Complete?
	InsurPlcyAnswRskAddictiveDrug	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAddictiveDrug	Addictive Subs.
	InsurPlcyAnswRskAssmtFrequency	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtFrequency	Frequency
	InsurPlcyAnswRskAssmtPersnHght	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtPersnHght	Height
	InsurPlcyAnswRskAssmtPersnWgt	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtPersnWgt	Weight
	InsurPlcyAnswRskAssmtStartDate	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtStartDate	Start Date
	InsurPlcyAnswRskAssmtEndDate	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtEndDate	End Date
	InsurPlcyAnswRskAssmtHobby	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtHobby	Hobby
	InsurPlcyAnswRskAssmtPrevIlln	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtPrevIlln	Prev. Illness
	InsurPlcyAnswRskAssmtCountry	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCountry	Country/Region
	InsurPlcyAnswRskAssmtBP	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtBP	BusPartner
	InsurPlcyAnswRskAssmtAddr	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtAddr	Address
	InsurPlcyAnswRskAssmtDte	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDte	Date
	InsurPlcyAnswRskAssmtDrug	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDrug	Medication
	InsurPlcyAnswRskAssmtCmntTxt	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCmntTxt	Comments
	InsurPlcyAnswRskAssmtAmt	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtAmt	Amount
	InsurPlcyAnswRskAssmtDurnYrs	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDurnYrs	Dur. in Years
	InsurPlcyAnswRskAssmtDurnMnths	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDurnMnths	Duration Months
	InsurPlcyAnswRskAssmtDurnDays	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDurnDays	Duration (Days)
	InsurPlcyAnswRskAssmtCmntID	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCmntID	Note Long Text
	InsurPlcyAnswRskAssmtAnswYesNo	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtAnswYesNo	Answer
	InsurPlcyAnswRskAssmtCrcy	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCrcy	Currency
	InsurPlcyAnswRskBodyMassIdxVal	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskBodyMassIdxVal	BMI
	InsurPlcyBodyMassIdxCrrtnVal	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyBodyMassIdxCrrtnVal	BMI Corr. Value
	InsurPlcyAnswRskAssmtWgtUnit	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtWgtUnit	Weight UnitMeas
	InsurPlcyAnswRskAssmtHghtUnit	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtHghtUnit	Height UnitMeas
	InsurPlcyBusinessObject	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyBusinessObject	Process.Status
	LastChangeDateTime	I_InsurPlcyAnswRskAssmtBasic_2	LastChangeDateTime	Timestamp
KEY	InsurPlcyOrderNumber	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyOrderNumber	Sequence Number
KEY	InsurPlcyInsurContr	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyInsurContr	Contract Key
KEY	InsurPlcyCoveragePackageID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyCoveragePackageID	Cov.Package ID
KEY	InsurPlcyCoverageID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyCoverageID	Coverage Key
KEY	InsurPlcyRskAssmtQstnID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyRskAssmtQstnID	Question Key
KEY	InsurPlcyRskAssmtAnswID	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyRskAssmtAnswID	Answer
	InsurPlcyApplUUID
	InsurPlcyBusProcType	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyBusProcType	Bus. Process
	InsurPlcyBusProcessNumerator	P_InPlAnswRskAssmtLoadJrnlAppl	InsurPlcyBusProcessNumerator	Bus. Proc. No.
	InsurPlcyJrnlEndNmbr	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyJrnlEndNmbr	Term. Jour. No.
	InsurPlcyJrnlNmbr	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyJrnlNmbr	Journal Number
	InsurPlcyProductPackageID	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyProductPackageID	Prod. Pckg. Key
	InsurPlcyAnswRskAssmtIsCancld	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtIsCancld	Rev. Flag
	InsurPlcyRskAssmtQstnApplQstn	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyRskAssmtQstnApplQstn	Appl. Question
	InsurPlcyRskAssmtIsNotAnswered	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyRskAssmtIsNotAnswered	No Answer
	InsurPlcyAnswIsCmpltlyAnswered	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswIsCmpltlyAnswered	Complete?
	InsurPlcyAnswRskAddictiveDrug	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAddictiveDrug	Addictive Subs.
	InsurPlcyAnswRskAssmtFrequency	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtFrequency	Frequency
	InsurPlcyAnswRskAssmtPersnHght	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtPersnHght	Height
	InsurPlcyAnswRskAssmtPersnWgt	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtPersnWgt	Weight
	InsurPlcyAnswRskAssmtStartDate	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtStartDate	Start Date
	InsurPlcyAnswRskAssmtEndDate	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtEndDate	End Date
	InsurPlcyAnswRskAssmtHobby	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtHobby	Hobby
	InsurPlcyAnswRskAssmtPrevIlln	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtPrevIlln	Prev. Illness
	InsurPlcyAnswRskAssmtCountry	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCountry	Country/Region
	InsurPlcyAnswRskAssmtBP	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtBP	BusPartner
	InsurPlcyAnswRskAssmtAddr	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtAddr	Address
	InsurPlcyAnswRskAssmtDte	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDte	Date
	InsurPlcyAnswRskAssmtDrug	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDrug	Medication
	InsurPlcyAnswRskAssmtCmntTxt	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCmntTxt	Comments
	InsurPlcyAnswRskAssmtAmt	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtAmt	Amount
	InsurPlcyAnswRskAssmtDurnYrs	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDurnYrs	Dur. in Years
	InsurPlcyAnswRskAssmtDurnMnths	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDurnMnths	Duration Months
	InsurPlcyAnswRskAssmtDurnDays	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtDurnDays	Duration (Days)
	InsurPlcyAnswRskAssmtCmntID	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCmntID	Note Long Text
	InsurPlcyAnswRskAssmtAnswYesNo	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtAnswYesNo	Answer
	InsurPlcyAnswRskAssmtCrcy	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtCrcy	Currency
	InsurPlcyAnswRskBodyMassIdxVal	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskBodyMassIdxVal	BMI
	InsurPlcyBodyMassIdxCrrtnVal	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyBodyMassIdxCrrtnVal	BMI Corr. Value
	InsurPlcyAnswRskAssmtWgtUnit	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtWgtUnit	Weight UnitMeas
	InsurPlcyAnswRskAssmtHghtUnit	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyAnswRskAssmtHghtUnit	Height UnitMeas
	InsurPlcyBusinessObject	I_InsurPlcyAnswRskAssmtBasic_2	InsurPlcyBusinessObject	Process.Status
	LastChangeDateTime	I_InsurPlcyAnswRskAssmtBasic_2	LastChangeDateTime	Timestamp
	_Currency	I_InsurPlcyAnswRskAssmtBasic_2	_Currency

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 I_InsurPlcyAnswRskAssmtVersion.
-- 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 I_InsurPlcyAnswRskAssmtVersion AS
SELECT
  cast( AnswRskAssmtLoadJrnlAppl.InsurPlcyUUID as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyRskAssmtQstnID AS InsurPlcyRskAssmtQstnID,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyRskAssmtAnswID AS InsurPlcyRskAssmtAnswID,
  cast( AnswRskAssmtLoadJrnlAppl.InsurPlcyApplUUID as /pm0/vdm_application_uuid preserving type ) AS InsurPlcyApplUUID,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  AnswRskAssmtLoadJrnlAppl.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  AnswRskAssmt.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  AnswRskAssmt.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  AnswRskAssmt.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  AnswRskAssmt.InsurPlcyAnswRskAssmtIsCancld AS InsurPlcyAnswRskAssmtIsCancld,
  AnswRskAssmt.InsurPlcyRskAssmtQstnApplQstn AS InsurPlcyRskAssmtQstnApplQstn,
  AnswRskAssmt.InsurPlcyRskAssmtIsNotAnswered AS InsurPlcyRskAssmtIsNotAnswered,
  AnswRskAssmt.InsurPlcyAnswIsCmpltlyAnswered AS InsurPlcyAnswIsCmpltlyAnswered,
  AnswRskAssmt.InsurPlcyAnswRskAddictiveDrug AS InsurPlcyAnswRskAddictiveDrug,
  AnswRskAssmt.InsurPlcyAnswRskAssmtFrequency AS InsurPlcyAnswRskAssmtFrequency,
  AnswRskAssmt.InsurPlcyAnswRskAssmtPersnHght AS InsurPlcyAnswRskAssmtPersnHght,
  AnswRskAssmt.InsurPlcyAnswRskAssmtPersnWgt AS InsurPlcyAnswRskAssmtPersnWgt,
  AnswRskAssmt.InsurPlcyAnswRskAssmtStartDate AS InsurPlcyAnswRskAssmtStartDate,
  AnswRskAssmt.InsurPlcyAnswRskAssmtEndDate AS InsurPlcyAnswRskAssmtEndDate,
  AnswRskAssmt.InsurPlcyAnswRskAssmtHobby AS InsurPlcyAnswRskAssmtHobby,
  AnswRskAssmt.InsurPlcyAnswRskAssmtPrevIlln AS InsurPlcyAnswRskAssmtPrevIlln,
  AnswRskAssmt.InsurPlcyAnswRskAssmtCountry AS InsurPlcyAnswRskAssmtCountry,
  AnswRskAssmt.InsurPlcyAnswRskAssmtBP AS InsurPlcyAnswRskAssmtBP,
  AnswRskAssmt.InsurPlcyAnswRskAssmtAddr AS InsurPlcyAnswRskAssmtAddr,
  AnswRskAssmt.InsurPlcyAnswRskAssmtDte AS InsurPlcyAnswRskAssmtDte,
  AnswRskAssmt.InsurPlcyAnswRskAssmtDrug AS InsurPlcyAnswRskAssmtDrug,
  AnswRskAssmt.InsurPlcyAnswRskAssmtCmntTxt AS InsurPlcyAnswRskAssmtCmntTxt,
  AnswRskAssmt.InsurPlcyAnswRskAssmtAmt AS InsurPlcyAnswRskAssmtAmt,
  AnswRskAssmt.InsurPlcyAnswRskAssmtDurnYrs AS InsurPlcyAnswRskAssmtDurnYrs,
  AnswRskAssmt.InsurPlcyAnswRskAssmtDurnMnths AS InsurPlcyAnswRskAssmtDurnMnths,
  AnswRskAssmt.InsurPlcyAnswRskAssmtDurnDays AS InsurPlcyAnswRskAssmtDurnDays,
  AnswRskAssmt.InsurPlcyAnswRskAssmtCmntID AS InsurPlcyAnswRskAssmtCmntID,
  AnswRskAssmt.InsurPlcyAnswRskAssmtAnswYesNo AS InsurPlcyAnswRskAssmtAnswYesNo,
  AnswRskAssmt.InsurPlcyAnswRskAssmtCrcy AS InsurPlcyAnswRskAssmtCrcy,
  AnswRskAssmt.InsurPlcyAnswRskBodyMassIdxVal AS InsurPlcyAnswRskBodyMassIdxVal,
  AnswRskAssmt.InsurPlcyBodyMassIdxCrrtnVal AS InsurPlcyBodyMassIdxCrrtnVal,
  AnswRskAssmt.InsurPlcyAnswRskAssmtWgtUnit AS InsurPlcyAnswRskAssmtWgtUnit,
  AnswRskAssmt.InsurPlcyAnswRskAssmtHghtUnit AS InsurPlcyAnswRskAssmtHghtUnit,
  AnswRskAssmt.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  AnswRskAssmt.LastChangeDateTime AS LastChangeDateTime,
  AnswRskAssmt._Currency AS _Currency
FROM I_InsurPlcyAnswRskAssmtBasic_2 AS AnswRskAssmt
INNER JOIN P_InPlAnswRskAssmtLoadJrnlAppl AS AnswRskAssmtLoadJrnlAppl ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_InsurPlcyAnswRskAssmtBasic_2
;

Depth:

I_InsurPlcyAnswRskAssmtVersion view_entity

I_InsurPlcyAnswRskAssmtBasic_2 view_entity
P_InPlAnswRskAssmtLoadJrnlAppl view_entity
P_InPlAnswRskAssmtLoadJrnlAppl view_entity
I_InsurPlcyAnswRskAssmtBasic_2 view_entity

R_InsurPlcyAnswRskAssmtTP_2 view_entity