What is R_InsurPlcyCvrgOptnDraft in SAP S/4HANA?

R_InsurPlcyCvrgOptnDraft is a basic CDS view in SAP S/4HANA. Coverage Option - Draft It contains 47 fields.

Which tables does R_InsurPlcyCvrgOptnDraft read from?

R_InsurPlcyCvrgOptnDraft reads data from: /pm0/abdrcovcp.

What VDM layer is R_InsurPlcyCvrgOptnDraft?

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

R_InsurPlcyCvrgOptnDraft

DDL: R_INSURPLCYCVRGOPTNDRAFT Type: view_entity BASIC

47 Fields 1 Data Sources 9 Associations

Coverage Option - Draft

R_InsurPlcyCvrgOptnDraft is a Basic CDS View that provides data about "Coverage Option - Draft" in SAP S/4HANA. It reads from 1 data source (/pm0/abdrcovcp) and exposes 47 fields with key fields InsurPlcyUUID, InsurPlcyApplUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID. It has 9 associations to related views.

Data Sources (1)

Source	Alias	Join Type
/pm0/abdrcovcp	/pm0/abdrcovcp	from

Associations (9)

Cardinality	Target	Alias	Condition
[1..1]	E_InsurPlcyCoverageOptionDraft	_Extension	`$projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID and $projection.InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID and $projection.DraftUUID = _Extension.DraftUUID`
[0..1]	R_InsurPlcyLifeCvrgOptionDraft	_LifeCoverageOption	$projection.InsurPlcyUUIDForEdit = _LifeCoverageOption.InsurPlcyUUIDForEdit and $projection.InsurPlcyApplUUIDForEdit = _LifeCoverageOption.InsurPlcyApplUUIDForEdit and $projection.InsurPlcyInsurContrForEdit = _LifeCoverageOption.InsurPlcyInsurContrForEdit and $projection.InsurPlcyCvPcgIDForEdit = _LifeCoverageOption.InsurPlcyCvPcgIDForEdit and $projection.InsurPlcyCoverageIDForEdit = _LifeCoverageOption.InsurPlcyCoverageIDForEdit and $projection.InsurPlcyCvrgOptnIDForEdit = _LifeCoverageOption.InsurPlcyCvrgOptnIDForEdit
[0..*]	R_InsurPlcyAcctBalShtValDraft	_AccBalanceSheetValues	$projection.InsurPlcyUUIDForEdit = _AccBalanceSheetValues.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _AccBalanceSheetValues.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _AccBalanceSheetValues.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _AccBalanceSheetValues.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _AccBalanceSheetValues.InsurPlcyCoverageID and $projection.InsurPlcyCvrgOptnIDForEdit = _AccBalanceSheetValues.InsurPlcyCoverageOptionID
[0..*]	R_InsurPlcyAssessmentBasisDrft	_AssessmentBasis	`$projection.InsurPlcyUUIDForEdit = _AssessmentBasis.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _AssessmentBasis.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _AssessmentBasis.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _AssessmentBasis.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _AssessmentBasis.InsurPlcyCoverageID and $projection.InsurPlcyCvrgOptnIDForEdit = _AssessmentBasis.InsurPlcyCoverageOptionID`
[0..*]	R_InsurancePolicyBenefitDraft	_Benefit	`$projection.InsurPlcyUUIDForEdit = _Benefit.InsurPlcyUUIDForEdit and $projection.InsurPlcyApplUUIDForEdit = _Benefit.InsurPlcyApplUUIDForEdit and $projection.InsurPlcyInsurContrForEdit = _Benefit.InsurPlcyInsurContrForEdit and $projection.InsurPlcyCvPcgIDForEdit = _Benefit.InsurPlcyCvPcgIDForEdit and $projection.InsurPlcyCoverageIDForEdit = _Benefit.InsurPlcyCoverageIDForEdit and $projection.InsurPlcyCvrgOptnIDForEdit = _Benefit.InsurPlcyCvrgOptnIDForEdit`
[0..*]	R_InsurancePolicyClauseDraft	_Clause	$projection.InsurPlcyUUIDForEdit = _Clause.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _Clause.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _Clause.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _Clause.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _Clause.InsurPlcyCoverageID and $projection.InsurPlcyCvrgOptnIDForEdit = _Clause.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _Clause.InsurPlcyInsuredObjectID and $projection.InsurPlcyUndrwrtgDcsnRiskID = _Clause.InsurPlcyUndrwrtgDcsnRiskID and $projection.InsurPlcySubCvrgID = _Clause.InsurPlcySubCvrgID
[0..*]	R_InsurPolicyInsuredObjectDrft	_InsuredObject	`$projection.InsurPlcyUUIDForEdit = _InsuredObject.InsurPlcyUUIDForEdit and $projection.InsurPlcyApplUUIDForEdit = _InsuredObject.InsurPlcyApplUUIDForEdit and $projection.InsurPlcyInsurContrForEdit = _InsuredObject.InsurPlcyInsurContrForEdit and $projection.InsurPlcyCvPcgIDForEdit = _InsuredObject.InsurPlcyCvPcgIDForEdit and $projection.InsurPlcyCoverageIDForEdit = _InsuredObject.InsurPlcyCoverageIDForEdit and $projection.InsurPlcyCvrgOptnIDForEdit = _InsuredObject.InsurPlcyCvrgOptnIDForEdit`
[0..*]	R_InsurancePolicyPremiumDraft	_Premium	$projection.InsurPlcyUUIDForEdit = _Premium.InsurPlcyUUIDForEdit and $projection.InsurPlcyApplUUIDForEdit = _Premium.InsurPlcyApplUUIDForEdit and $projection.InsurPlcyInsurContrForEdit = _Premium.InsurPlcyInsurContrForEdit and $projection.InsurPlcyCvPcgIDForEdit = _Premium.InsurPlcyCvPcgIDForEdit and $projection.InsurPlcyCoverageIDForEdit = _Premium.InsurPlcyCoverageIDForEdit and $projection.InsurPlcyCvrgOptnIDForEdit = _Premium.InsurPlcyCvrgOptnIDForEdit and $projection.InsurPlcyInsuredObjectID = _Premium.InsurPlcyInsrdObjIDForEdit
[0..*]	R_InsurPlcySurchargeDiscountD	_SurchargeDiscount	$projection.InsurPlcyUUIDForEdit = _SurchargeDiscount.InsurPlcyUUID and $projection.InsurPlcyApplUUIDForEdit = _SurchargeDiscount.InsurPlcyApplUUID and $projection.InsurPlcyInsurContrForEdit = _SurchargeDiscount.InsurPlcyInsurContr and $projection.InsurPlcyCvPcgIDForEdit = _SurchargeDiscount.InsurPlcyCoveragePackageID and $projection.InsurPlcyCoverageIDForEdit = _SurchargeDiscount.InsurPlcyCoverageID and $projection.InsurPlcyCvrgOptnIDForEdit = _SurchargeDiscount.InsurPlcyCoverageOptionID and $projection.InsurPlcyInsuredObjectID = _SurchargeDiscount.InsurPlcyInsuredObjectID and $projection.InsurPlcyUndrwrtgDcsnRiskID = _SurchargeDiscount.InsurPlcyUndrwrtgDcsnRiskID

Annotations (10)

Name	Value	Level
EndUserText.label	Coverage Option - 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	BCO	view
AbapCatalog.extensibility.allowNewDatasources	false	view

Fields (47)

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	InsurPlcyCoverageOptionID	insurplcycoverageoptionid	Cov. Option Key
KEY	DraftUUID	draftuuid	UUID
	InsurPlcyUUIDForEdit	insurplcyuuidforedit	Policy UUID
	InsurPlcyApplUUIDForEdit	insurplcyappluuidforedit	Policy UUID
	InsurPlcyInsurContrForEdit	insurplcyinsurcontrforedit	Contract Key
	InsurPlcyCvPcgIDForEdit	insurplcycvpcgidforedit	Cov.Package ID
	InsurPlcyCoverageIDForEdit	insurplcycoverageidforedit	Coverage Key
	InsurPlcyCvrgOptnIDForEdit	insurplcycvrgoptnidforedit	Cov. Option Key
	InsurPlcyInsuredObjectID	insurplcyinsuredobjectid	Ins. Obj. No.
	InsurPlcyUndrwrtgDcsnRiskID	insurplcyundrwrtgdcsnriskid	UndWritDecision
	InsurPlcySubCvrgID	insurplcysubcvrgid	Subcoverage Key
	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
	InsurPlcyCvrgOptionIsCancelled	insurplcycvrgoptioniscancelled	Rev. Flag
	InsurPlcyLineOfBusiness	insurplcylineofbusiness	LoB Name
	InsurPlcyCvrgOptionStartDate	insurplcycvrgoptionstartdate	Start Date
	InsurPlcyCvrgOptionEndDate	insurplcycvrgoptionenddate	End Date
	InsurPlcyCvrgOptionCvrgNmbr	insurplcycvrgoptioncvrgnmbr	Coverage Number
	InsurPlcyCvrgOptnCvrgOptnNmbr	insurplcycvrgoptncvrgoptnnmbr	Cov. Option No.
	InsurPlcyCvrgOptionProdMgrID	insurplcycvrgoptionprodmgrid	Cov. Optn PM-ID
	InsurPlcyCvrgOptionCurrency	insurplcycvrgoptioncurrency	Currency
	InsurPlcyCvrgOptionGnrtnDate	insurplcycvrgoptiongnrtndate	Generation Date
	InsurPlcyCvrgOptnGnrtnDetnDte	insurplcycvrgoptngnrtndetndte	GenDetermDate
	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
	_AccBalanceSheetValues	_AccBalanceSheetValues
	_LifeCoverageOption	_LifeCoverageOption
	_AssessmentBasis	_AssessmentBasis
	_Benefit	_Benefit
	_Clause	_Clause
	_InsuredObject	_InsuredObject
	_Premium	_Premium
	_SurchargeDiscount	_SurchargeDiscount

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_InsurPlcyCvrgOptnDraft.
-- 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_InsurPlcyCvrgOptnDraft AS
SELECT
  InsurPlcyUUID,
  InsurPlcyApplUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyCoverageOptionID,
  DraftUUID,
  InsurPlcyUUIDForEdit,
  InsurPlcyApplUUIDForEdit,
  InsurPlcyInsurContrForEdit,
  InsurPlcyCvPcgIDForEdit,
  InsurPlcyCoverageIDForEdit,
  InsurPlcyCvrgOptnIDForEdit,
  InsurPlcyInsuredObjectID,
  InsurPlcyUndrwrtgDcsnRiskID,
  InsurPlcySubCvrgID,
  InsurPlcyOrderNumber,
  InsurPlcyBusProcType,
  InsurPlcyBusProcessNumerator,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyJrnlNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyCvrgOptionIsCancelled,
  InsurPlcyLineOfBusiness,
  InsurPlcyCvrgOptionStartDate,
  InsurPlcyCvrgOptionEndDate,
  InsurPlcyCvrgOptionCvrgNmbr,
  InsurPlcyCvrgOptnCvrgOptnNmbr,
  InsurPlcyCvrgOptionProdMgrID,
  InsurPlcyCvrgOptionCurrency,
  InsurPlcyCvrgOptionGnrtnDate,
  InsurPlcyCvrgOptnGnrtnDetnDte,
  LastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM /pm0/abdrcovcp
LEFT OUTER JOIN E_InsurPlcyCoverageOptionDraft AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyApplUUID = _Extension.InsurPlcyApplUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID AND InsurPlcyCoverageOptionID = _Extension.InsurPlcyCoverageOptionID AND InsurPlcyCoverageID = _Extension.InsurPlcyCoverageID AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
LEFT OUTER JOIN R_InsurPlcyLifeCvrgOptionDraft AS _LifeCoverageOption ON InsurPlcyUUIDForEdit = _LifeCoverageOption.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _LifeCoverageOption.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _LifeCoverageOption.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _LifeCoverageOption.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _LifeCoverageOption.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _LifeCoverageOption.InsurPlcyCvrgOptnIDForEdit  -- association [0..1]
LEFT OUTER JOIN R_InsurPlcyAcctBalShtValDraft AS _AccBalanceSheetValues ON InsurPlcyUUIDForEdit = _AccBalanceSheetValues.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _AccBalanceSheetValues.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _AccBalanceSheetValues.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _AccBalanceSheetValues.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _AccBalanceSheetValues.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _AccBalanceSheetValues.InsurPlcyCoverageOptionID  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyAssessmentBasisDrft AS _AssessmentBasis ON InsurPlcyUUIDForEdit = _AssessmentBasis.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _AssessmentBasis.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _AssessmentBasis.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _AssessmentBasis.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _AssessmentBasis.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _AssessmentBasis.InsurPlcyCoverageOptionID  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyBenefitDraft AS _Benefit ON InsurPlcyUUIDForEdit = _Benefit.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Benefit.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Benefit.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Benefit.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Benefit.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _Benefit.InsurPlcyCvrgOptnIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyClauseDraft AS _Clause ON InsurPlcyUUIDForEdit = _Clause.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _Clause.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _Clause.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _Clause.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _Clause.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _Clause.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _Clause.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _Clause.InsurPlcyUndrwrtgDcsnRiskID AND InsurPlcySubCvrgID = _Clause.InsurPlcySubCvrgID  -- association [0..*]
LEFT OUTER JOIN R_InsurPolicyInsuredObjectDrft AS _InsuredObject ON InsurPlcyUUIDForEdit = _InsuredObject.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _InsuredObject.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _InsuredObject.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _InsuredObject.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _InsuredObject.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _InsuredObject.InsurPlcyCvrgOptnIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyPremiumDraft AS _Premium ON InsurPlcyUUIDForEdit = _Premium.InsurPlcyUUIDForEdit AND InsurPlcyApplUUIDForEdit = _Premium.InsurPlcyApplUUIDForEdit AND InsurPlcyInsurContrForEdit = _Premium.InsurPlcyInsurContrForEdit AND InsurPlcyCvPcgIDForEdit = _Premium.InsurPlcyCvPcgIDForEdit AND InsurPlcyCoverageIDForEdit = _Premium.InsurPlcyCoverageIDForEdit AND InsurPlcyCvrgOptnIDForEdit = _Premium.InsurPlcyCvrgOptnIDForEdit AND InsurPlcyInsuredObjectID = _Premium.InsurPlcyInsrdObjIDForEdit  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcySurchargeDiscountD AS _SurchargeDiscount ON InsurPlcyUUIDForEdit = _SurchargeDiscount.InsurPlcyUUID AND InsurPlcyApplUUIDForEdit = _SurchargeDiscount.InsurPlcyApplUUID AND InsurPlcyInsurContrForEdit = _SurchargeDiscount.InsurPlcyInsurContr AND InsurPlcyCvPcgIDForEdit = _SurchargeDiscount.InsurPlcyCoveragePackageID AND InsurPlcyCoverageIDForEdit = _SurchargeDiscount.InsurPlcyCoverageID AND InsurPlcyCvrgOptnIDForEdit = _SurchargeDiscount.InsurPlcyCoverageOptionID AND InsurPlcyInsuredObjectID = _SurchargeDiscount.InsurPlcyInsuredObjectID AND InsurPlcyUndrwrtgDcsnRiskID = _SurchargeDiscount.InsurPlcyUndrwrtgDcsnRiskID  -- association [0..*]
;

Depth:

R_InsurPlcyCvrgOptnDraft view_entity

/pm0/abdrcovcp