What is R_InsurPlcyBnftDeterminationD in SAP S/4HANA?

R_InsurPlcyBnftDeterminationD is a basic CDS view in SAP S/4HANA. Benefit Determination - Draft It contains 42 fields.

Which tables does R_InsurPlcyBnftDeterminationD read from?

R_InsurPlcyBnftDeterminationD reads data from: /pm0/abdrbnfcalc.

What VDM layer is R_InsurPlcyBnftDeterminationD?

R_InsurPlcyBnftDeterminationD is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_InsurPlcyBnftDeterminationD

DDL: R_INSURPLCYBNFTDETERMINATIOND Type: view_entity BASIC

42 Fields 1 Data Sources 2 Associations

Benefit Determination - Draft

R_InsurPlcyBnftDeterminationD is a Basic CDS View that provides data about "Benefit Determination - Draft" in SAP S/4HANA. It reads from 1 data source (/pm0/abdrbnfcalc) and exposes 42 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
/pm0/abdrbnfcalc	/pm0/abdrbnfcalc	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	E_InsurPlcyBnftDetnDrft	_Extension	`$projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.InsurPlcyBnftDetnID = _Extension.InsurPlcyBnftDetnID and $projection.DraftUUID = _Extension.DraftUUID`
[0..*]	R_InsurPlcyFundAssignmentDraft	_FundAssignment	$projection.InsurPlcyUUIDForEdit = _FundAssignment.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _FundAssignment.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _FundAssignment.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _FundAssignment.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _FundAssignment.InsurPlcyCoverageID and $projection.InsurPlcyCoverageOptionID = _FundAssignment.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _FundAssignment.InsurPlcyInsuredObjectID and $projection.InsurancePolicyPremium = _FundAssignment.InsurancePolicyPremium and $projection.InsurPlcyBenefitID = _FundAssignment.InsurPlcyBenefitID and $projection.InsurPlcyBnftDetnIDForEdit = _FundAssignment.InsurPlcyBnftDetnID

Annotations (11)

Name	Value	Level
EndUserText.label	Benefit Determination - Draft	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AbapCatalog.extensibility.extensible	true	view
AbapCatalog.extensibility.elementSuffix	BTR	view
AbapCatalog.extensibility.allowNewDatasources	false	view
AbapCatalog.extensibility.allowNewCompositions	false	view

Fields (42)

Key	Field	Source Field	Description
KEY	InsurPlcyUUID	insurplcyuuid	Policy UUID
KEY	InsurPlcyApplUUID	insurplcyappluuid	Policy UUID
KEY	InsurPlcyInsurContr	insurplcyinsurcontr	Contract Key
KEY	InsurPlcyCoveragePackageID	insurplcycoveragepackageid	Cov.Package ID
KEY	InsurPlcyCoverageID	insurplcycoverageid	Coverage Key
KEY	InsurPlcyBnftDetnID	insurplcybnftdetnid	Benefit Determ.
KEY	DraftUUID	draftuuid	UUID
	InsurPlcyUUIDForEdit	insurplcyuuid	Policy UUID
	InsurPlcyApplUUIDForEdit	insurplcyappluuid	Policy UUID
	InsurPlcyInsurContrForEdit	insurplcyinsurcontr	Contract Key
	InsurPlcyCvPcgIDForEdit	insurplcycoveragepackageid	Cov.Package ID
	InsurPlcyCoverageIDForEdit	insurplcycoverageid	Coverage Key
	InsurPlcyCoverageOptionID	insurplcycoverageoptionid	Cov. Option Key
	InsurPlcyInsuredObjectID	insurplcyinsuredobjectid	Ins. Obj. No.
	InsurancePolicyPremium	insurancepolicypremium	Premium ID
	InsurPlcyBenefitID	insurplcybenefitid	Benefit
	InsurPlcyBnftDetnIDForEdit	insurplcybnftdetnid	Benefit Determ.
	InsurPlcyOrderNumber	insurplcyordernumber	Sequence Number
	InsurPlcyBusProcType	insurplcybusproctype	Bus. Process
	InsurPlcyBusProcessNumerator	insurplcybusprocessnumerator	Bus. Proc. No.
	InsurPlcyJrnlEndNmbr	insurplcyjrnlendnmbr	Term. Jour. No.
	InsurPlcyJrnlNmbr	insurplcyjrnlnmbr	Journal Number
	InsurPlcyProductPackageID	insurplcyproductpackageid	Prod. Pckg. Key
	InsurPlcyBnftDetnIsCancelled	insurplcybnftdetniscancelled	Rev. Flag
	InsurPlcyBnftDetnCurrency	insurplcybnftdetncurrency	Currency
	InsurPlcyBnftDetnCalcdBnftAmt	insurplcybnftdetncalcdbnftamt	Calc. Ben. Val.
	InsurPlcyBnftDetnClrdBnftAmt	insurplcybnftdetnclrdbnftamt	BV to be Clrd
	InsurPlcyBnftDetnPaytFrequency	insurplcybnftdetnpaytfrequency	Payment Frequency
	InsurPlcyBnftDetnAdjmtCatID	insurplcybnftdetnadjmtcatid	Adjustment Cat.
	InsurPlcyBnftDetnBnftType	insurplcybnftdetnbnfttype	Benefit Type
	InsurPlcyBnftDetnClmRsrvDetAmt	insurplcybnftdetnclmrsrvdetamt	CR Detail Value
	InsurPlcyBnftDetnClmRsrvDetCat	insurplcybnftdetnclmrsrvdetcat	CR Category
	InsurPlcyBnftNrOfWaitPerdDays	insurplcybnftnrofwaitperddays	Wait. Per. (Days)
	InsurPlcyBnftRvslDeductionAmt	insurplcybnftrvsldeductionamt	Reversal Dedctn
	LastChangeDateTime	lastchangedatetime	Timestamp
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	HasActiveEntity	hasactiveentity	TRUE
	DraftFieldChanges	draftfieldchanges	Field Changes
	_FundAssignment	_FundAssignment

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_InsurPlcyBnftDeterminationD.
-- 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_InsurPlcyBnftDeterminationD AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyBnftDetnID,
  DraftUUID,
  insurplcyuuid AS InsurPlcyUUIDForEdit,
  insurplcyappluuid AS InsurPlcyApplUUIDForEdit,
  insurplcyinsurcontr AS InsurPlcyInsurContrForEdit,
  insurplcycoveragepackageid AS InsurPlcyCvPcgIDForEdit,
  insurplcycoverageid AS InsurPlcyCoverageIDForEdit,
  InsurPlcyCoverageOptionID,
  InsurPlcyInsuredObjectID,
  InsurancePolicyPremium,
  InsurPlcyBenefitID,
  insurplcybnftdetnid AS InsurPlcyBnftDetnIDForEdit,
  InsurPlcyOrderNumber,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyBnftDetnIsCancelled,
  InsurPlcyBnftDetnCurrency,
  InsurPlcyBnftDetnCalcdBnftAmt,
  InsurPlcyBnftDetnClrdBnftAmt,
  InsurPlcyBnftDetnPaytFrequency,
  InsurPlcyBnftDetnAdjmtCatID,
  InsurPlcyBnftDetnBnftType,
  InsurPlcyBnftDetnClmRsrvDetAmt,
  InsurPlcyBnftDetnClmRsrvDetCat,
  InsurPlcyBnftNrOfWaitPerdDays,
  InsurPlcyBnftRvslDeductionAmt,
  LastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM /pm0/abdrbnfcalc
LEFT OUTER JOIN E_InsurPlcyBnftDetnDrft AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND InsurPlcyBnftDetnID = _Extension.InsurPlcyBnftDetnID AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyFundAssignmentDraft AS _FundAssignment ON InsurPlcyUUIDForEdit = _FundAssignment.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _FundAssignment.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _FundAssignment.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _FundAssignment.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _FundAssignment.InsurPlcyCoverageID AND InsurPlcyCoverageOptionID = _FundAssignment.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _FundAssignment.InsurPlcyInsuredObjectID AND InsurancePolicyPremium = _FundAssignment.InsurancePolicyPremium AND InsurPlcyBenefitID = _FundAssignment.InsurPlcyBenefitID AND InsurPlcyBnftDetnIDForEdit = _FundAssignment.InsurPlcyBnftDetnID  -- association [0..*]
;

Depth:

R_InsurPlcyBnftDeterminationD view_entity

/pm0/abdrbnfcalc