I_InsurApplContrCvrgInsrdVeh

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_InsurApplContrCvrgInsrdVeh.
-- 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_InsurApplContrCvrgInsrdVeh AS
SELECT
  Vehicle.InsurPlcyUUID AS InsurPlcyUUID,
  Vehicle.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  Vehicle.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  Vehicle.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  Vehicle.InsurPlcyInsuredObjectID AS InsurPlcyInsuredObjectID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  Vehicle.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Vehicle.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Vehicle.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Vehicle.InsurPlcyInsrdObjectTemplate AS InsurPlcyInsrdObjectTemplate,
  Vehicle.InsurPlcyInsuredObjectCategory AS InsurPlcyInsuredObjectCategory,
  Vehicle.InsurPlcyInsrdObjSubCategory AS InsurPlcyInsrdObjSubCategory,
  Vehicle.InsurPlcyInsrdObjUnqID AS InsurPlcyInsrdObjUnqID,
  Vehicle.InsurPlcyInsrdVehRiskCode AS InsurPlcyInsrdVehRiskCode,
  Vehicle.InsurPlcyInsrdVehTariffGroup AS InsurPlcyInsrdVehTariffGroup,
  Vehicle.InsurPlcyInsrdVehIsCoEmplDisc AS InsurPlcyInsrdVehIsCoEmplDisc,
  Vehicle.InsurPlcyInsrdVehIsDrvrTrng AS InsurPlcyInsrdVehIsDrvrTrng,
  Vehicle.InsurPlcyInsrdVehIsFamLicPlt AS InsurPlcyInsrdVehIsFamLicPlt,
  Vehicle.InsurPlcyInsrdVehNightParkArea AS InsurPlcyInsrdVehNightParkArea,
  Vehicle.InsurPlcyInsrdVehAcqnDate AS InsurPlcyInsrdVehAcqnDate,
  Vehicle.InsurPlcyInsrdVehUserRange AS InsurPlcyInsrdVehUserRange,
  Vehicle.InsurPlcyInsrdVehEvdcLmtdToDte AS InsurPlcyInsrdVehEvdcLmtdToDte,
  Vehicle.InsurPlcyInsrdVehResidentPrpty AS InsurPlcyInsrdVehResidentPrpty,
  Vehicle.InsurPlcyInsrdVehAgeAcqnInYrs AS InsurPlcyInsrdVehAgeAcqnInYrs,
  Vehicle.InsurPlcyInsrdVehHasAbs AS InsurPlcyInsrdVehHasAbs,
  Vehicle.InsurPlcyInsrdVehDiffntOwner AS InsurPlcyInsrdVehDiffntOwner,
  Vehicle.InsurPlcyInsrdVehDrvr1Name AS InsurPlcyInsrdVehDrvr1Name,
  Vehicle.InsurPlcyInsrdVehDrvr2Name AS InsurPlcyInsrdVehDrvr2Name,
  Vehicle.InsurPlcyInsrdVehDrvr3Name AS InsurPlcyInsrdVehDrvr3Name,
  Vehicle.InsurPlcyInsrdVehDrvr1BirthDte AS InsurPlcyInsrdVehDrvr1BirthDte,
  Vehicle.InsurPlcyInsrdVehDrvr2BirthDte AS InsurPlcyInsrdVehDrvr2BirthDte,
  Vehicle.InsurPlcyInsrdVehDrvr3BirthDte AS InsurPlcyInsrdVehDrvr3BirthDte,
  Vehicle.InsurPlcyInsrdVehCertDate AS InsurPlcyInsrdVehCertDate,
  Vehicle.InsurPlcyInsrdVehRatgRiskCode AS InsurPlcyInsrdVehRatgRiskCode,
  Vehicle.InsurPlcyInsrdVehDrvrLicIsSent AS InsurPlcyInsrdVehDrvrLicIsSent,
  Vehicle.InsurPlcyInsrdVehIssDrvrLicDte AS InsurPlcyInsrdVehIssDrvrLicDte,
  Vehicle.InsurPlcyInsrdVehRegnIssgAgcy AS InsurPlcyInsrdVehRegnIssgAgcy,
  Vehicle.InsurPlcyVehAdminvIssgAgcy AS InsurPlcyVehAdminvIssgAgcy,
  Vehicle.InsurPlcyInsrdVehRegnRespAgcy AS InsurPlcyInsrdVehRegnRespAgcy,
  Vehicle.InsurPlcyVehAdminvRespAgcy AS InsurPlcyVehAdminvRespAgcy,
  Vehicle.InsurPlcyVehRegnIsDvtnIssgAgcy AS InsurPlcyVehRegnIsDvtnIssgAgcy,
  Vehicle.InsurPlcyVehRegnIsDvtnRespAgcy AS InsurPlcyVehRegnIsDvtnRespAgcy,
  Vehicle.InsurPlcyInsrdVehTypeOfVehicle AS InsurPlcyInsrdVehTypeOfVehicle,
  Vehicle.InsurPlcyInsrdVehGrssListPrice AS InsurPlcyInsrdVehGrssListPrice,
  Vehicle.InsurPlcyInsrdVehNetListPrice AS InsurPlcyInsrdVehNetListPrice,
  Vehicle.InsurPlcyInsrdVehMnlListPrice AS InsurPlcyInsrdVehMnlListPrice,
  Vehicle.InsurPlcyInsrdVehExtReference AS InsurPlcyInsrdVehExtReference,
  Vehicle.InsurPlcyInsrdVehNumberOfSeats AS InsurPlcyInsrdVehNumberOfSeats,
  Vehicle.InsurPlcyInsrdVehYrlyMlgeQty AS InsurPlcyInsrdVehYrlyMlgeQty,
  Vehicle.InsurPlcyInsrdVehYrlyMlgeUnit AS InsurPlcyInsrdVehYrlyMlgeUnit,
  Vehicle.InsurPlcyInsrdVehCurrency AS InsurPlcyInsrdVehCurrency,
  Vehicle.LastChangeDateTime AS LastChangeDateTime
FROM P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyInsuredVehicleBasic AS Vehicle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON InsurPlcyInsrdVehCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyInsrdObjectTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
LEFT OUTER JOIN I_InsurInsrdObjectCategory AS _InsurInsrdObjectCategory ON InsurPlcyInsuredObjectCategory = _InsurInsrdObjectCategory.InsurPlcyInsuredObjectCategory  -- association [1..1]
LEFT OUTER JOIN I_InsurInsrdObjSubCategory AS _InsurInsrdObjSubCategory ON InsurPlcyInsrdObjSubCategory = _InsurInsrdObjSubCategory.InsurPlcyInsrdObjSubCategory  -- association [1..1]
;