I_InsurancePolicyDateVersion

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_InsurancePolicyDateVersion.
-- 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_InsurancePolicyDateVersion AS
SELECT
  cast( DateLoadJrnlAppl.InsurPlcyUUID as /pm0/vdm_policy_uuid preserving type ) AS InsurPlcyUUID,
  DateLoadJrnlAppl.InsurPlcyOrderNumber AS InsurPlcyOrderNumber,
  DateLoadJrnlAppl.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  DateLoadJrnlAppl.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  DateLoadJrnlAppl.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  DateLoadJrnlAppl.InsurancePolicyDateIdentifier AS InsurancePolicyDateIdentifier,
  cast( DateLoadJrnlAppl.InsurPlcyApplUUID as /pm0/vdm_application_uuid preserving type ) AS InsurPlcyApplUUID,
  DateLoadJrnlAppl.InsurPlcyBusProcType AS InsurPlcyBusProcType,
  DateLoadJrnlAppl.InsurPlcyBusProcessNumerator AS InsurPlcyBusProcessNumerator,
  Date.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  Date.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  Date.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  Date.InsurPlcyDateIsCancelled AS InsurPlcyDateIsCancelled,
  Date.InsurancePolicyDateType AS InsurancePolicyDateType,
  Date.InsurPolicyTimeModelFunction AS InsurPolicyTimeModelFunction,
  Date.InsurPlcyDateEffectiveDate AS InsurPlcyDateEffectiveDate,
  Date.InsurPlcyDateIsAuxiliary AS InsurPlcyDateIsAuxiliary,
  Date.InsurPlcyDateReleaseDate AS InsurPlcyDateReleaseDate,
  Date.InsurPlcyDateApplicationID AS InsurPlcyDateApplicationID,
  Date.InsurPlcyDatePerfPhaseType AS InsurPlcyDatePerfPhaseType,
  Date.InsurPlcyBusinessObject AS InsurPlcyBusinessObject,
  Date.LastChangeDateTime AS LastChangeDateTime
FROM I_InsurPlcyDateBasic AS Date
INNER JOIN P_InsurPlcyDateLoadJrnlAppl AS DateLoadJrnlAppl ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_InsurPlcyDateBasic
;