I_InsurPlcyNamedDriverVersion

DDL: I_INSURPLCYNAMEDDRIVERVERSION Type: view_entity COMPOSITE
50 Fields 4 Data Sources

Named Driver

I_InsurPlcyNamedDriverVersion is a Composite CDS View that provides data about "Named Driver" in SAP S/4HANA. It reads from 4 data sources (I_InsurPlcyNamedDriverBasic_2, I_InsurPlcyNamedDriverBasic_2, P_InsurPlcyNmdDrvrLoadJrnlAppl, P_InsurPlcyNmdDrvrLoadJrnlAppl) and exposes 50 fields with key fields InsurPlcyUUID, InsurPlcyOrderNumber, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID.

Data Sources (4)

SourceAliasJoin Type
I_InsurPlcyNamedDriverBasic_2 NamedDriver from
I_InsurPlcyNamedDriverBasic_2 NamedDriver union
P_InsurPlcyNmdDrvrLoadJrnlAppl NmdDrvrLoadJrnlAppl inner
P_InsurPlcyNmdDrvrLoadJrnlAppl NmdDrvrLoadJrnlAppl inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Named Driver view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID
KEY InsurPlcyOrderNumber P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyOrderNumber Sequence Number
KEY InsurPlcyInsurContr P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyInsrdVehNmdDrvrID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyInsrdVehNmdDrvrID Named Driver ID
InsurPlcyApplUUID
InsurPlcyBusProcType P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyNamedDriverBasic_2 InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyNamedDriverBasic_2 InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyNamedDriverBasic_2 InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyNamedDriverIsCanceled I_InsurPlcyNamedDriverBasic_2 InsurPlcyNamedDriverIsCanceled Reversal
InsurPlcyNmdDrvrAddressNumber I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrAddressNumber
InsurPlcyNamedDriver I_InsurPlcyNamedDriverBasic_2 InsurPlcyNamedDriver Partner ID
InsurPlcyNmdDrvrBirthDate I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrBirthDate Date of Birth
InsurPlcyNmdDrvrDrvrCategoryID I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrDrvrCategoryID Driver Cat. ID
InsurPlcyNamedDriverGender I_InsurPlcyNamedDriverBasic_2 InsurPlcyNamedDriverGender Gender
InsurPlcyNmdDrvrDrvrLicNumber I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrDrvrLicNumber Driver's Lic.
InsurPlcyNmdDrvrDrvrLicIssDte I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrDrvrLicIssDte Driv. Lic. Date
InsurPlcyNmdDrvrMaritalStatus I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrMaritalStatus Marital Status
InsurPlcyNmdDrvrTemplate I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrTemplate
InsurPlcyBusinessObject I_InsurPlcyNamedDriverBasic_2 InsurPlcyBusinessObject Process.Status
KEY InsurPlcyOrderNumber P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyOrderNumber Sequence Number
KEY InsurPlcyInsurContr P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyCoverageID Coverage Key
KEY InsurPlcyCoverageOptionID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyCoverageOptionID Cov. Option Key
KEY InsurPlcyInsuredObjectID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcyInsrdVehNmdDrvrID P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyInsrdVehNmdDrvrID Named Driver ID
InsurPlcyApplUUID
InsurPlcyBusProcType P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyBusProcType Bus. Process
InsurPlcyBusProcessNumerator P_InsurPlcyNmdDrvrLoadJrnlAppl InsurPlcyBusProcessNumerator Bus. Proc. No.
InsurPlcyJrnlNmbr I_InsurPlcyNamedDriverBasic_2 InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyNamedDriverBasic_2 InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyNamedDriverBasic_2 InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyNamedDriverIsCanceled I_InsurPlcyNamedDriverBasic_2 InsurPlcyNamedDriverIsCanceled Reversal
InsurPlcyNmdDrvrAddressNumber I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrAddressNumber
InsurPlcyNamedDriver I_InsurPlcyNamedDriverBasic_2 InsurPlcyNamedDriver Partner ID
InsurPlcyNmdDrvrBirthDate I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrBirthDate Date of Birth
InsurPlcyNmdDrvrDrvrCategoryID I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrDrvrCategoryID Driver Cat. ID
InsurPlcyNamedDriverGender I_InsurPlcyNamedDriverBasic_2 InsurPlcyNamedDriverGender Gender
InsurPlcyNmdDrvrDrvrLicNumber I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrDrvrLicNumber Driver's Lic.
InsurPlcyNmdDrvrDrvrLicIssDte I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrDrvrLicIssDte Driv. Lic. Date
InsurPlcyNmdDrvrMaritalStatus I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrMaritalStatus Marital Status
InsurPlcyNmdDrvrTemplate I_InsurPlcyNamedDriverBasic_2 InsurPlcyNmdDrvrTemplate
InsurPlcyBusinessObject I_InsurPlcyNamedDriverBasic_2 InsurPlcyBusinessObject Process.Status
LastChangeDateTime I_InsurPlcyNamedDriverBasic_2 LastChangeDateTime Timestamp

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_InsurPlcyNamedDriverVersion.
-- 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_InsurPlcyNamedDriverVersion AS
SELECT
  cast(NmdDrvrLoadJrnlAppl.InsurPlcyUUID as /pm0/vdm_policy_uuid preserving type) AS InsurPlcyUUID,
  NmdDrvrLoadJrnlAppl.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  NmdDrvrLoadJrnlAppl.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  NmdDrvrLoadJrnlAppl.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  NmdDrvrLoadJrnlAppl.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  NmdDrvrLoadJrnlAppl.InsurPlcyCoverageOptionID AS InsurPlcyCoverageOptionID,
  NmdDrvrLoadJrnlAppl.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  NmdDrvrLoadJrnlAppl.InsurPlcyInsrdVehNmdDrvrID AS InsurPlcyInsrdVehNmdDrvrID,
  cast(NmdDrvrLoadJrnlAppl.InsurPlcyApplUUID as /pm0/vdm_application_uuid preserving type) AS InsurPlcyApplUUID,
  NmdDrvrLoadJrnlAppl.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  NmdDrvrLoadJrnlAppl.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  NamedDriver.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  NamedDriver.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  NamedDriver.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  NamedDriver.InsurPlcyNamedDriverIsCanceled AS InsurPlcyNamedDriverIsCanceled,
  NamedDriver.InsurPlcyNmdDrvrAddressNumber AS InsurPlcyNmdDrvrAddressNumber,
  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.InsurPlcyNmdDrvrTemplate AS InsurPlcyNmdDrvrTemplate,
  NamedDriver.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  NamedDriver.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyNamedDriverBasic_2 AS NamedDriver
INNER JOIN P_InsurPlcyNmdDrvrLoadJrnlAppl AS NmdDrvrLoadJrnlAppl ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_InsurPlcyNamedDriverBasic_2
;

Learn More