I_InsurApplCvrgNamedDriver

DDL: I_INSURAPPLCVRGNAMEDDRIVER Type: view_entity COMPOSITE
25 Fields 2 Data Sources 4 Associations

InsOb Nmd Drvr of Cvrg of CvPcg in Appl

I_InsurApplCvrgNamedDriver is a Composite CDS View that provides data about "InsOb Nmd Drvr of Cvrg of CvPcg in Appl" in SAP S/4HANA. It reads from 2 data sources (I_InsurPlcyNamedDriverBasic, P_InsurPolicyJournalKeys) and exposes 25 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyInsuredObjectID. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurPlcyNamedDriverBasic NamedDriver inner
P_InsurPolicyJournalKeys PlcyJrnl from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_InsurPlcyNmdDrvrGender _InsurPlcyNmdDrvrGender $projection.InsurPlcyNamedDriverGender = _InsurPlcyNmdDrvrGender.InsurPlcyNamedDriverGender
[1..1] I_InsurPlcyDrvrMaritalStsLink _InsurPlcyNmdDrvrMaritalSts $projection.InsurPlcyNmdDrvrMaritalStatus = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrMaritalStatus and $projection.InsurPlcyNmdDrvrTemplate = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrTemplate
[1..1] I_InsurPlcyNmdDrvrCategoryLink _InsurPlcyNmdDrvrCategoryLink $projection.InsurPlcyNmdDrvrDrvrCategoryID = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrDrvrCategoryID and $projection.InsurPlcyNmdDrvrTemplate = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrTemplate
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyNmdDrvrTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

Annotations (11)

NameValueLevelField
EndUserText.label InsOb Nmd Drvr of Cvrg of CvPcg in Appl view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsrdVehNmdDrvrID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IACvgNmdDrvr view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyNamedDriverBasic InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyNamedDriverBasic InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyNamedDriverBasic InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyNamedDriverBasic InsurPlcyCoverageID Coverage Key
KEY InsurPlcyInsuredObjectID I_InsurPlcyNamedDriverBasic InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyInsrdVehNmdDrvrID I_InsurPlcyNamedDriverBasic InsurPlcyInsrdVehNmdDrvrID Named Driver ID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyNamedDriverBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyNamedDriverBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyNamedDriverBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyNmdDrvrTemplate I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrTemplate
AddressID I_InsurPlcyNamedDriverBasic AddressID Ship-to address
InsurPlcyNamedDriver I_InsurPlcyNamedDriverBasic InsurPlcyNamedDriver Partner ID
InsurPlcyNmdDrvrBirthDate I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrBirthDate Date of Birth
InsurPlcyNmdDrvrDrvrCategoryID I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrDrvrCategoryID Driver Cat. ID
InsurPlcyNamedDriverGender I_InsurPlcyNamedDriverBasic InsurPlcyNamedDriverGender Gender
InsurPlcyNmdDrvrDrvrLicNumber I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrDrvrLicNumber Driver's Lic.
InsurPlcyNmdDrvrDrvrLicIssDte I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrDrvrLicIssDte Driv. Lic. Date
InsurPlcyNmdDrvrMaritalStatus I_InsurPlcyNamedDriverBasic InsurPlcyNmdDrvrMaritalStatus Marital Status
LastChangeDateTime I_InsurPlcyNamedDriverBasic LastChangeDateTime Timestamp
_InsurApplInsuredObject _InsurApplInsuredObject
_InsurPlcyNmdDrvrGender _InsurPlcyNmdDrvrGender
_InsurPlcyNmdDrvrMaritalSts _InsurPlcyNmdDrvrMaritalSts
_InsurPlcyNmdDrvrCategoryLink _InsurPlcyNmdDrvrCategoryLink
_InsurPlcyTemplateT _InsurPlcyTemplateT

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_InsurApplCvrgNamedDriver.
-- 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_InsurApplCvrgNamedDriver AS
SELECT
  NamedDriver.InsurPlcyUUID AS InsurPlcyUUID,
  NamedDriver.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  NamedDriver.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  NamedDriver.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  NamedDriver.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  NamedDriver.InsurPlcyInsrdVehNmdDrvrID AS InsurPlcyInsrdVehNmdDrvrID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  NamedDriver.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  NamedDriver.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  NamedDriver.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  NamedDriver.InsurPlcyNmdDrvrTemplate AS InsurPlcyNmdDrvrTemplate,
  NamedDriver.AddressID AS AddressID,
  NamedDriver.InsurPlcyNamedDriver AS InsurPlcyNamedDriver,
  NamedDriver.InsurPlcyNmdDrvrBirthDate AS InsurPlcyNmdDrvrBirthDate,
  NamedDriver.InsurPlcyNmdDrvrDrvrCategoryID AS InsurPlcyNmdDrvrDrvrCategoryID,
  NamedDriver.InsurPlcyNamedDriverGender AS InsurPlcyNamedDriverGender,
  NamedDriver.InsurPlcyNmdDrvrDrvrLicNumber AS InsurPlcyNmdDrvrDrvrLicNumber,
  NamedDriver.InsurPlcyNmdDrvrDrvrLicIssDte AS InsurPlcyNmdDrvrDrvrLicIssDte,
  NamedDriver.InsurPlcyNmdDrvrMaritalStatus AS InsurPlcyNmdDrvrMaritalStatus,
  NamedDriver.LastChangeDateTime AS LastChangeDateTime
FROM P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyNamedDriverBasic AS NamedDriver ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurPlcyNmdDrvrGender AS _InsurPlcyNmdDrvrGender ON InsurPlcyNamedDriverGender = _InsurPlcyNmdDrvrGender.InsurPlcyNamedDriverGender  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyDrvrMaritalStsLink AS _InsurPlcyNmdDrvrMaritalSts ON InsurPlcyNmdDrvrMaritalStatus = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrMaritalStatus AND InsurPlcyNmdDrvrTemplate = _InsurPlcyNmdDrvrMaritalSts.InsurPlcyNmdDrvrTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyNmdDrvrCategoryLink AS _InsurPlcyNmdDrvrCategoryLink ON InsurPlcyNmdDrvrDrvrCategoryID = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrDrvrCategoryID AND InsurPlcyNmdDrvrTemplate = _InsurPlcyNmdDrvrCategoryLink.InsurPlcyNmdDrvrTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyNmdDrvrTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
;

Learn More